What I Shoot
Error: Twitter did not respond. Please wait a few minutes and refresh this page.
Sometimes we need to generate current timestamp in a special format (e.g. suffixes for backup files). If we are unlucky that requested format is not supported by CONVERT function and SQL Server version is 2008 R2 and older this might … Continue reading
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:
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: