Microsoft® SQL Server® Notes for Professionals book
If you found this free Microsoft® SQL Server® book useful,
then please share it ❤😊
Chapters
- Getting started with Microsoft SQL Server
- Data Types
- Converting data types
- User Defined Table Types
- SELECT statement
- Alias Names in SQL Server
- NULLs
- Variables
- Dates
- Generating a range of dates
- Database Snapshots
- COALESCE
- IF...ELSE
- CASE Statement
- INSERT INTO
- MERGE
- CREATE VIEW
- Views
- UNION
- TRY/CATCH
- 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
- PIVOT / UNPIVOT
- 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
- SCOPE_IDENTITY()
- Sequences
- Index
- Full-Text Indexing
- Trigger
- Cursors
- Transaction isolation levels
- Advanced options
- Migration
- Table Valued Parameters
- DBMAIL
- In-Memory OLTP (Hekaton)
- Temporal Tables
- Use of TEMP Table
- Scheduled Task or Job
- Isolation levels and locking
- Sorting/ordering rows
- 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
- Natively compiled modules (Hekaton)
- Spatial Data
- Dynamic SQL
- Dynamic data masking
- Export data in txt file by using SQLCMD
- Common Language Runtime Integration
- Delimiting special characters and reserved words
- DBCC
- BULK Import
- Service broker
- Permissions and Security
- Database permissions
- Row-level security
- Encryption
- PHANTOM read
- Filestream
- bcp (bulk copy program) Utility
- SQL Server Evolution through different versions (2000 - 2016)
- SQL Server Management Studio (SSMS)
- Managing Azure SQL Database
- System database - TempDb
- Microsoft SQL Server Management Studio Shortcut Keys
Example book pages
What people are saying about this Microsoft® SQL Server® Notes for Professionals book
This is awesome. I see lots of good code snippets to add to my onenote doc full of code notes. Thanks!
Nice reference, short and to the point. Good job.
This looks brilliant. Really thorough and succinct. 10 minutes in and I'm learning new things already.
Thank you. This will help me with my studies. 👍
Thanks you very much. add to the my MSSQL book library
Thank you for this!! Have to add to my SQL notes! Great stuff.
The Microsoft® SQL Server® Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow. Text content is released under Creative Commons BY-SA. See credits at the end of this book whom contributed to the various chapters. Images may be copyright of their respective owners unless otherwise specified
Book created for educational purposes and is not affiliated with Microsoft® SQL Server® group(s), company(s) nor Stack Overflow. All trademarks belong to their respective company owners
286 pages, published on May 2018
More Programming Books
View More Free Programming Books
To support continued development and improvements to this book, please consider a small bitcoin donation: 1H63m55bw6KDYUaKU1mYLGrzDf4wcrVzhX