Jared Westover

Jared Westover is a SQL Server specialist with two decades of industry experience covering T-SQL development, performance tuning, administration and Microsoft Fabric. He is currently a software architect at Crowe, an author at Pluralsight and primary contributor at sqlhabits.com.  On MSSQLTips.com, Jared is a respected award-winning author for his clever T-SQL solutions and bringing to light new real-world solutions to age-old development problems.
  • MSSQLTips Awards
    • Achiever Award (75+ tips) - 2026
    • Author of the Year - 2023
    • Author Contender - 2024/2025
Title Category Date
Temporary Tables in a Microsoft Fabric Warehouse Microsoft Fabric2026-05-20
SQL Server Isolation Level Comparison – Repeatable Read and Snapshot Isolation Performance Tuning2026-05-19
Get Started with SQL Server Query Store Query Store2026-05-18
Picking the ON or WHERE Clause for the SQL Predicate Performance Tuning2026-05-14
Using REGEXP_COUNT to Count Strings in SQL Server 2025 SQL Server 20252026-05-13
Shred JSON Data into Rows and Columns with T-SQL TSQL2026-05-10
SQL Server OPTION RECOMPILE for Simple Queries Performance Tuning2026-05-04
Make Deployable SQL Scripts Idempotent Application Development2026-03-18
How NTILE Handles Uneven Row Distribution in SQL TSQL2026-03-07
Inline Scalar UDFs in Fabric Warehouses – Part 1 Microsoft Fabric2026-03-06
Simple Way to Calculate Running Totals in SQL Server TSQL2026-03-06
Using Python to Run SQL Against Fabric Warehouses Python2026-03-06
Monitor SQL Server Performance at Scale with SQLGrease Monitoring2026-03-03
The Hidden Work Behind SELECT TOP in SQL Server TSQL2026-02-25
When to use DENSE_RANK instead of SQL RANK TSQL2026-02-12
SSMS 22 Productivity Tips Video SQL Server Management Studio2026-01-23
Using REGEXP_LIKE in SQL Server 2025 SQL Server 20252026-01-12
Find Missing SQL Server Data with NOT EXISTS TSQL2025-12-17
Controlling SQL Window Functions with Framing TSQL2025-12-01
Inline Scalar UDFs vs. Inline Code Performance Comparison in Fabric Warehouses – Part 2 Microsoft Fabric2025-10-02
Microsoft Fabric vs Azure SQL Database Performance Comparison Azure SQL Database2025-07-28
Reduce SQL Server Deadlocks with a Clustered Index Locking and Blocking2025-07-16
Understanding Concurrency Limits of Microsoft Fabric Data Warehouses Microsoft Fabric2025-05-28
SQL Rank Functions – ROW_NUMBER, RANK, DENSE_RANK, NTILE TSQL2025-05-26
Restrict User Query Access in SQL Server Security2025-05-15
SQL Export to Excel via Power BI XMLA Power BI2025-04-16
Foreign Keys and Performance in a Microsoft Fabric Warehouse Microsoft Fabric2025-03-19
DAX CASE Statement Functionality using IF, SWITCH and SWITCH True Power BI2025-02-26
Add New Columns Versus New Table in SQL Server Database Design2025-02-04
SQL CASE Statement in JOIN Clause TSQL2025-01-15
SQL Databases in Fabric Microsoft Fabric2025-01-13
Troubleshoot Chained SQL Server CTE Common Table Expressions2025-01-02
Monitor SQL Server Performance and Daily Operations with dbWatch Monitoring2025-01-01
Build Polymorphic Associations in SQL Server with Foreign Keys Database Design2024-12-06
Convert Excel Workbooks to CSV with Microsoft Fabric Microsoft Fabric2024-11-20
Calculate a Moving Average with T-SQL Windowing Functions TSQL2024-11-13
Limit Cost Threshold for Parallelism for Small SQL Queries Database Administration2024-10-28
SQL Combine Multiple Columns – UNPIVOT, UNION ALL vs CROSS APPLY TSQL2024-09-30
Uncover SQL Server Missing Indexes Performance Tuning2024-09-11
Cost Threshold for Parallelism Affects SQL Server Missing Indexes Performance Tuning2024-08-22
SQL Local Variables and Performance Issues Performance Tuning2024-07-31
Reduce SQL Server Blocking with READ_COMMITTED_SNAPSHOT Locking and Blocking2024-07-18
Add Indexes to Improve SQL DELETE Performance Indexing2024-06-26
Prevent Duplicate Records in SQL using Filtered Index Indexing2024-06-19
Replace SQL Cursors with Set Based Operations – OUTPUT and MERGE TSQL2024-05-30
SQL Server Temporary Tables – Local and Global Examples Temp Tables2024-05-07
SQL Server Temporary Stored Procedures Stored Procedures2024-04-29
Replace a SQL WHILE Loop with Set Based Logic in T-SQL TSQL2024-04-09
Pass Parameters to SQLQueryStress for SQL Server Performance Tuning Performance Tuning2024-03-21
Manipulate Strings in SQL Server with REPLACE, TRIM, STUFF, CHARINDEX TSQL2024-03-05
Free Azure SQL Managed Instance Azure SQL Managed Instance2024-02-09
How to Get Started with an Azure SQL Managed Instance Migration Azure SQL Managed Instance2024-01-16
Performance Impact of SQL Server Check Constraints Constraints2023-12-07
Recursive Common Table Expression in SQL Server Examples Common Table Expressions2023-11-21
SQL Server Table Design Guide – Data Types, Primary Keys and more Database Design2023-11-01
SQL Server Index Fragmentation Considerations with Modern Hardware Fragmentation and Index Maintenance2023-10-10
SQL Pivot and Unpivot Data using T-SQL Code TSQL2023-09-22
Using SQL Server Database Snapshots to Quickly Revert a Database Backup2023-09-13
Rebuild Indexes in SQL Server Options and Potential Impacts Indexing2023-08-28
SQL Server Columnstore Indexes Tuple Mover Background Process Indexing2023-08-14
SQL Server Triggers versus Temporal Tables for Data Changes in a Table Change Data Capture2023-07-27
Selecting Azure SQL Managed Instance vs. Azure SQL Database Azure SQL Managed Instance2023-07-05
SQL Server Ordered Columnstore Indexes to Improve Data Warehouse Perfo Indexing2023-06-19
Insight into Rowstore and Columnstore Indexes in SQL Server Database Design2023-06-08
Replace Text in SQL Server Strings using REPLACE and TRANSLATE TSQL2023-04-19
Return TOP (N) Rows in SQL using APPLY or ROW_NUMBER() Functions TSQL2023-04-11
SQL MERGE vs INSERT, UPDATE, DELETE Performance Considerations TSQL2023-03-08
Filtered Indexes Ignored in SQL Server Indexing2023-02-16
SQL Server ROW_NUMBER Ranking Function that Returns a Row Rank Value Functions System2023-02-08
SQL Server Filtered Indexes for Multi Table SQL Join Explained Indexing2023-01-23
Covering Index in SQL Server with Key and Non-Key Columns Indexing2023-01-11
Determine SQL Server Page Counts for Tables, Indexes and Objects Database Design2022-12-09
SELECT COUNT FROM SQL Server Examples and Statistics Functions System2022-11-16
SQL RAISERROR for Error Handling During Code Execution Error Handling2022-11-03
Design SQL Server Indexes for Faster Query Performance Indexing2022-10-20
SQL Server THROW for Error Handling Error Handling2022-10-11
SQL Transaction Examples when Modifying Data in SQL Server Tables Transactions2022-09-27
Tune SQL Server Stored Procedures and Indexes with SqlQueryStress Performance Tuning2022-09-19
Options to Compare Data from Two SQL Server Tables TSQL2022-09-06
SQL CONVERT, CAST, TRY_CAST, TRY_CONVERT and TRY_PARSE Examples Functions System2022-08-30
Find Mismatched SQL Server Data Between Two Tables TSQL2022-08-15
SQL Server Stored Procedure Debug Logic for Execution Problems Stored Procedures2022-08-02
SQL Server Table Compression – Page, Columnstore and Archive Compression2022-07-22
Random Date Generator in SQL Server Dates2022-07-12