Monthly Archives: April 2017

Try and try again – SSMS

Came across this very interesting article which talks about connection resiliency logic in the SQL Server management studio. What this basically does is try to re-connect in case of a time out after sleeping for 10 seconds. The default value for retry is 1 and default interval is 10 seconds. This article from
https://blogs.msdn.microsoft.com/sqlcat/2017/04/06/try-and-try-again-not-always-a-good-idea-at-least-not-for-ssms/

White Paper on connection resiliency

https://msdn.microsoft.com/en-us/library/dn632678.aspx

I hope this article was useful. Have a good day ahead.
Bodhisatya

 

 

End of Days – CodePlex

Microsoft will be shutting down codeplex come December. The official date seems to be the 15th of December 2017. All source code has been moved to GitHub. Codeplex was started in 2006 and was a repository for any developer who wanted to share code with the community.

Link below for more details..

https://blogs.msdn.microsoft.com/bharry/2017/03/31/shutting-down-codeplex/

 

I hope this article was useful. Have a good day ahead.
Bodhisatya

SQL Server 2016 – End of an Era – So long AdventureWorks..Welcome World Wide Importers

End of an era if I should say so. It all started with SQL Server 2005 with a database named AdventureWorks. A sample database to help learn different aspects of the product. Take a bow AdventureWorks.

Welcome [WideWorldImporters]!!! This is a new database developed by MS targeting SQL server 2016 and Azure. Links below for download. Loads of goodies to download.

https://github.com/Microsoft/sql-server-samples/releases/tag/wide-world-importers-v1.0

 

I hope this article was useful. Have a good day ahead.
Bodhisatya

SQL Server – How to compare execution plans

One of the challenges for DBAs and Developers was to compare execution plans effectively. In the latest SSMS released by MS we have an option of comparing execution plans in a better readable format. This short article will explain that.

Step 1: Download the latest SSMS from MS website or If you have installed SQL server 2016 then this feature will be available.

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms

Step 2: Install the downloaded package

Step 3: Execute a query and save the execution plan somewhere.

Step 4: Execute another query and wait till the plan is displayed.

Step 5: Right click on the displayed plan and choose the following option highlighted.

This will ask for the saved execution plan. Choose the saved plan.

Step 6: Click on open
The actions opens 2 windows which shows the difference between the 2 execution plans as depicted below. This is a very handy feature when we need to compare the execution plans for a SP or query pre and post change to gauge the effect in terms of performance.

 

 

 

I hope this article was useful. Have a good day ahead.
Bodhisatya

SQL Server 2012,2014,2016 – When a CU patch can break an existing functionality!!!

Recently MS released the following patches for SQL Server. The product team has identified that the patches can be potential CDC functionality breaker. The link below for the note from the product team. Worth a read before applying them on production boxes specially if CDC is active.

  • SQL 2012 SP3 CU8
  • SQL 2014 SP1 CU10
  • SQL 2014 SP2 CU4
  • SQL 2016 RTM CU5
  • SQL 2016 SP1 CU2

https://blogs.msdn.microsoft.com/sql_server_team/cdc-functionality-may-break-after-upgrading-to-the-latest-cu-for-sql-server-2012-2014-and-2016/

 

I hope this article was useful. Have a good day ahead.
Bodhisatya

 

%d bloggers like this: