In this post I would like to explain one of the interesting issues that I encountered while upgrading a SQL Server Instance. Symptoms · SQL Server instance is upgraded using a service pack or any other update. · After the upgrade SQL server service...

We recently saw some cases where customer migrated their SQL Database to Basic edition. After the migration they get the following error while attempting to publish their database via SQL Server Data Tools ( SSDT ) in Visual Studio 2013 Failed to import...

  Issue : If you have a Merge Replication, you may encounter the below error message thrown by Expired Subscription Cleanup job (sp_expired_subscription_cleanup) with a mention of conflict table of an article for the publication as below: Msg 1934...

Today, I want to point out another SQL Server 2012 SP2 fix that may affect your performance troubleshooting. When you are troubleshooting a long running query, chances are you will use sys.dm_exec_requests to look for progresses of the query. But one...

Bob Ward introduced Part 1 and Part 2 of ‘A faster CHECKDB’ as highlighted in the following links. Part 1: http://blogs.msdn.com/b/psssql/archive/2011/12/20/a-faster-checkdb-part-i.aspx   Part 2: http://blogs.msdn.com/b/psssql/archive/2012/02/23...