SQL Server – Import Flat File using SSMS
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 …
Read MoreTag: SSMS
SQL Server Vulnerability Assessment using SSMS
Hello 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 …
Read MoreSQL Server Management Studio – Data Classification
Hello 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 …
Read MoreCompare Query plan using SSMS
Recently 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 …
Read MoreSQL Server – Customize Database object Script
SSMS 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 …
Read MoreSQL Server– Template Explorer
Yesterday 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 …
Read MoreSQL Server new query window shortcut
Shortcuts 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 …
Read More