Here are all the Insider newsletters we’ve published in the past for you to enjoy!
- May 26th, 2026 – Workload risk analysis, differential backup size issues, tempdb space governing in 2025, and more
- May 5th, 2026 – Proactive monitoring, replication issues, time-limited XEvent sessions, and more
- April 14th, 2026 – Getting a guarantee, duplicate indexes, decompiling CLR, and more
- March 30th, 2026 – Physical security considerations, TDE, log shipping config, and more
- March 17th, 2026 – When enough is enough, March Madness sale, demo on memory tracking, and more
- March 3rd, 2026 – The trap of big numbers, March Madness sale, demo on spinlock statistics, and more
- February 17th, 2026 – Brand new SQL 2025 course, a major personal milestone, and more
- February 4th, 2026 – The Joy of Aha! moments, demo on optimization statistics in query plans, and more
- January 20th, 2026 – Graphics and micro-goals, demo on JSON performance 2025, and more
- January 6th, 2026 – New… Year resolutions, Kimberly&Joe podcast, 2025 course, 2025 book review, and more
- December 17th, 2025 – New SQL Server 2025 course, real-life disaster prep at Camp Savage, December sale
- December 2nd, 2025 – We’re back, Joe’s back, new courses, December sale
- March 20th, 2025 – Too many things to do, books, sale, and more
- February 25th, 2025 – New Year Goals, message from Kimberly, books, and more
- Don’t know what happened here – I skipped 283 by accident!
- December 30th, 2024 – Looking forward to 2025, books, and more
- November 21st, 2024 – Not reinventing the wheel, demo on log in a backup, and more
- October 30th, 2024 – Repairing symptoms vs problem, tempdb recovery demo, and more
- October 24th, 2024 – (Mini) Unusual security considerations and more
- October 17th, 2024 – Ransomware attacks, Black Friday sale, and video on Vulnerability Assessment Tool
- January 3rd, 2024 – New Year resolutions and lots on wait statistics
- November 15th, 2023 – Black Friday sale, importance of communication and video on Server Audit
- August 8th, 2023 – building confidence, Blackbelt Base Camp, and video on Server Audit
- June 26th, 2023 – knowing *why*, Blackbelt sale, and video on blogging
- June 12th, 2023 – proactive monitoring, self-service health checks, and demo on SQL Server Audit filtering
- April 18th, 2023 – application consistency checking, Easter sale, and favorite demos from Pluralsight
- March 30th, 2023 – important life change, Easter sale, and introductory demo on SQL Server Audit
- January 10th, 2023 – 2022 review before starting on 2023 and demo on 2022 backup metadata enhancements
- November 28th, 2022 – EOY massive sale, 2023 classes, SQL Server Community, and demo on lock escalation debugging
- October 31st, 2022 – Summer fun at camp, PASS, and demo on corruption
- July 5th, 2022 – Log shipping performance and demo on DBCC CHECKCONSTRAINTS
- June 13th, 2022 – Backup strategy and demo on restore sequences
- May 26th, 2022 – Knowing what you’re doing and demo on scripting statistics in SSMS
- March 9th, 2022 – Index key size and depth considerations and demo on 2019 inline scalar UDFs
- February 22nd, 2022 – Consistency checking with AGs and demo on log backups and log clearing
- February 9th, 2022 – Business continuity and demo on getting stats from query plans
- January 18th, 2022 – Nostalgic hobbies and demo on stats updates using Ola’s code
- January 4th, 2022 – Setting New Year resolutions and demo on Query Store Q&A
- December 14th, 2021 – Is the on-prem DBA role dead and demo on complex hack-attach scenario
- December 1st, 2021 – Weird differential backup behavior and demo on AG permissions issues
- November 9th, 2021 – Why no automatic index maintenance and demo on SIDs and server principals
- October 26th, 2021 – Carrots, eggs, and coffee beans and demo on purging large amounts of data
- October 12th, 2021 – Dealing with log corruption and demo on reconstructing damaged data using indexes
- September 29th, 2021 – New SQLskills Insider free training sessions, tuning app performance, and demo on auto-close
- September 15th, 2021 – New SQLskills Insider free training sessions and demo on large delete strategies
- September 1st, 2021 – Disappearing corruptions and demo on tuning statistics maintenance
- August 18th, 2021 – How I made a life change and video explaining deadlocks with memory grants
- June 28th, 2021 – Why learn SQL Server internals and demo on Plan Explorer and statistics
- June 15th, 2021 – Backup testing and demo on Query Store query plan hints
- June 1st, 2021 – Investing in yourself and demo on managing backup history
- May 18th, 2021 – Radical disaster recovery and demo on copying data between Azure SQL DBs
- April 27th, 2021 – Getting a guarantee and demo on Azure VM I/O throughput
- April 13th, 2021 – Online empathy and demo on deciphering Azure VM naming
- March 30th, 2021 – Workload risk assessment and demo on Query Store wait statistics
- March 17th, 2021 – Helping people feel seen and demo on how much log in a full backup
- March 2nd, 2021 – Is your app using SQL Server correctly and demo on AG read-only routing with named instances
- February 17th, 2021 – Thoughts on courage and demo on investigating statistics issues
- February 2nd, 2021 – Curious lack of motivation and demo on creating an Azure SQL DB
- January 19th, 2021 – Bigger isn’t better and demo on Query Store and dynamic string execution
- January 7th, 2021 – 2021 classes, streaming recordings, and demo on session waits via XEvents
- December 17th, 2020 – 2021 classes, streaming recordings, and demo on common scripts on Azure
- November 17th, 2020 – slow and steady perf tuning and demo on searching Query Store
- November 3rd, 2020 – the silent killer and demo on Elastic Job Agent
- October 20th, 2020 – Query Store, upgrading to 2019, and demo on 2019 Query Store
- October 6th, 2020 – reinventing the wheel and videos on questioning and listening
- September 22nd, 2020 – badges, discounts, self evaluation, and locking a database in Azure
- September 8th, 2020 – badges, unusual security items and demo video on Azure VM Resource Provider
- August 26th, 2020 – 25 years old and another demo video on Azure Serverless
- August 12th, 2020 – new website, fixating on a single perf metric, and demo video on Azure Serverless
- July 29th, 2020 – why start with wait stats and demo video comparing XEvents in Azure and on-prem
- July 15th, 2020 – Azure SQL Database – consistency checking and demo video on using XEvents
- July 1st, 2020 – on mentoring and demo video on SQL Callstack Resolver tool
- June 16th, 2020Â – more on internals and demo video on stats defaults with Ola’s scripts
- June 2nd, 2020Â – understanding code and demo video on new Azure MI defaults
- May 12th, 2020Â – reaching out to others and demo video on tipping points in Plan Explorer
- April 28th, 2020Â – importance of knowing internals and demo video on Azure performance tuning
- April 14th, 2020Â – accepting change and demo video on new Azure compute and memory options
- March 31st, 2020Â – taking care of you and demo video on importing a certificate
- March 17th, 2020Â – disaster preparation and demo video on parallel crash recovery
- March 3rd, 2020Â – application consistency checking and demo video on 2019 Showplan XML
- February 18th, 2020Â – right way of testing and demo video on regaining SQL Server access
- February 4th, 2020Â – Archiving data for performance and demo video on DBCC CLONEDATABASE
- January 21st, 2020Â – Backups in Azure and demo video on certificate-based protocol encryption
- January 7th, 2020Â – New Year resolutions and demo video on what-if? index analysis in Plan Explorer
- December 10th, 2019Â – SQL Server 2019 and demo video on in-memory tempdb metadata tables
- November 26th, 2019Â – importance of communication and demo video on Accelerated Database Recovery
- November 12th, 2019Â – training styles and demo video on Azure storage performance
- October 29th, 2019Â – 8-bit computers, information sharing, and demo video on Azure SQL Database ‘serverless’
- October 8th, 2019Â – patching symptoms vs. removing the problem and demo video on Storage Spaces simple storage pools
- September 24th, 2019Â – hard questions about DR testing and demo video on Geekbench 5
- September 10th, 2019Â – SQL Server 2019 and demo video on 2019 Query Store options
- August 27th, 2019Â – procrastination and demo video on migrating/upgrading SSRS
- August 13th, 2019Â – removing duplicate indexes and demo video on IMOLTP query statistics
- July 30th, 2019Â – importance of testing and demo video on Query Tuning Assistant
- June 18th, 2019Â – performance troubleshooting and demo video on auto-scaling in Azure SQL Database
- June 4th, 2019Â – support, DBAs, and video on new AMD processors
- May 21st, 2019Â – wrong things to do regularly and demo video on notebooks in Azure data Studio
- May 7th, 2019Â – 200! Is the on-premises DBA role dying and our six favorite demo videos from Pluralsight courses
- April 22nd, 2019Â – Bigger is not always better and demo video on Distributed Reply misconfigurations
- April 8th, 2019Â – Avoiding building Artificial Stupidity and video on new Xeon processors
- March 26th, 2019Â – Workload characteristic analysis and demo on ad hoc vs. parameterized queries
- March 12th, 2019Â – Maps and mapping and demo on using STOPAT with RESTORE
- February 26th, 2019Â – Staying up-to-date with Azure and demo on columnstore segment elimination
- February 12th, 2019Â – Generator woes, slow AG/FCI failovers, and demo on columnstore vs. rowstore
- January 29th, 2019Â – Upgrading without performance surprises and demo on columnstore index statistics
- January 15th, 2019Â – New Year resolutions and demo on missing indexes for all databases
- December 18th, 2018Â – Looking forward to 2019, new Power BI class, and demo on Azure Query Performance Insight
- December 4th, 2018Â – unkillable processes and demo on the Azure Data Discovery and Classification tool
- November 19th, 2018Â – 2019 Q1 online classes, Thanksgiving, and demo on the Azure Vulnerability Assessment tool
- November 6th, 2018Â – NUMA configuration issues and demo on short-circuiting scalar UDF execution
- October 23rd, 2018Â – 4-day Azure class, coping with failed upgrades, and demo on copying an Azure SQL Database
- October 9th, 2018Â – Spring 2019 classes, procrastination, and demo on shrink considerations
- September 25th, 2018Â – Groupthink stiffling change and demo on getting traceflag info from query plans
- September 10th, 2018Â – Misconstrued wait types and demo on getting UDF info using Extended Events
- August 27th, 2018Â – Difference between locks and latches and demo on recovering from a lost tempdb path
- July 23rd, 2018Â – Removing duplicate indexes and demo on missing UDF info in showplanXML
- July 9th, 2018Â – Reinventing the wheel and demo on multiple UPDATE plans in Query Store
- June 25th, 2018Â – New live, online classes, reducing code-change risk and demo on Dynamic Data Masking
- June 11th, 2018Â – New live, online classes, preemptive waits and demo on SQL Operations Studio
- May 29th, 2018Â – Out-of-the-box ways to recover data and demo on recovering data from nonclustered indexes
- May 14th, 2018Â – Tuning application performance and demo on tempdb spill info
- April 30th, 2018Â – Using CONTINUE_AFTER_ERROR and demo on common database mirroring problems
- April 16th, 2018Â – Asking questions correctly, Query Store class, and demo on inter-database Service Broker use
- April 2nd, 2018Â – New online Query Store class, using COPY_ONLY for backups, and video on migrating a database to an Azure Managed Instance
- March 19th, 2018Â – problems using read committed isolation and video on viewing statistics used by the Optimizer
- February 26th, 2018Â – preventing DBAs from doing their jobs and video on using PERSIST_SAMPLE_PERCENT
- February 12th, 2018Â – poor vendor advice and video on using sys.dm_db_stats_histogram
- January 29th, 2018Â – problems with critical SQL Agent jobs and video on checking Spectre/Meltdown patch status
- January 15th, 2018Â – making error logs smaller, why shrink can be so slow, and video on tracking In-Memory OLTP memory usage
- January 2nd, 2018Â – considerations for the New Year, FILESTREAM problems, and video on configuring log shipping using SSMS
- December 18th, 2017Â -announcing our live, online training, new features in Azure, and video on wait statistics in Query Store
- December 4th, 2017Â – data center recovery and video on observer overhead affecting performance
- November 21st, 2017Â – doing things because they’ve always been done, Thanksgiving, and video on differential backup sizes
- November 6th, 2017Â – radical disaster recovery, partitioning, and video on expressing yourself properly
- October 23rd, 2017Â – application session settings and video on nonclustered index seeks
- October 9th, 2017Â – asking questions and video on operator execution statistics
- September 25th, 2017Â – knowing what you’re doing and video on configuring Distributed AGs
- August 15th, 2017Â – the silent killer and video on Azure VM metrics
- July 31st, 2017Â – side-effects of enabling features and video on the SSMS diagnostic add-in
- July 17th, 2017Â – misconceptions around recovery interval and checkpoints and video on indexing for in-memory tables
- June 19th, 2017Â – environment security and video on parallelism inhibitors
- June 5th, 2017Â – keeping up-to-date for free and video on Azure SQL Database maintenance
- May 22nd, 2017Â – database snapshots hidden problems and video on Azure SQL Database maintenance
- May 8th, 2017Â – removing logging overhead, VM misconfiguration, and video on Azure SQL Database maintenance
- April 24th, 2017Â – fear of making changes, hidden duplicate indexes, and video on decompiling CLR assemblies
- April 10th, 2017Â – Database space savings without compression and video on automatic AG seeding
- March 27th, 2017Â – Azure cost savings, importance of baselines and video on bypassing an active trigger
- March 13th, 2017Â – control pages, getting a guarantee, and video on using the Data Migration Assistant
- February 27th, 2017Â – trace flag 1448, processor issues, and video on In-Memory OLTP
- February 13th, 2017Â – problems from temp table usage and video on using the Query Store for testing cardinality estimator changes
- January 30th, 2017Â – importance of having a performance baseline and video on using the new Azure DTU calculator
- January 16th, 2017Â – setting and reviewing goals and video on forcing service with an AG failover
- December 19th, 2016Â – monitoring SQL Server memory and video on monitoring memory
- December 5th, 2016Â – SQL Server 2016 memory and processor choice and video on optimal restore sequences
- November 21st, 2016Â – feature additions to Standard Edition and video on using the Geekbench 4 tool
- November 7th, 2016Â – application consistency checking and video on table creation internals
- October 24th, 2016Â – problems with Windows Server 2016 processor choice and video on 2014 query execution statistics
- October 10th, 2016Â – problems with VM core/socket configuration and video on SSISDB in an AG
- September 26th, 2016Â – optimizer buffer pool knowledge and video on using bacpacs
- September 12th, 2016Â – understanding code and video on using Plan Explorer index analysis
- August 29th, 2016Â – ints and bigints and video on using Extended Events histogram targets
- July 18th, 2016Â – upgrade pros and cons and video on using query store to test compatibility modes
- July 5th, 2016Â – mirroring/AG redo queues and video on tracking delayed truncation
- June 20th, 2016Â – trace flags, internals, and more and video on storage vendor tools
- June 6th, 2016Â – online empathy and video on using 2016 query store to force plans
- May 23rd, 2016Â – going beyond ‘the answer’ and video on using DBCC CHECKCONSTRAINTS
- May 9th, 2016Â – waits, transactions, operator internals, and video on Azure tier scaling
- April 25th, 2016Â – automatic page repair and video on concurrent statistics updates
- April 11th, 2016Â – end of an era and video on performance of indexing methods
- March 28th, 2016Â – backups and de-duplication and video on 2016 tempdb spill warnings
- March 14th, 2016Â – consistency checking of AG replicas and video on the dangers of TRUSTWORTHY
- February 29th, 2016Â – dealing with log corruption and video on using DTU Calculator for Azure SQL Database
- February 15th, 2016Â – curious empty pages in heaps and video on using DiskSpd
- February 1st, 2016Â – clustering and mirroring and video on debugging memory leaks
- January 18th, 2016Â – performance metrics and video on downloading debug symbols
- January 4th, 2016Â – setting and reviewing goals and video on debugging lock escalation problems
- December 14th, 2015Â – fragmentation Q&A and video on predicate pushdown diagnostics
- November 30th, 2015Â – HA/DR technologies causing blocking and video on execution plans
- November 9th, 2015Â – performance monitoring of HA/DR technologies and demo on the new Query Store feature
- October 26th, 2015Â – more on fanout, CHECKDB bug fixes, and testing, and demo on @@VERSION changes
- October 12th, 2015Â – index fanout considerations and demo on low-priority lock waits
- September 28th, 2015Â – tempdb log problems and demo on converting scalar UDFs to inline TVFs
- September 14th, 2015Â – carrots, eggs, and coffee beans and demo on XEvents histograms
- August 31st, 2015Â – unusual security considerations and demo on CPU-Z benchmarking
- August 17th, 2015Â – log shipping performance problems and demo on 2016 Stretch Database
- August 3rd, 2015Â – hardware and software developments and demo on tracking page splits
- July 6th, 2015Â – evaluating your SQL skills and demo on incremental statistics
- June 22nd, 2015Â – perils of waiting for SP1 and demo on data compression
- June 8th, 2015Â – page file size and demo on backing up to a URL
- May 25th, 2015Â – backup strategies and demo on using CrystalDiskMark
- May 11th, 2015Â – fragmentation and flash drives and demo on 2014 backup encryption
- April 27th, 2015Â – dangerous SQL Server options and demo on the effects of AutoClose
- April 13th, 2015Â – Larry Toothman, #SQLFamily, and demo on compensation log records
- March 30th, 2015Â – on mentoring and demo on triggers with CDC
- March 16th, 2015Â – DBCC CHECKDB tidbits and demo on adding tempdb data files
- March 2nd, 2015Â – focus! and demo on using sp_rev_login
- February 16th, 2015Â – monkeys, bananas and demo on AGs using named instances
- February 2nd, 2015Â – 100! Special edition with 100 hints and tips and demo on delayed durability
- January 19th, 2015Â – purging unwanted data and demo on incremental statistics
- January 5th, 2015Â – reflections on goals and demo on measuring sequential I/O performance
- December 22nd, 2014Â – Happy Holidays!
- December 8th, 2014Â – procrastination and demo on query plan operators with columnstore indexes
- November 24th, 2014Â – delayed durability and demo on using OFFSET/FETCH
- November 10th, 2014Â – the butterfly effect and PASStv session recordings
- October 27th, 2014Â – jumping too quickly, 2015 classes, and demo on finding hidden plan costs with Extended Events
- October 13th, 2014Â – hidden cost of readable secondaries and demo on reverse order deadlocks
- September 29th, 2014Â – dangers of changing recovery model and video on plan invalidation causes
- September 15th, 2014Â – business continuity and demo on global trace flags
- August 18th, 2014Â – tempdb allocation usage internals and demo on join order forcing problems
- August 4th, 2014Â – precision questioning and demo on using framing with window functions
- July 21st, 2014Â – transaction rollbacks, differential backups, and another demo on included columns
- July 7th, 2014Â – proactive performance monitoring and demo on included columns
- June 23rd, 2014Â – Knee-jerk troubleshooting and demo on plan cache investigation
- June 9th, 2014Â – Emergency preparedness and demo on using Extended Event predicates correctly
- May 27th, 2014Â – Adding data files to tempdb correctly and demo on examining instance config options
- May 12th, 2014Â – Reducing code-change risk and demo on page split internals
- April 28th, 2014Â – Automatic features and demo video on sort operators in query plans
- April 14th, 2014Â – Security, security, security!
- March 31st, 2014Â – Magic numbers and demo video on a simple server monitoring system
- March 17th, 2014Â – Slowing down and demo video on investigating CPU-utilization issues on VMware
- March 3rd, 2014Â – SQL Server instance sprawl and demo video on investigating FGCB_ADD_REMOVE latch contention
- February 17th, 2014Â – Setting a challenge for yourself and demo video on using Service Broker
- February 3rd, 2014Â – Management causing DBA problems and demo video on Lock Pages In Memory
- January 20th, 2014Â – Preventing DBAs from doing their job and demo video on statistics updates and query plan recompilations
- January 6th, 2014Â – Critical Agent jobs and demo video on Plan Explorer and missing indexes
- December 9th, 2013Â – Why we’re looking forward to 2014 and demo video on enabling database mail
- November 25th, 2013Â – Trace flags everyone should use and demo video on using older backups to retrieve deleted data
- November 11th, 2013Â – Why learn how SQL Server works and demo video on using the missing index DMVs
- October 28th, 2013Â – Hard questions about practicing DR and demo video on Extended Events templates
- October 14th, 2013Â – Index rebuild and reorganize differences and demo video on implicit conversions
- September 30th, 2013Â – Making consistency checks run faster and demo video on recovering from data purity errors
- September 16th, 2013Â – More on the MCM program cancellation, staggered index maintenance, and demo video on using query hashes
- September 3rd, 2013Â – Microsoft kills the MCM program, consistency checking bug, and demo video on enabling instant file initialization
- August 19th, 2013Â – Outside-the-box waits analysis and demo video on tempdb space usage
- August 5th, 2013Â – ASYNC_NETWORK_IO wait type and demo video on parallel crash recovery
- July 22nd, 2013Â – Filtering benign wait types and demo video on SSMS Object Explorer features
- July 8th, 2013 – ‘Disappearing’ corruptions and demo video on undetectable performance problems
- June 24th, 2013Â –Â Making restores go faster and demo video on data compression
- June 10th, 2013 –Â Easy wasted key/index/fragmented space removal and demo on finding duplicate statistics
- May 28th, 2013Â – Data compression, new classes, and demo showing deferred-drop behavior
- May 13th, 2013Â – Invalid tail-of-the-log backups and demo on the tsql_stack Extended Events action
- April 29th, 2013Â –Â Using CONTINUE_AFTER_ERROR and demo video on DISTINCT aggregate improvements
- April 15th, 2013Â –Â Lesser-known Enterprise features and demo video on SSMS features
- April 1st, 2013Â –Â I/O latency monitoring and demo video on recreating log files on database attach
- March 18th, 2013Â –Â Why shrink may run so slowly and demo video on moving from SQL Trace to XEvents
- March 4th, 2013 – The benefits of multiple filegroups and demo video on the system_health XEvent session
- February 18th, 2013Â – CXPACKET waits and demo video on linked servers and statistics
- February 4th, 2013Â – Undocumented commands and demo video on Microsoft Data Link
- January 21st, 2013Â – Deferred deallocation and demo video on sys.dm_db_stats_properties
- January 7th, 2013Â – SQL Server resolutions and demo video on recreating missing log files on attach
- December 10th, 2012Â – High-availability strategy requirements and demo video on indexing strategies
- November 26th, 2012Â – Application performance tuning and demo video on Windows Server 2012 Task Manager
- November 12th, 2012Â – Monitoring mirroring and demo video on regaining instance access without downtime
- October 29th, 2012Â – Extended Events and demo video on regaining instance access without the sysadmin role
- October 15th, 2012Â – Performance baselining and video on EXECUTE AS and SQL injection
- October 1st, 2012Â – Crash recovery and demo video on setting PerfMon default counters
- September 17th, 2012Â – Provisioning new hardware, 2013 Immersion Events, and cardinality-estimate issues
- September 4th, 2012Â – SQLskills training online, taking risks, and SQL Agent cluster failover
- August 20th, 2012Â – Finding and removing duplicate indexes
- August 6th, 2012Â – Being too thinly spread and demo video on DBCC CHECKDB and rolled-back transactions
- July 23rd, 2012Â – Paralyzing fear of change and demo video 3 on Distributed Replay
- July 9th, 2012Â – Certification changes and demo video 2 on Distributed Replay
- June 25th, 2012Â – Home-grown DBAs and demo video on Distributed Replay
- June 11th, 2012Â – SQLskills online training, virus recovery, and demo video on semantic search
- May 28th, 2012Â – Reinventing the wheel and demo video on the SSMS Tools Pack
- May 14th, 2012Â – Avoiding quicksand and demo video on wait statistics
- April 30th, 2012Â – Dealing with system databases and demo video on Process Explorer
- April 16th, 2012Â – Default blame acceptors and demo video on 2012 Extended Events UI
- April 3rd, 2012Â – Re-evaluating operational practices and video on snapshot isolation
- March 19th, 2012Â – Hidden gems in your team and demo video on Plan Explorer
- March 5th, 2012Â – The value of certifications and demo video on SQL Nexus
- February 20th, 2012Â – Incorrect consistency checking and demo video on PerfMon tricks
- February 6th, 2012Â – Problematic vendor configuration guidance and demo video on the free PAL tool
- January 23rd, 2012Â – Getting past ‘the answer’ and lecture video on indexing strategies
- January 9th, 2012Â – Learning about SQL Server and demo video on troubleshooting common VM issues
- December 26th, 2011Â – Work-life balance, 2012 UK classes and video on communication skills
- December 12th, 2011Â – Making use of automation and demo video on deadlock debugging
- November 28th, 2011Â – Bigger hardware is NOT always a good solution and demo/lecture video on partitioning
- November 14th, 2011Â – Outside-the-box with Resource Governor and demo video on query timeout debugging
- October 31st, 2011Â – Blocking without locking and demo video on deadlock analysis
- October 17th, 2011Â – Partitioning fundamentals and demo video on tempdb space tracking
- October 3rd, 2011Â – Automated SQL features and demo video on fully logged operations
- September 20th, 2011Â – Common temp table misuse and demo video on the inconsistent analysis problem
- September 4th, 2011Â – Instance-wide fillfactor and demo videos on corruption recovery
- August 21st, 2011Â – Data center recovery and demo video on error log management
- August 7th, 2011Â – Corruption response and demo video on tail-log backups
- July 24th, 2011Â – Backup testing and demo video on undroppable log files
- July 10th, 2011Â – Pros and cons of upgrading and demo video on database snapshots
- June 26th, 2011Â – Log record removal and demo video on wait stats for a single operation
- June 12th, 2011Â – Normalization and demo video on tempdb latch contention
- May 29th, 2011Â – Communication and demo video on trusting the tools
- May 15th, 2011Â – (Un)trustworthy information and demo video on checkpoint tracking
- May 5th, 2011Â – Head-in-the-sand log management and demo video on nested transactions
- April 21st, 2011Â – Cloud overload and demo video on log file performance analysis
- April 7th, 2011Â – Guarantees, Polar Bears, and demo video on undocumented DBCC commands
- March 22nd, 2011Â – Knee-jerk performance tuning and demo video on SELECT-INTO logging
- March 9th, 2011Â – SSDs and fragmentation, and demo video on RESTORE WITH RESTART
And here is the myths and misconceptions whitepaper.