DDL, DML, DCL & TCL statements in SQL (Database basics)

All about IDENTITY property in SQL Server (Deep Dive)

Deep dive: Using JSON with SQL Server

Read JSON data from a table and parse it to rows and columns

Store JSON data in SQL Table using IsJSON() CHECK constraint

Parse JSON string with nested elements in SQL Server

Import JSON string to SQL tabular row-column format

Convert rows from a SQL Query or Table to JSON format

Download SQL Server 2019 for free (with SSMS)

Connect SQL Server on Linux Azure VM from SSMS

Install SQL Server on Linux Azure VM

Create a Ubuntu Linux VM on Microsoft Azure

Download and Install SQL Server 2017 and SSMS

Import multiple Record sets from an Excel sheet to SQL Server

Import data from Excel to SQL Server table

Export a Table or Query results from SQL Server to Excel

Move master database to another drive in SQL Server

Move tempdb to another drive in SQL Server

Move user Database (.mdf and .ldf files) to another drive in SQL Server (DBA stuff)

Detach and Attach a Database in SQL Server

Run SQL Query with Date Range filter in Excel

Call Stored Procedure with multiple parameters from Excel

Create Parametrized SQL Reports in Excel

Create Pivot Table report in Excel by connecting SQL Server

Call Stored Procedure from Excel and show results