SQL Server Education (by the geeks, for the geeks)
Hello Friends, Microsoft added lots of new features in SQL Server Management Studio to make it more helpful tool. One more feature “Import Flat File…” option has been added by Microsoft …
SQL Server – Import Flat File using SSMS Read MoreHello Friends, As a Database professional, we all are aware about the importance of Data (Most Valuable Asset for a Company). There are lots of things we do to protect our …
SQL Server Vulnerability Assessment using SSMS Read MoreHello Friends, The first step in Data Security or Data Protection is identifying sensitive data. We have to check every table one by one and identify every column which stores sensitive …
SQL Server Management Studio – Data Classification Read MoreRecently Microsoft released SSMS 17.0. This release of SSMS supports SQL Server 2017 for both running on Windows and Linux. In this release Microsoft has added new features as well as …
Compare Query plan using SSMS Read MoreSSMS provides functionality to generate script for database objects. I’ve seen developer use this functionality to generate script for various objects like Tables, Procedures, Triggers and other database objects but after …
SQL Server – Customize Database object Script Read MoreYesterday when I was about to leave office , I got a call from one of my friend. He wanted to know how to write a recursive query?I said use Template …
SQL Server– Template Explorer Read MoreShortcuts help you to do your work swiftly and with increased productivity. In this blog we’ll look at new query window shortcut every SQL Server geek should know Shortcut Usage Window …
SQL Server new query window shortcut Read More