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
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
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: