My blog about SQL Server
SSMS new versions come up with some cool features. The new features provide support for the SQL Server 2008 databases and onward. Vulnerability Assessment (active from SSMS 17.4) Right click on a database Tasks -> Vulnerability Assessment -> Scan For Continue reading Some New Cool Features in SSMS
In this article I’ll show you how to connect to SQL Azure database instance and create a simple database. First you have to own an Azure account. In the account you have to have a resource (your database server). Some of the Continue reading Connect to SQL Azure database from SSMS
A new functionality in SSSM 2016 is the ability to compare two execution plans. In one of the execution plans by right clicking and choosing the “Compare Showplan” option you’re already having the comparison. Example comparison If you want to Continue reading Showplan comparison
The installation of SSMS 2016 is different and it’s a separate installation. It’s not a part of the SQL Server installation as it was the case until SQL Server 2014. The link from the window below forwards you to the newest release which Continue reading The new SQL Server Management Studio 2016
SQL Server 2016 brings one of the new features – The live execution plan. You can enable it by clicking the highlighted icon on the Toolbar. Then running a query is shown with a live flow of the execution plan like below Continue reading Live execution plans
It’s a very good practice that you check the dependencies of the other objects when you change an object. Many developers just don’t do it, even when the change(s) is tiny it could withdraw change(s) in other objects. The example Continue reading Objects dependency check up in SSMS