Tag Archives: MSSQL 2008 R2

Get first and last day of month in SQL 2012 and SQL 2008 and earlier

This article has been reviewed, improved and moved to my new blog http://blog.hubacek.uk/get-first-and-last-day-of-month-in-sql-2012-and-sql-2008-and-earlier/ Today I had to create an ETL for batch loading of records into data warehouse for the current month. For this I had to get first and last day … Continue reading

Posted in Microsoft SQL Server | Tagged , , , , , , , , , , | 4 Comments

Microsoft SQL Server 2008 R2 Service Pack 2 Released (10.50.4000.0)

Microsoft has released second service pack for SQL Server 2008 R2 (10.50.4000.0). It contains generally all hotfixes provided in SQL Server 2008 R2 SP1 CU 1 to 5. Some of the hotfixes are highlighted at Technet’s blog:

Posted in Microsoft SQL Server | Tagged , , , , , , | Leave a comment

Microsoft SQL Server 2008 R2 Service Pack 1 and Master Data Services

Do you have Master Data Services deployed? Have you applied Service Pack 1 for Microsoft SQL Server 2008 R2? Did you know that Cumulative Patches and Service Packs contain updates for MDS but update wizard has to be started separately?

Posted in Microsoft SQL Server | Tagged , , , , , , , | Leave a comment

Is it possible to run Integration Services 2008 R2 against MSDB at 2005 instance?

Last week I was asked by my colleague whether Integration Services 2008R2 can run against MSDB database located at Microsoft SQL 2005. At first I was in belief it was possible because I remembered article in MSDN library which said:

Posted in Microsoft SQL Server | Tagged , , , , , , | 10 Comments