- Creating_Database.sql - Create a new SQL Server database.
- Backup_Database.sql - Backup and restore database operations.
- SQL_Server_Agent_Jobs.sql - Automate tasks with SQL Server Agent jobs.
- Update_Text.sql - Update and manage text data.
- Replication_Basics.sql - Set up and manage database replication.
- OpenRowSet.sql - Query external data sources using OPENROWSET.
- Bulk_Insert.sql - Perform efficient bulk data loading.
- CLR.sql - Integrate .NET code with SQL Server CLR.
- Localization.sql - Localization and globalization features in SQL Server 2022.
- Indices_Part_1.sql - Introduction to index creation and usage.
- Stored_Procedures.sql - Create and use stored procedures.
- Functions.sql - User-defined functions examples.
- Triggers.sql - Implement triggers for automation.
- Views.sql - Create and use database views.
- Index_Walkthrough_1.sql - Index walkthrough part 1.
- Index_Walkthrough_2.sql - Index walkthrough part 2.
- Hierarchy_Data.sql - Work with hierarchical data structures.
- XML.sql - Store and query XML data.
- JSON.sql - Store and query JSON data.
- Graph.sql - Model and query graph data.
- Spatial_Data.sql - Use spatial data types and queries.
- Match.sql - Pattern matching and search operations.
- Statements.sql - Common SQL statements and usage.
- Windowing_Functions.sql - Use window functions for analytics.
- Rank_Functions.sql - Ranking and row numbering functions.
- Time_Series.sql - Analyze and manage time series data.
- Advanced_Queries.sql - Advanced query techniques.
- Data_Import_Export.sql - Import and export data.
- Dynamic_SQL.sql - Generate and execute dynamic SQL.
- Error_Handling.sql - Error handling strategies in SQL.
- Temp_Tables.sql - Use temporary tables for intermediate results.
- CTE.sql - Common Table Expressions (CTE) usage.
- Pivot_Unpivot.sql - Pivot and unpivot data for reporting.
- RLS.sql - Implement row-level security.
- Approx_Functions.sql - Use approximate query processing functions.
- Predicts.sql - Predictive functions in SQL Server.
- Full_Text_Search.sql - Full-text search capabilities.
- Performance_Tuning.sql - Performance tuning examples.
- JSON_Advanced.sql - Advanced JSON data handling.
- Isolation_Levels.sql - Transaction isolation levels.
- Graph_Database.sql - Advanced graph database features.
- Temporal_Tables.sql - Temporal tables for historical data tracking.
- Partitioning.sql - Table and index partitioning strategies.
- Query_Store.sql - Monitor and analyze queries with Query Store.
- Security_1.sql - Security best practices (part 1).
- Security_2.sql - Security best practices (part 2).
- Always_Encrypted.sql - Protect sensitive data with Always Encrypted.
- Ledger.sql - Immutable data storage using SQL Server Ledger.
- Transactions.sql - Transaction management examples.
- Concurrency.sql - Concurrency control techniques.
- Extended_Events.sql - Monitor and troubleshoot with Extended Events.
- In_Memory_OLTP.sql - In-Memory OLTP for high-performance workloads.
- Memory_Optimized_Tables.sql - Use memory-optimized tables.
- Partitioning.sql - Additional partitioning examples.
- SET.md - Reference for SQL Server SET options and statements.
- JSON_Native_Type.sql - Native JSON data type with binary storage, modify() method, and JSON aggregate functions.
- Regular_Expressions.sql - Complete regex support: REGEXP_LIKE, REGEXP_REPLACE, REGEXP_SUBSTR, REGEXP_INSTR, REGEXP_COUNT, REGEXP_MATCHES, REGEXP_SPLIT_TO_TABLE.
- External_REST_Endpoints.sql - Call REST/GraphQL endpoints with sp_invoke_external_rest_endpoint for Azure Functions, Event Hubs, and OpenAI integration.
- Change_Event_Streaming.sql - Stream incremental DML changes to Azure Event Hubs in real-time with CloudEvents format.
- Fuzzy_String_Matching.sql - EDIT_DISTANCE and EDIT_DISTANCE_SIMILARITY functions for approximate string matching and data deduplication.