Microsoft SQL Server Notes for Professionals

Overview & Synopsis

The contents
include:Getting started with Microsoft SQL Server, Data Types, Converting data types,
SELECT statement,Alias Names in SQL Server, NULLs, Variables, Dates, Generating a range of dates,
Database Snapshots, COALESCE, CASE Statement, INSERT INTO, MERGE, CREATE VIEW, Views,
UNION, WHILE loop, OVER Clause, GROUP BY, ORDER BY, The STUFF Function, JSON in SQL Server,
OPENJSON, FOR JSON, Queries with JSON data, Storing JSON in SQL tables, Modify JSON text, FOR
XML PATH, Join,cross apply, Computed Columns, Common Table Expressions, Move and copy data
around tables,Limit Result Set, Retrieve Information about your Instance, With Ties Option,
String Functions,Logical Functions, Aggregate Functions, String Aggregate functions in SQL
Server, Ranking Functions,Window functions, Dynamic SQL Pivot, Partitioning, Stored Procedures, Retrieve
information about the database, Split String function in SQL Server, Insert, Primary Keys, Foreign
Keys, Last Inserted Identity, Sequences, Index, Trigger, Cursors, Transaction isolation levels,
Advanced options,Migration, Table Valued Parameters, DBMAIL, Temporal Tables, Use of TEMP Table,
Scheduled Task Job, Isolation levels and locking, Privileges or Permissions, SQLCMD,
Resource Governor, File Group, Basic DDL Operations in MS SQL Server, Subqueries, Pagination, CLUSTERED
COLUMNSTORE,Parsename, Installing SQL Server on Windows, Analyzing a Query, Query Hints,
Query Store,Querying results by page, Schemas, Backup and Restore Database, Transaction
handling, Spatial Data, Dynamic SQL, Dynamic data masking, Common Language Runtime Integration,
Delimiting special characters and reserved words, DBCC, BULK Import, Service broker,
Permissions and Security,Database permissions, Encryption.