SQL Server IntelliSense and Autocomplete
Starting from SQL Server 2008, Microsoft introduced a new feature in the SQL Server Management...
Different Ways to Compare SQL Server Tables Schema and Data
SQL Server provides us with different solutions to replicate or archive a database table or tables to another database, or the same...
Jump to Start Test-Driven Database Development (TDDD)
As a rule, we start to develop database solutions by creating database objects, such as tables, views, stored procedures, etc., based on...
How to Copy SQL Server Databases from One Instance to Another
Copying or moving databases is one of the most common tasks for data professionals who regularly...
Getting Started with Mssql-cli Command-Line Query Tool
A recent announcement on the release of several SQL Server tools has raised expectations across various groups. Product requirements...
Art of Isolating Dependencies and Data in Database Unit Testing
All the database developers more or less write database unit tests that not only help in detecting bugs early but also save a lot of time...
How to Use Default and Custom Widgets in SQL Server Operations Studio
There are already a number of articles and blog posts that reveal the benefits of the SQL...
Microsoft SQL Operations Studio: Configuration and Querying
In my previous article, Microsoft SQL Operations Studio: Understanding and Installation, we discussed deeply the need for a new SQL Server...
Microsoft SQL Operations Studio: Understanding and Installation
SQL Server Management Studio is considered as the default integrated graphical user interface tool that has been used for many years to...
