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
Connect SQL Server from Excel and retrieve data
Download & Install SQL Server Management Studio (SSMS) 2016
Install SQL Server 2016 RTM
Polybase - Install JRE 7 Update while installing SQL Server 2016/2017
CHOOSE() and IIF() functions in SQL Server 2012
FORMAT() function in SQL Server 2012
CONCAT() function in SQL Server 2012
HAVING clause and difference with GROUP BY & WHERE clause in SQL statement
GROUP BY with Aggregate functions in SQL statement
SQL Server 2016 new feature - IF EXISTS with ALTER TABLE and DROP stmts
new STRING_SPLIT() function in SQL Server 2016
WHERE clause in SQL Server (DML, Filter table rows)
SELECT statement in SQL Server (DML, DQL, Query table data)
DDL, DML, DCL & TCL statements in SQL (Database basics)
Candidate, Primary, Alternate, Super and Composite key types in DBMS (SQL)
Table Variables in SQL Server (Pound Tables)
Temporary Tables in SQL Server (Hash Tables)
NOT NULL, DEFAULT, CHECK Constraints in SQL Server (Domain Integrity in DBMS)
Backup and Restore Database in SQL Server
Foreign Key (FK) Constraint in SQL Server (Referential Integrity in DBMS)
Install SQL Server 2014 Analysis Service Tabular Model (SSAS - ROLAP)
Install SQL Server Reporting Service (SSRS 2014)
Install SQL Server Analysis Services (SSAS, MOLAP 2014)
Install SQL Server Integration Service (SSIS 2014)
Install SQL Server Named Instance
Unique Key (UK) Constraint in SQL Server
