What I Shoot
Error: Twitter did not respond. Please wait a few minutes and refresh this page.
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
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:
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?
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: