Fundamentals of Managing Datafiles in SQL Server
Introduction Datafiles are physical objects that constitute the most important part of the database...
Use Cases for SQL Server MERGE Statement: Syncing Online and History Tables
INTRODUCTION The SQL Server MERGE statement is an incredibly useful tool for carrying out DML operations based on comparing two tables or...
Add Columns to an Existing Table in SQL Server Database
Introduction A table is a two-dimensional logical structure and the fundamental means of storing data in relational database management...
Using SQL Server Configuration Manager
Introduction SQL Server Configuration Manager is a part of SQL Server Suite, allowing us to...
Views in SQL Server
Introduction A view in SQL Server is a virtual table-like structure based on the result-set of an SQL statement. On the surface, a view is...
Using CASE Expressions in SQL Server
Introduction CASE Expressions in SQL Server are used for the column values substitution to present the result sets in a particular fashion...
Seven Secrets in SSMS for Developers
SQL Server Management Studio is Microsoft’s primary client tool for interacting with SQL Server....
SQL Server Inner Join Basics with Examples
Introduction T-SQL allows us to combine records from more than one table and return them as a single result set. This is achieved through...
Deploying a Database on Azure SQL
Introduction Azure SQL Database is a Platform as a Service (PaaS) offered by Microsoft Azure. Hence, you need the Azure subscription to use...
Deploying a Certificate for Encrypted Connection SQL Server
Introduction Last year we got a requirement to ensure encrypted connections to our SQL Server...
