Here are all the Insider newsletters we’ve published in the past for you to enjoy!

  1. January 18th, 2022 – Nostalgic hobbies and demo on stats updates using Ola’s code
  2. January 4th, 2022 – Setting New Year resolutions and demo on Query Store Q&A
  3. December 14th, 2021 – Is the on-prem DBA role dead and demo on complex hack-attach scenario
  4. December 1st, 2021 – Weird differential backup behavior and demo on AG permissions issues
  5. November 9th, 2021 – Why no automatic index maintenance and demo on SIDs and server principals
  6. October 26th, 2021 – Carrots, eggs, and coffee beans and demo on purging large amounts of data
  7. October 12th, 2021 – Dealing with log corruption and demo on reconstructing damaged data using indexes
  8. September 29th, 2021 – New SQLskills Insider free training sessions, tuning app performance, and demo on auto-close
  9. September 15th, 2021 – New SQLskills Insider free training sessions and demo on large delete strategies
  10. September 1st, 2021 – Disappearing corruptions and demo on tuning statistics maintenance
  11. August 18th, 2021 – How I made a life change and video explaining deadlocks with memory grants
  12. June 28th, 2021 – Why learn SQL Server internals and demo on Plan Explorer and statistics
  13. June 15th, 2021 – Backup testing and demo on Query Store query plan hints
  14. June 1st, 2021 – Investing in yourself and demo on managing backup history
  15. May 18th, 2021 – Radical disaster recovery and demo on copying data between Azure SQL DBs
  16. April 27th, 2021 – Getting a guarantee and demo on Azure VM I/O throughput
  17. April 13th, 2021 – Online empathy and demo on deciphering Azure VM naming
  18. March 30th, 2021 – Workload risk assessment and demo on Query Store wait statistics
  19. March 17th, 2021 – Helping people feel seen and demo on how much log in a full backup
  20. March 2nd, 2021 – Is your app using SQL Server correctly and demo on AG read-only routing with named instances
  21. February 17th, 2021 – Thoughts on courage and demo on investigating statistics issues
  22. February 2nd, 2021 – Curious lack of motivation and demo on creating an Azure SQL DB
  23. January 19th, 2021 – Bigger isn’t better and demo on Query Store and dynamic string execution
  24. January 7th, 2021 – 2021 classes, streaming recordings, and demo on session waits via XEvents
  25. December 17th, 2020 – 2021 classes, streaming recordings, and demo on common scripts on Azure
  26. November 17th, 2020 – slow and steady perf tuning and demo on searching Query Store
  27. November 3rd, 2020 – the silent killer and demo on Elastic Job Agent
  28. October 20th, 2020 – Query Store, upgrading to 2019, and demo on 2019 Query Store
  29. October 6th, 2020 – reinventing the wheel and videos on questioning and listening
  30. September 22nd, 2020 – badges, discounts, self evaluation, and locking a database in Azure
  31. September 8th, 2020 – badges, unusual security items and demo video on Azure VM Resource Provider
  32. August 26th, 2020 – 25 years old and another demo video on Azure Serverless
  33. August 12th, 2020 – new website, fixating on a single perf metric, and demo video on Azure Serverless
  34. July 29th, 2020 – why start with wait stats and demo video comparing XEvents in Azure and on-prem
  35. July 15th, 2020 – Azure SQL Database – consistency checking and demo video on using XEvents
  36. July 1st, 2020 – on mentoring and demo video on SQL Callstack Resolver tool
  37. June 16th, 2020 – more on internals and demo video on stats defaults with Ola’s scripts
  38. June 2nd, 2020 – understanding code and demo video on new Azure MI defaults
  39. May 12th, 2020 – reaching out to others and demo video on tipping points in Plan Explorer
  40. April 28th, 2020 – importance of knowing internals and demo video on Azure performance tuning
  41. April 14th, 2020 – accepting change and demo video on new Azure compute and memory options
  42. March 31st, 2020 – taking care of you and demo video on importing a certificate
  43. March 17th, 2020 – disaster preparation and demo video on parallel crash recovery
  44. March 3rd, 2020 – application consistency checking and demo video on 2019 Showplan XML
  45. February 18th, 2020 – right way of testing and demo video on regaining SQL Server access
  46. February 4th, 2020 – Archiving data for performance and demo video on DBCC CLONEDATABASE
  47. January 21st, 2020 – Backups in Azure and demo video on certificate-based protocol encryption
  48. January 7th, 2020 – New Year resolutions and demo video on what-if? index analysis in Plan Explorer
  49. December 10th, 2019 – SQL Server 2019 and demo video on in-memory tempdb metadata tables
  50. November 26th, 2019 – importance of communication and demo video on Accelerated Database Recovery
  51. November 12th, 2019 – training styles and demo video on Azure storage performance
  52. October 29th, 2019 – 8-bit computers, information sharing, and demo video on Azure SQL Database ‘serverless’
  53. October 8th, 2019 – patching symptoms vs. removing the problem and demo video on Storage Spaces simple storage pools
  54. September 24th, 2019 – hard questions about DR testing and demo video on Geekbench 5
  55. September 10th, 2019 – SQL Server 2019 and demo video on 2019 Query Store options
  56. August 27th, 2019 – procrastination and demo video on migrating/upgrading SSRS
  57. August 13th, 2019 – removing duplicate indexes and demo video on IMOLTP query statistics
  58. July 30th, 2019 – importance of testing and demo video on Query Tuning Assistant
  59. June 18th, 2019 – performance troubleshooting and demo video on auto-scaling in Azure SQL Database
  60. June 4th, 2019 – support, DBAs, and video on new AMD processors
  61. May 21st, 2019 – wrong things to do regularly and demo video on notebooks in Azure data Studio
  62. May 7th, 2019 – 200! Is the on-premises DBA role dying and our six favorite demo videos from Pluralsight courses
  63. April 22nd, 2019 – Bigger is not always better and demo video on Distributed Reply misconfigurations
  64. April 8th, 2019 – Avoiding building Artificial Stupidity and video on new Xeon processors
  65. March 26th, 2019 – Workload characteristic analysis and demo on ad hoc vs. parameterized queries
  66. March 12th, 2019 – Maps and mapping and demo on using STOPAT with RESTORE
  67. February 26th, 2019 – Staying up-to-date with Azure and demo on columnstore segment elimination
  68. February 12th, 2019 – Generator woes, slow AG/FCI failovers, and demo on columnstore vs. rowstore
  69. January 29th, 2019 – Upgrading without performance surprises and demo on columnstore index statistics
  70. January 15th, 2019 – New Year resolutions and demo on missing indexes for all databases
  71. December 18th, 2018 – Looking forward to 2019, new Power BI class, and demo on Azure Query Performance Insight
  72. December 4th, 2018 – unkillable processes and demo on the Azure Data Discovery and Classification tool
  73. November 19th, 2018 – 2019 Q1 online classes, Thanksgiving, and demo on the Azure Vulnerability Assessment tool
  74. November 6th, 2018 – NUMA configuration issues and demo on short-circuiting scalar UDF execution
  75. October 23rd, 2018 – 4-day Azure class, coping with failed upgrades, and demo on copying an Azure SQL Database
  76. October 9th, 2018 – Spring 2019 classes, procrastination, and demo on shrink considerations
  77. September 25th, 2018 – Groupthink stiffling change and demo on getting traceflag info from query plans
  78. September 10th, 2018 – Misconstrued wait types and demo on getting UDF info using Extended Events
  79. August 27th, 2018 – Difference between locks and latches and demo on recovering from a lost tempdb path
  80. July 23rd, 2018 – Removing duplicate indexes and demo on missing UDF info in showplanXML
  81. July 9th, 2018 – Reinventing the wheel and demo on multiple UPDATE plans in Query Store
  82. June 25th, 2018 – New live, online classes, reducing code-change risk and demo on Dynamic Data Masking
  83. June 11th, 2018 – New live, online classes, preemptive waits and demo on SQL Operations Studio
  84. May 29th, 2018 – Out-of-the-box ways to recover data and demo on recovering data from nonclustered indexes
  85. May 14th, 2018 – Tuning application performance and demo on tempdb spill info
  86. April 30th, 2018 – Using CONTINUE_AFTER_ERROR and demo on common database mirroring problems
  87. April 16th, 2018 – Asking questions correctly, Query Store class, and demo on inter-database Service Broker use
  88. April 2nd, 2018 – New online Query Store class, using COPY_ONLY for backups, and video on migrating a database to an Azure Managed Instance
  89. March 19th, 2018 – problems using read committed isolation and video on viewing statistics used by the Optimizer
  90. February 26th, 2018 – preventing DBAs from doing their jobs and video on using PERSIST_SAMPLE_PERCENT
  91. February 12th, 2018 – poor vendor advice and video on using sys.dm_db_stats_histogram
  92. January 29th, 2018 – problems with critical SQL Agent jobs and video on checking Spectre/Meltdown patch status
  93. January 15th, 2018 – making error logs smaller,
    why shrink can be so slow, and video on tracking In-Memory OLTP memory usage
  94. January 2nd, 2018 – considerations for the New Year,
    FILESTREAM problems, and video on configuring log shipping using SSMS
  95. December 18th, 2017 -announcing our live, online training, new features in Azure, and video on wait statistics in Query Store
  96. December 4th, 2017 – data center recovery and video on observer overhead affecting performance
  97. November 21st, 2017 – doing things because they’ve always been done, Thanksgiving, and video on differential backup sizes
  98. November 6th, 2017 – radical disaster recovery, partitioning, and video on expressing yourself properly
  99. October 23rd, 2017 – application session settings and video on nonclustered index seeks
  100. October 9th, 2017 – asking questions and video on operator execution statistics
  101. September 25th, 2017 – knowing what you’re doing and video on configuring Distributed AGs
  102. August 15th, 2017 – the silent killer and video on Azure VM metrics
  103. July 31st, 2017 – side-effects of enabling features and video on the SSMS diagnostic add-in
  104. July 17th, 2017 – misconceptions around recovery interval and checkpoints and video on indexing for in-memory tables
  105. June 19th, 2017 – environment security and video on parallelism inhibitors
  106. June 5th, 2017 – keeping up-to-date for free and video on Azure SQL Database maintenance
  107. May 22nd, 2017 – database snapshots hidden problems and video on Azure SQL Database maintenance
  108. May 8th, 2017 – removing logging overhead, VM misconfiguration, and video on Azure SQL Database maintenance
  109. April 24th, 2017 – fear of making changes, hidden duplicate indexes, and video on decompiling CLR assemblies
  110. April 10th, 2017 – Database space savings without compression and video on automatic AG seeding
  111. March 27th, 2017 – Azure cost savings, importance of baselines and video on bypassing an active trigger
  112. March 13th, 2017 – control pages, getting a guarantee, and video on using the Data Migration Assistant
  113. February 27th, 2017 – trace flag 1448, processor issues, and video on In-Memory OLTP
  114. February 13th, 2017 – problems from temp table usage and video on using the Query Store for testing cardinality estimator changes
  115. January 30th, 2017 – importance of having a performance baseline and video on using the new Azure DTU calculator
  116. January 16th, 2017 – setting and reviewing goals and video on forcing service with an AG failover
  117. December 19th, 2016 – monitoring SQL Server memory and video on monitoring memory
  118. December 5th, 2016 – SQL Server 2016 memory and processor choice and video on optimal restore sequences
  119. November 21st, 2016 – feature additions to Standard Edition and video on using the Geekbench 4 tool
  120. November 7th, 2016 – application consistency checking and video on table creation internals
  121. October 24th, 2016 – problems with Windows Server 2016 processor choice and video on 2014 query execution statistics
  122. October 10th, 2016 – problems with VM core/socket configuration and video on SSISDB in an AG
  123. September 26th, 2016 – optimizer buffer pool knowledge and video on using bacpacs
  124. September 12th, 2016 – understanding code and video on using Plan Explorer index analysis
  125. August 29th, 2016 – ints and bigints and video on using Extended Events histogram targets
  126. July 18th, 2016 – upgrade pros and cons and video on using query store to test compatibility modes
  127. July 5th, 2016 – mirroring/AG redo queues and video on tracking delayed truncation
  128. June 20th, 2016 – trace flags, internals, and more and video on storage vendor tools
  129. June 6th, 2016 – online empathy and video on using 2016 query store to force plans
  130. May 23rd, 2016 – going beyond ‘the answer’ and video on using DBCC CHECKCONSTRAINTS
  131. May 9th, 2016 – waits, transactions, operator internals, and video on Azure tier scaling
  132. April 25th, 2016 – automatic page repair and video on concurrent statistics updates
  133. April 11th, 2016 – end of an era and video on performance of indexing methods
  134. March 28th, 2016 – backups and de-duplication and video on 2016 tempdb spill warnings
  135. March 14th, 2016 – consistency checking of AG replicas and video on the dangers of TRUSTWORTHY
  136. February 29th, 2016 – dealing with log corruption and video on using DTU Calculator for Azure SQL Database
  137. February 15th, 2016 – curious empty pages in heaps and video on using DiskSpd
  138. February 1st, 2016 – clustering and mirroring and video on debugging memory leaks
  139. January 18th, 2016 – performance metrics and video on downloading debug symbols
  140. January 4th, 2016 – setting and reviewing goals and video on debugging lock escalation problems
  141. December 14th, 2015 – fragmentation Q&A and video on predicate pushdown diagnostics
  142. November 30th, 2015 – HA/DR technologies causing blocking and video on execution plans
  143. November 9th, 2015 – performance monitoring of HA/DR technologies and demo on the new Query Store feature
  144. October 26th, 2015 – more on fanout, CHECKDB bug fixes, and testing, and demo on @@VERSION changes
  145. October 12th, 2015 – index fanout considerations and demo on low-priority lock waits
  146. September 28th, 2015 – tempdb log problems and demo on converting scalar UDFs to inline TVFs
  147. September 14th, 2015 – carrots, eggs, and coffee beans and demo on XEvents histograms
  148. August 31st, 2015 – unusual security considerations and demo on CPU-Z benchmarking
  149. August 17th, 2015 – log shipping performance problems and demo on 2016 Stretch Database
  150. August 3rd, 2015 – hardware and software developments and demo on tracking page splits
  151. July 6th, 2015 – evaluating your SQL skills and demo on incremental statistics
  152. June 22nd, 2015 – perils of waiting for SP1 and demo on data compression
  153. June 8th, 2015 – page file size and demo on backing up to a URL
  154. May 25th, 2015 – backup strategies and demo on using CrystalDiskMark
  155. May 11th, 2015 – fragmentation and flash drives and demo on 2014 backup encryption
  156. April 27th, 2015 – dangerous SQL Server options and demo on the effects of AutoClose
  157. April 13th, 2015 – Larry Toothman, #SQLFamily, and demo on compensation log records
  158. March 30th, 2015 – on mentoring and demo on triggers with CDC
  159. March 16th, 2015 – DBCC CHECKDB tidbits and demo on adding tempdb data files
  160. March 2nd, 2015 – focus! and demo on using sp_rev_login
  161. February 16th, 2015 – monkeys, bananas and demo on AGs using named instances
  162. February 2nd, 2015 – 100! Special edition with 100 hints and tips and demo on delayed durability
  163. January 19th, 2015 – purging unwanted data and demo on incremental statistics
  164. January 5th, 2015 – reflections on goals and demo on measuring sequential I/O performance
  165. December 22nd, 2014 – Happy Holidays!
  166. December 8th, 2014 – procrastination and demo on query plan operators with columnstore indexes
  167. November 24th, 2014 – delayed durability and demo on using OFFSET/FETCH
  168. November 10th, 2014 – the butterfly effect and PASStv session recordings
  169. October 27th, 2014 – jumping too quickly, 2015 classes, and demo on finding hidden plan costs with Extended Events
  170. October 13th, 2014 – hidden cost of readable secondaries and demo on reverse order deadlocks
  171. September 29th, 2014 – dangers of changing recovery model and video on plan invalidation causes
  172. September 15th, 2014 – business continuity and demo on global trace flags
  173. August 18th, 2014 – tempdb allocation usage internals and demo on join order forcing problems
  174. August 4th, 2014 – precision questioning and demo on using framing with window functions
  175. July 21st, 2014 – transaction rollbacks, differential backups, and another demo on included columns
  176. July 7th, 2014 – proactive performance monitoring and demo on included columns
  177. June 23rd, 2014 – Knee-jerk troubleshooting and demo on plan cache investigation
  178. June 9th, 2014 – Emergency preparedness and demo on using Extended Event predicates correctly
  179. May 27th, 2014 – Adding data files to tempdb correctly and demo on examining instance config options
  180. May 12th, 2014 – Reducing code-change risk and demo on page split internals
  181. April 28th, 2014 – Automatic features and demo video on sort operators in query plans
  182. April 14th, 2014 – Security, security, security!
  183. March 31st, 2014 – Magic numbers and demo video on a simple server monitoring system
  184. March 17th, 2014 – Slowing down and demo video on investigating CPU-utilization issues on VMware
  185. March 3rd, 2014 – SQL Server instance sprawl and demo video on investigating FGCB_ADD_REMOVE latch contention
  186. February 17th, 2014 – Setting a challenge for yourself and demo video on using Service Broker
  187. February 3rd, 2014 – Management causing DBA problems and demo video on Lock Pages In Memory
  188. January 20th, 2014 – Preventing DBAs from doing their job and demo video on statistics updates and query plan recompilations
  189. January 6th, 2014 – Critical Agent jobs and demo video on Plan Explorer and missing indexes
  190. December 9th, 2013 – Why we’re looking forward to 2014 and demo video on enabling database mail
  191. November 25th, 2013 – Trace flags everyone should use and demo video on using older backups to retrieve deleted data
  192. November 11th, 2013 – Why learn how SQL Server works and demo video on using the missing index DMVs
  193. October 28th, 2013 – Hard questions about practicing DR and demo video on Extended Events templates
  194. October 14th, 2013 – Index rebuild and reorganize differences and demo video on implicit conversions
  195. September 30th, 2013 – Making consistency checks run faster and demo video on recovering from data purity errors
  196. September 16th, 2013 – More on the MCM program cancellation, staggered index maintenance, and demo video on using query hashes
  197. September 3rd, 2013 – Microsoft kills the MCM program, consistency checking bug, and demo video on enabling instant file initialization
  198. August 19th, 2013 – Outside-the-box waits analysis and demo video on tempdb space usage
  199. August 5th, 2013 – ASYNC_NETWORK_IO wait type and demo video on parallel crash recovery
  200. July 22nd, 2013 – Filtering benign wait types and demo video on SSMS Object Explorer features
  201. July 8th, 2013 – ‘Disappearing’ corruptions and demo video on undetectable performance problems
  202. June 24th, 2013 – Making restores go faster and demo video on data compression
  203. June 10th, 2013 – Easy wasted key/index/fragmented space removal and demo on finding duplicate statistics
  204. May 28th, 2013 – Data compression, new classes, and demo showing deferred-drop behavior
  205. May 13th, 2013 – Invalid tail-of-the-log backups and demo on the tsql_stack Extended Events action
  206. April 29th, 2013 – Using CONTINUE_AFTER_ERROR and demo video on DISTINCT aggregate improvements
  207. April 15th, 2013 – Lesser-known Enterprise features and demo video on SSMS features
  208. April 1st, 2013 – I/O latency monitoring and demo video on recreating log files on database attach
  209. March 18th, 2013 – Why shrink may run so slowly and demo video on moving from SQL Trace to XEvents
  210. March 4th, 2013 – The benefits of multiple filegroups and demo video on the system_health XEvent session
  211. February 18th, 2013 – CXPACKET waits and demo video on linked servers and statistics
  212. February 4th, 2013 – Undocumented commands and demo video on Microsoft Data Link
  213. January 21st, 2013 – Deferred deallocation and demo video on sys.dm_db_stats_properties
  214. January 7th, 2013 – SQL Server resolutions and demo video on recreating missing log files on attach
  215. December 10th, 2012 – High-availability strategy requirements and demo video on indexing strategies
  216. November 26th, 2012 – Application performance tuning and demo video on Windows Server 2012 Task Manager
  217. November 12th, 2012 – Monitoring mirroring and demo video on regaining instance access without downtime
  218. October 29th, 2012 – Extended Events and demo video on regaining instance access without the sysadmin role
  219. October 15th, 2012 – Performance baselining and video on EXECUTE AS and SQL injection
  220. October 1st, 2012 – Crash recovery and demo video on setting PerfMon default counters
  221. September 17th, 2012 – Provisioning new hardware, 2013 Immersion Events, and cardinality-estimate issues
  222. September 4th, 2012 – SQLskills training online, taking risks, and SQL Agent cluster failover
  223. August 20th, 2012 – Finding and removing duplicate indexes
  224. August 6th, 2012 – Being too thinly spread and demo video on DBCC CHECKDB and rolled-back transactions
  225. July 23rd, 2012 – Paralyzing fear of change and demo video 3 on Distributed Replay
  226. July 9th, 2012 – Certification changes and demo video 2 on Distributed Replay
  227. June 25th, 2012 – Home-grown DBAs and demo video on Distributed Replay
  228. June 11th, 2012 – SQLskills online training, virus recovery, and demo video on semantic search
  229. May 28th, 2012 – Reinventing the wheel and demo video on the SSMS Tools Pack
  230. May 14th, 2012 – Avoiding quicksand and demo video on wait statistics
  231. April 30th, 2012 – Dealing with system databases and demo video on Process Explorer
  232. April 16th, 2012 – Default blame acceptors and demo video on 2012 Extended Events UI
  233. April 3rd, 2012 – Re-evaluating operational practices and video on snapshot isolation
  234. March 19th, 2012 – Hidden gems in your team and demo video on Plan Explorer
  235. March 5th, 2012 – The value of certifications and demo video on SQL Nexus
  236. February 20th, 2012 – Incorrect consistency checking and demo video on PerfMon tricks
  237. February 6th, 2012 – Problematic vendor configuration guidance and demo video on the free PAL tool
  238. January 23rd, 2012 – Getting past ‘the answer’ and lecture video on indexing strategies
  239. January 9th, 2012 – Learning about SQL Server and demo video on troubleshooting common VM issues
  240. December 26th, 2011 – Work-life balance, 2012 UK classes and video on communication skills
  241. December 12th, 2011 – Making use of automation and demo video on deadlock debugging
  242. November 28th, 2011 – Bigger hardware is NOT always a good solution and demo/lecture video on partitioning
  243. November 14th, 2011 – Outside-the-box with Resource Governor and demo video on query timeout debugging
  244. October 31st, 2011 – Blocking without locking and demo video on deadlock analysis
  245. October 17th, 2011 – Partitioning fundamentals and demo video on tempdb space tracking
  246. October 3rd, 2011 – Automated SQL features and demo video on fully logged operations
  247. September 20th, 2011 – Common temp table misuse and demo video on the inconsistent analysis problem
  248. September 4th, 2011 – Instance-wide fillfactor and demo videos on corruption recovery
  249. August 21st, 2011 – Data center recovery and demo video on error log management
  250. August 7th, 2011 – Corruption response and demo video on tail-log backups
  251. July 24th, 2011 – Backup testing and demo video on undroppable log files
  252. July 10th, 2011 – Pros and cons of upgrading and demo video on database snapshots
  253. June 26th, 2011 – Log record removal and demo video on wait stats for a single operation
  254. June 12th, 2011 – Normalization and demo video on tempdb latch contention
  255. May 29th, 2011 – Communication and demo video on trusting the tools
  256. May 15th, 2011 – (Un)trustworthy information and demo video on checkpoint tracking
  257. May 5th, 2011 – Head-in-the-sand log management and demo video on nested transactions
  258. April 21st, 2011 – Cloud overload and demo video on log file performance analysis
  259. April 7th, 2011 – Guarantees, Polar Bears, and demo video on undocumented DBCC commands
  260. March 22nd, 2011 – Knee-jerk performance tuning and demo video on SELECT-INTO logging
  261. March 9th, 2011 – SSDs and fragmentation, and demo video on RESTORE WITH RESTART

And here is the myths and misconceptions whitepaper.

[]