Tag Archives: Microsoft SQL Server 2008

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

How to make Master Data Services database operational after restore?

From time to time we need to migrate databases to other instance or we just need to copy database within multi-tier environment. Some databases including Master Data Services database need some after restore attention. Although script bellow is not my … Continue reading

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