Today, Pluralsight published my latest course, “SQL Server: Common Query Tuning Problems and Solutions – Part 2“. Part two is 2 hours and 17 minutes long
Pluralsight published my latest course, “SQL Server: Common Query Tuning Problems and Solutions – Part 1“. Part 1 is 2 hours and 31 minutes and
I am really happy to announce that Kimberly Tripp and I will be delivering a post-conference in November’s SQLIntersection conference at the MGM Grand. The
I’ve been working on writing a new Microsoft white paper since January covering the main changes made in the SQL Server 2014 Cardinality Estimator, and
Consider a scenario where your application timeout setting is 30 seconds and you’ve been asked to proactively start tuning workloads that are at risk of
I uploaded the deck from my session for SQLSaturday #287 Madison 2014 and you can download it here. It was an excellent event! Great organizers,
In SQL Server 2014 CTP2 in the AdventureWorks2012 database, execute the following batch: The first query uses the legacy cardinality estimator and the second query
If you’re in the area, just a heads-up that I’ll be speaking at the following events: PASSMN Minnesota SQL Server User GroupLocation: 3601 West 76th
Consider the following scenario: You want to migrate all databases on a specific SQL Server instance to a new SQL Server 2014 instance You want
Testing on SQL Server 2014, CTP2, version 12.0.1524, imagine you have two databases – one called T1 and one called T2 configured with database compatibility
Today Pluralsight published my new course, “SQL Server: Transact-SQL Common Table Expressions”. This is a demo-centric, short course on how to create and use common
The SQL Server 2005 “Performance Tuning and Optimization (Full-Text Search)” books online topic has the following recommendation: “Combine multiple CONTAINS predicates into one CONTAINS predicate.
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.