What I read
What I Shoot
Categories
-
Recent Posts
Follow me on Twitter
Error: Twitter did not respond. Please wait a few minutes and refresh this page.
Meta
Archives
Advertisements
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
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
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?
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:
