SQL with Manoj

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