Aaron Bertrand

Aaron Bertrand (@AaronBertrand) is a passionate technologist with industry experience dating back to Classic ASP and SQL Server 6.5. He is editor-in-chief of the performance-related blog, SQLPerformance.com, and also blogs at sqlblog.org.

2023 Awards   

2022 Awards      

2021 Awards   

2020 Awards   

2019 Awards   

2018 Awards   

2017 Awards   

2016 Awards      

2015 Awards      

2014 Awards      

2013 Awards   

Category	Tip Title
Auditing and Compliance	Use Extended Events to Get More Information About Failed SQL Server Login Attempts
Availability Groups	Queue table issues with Availability Groups in SQL Server
Compression	Unicode Compression in SQL Server 2008 R2
Constraints	Drop and Re-Create All Foreign Key Constraints in SQL Server
Constraints	Enforce a Unique Constraint Where Order Does Not Matter in SQL Server
Containers	Best Practices for Docker to run SQL Server on a Mac
Containers	Performance Testing Azure SQL Edge on Intel and M1 MacBooks
Containers	Testing SQL Server Edge and Docker on the latest MacBooks
Data Types	Always use the right case for data type names in SQL Server
Database Administration	Build a quota system for SQL Server user defined tables
Database Administration	Checklists to Manage SQL Server Deployments or Maintenance
Database Administration	Customize SQL Server Notifications for DDL Changes
Database Administration	Enforce SQL Server Database Naming Conventions Using DDL Triggers
Database Administration	Finding SQL Server views with (or without) a certain property
Database Administration	Get Column Attributes for all SQL Server Tables that Match Search Criteria
Database Administration	How To Find Space Used by Tables and Indexes in SQL Server – Part 3
Database Administration	Making SQL Server metadata queries easier with these new Views
Database Administration	Over 40 queries to find SQL Server tables with or without a certain property
Database Administration	Script to rename constraints and indexes to conform to a SQL Server naming convention
Database Administration	SQL Server at Scale - Automate Archive Table Creation - Part 3
Database Administration	SQL Server at Scale - Using an Archive Table - Part 2
Database Administration	SQL Server at Scale - Using an Archive Table, Part 1
Database Administration	SQL Server File and Filegroup Space Usage – Part 1
Database Administration	SQL Server Index and Partition Space Usage - Part 2
Database Administration	SQL Server Video - Tricks to play on your DBA - 1
Database Administration	SQL Server Video - Tricks to play on your DBA - 2
Database Configurations	More Reasons to Enable SQL Server Indirect Checkpoints
Database Design	Alter Table Modify Column ONLINE Issues in SQL Server
Database Design	Find SQL Server Integer Columns to Make Skinnier
Database Design	Populate dimension tables dynamically in SQL Server - Part 2
Database Design	Populate dimension tables dynamically in SQL Server – Part 1
Database Design	Query Extended Properties from Multiple SQL Server Databases
Database Design	SQL Server Data Type Consistency
Database Design	Storing E-mail addresses more efficiently in SQL Server
Database Design	Storing E-mail addresses more efficiently in SQL Server - Part 2
Dates	Build a cheat sheet for SQL Server date and time formats
Dates	Calendar Table in SQL Server to Identify Date Gaps and Islands
Dates	Create a Calendar Table in SQL Server to Optimize Scheduling Problems
Dates	Creating a date dimension or calendar table in SQL Server
Dates	Handle conversion between time zones in SQL Server - part 1
Dates	Handle conversion between time zones in SQL Server - part 2
Dates	Handle conversion between time zones in SQL Server - part 3
Dates	How SQL Server handles the date format YYYY-MM-DD
Dates	Simplify Date Period Calculations in SQL Server
Dates	Simulating TRY_PARSE for dates in SQL Server 2008
Dates	SQL Calendar Table - Use a Table and View to Simplify Generation
Dates	SQL Date Calculation Simplifications in SQL Server
Dates	SQL Server DateTime Best Practices
Dates	Use SQL Server and CSS to Generate More Interesting Events Calendar in HTML
Dates	Using a calendar table in SQL Server - Part 1
Dates	Using T-SQL to find events that overlap (or don't) in SQL Server
DBA Best Practices	Benefits of SCHEMABINDING in SQL Server
DBA Best Practices	Use Consistent SQL Server Naming Conventions
Dedicated Administrator Connection	Troubleshooting the SQL Server Dedicated Administrator Connection
Deprecated Features	Identify deprecated SQL Server code with a server side trace
Dynamic Management Views and Functions	Determine SQL Server memory use by database and object
Dynamic Management Views and Functions	Make SQL Server DMV Queries Backward Compatible
Dynamic Management Views and Functions	SQL Server Queries With Hints
Dynamic Management Views and Functions	Use caution with sys.dm_db_database_page_allocations in SQL Server
Dynamic SQL	Validate the contents of large dynamic SQL strings in SQL Server
Encryption	Always Encrypted: Enhancements in SQL Server
Encryption	SQL Server 2016 Always Encrypted
Error Handling	Checking for potential constraint violations before entering SQL Server TRY and CATCH logic
Express Edition	Getting Started with SQL Server 2012 Express LocalDB
Express Edition	Getting Started with SQL Server 2017 Express LocalDB
Extended Events	Convert Existing SQL Server Traces to Extended Events Sessions
Extended Events	Extracting ShowPlan XML from SQL Server Extended Events
Extended Events	Give SQL Server users access to Extended Events
Extended Events	Improve SQL Server Extended Events system_health Session
Extended Events	Query Data from Extended Events in SQL Server
Extended Events	SQL Server Checkpoint Monitoring with Extended Events
Extended Events	SQL Server Extended Events Filtering by Database Name
Extended Events	Using collect_database_name with SQL Server Extended Events
Functions System	Dealing with the single-character delimiter in SQL Server's STRING_SPLIT function
Functions System	Deciding between COALESCE and ISNULL in SQL Server
Functions System	FORMAT is a convenient but expensive SQL Server function - Part 1
Functions System	FORMAT is a convenient but expensive SQL Server function – Part 2
Functions System	Solve old problems with SQL Server’s new STRING_AGG and STRING_SPLIT functions
Functions System	SQL Server Split String Replacement Code with STRING_SPLIT
Functions System	Using FOR XML PATH and STRING_AGG() to denormalize SQL Server data
Functions System	Using GREATEST and LEAST functions in Azure SQL Database
Functions User Defined UDF	Four ways to improve scalar function performance in SQL Server
Functions User Defined UDF	Simulating TRY_CONVERT() in SQL Server 2008
Functions User Defined UDF	Simulating TRY_CONVERT() in SQL Server 2008 – Part 2
Functions User Defined UDF	SQL Server STRING SPLIT Limitations
Import and Export	Scale SQL Server Bulk Loading On a Budget - Part 1
Import and Export	Scale SQL Server Bulk Loading with Partition Switching for Performance - Part 2
Indexing	Be Careful with Key Order in SQL Server Missing Index Recommendations
Indexing	Faster SQL Server SELECT COUNT(*) Queries with Columnstore Indexes
Indexing	Find Queries with Index Hints in SQL Server
Indexing	How Forced Parameterization in SQL Server Affects Filtered Indexes
Indexing	Move all SQL Server indexed views to a new filegroup
Install and Uninstall	Cleanly Uninstalling Stubborn SQL Server Components
JOIN Tables	Issue with UNION and columns with mismatched data types in SQL Server
Locking and Blocking	Avoid using NOLOCK on SQL Server UPDATE and DELETE statements
Locking and Blocking	Eliminate False Positive SQL NOLOCK patterns in SQL Server - Part 3
Locking and Blocking	Find Problematic SQL NOLOCK Patterns in SQL Server DML Statements - Part 4
Locking and Blocking	Finding problematic NOLOCK patterns in SQL Server - Part 1
Locking and Blocking	Finding problematic SQL NOLOCK patterns for UPDATE and DELETE - Part 2
Locking and Blocking	SQL Server NOLOCK Anomalies, Issues and Inconsistencies
Monitoring	Virtual Log File Monitoring in SQL Server 2017
Partitioning	Partitioning Data in SQL Server without using Partitioned Tables
Partitioning	Why shouldn't I create 15,000 SQL Server partitions in advance?
Performance Data Warehouse	Removing the SQL Server Management Data Warehouse
Performance Tuning	Changes to SQL Server CXPACKET Wait Types
Performance Tuning	Identify SQL Servers with inefficient power plans using Policy Based Management
Performance Tuning	Identifying Key and RID Lookup Issues and How to Resolve
Performance Tuning	Improve SQL Server Performance for Large Log Table Queries using a Goal Posts Table
Performance Tuning	Measure Delayed Durability impact in SQL Server 2016 and later
Performance Tuning	More intuitive tool for reading SQL Server execution plans
Performance Tuning	Optimize for ad hoc workloads - at the database level - in SQL Server
Performance Tuning	Table Variable Deferred Compilation in SQL Server
Performance Tuning	Why the SQL Server FORCESCAN hint exists
Policy Based Management	Enforce SQL Server Database Naming Conventions Using Policy Based Management
Policy Based Management	Find all SQL Server columns of a specific data type using Policy Based Management
Policy Based Management	Find unused SQL Server indexes with Policy Based Management
Professional Development Career	Five Things I Wish I Knew When I Started My SQL Server Career
Profiler and Trace	Maintaining SQL Server default trace historical events for analysis and reporting
Query Optimization	Reasons for SQL Server Query Performance Fluctuations
Query Plans	Minimize SQL Server plan cache bloat
Query Plans	Revisit your use of the SQL Server REMOTE join hint
Resource Governor	Using DMVs to Adjust SQL Server Resource Governor Settings
Restore	The importance of SQL Server’s internal database version
Scripts	Making a more reliable and flexible sp_MSforeachdb
Scripts	Search all string columns in all SQL Server databases
Scripts	Search all String Columns in all SQL Server Tables or Views
Security	Data cleanup in SQL Server becomes more important with GDPR
Security	Get Alerts for Specific SQL Server Login Failed Events
Security	Is your SQL Server environment ready for GDPR?
Security	Map between SQL Server SIDs and Windows SIDs
Security	More on Recovering Access to a SQL Server Instance
Security	Performance Impact of SQL Server 2016 Row-Level Security
Security	Prevent and Log Certain SQL Server Login Attempts
Security	Recover access to a SQL Server instance
Security	Script to Set the SQL Server Database Default Schema For All Users
Security	Solving forget me requests for GDPR in SQL Server
Security	Tracking Login Password Changes in SQL Server
Security	Verify the databases a SQL Server login can see - and why
SQL Injection	Protecting Yourself from SQL Injection in SQL Server - Part 1
SQL Injection	Protecting Yourself from SQL Injection in SQL Server - Part 2
SQL Server 2016	Advanced JSON Techniques in SQL Server - Part 1
SQL Server 2016	Advanced JSON Techniques in SQL Server - Part 2
SQL Server 2016	Advanced JSON Techniques in SQL Server - Part 3
SQL Server 2016	Beware of Side-Channel Attacks in Row-Level Security in SQL Server 2016
SQL Server 2016	Identify Candidate Tables for SQL Server 2016 Stretch Databases
SQL Server 2016	New Features in SQL Server 2016 Service Pack 1
SQL Server 2016	Phase out CONTEXT_INFO() in SQL Server 2016 with SESSION_CONTEXT()
SQL Server 2016	Prepare for an Upgrade with the SQL Server 2016 Upgrade Advisor
SQL Server 2016	SQL Server 2016 Row Level Security Introduction
SQL Server 2016	SQL Server 2016 Row Level Security Limitations, Performance and Troubleshooting
SQL Server 2016	Understand the Limitations of SQL Server Dynamic Data Masking
SQL Server 2016	Use Dynamic Data Masking in SQL Server 2016 CTP 2.1
SQL Server 2017	More on Resumable Online Index Rebuilds in SQL Server 2017
SQL Server 2017	Overview of Database Engine Changes in SQL Server 2017
SQL Server 2019	Accelerated Database Recovery in SQL Server 2019
SQL Server 2019	Impact of UTF-8 support in SQL Server 2019
SQL Server 2019	Improve SQL Server Scalar UDF Performance in SQL Server 2019 with Scalar UDF Inlining
SQL Server 2019	Memory-Optimized TempDB Metadata in SQL Server 2019
SQL Server 2019	Minimizing PAGELATCH_EX waits in SQL Server 2019
SQL Server 2019	New Command in SQL Server 2019 ADD SENSITIVITY CLASSIFICATION
SQL Server 2019	New Function in SQL Server 2019 - sys.dm_db_page_info
SQL Server 2019	SQL Server 2019 APPROX_COUNT_DISTINCT Function
SQL Server 2019	SQL Server 2019 Execution Plan Enhancements
SQL Server 2019	SQL Server 2019 Installation Enhancements for MAXDOP and Max Memory
SQL Server 2019	What's New in the First Public CTP of SQL Server 2019
SQL Server 2022	My Favorite T-SQL Enhancements in SQL Server 2022
SQL Server 2022	Overcome Challenges with GENERATE_SERIES in SQL Server
SQL Server Agent	Manage SQL Server Agent History More Effectively
SQL Server Management Studio	Connect to SQL Servers in another domain using Windows Authentication
SQL Server Management Studio	SQL Server Management Studio 18 New Features - High DPI Support and 2 MB Query Output to Minimize Truncated Results
SQL Server Management Studio	Troubleshooting IntelliSense in SQL Server Management Studio 2012
SQL Server Management Studio	Use SQL Server Code Snippets to encourage consistent conventions
Stored Procedures	Simple process to track and log SQL Server stored procedure use
System Databases	Cleaning up the SQL Server master database
Temporal Tables	Auditing Who Changed Temporal Table Data in SQL Server
Temporal Tables	Managing Temporal Table History in SQL Server 2016
Triggers	Auditing when Triggers are Disabled or Enabled for SQL Server
Triggers	Avoid External Dependencies in SQL Server Triggers
Triggers	Extend SQL Server DDL Triggers for more functionality: Part 2
Triggers	Extending SQL Server DDL Triggers for more functionality: Part 1
Triggers	Improve SQL Server Efficiency by Switching to INSTEAD OF Triggers
Triggers	Keeping your SQL Server DDL Trigger Audit Table in Check
Triggers	Script triggers from any database in SQL Server
Triggers	SQL Server DDL Triggers to Track All Database Changes
TSQL	A way to improve STRING_SPLIT in SQL Server - and you can help
TSQL	Advanced report examples in SQL Server using PIVOT and GROUPING SETS
TSQL	Advanced testing with WAITFOR in SQL Server client tools
TSQL	Avoiding WHILE 1 = 1 loops in SQL Server
TSQL	Change All Computed Columns to Persisted in SQL Server
TSQL	Do tabs vs. spaces affect performance in SQL Server?
TSQL	Execute a Command in the Context of Each Database in SQL Server - Part 2
TSQL	Execute a Command in the Context of Each Database in SQL Server using sp_ineachdb
TSQL	Fastest way to Delete Large Number of Records in SQL Server
TSQL	Four SQL Server Syntax Rules I Always Follow
TSQL	Generating Random Numbers in SQL Server Without Collisions
TSQL	Handling an unknown number of parameters in SQL Server
TSQL	Make your SQL Server database changes backward compatible when adding a new column
TSQL	Make your SQL Server database changes backward compatible when changing a relationship
TSQL	Make your SQL Server database changes backward compatible when dropping a column
TSQL	Make your SQL Server database changes backward compatible when renaming an entity
TSQL	Making SQL Server Function Changes Backwards Compatible
TSQL	Ordered String Splitting in SQL Server with OPENJSON
TSQL	Removing Duplicates from Strings in SQL Server
TSQL	Safeguard to Avoid Costly Mistakes for UPDATE or DELETE Statements in SQL Server Management Studio
TSQL	Script to create dynamic PIVOT queries in SQL Server
TSQL	Simulating ON DELETE CASCADE in SQL Server
TSQL	SQL GROUP BY Alias - An Oracle feature that would be great in SQL Server
TSQL	SQL Server CASE Expression Overview
TSQL	The SQL Server Numbers Table, Explained - Part 1
TSQL	The SQL Server Numbers Table, Explained - Part 2
TSQL	Top 5 Reasons for Wrong Results in SQL Server
TSQL	Trusting STRING_SPLIT() order in Azure SQL Database
TSQL	Unpivoting Multiple Sets of Columns in SQL Server using CROSS APPLY
TSQL	Use Caution with SQL Server's MERGE Statement
TSQL	Use SQL Server's UNPIVOT operator to dynamically normalize output
TSQL	Use SQL Server's UNPIVOT operator to help normalize output
TSQL	What Effect Does Persisting a Computed Column Have in SQL Server?
TSQL	What Happens When a Computed Column is Persisted in SQL Server?
Upgrades and Migrations	Choosing Between SQL Server 2012 and SQL Server 2014
User Defined Type UDT	How to Alter User Defined Table Type in SQL Server
Views	Avoid ORDER BY in SQL Server views
Views	Use DDL Triggers to Automatically Keep SQL Server Views in Sync

Tutorial	Topic
SQL Server Date Video Tutorial	SQL Server Date and Time Data Type Comparison
SQL Server Date Video Tutorial	Recommended SQL Server Date Formats
SQL Server Date Video Tutorial	SQL Server Between Dates Issue
SQL Server Date Video Tutorial	SQL Server Date Time Shorthand and Other Tricks

No Records Found

CategoryGroup	Category (articles)
Analysis Services	Analysis Services Administration (33)
Analysis Services	Analysis Services Development (95)
Analysis Services	Analysis Services Dimensions (16)
Analysis Services	Analysis Services Measure Groups (7)
Analysis Services	Analysis Services Performance (14)
Analysis Services	Analysis Services Security (7)
Analysis Services	Analysis Services Tutorials (6)
Business Intelligence	Artificial Intelligence (34)
Business Intelligence	Big Data (25)
Business Intelligence	Data Science (3)
Business Intelligence	Data Warehousing (8)
Business Intelligence	Import and Export (80)
Business Intelligence	R Language (11)
Business Intelligence	Snowflake (28)
Cloud	Amazon AWS (39)
Cloud	Amazon AWS RDS (22)
Cloud	Azure (154)
Cloud	Azure Backup and Restore (25)
Cloud	Azure Cosmos DB (15)
Cloud	Azure Functions (7)
Cloud	Azure SQL Database (52)
Cloud	Azure SQL Managed Instance (7)
Cloud	Cloud Strategy (31)
Cloud	Google Cloud (10)
Cloud Analytics	Apache Spark (13)
Cloud Analytics	Azure Data Factory (73)
Cloud Analytics	Azure Databricks (40)
Cloud Analytics	Azure Integration Services (14)
Cloud Analytics	Azure Synapse Analytics (43)
Cloud Analytics	Microsoft Fabric (37)
Data Quality	Data Cleansing for Validation (5)
Data Quality	Data Quality Services (10)
Data Quality	Master Data Services (41)
Database Administration	Central Management Servers (10)
Database Administration	Comparison Data and Objects (15)
Database Administration	Database Administration (214)
Database Administration	DBA Best Practices (39)
Database Administration	Dedicated Administrator Connection (4)
Database Administration	Scripts (35)
Database Administration	System Databases (31)
Database Configuration	Compression (22)
Database Configuration	Database Configurations (20)
Database Configuration	Database Mail (19)
Database Configuration	FILESTREAM (9)
Database Configuration	Full Text Search (21)
Database Configuration	In Memory OLTP (32)
Database Configuration	Linked Servers (18)
Database Configuration	Policy Based Management (29)
Database Configuration	Recovery Models (4)
Database Configuration	Resource Governor (5)
Database Configuration	SQL Server Configurations (75)
Database Design	Constraints (20)
Database Design	Data Types (22)
Database Design	Database Design (95)
Database Design	Identities (17)
Database Design	JOIN Tables (23)
Database Design	Synonyms (5)
Database Design	Table Valued Parameters (4)
Database Design	Temp Tables (16)
Database Design	Temporal Tables (13)
Database Design	User Defined Type UDT (3)
Database Design	Views (17)
Database Development	Application Development (54)
Database Development	Common Runtime Language (13)
Database Development	Debugging (4)
Database Development	DevOps (40)
Database Development	Entity Framework (13)
Database Development	Language Integrated Query LINQ (7)
Database Development	Paging (5)
Database Development	Referential Integrity (5)
Database Development	Service Broker (11)
Database Development	Testing (32)
Database Development	XML (15)
Database Maintenance	Database Console Commands DBCCs (25)
Database Maintenance	Fragmentation and Index Maintenance (28)
Database Maintenance	Maintenance (34)
Disaster Recovery / High Availability	Availability Groups (81)
Disaster Recovery / High Availability	Backup (81)
Disaster Recovery / High Availability	Clustering (77)
Disaster Recovery / High Availability	Database Mirroring (33)
Disaster Recovery / High Availability	Disaster Recovery (23)
Disaster Recovery / High Availability	High Availability (3)
Disaster Recovery / High Availability	Log Shipping (18)
Disaster Recovery / High Availability	Replication (78)
Disaster Recovery / High Availability	Restore (43)
Functions	Dates (56)
Functions	Functions System (99)
Functions	Functions User Defined UDF (41)
Infrastructure	Contained Databases (4)
Infrastructure	Containers (13)
Infrastructure	Hardware (13)
Infrastructure	Spatial Data Storage (9)
Infrastructure	Virtualization (25)
Integration Services Admin	Integration Services Administration (10)
Integration Services Admin	Integration Services Best Practices (12)
Integration Services Admin	Integration Services Configuration Options (22)
Integration Services Admin	Integration Services Performance (12)
Integration Services Admin	Integration Services Security (7)
Integration Services Admin	Integration Services Upgrade (4)
Integration Services Development	Data Transformation Services (6)
Integration Services Development	Integration Services Analysis Services Tasks (5)
Integration Services Development	Integration Services Connection Managers (5)
Integration Services Development	Integration Services Control Flow Transformations (14)
Integration Services Development	Integration Services Data Flow Transformations (19)
Integration Services Development	Integration Services Development (118)
Integration Services Development	Integration Services Error Handling (8)
Integration Services Development	Integration Services Excel (14)
Integration Services Development	Integration Services Execute Package Options (8)
Integration Services Development	Integration Services Oracle (4)
Microsoft Office	Microsoft Access Integration (8)
Microsoft Office	Microsoft Excel Integration (46)
Microsoft Office	Microsoft Flow (1)
Other RDBMS	Other Database Platforms (16)
Other RDBMS	PostgreSQL (16)
Other RDBMS	SQL Server and Oracle Comparison (30)
Other RDBMS	SQL Server on Linux (78)
Other RDBMS	SQL Server vs Oracle vs PostgreSQL Comparison (20)
Performance	Dynamic Management Views and Functions (34)
Performance	Error Logs (12)
Performance	Extended Events (22)
Performance	Indexing (97)
Performance	Locking and Blocking (44)
Performance	Monitoring (110)
Performance	Partitioning (17)
Performance	Performance Data Warehouse (4)
Performance	Performance Tuning (129)
Performance	Profiler and Trace (20)
Performance	Query Optimization (15)
Performance	Query Plans (20)
Performance	Query Store (9)
Power Platform	Power Apps (20)
Power Platform	Power BI (180)
Power Platform	Power BI Charts (59)
Power Platform	Power BI Formatting (17)
Professional Development	Professional Development Branding (16)
Professional Development	Professional Development Career (18)
Professional Development	Professional Development Career Planning (21)
Professional Development	Professional Development Certifications (64)
Professional Development	Professional Development Community (16)
Professional Development	Professional Development Interview Questions BI (18)
Professional Development	Professional Development Interview Questions DBA (23)
Professional Development	Professional Development Interview Questions Developer (9)
Professional Development	Professional Development Interviewing (40)
Professional Development	Professional Development Job Search (24)
Professional Development	Professional Development Management (14)
Professional Development	Professional Development Resume (13)
Professional Development	Professional Development Skills Development (18)
Python	Python (100)
Reporting Services Admin	Reporting Services Administration (21)
Reporting Services Admin	Reporting Services Best Practices (6)
Reporting Services Admin	Reporting Services Configuration (10)
Reporting Services Admin	Reporting Services Installation (10)
Reporting Services Admin	Reporting Services Migration (5)
Reporting Services Admin	Reporting Services Monitoring (5)
Reporting Services Admin	Reporting Services Network Load Balancing (4)
Reporting Services Admin	Reporting Services Performance (6)
Reporting Services Admin	Reporting Services Security (9)
Reporting Services Development	Reporting Services Analysis Services (4)
Reporting Services Development	Reporting Services Charts (25)
Reporting Services Development	Reporting Services Data Sources (10)
Reporting Services Development	Reporting Services Development (68)
Reporting Services Development	Reporting Services Dynamic Reports (11)
Reporting Services Development	Reporting Services Formatting (26)
Reporting Services Development	Reporting Services KPI (5)
Reporting Services Development	Reporting Services Overview (6)
Reporting Services Development	Reporting Services Parameters (15)
Reporting Services Development	Reporting Services Report Builder (9)
Security	Auditing and Compliance (49)
Security	Encryption (35)
Security	Security (201)
Security	SQL Injection (5)
Security	Surface Area Configuration Manager (4)
SharePoint	SharePoint (131)
SharePoint	SharePoint Administration (45)
SharePoint	SharePoint Configuration (27)
SharePoint	Sharepoint Design (46)
SharePoint	SharePoint Document Management (20)
SQL Coding	Change Data Capture (16)
SQL Coding	Common Table Expressions (5)
SQL Coding	Dynamic SQL (7)
SQL Coding	Error Handling (13)
SQL Coding	Stored Procedures (32)
SQL Coding	Transactions (10)
SQL Coding	Triggers (44)
SQL Coding	TSQL (355)
Tools	Azure Data Studio (18)
Tools	PowerShell (131)
Tools	SQL Operations Studio (11)
Tools	SQL Server Agent (96)
Tools	SQL Server Management Objects SMO (3)
Tools	SQL Server Management Studio (79)
Tools	SQL Server Management Studio Configuration (22)
Tools	SQL Server Management Studio Shortcuts (10)
Tools	Tools (35)
Versions	Deprecated Features (6)
Versions	Express Edition (16)
Versions	Install and Uninstall (33)
Versions	Licensing (4)
Versions	SQL Server 2016 (96)
Versions	SQL Server 2017 (44)
Versions	SQL Server 2019 (20)
Versions	SQL Server 2022 (21)
Versions	Upgrades and Migrations (54)