Repository files navigation
Creating_Database.sql - Create a new SQL Server database.Backup_Database.sql - Backup and restore database operations.
Administration & Maintenance
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.
Data Modeling & Advanced Data Types
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.
Performance & Optimization
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 & Concurrency
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.
SQL Server 2025 New Features
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.
New samples and scripts will be added soon.
You can’t perform that action at this time.