10 Tips & Tricks To Work With SQL Server Management Studio
SSMS provides access for managing and solving queries in SQL. However, besides its primary and most...
Auto Create Statistics and Auto Update Statistics
Statistics comprises lightweight objects that are used by SQL Server Query optimizer to determine the optimal way to retrieve data from the...
SQL Vulnerability Assessment
SQL Vulnerability Assessment is a feature available in the latest versions of SQL Server Management Studio (SSMS). This feature is very...
SQL Data Discovery and Classification
With the recent data protection laws and the implementation of GDPR last year, it is imperative for...
SQL Server IntelliSense and Autocomplete
Starting from SQL Server 2008, Microsoft introduced a new feature in the SQL Server Management Studio that helps the database developers...
Registered Server, a Hidden Gem of SQL Server Management Studio
Managing numerous database servers in an organization can be performed using the PowerShell scripts but it requires some complex PowerShell...
SQL Server Management Studio (SSMS) Registered Server
Managing numerous database servers in an organization is difficult. Either we must maintain a list...
