Monthly Archives: December 2010

Named Ranges in SQL

If you create reports with parameters the most popular parameters are start and end of time interval. But what if you need to run the same report every day for the last/current week? Named ranges are the best choice. You … Continue reading

Posted in Uncategorized | Leave a comment

Sharepoint 2010 + PowerShell + Sql Server

That trio allows to simplify some admin tasks. You can synchronize SharePoint data with SQL server as a script and schedule it. How to do that? PowerShell is a good choice which glues SharePoint and SQL Server. Here is one magic sample which allows … Continue reading

Posted in Uncategorized | Leave a comment