Seven Secrets in SSMS for Developers
SQL Server Management Studio is Microsoft’s primary client tool for interacting with SQL Server....
3 Nasty I/O Statistics That Lag SQL Query Performance
“But it ran fine on our development server!” How many times did I hear it when SQL query performance issues occurred here and there? I...
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 demanded options, it includes lots of...
Welcome Back the T-SQL Debugger with SQL Complete – SQL Debugger
When you develop large chunks of T-SQL code with the help of the SQL Server Management Studio tool,...
SQL Vulnerability Assessment
SQL Vulnerability Assessment is a feature available in the latest versions of SQL Server Management Studio (SSMS). This feature is very...
Tutorial on SQL (DDL, DML) on the example of MS SQL Server dialect
Introduction This tutorial includes information about SQL (DDL, DML) that I have gathered during my professional life. This is the minimum...
SQL Data Discovery and Classification
With the recent data protection laws and the implementation of GDPR last year, it is imperative for...
SQL Server Database Tables Export and Import Methods
When working as a SQL Server database administrator or developer, you cannot live in your isolated SQL Server world without communicating...
Basics of Running T-SQL Statements from Command Line using SQLCMD
This article is about developing a basic understanding of sqlcmd utility to run T-SQL commands directly from the command prompt without the...
How to Write T-SQL Queries Like a Pro
The skills of writing different types of SQL Server queries require you to have good knowledge in...
