One of my all-time favorite times of the year happens to be the Christmas Season. I enjoy 
the season because it is supposed to remind us to try and be better people. And for me, it does help. In all honesty, it should be a better effort year round, but this is a good time of year to try and get back on track and to try and focus more on other more important things.
For me, one of the more important things is to try and help others. Focusing on other people and their needs helps them but also helps one’s self. It is because of the focus on others that I enjoy, not just Christmas Day, but also the 12 Days of Christmas.
The 12 Days of Christmas is about giving for 12 Days. Though, in this day and age, most view it as a span of 12 Days in which they are entitled to receive gifts. If we are giving for a mere 12 Days and not focusing on receiving, then wouldn’t we all be just a little bit happier? I know that when I focus more on the giving I am certainly happier.
Giving
In the spirit of the 12 Days of Christmas and Giving, I have a 12 Day series that I generally try to do each Holiday Season. The series will generally begin on Christmas day to align with the actual 12 Days of Christmas (rather than the adopted tradition of ending on Christmas). This also means that the series will generally end on the celebration of “Twelfth Night” which is January 5th.
Each annual series will include several articles about SQL Server and have a higher goal of trying to learn something more about SQL Server. Some articles may be deep technical dives, while others may prove to be more utilitarian with a script or some functionality that can be quickly put to use and frequently used. Other articles may just be for fun. In all, there will be several articles which I hope will bring some level of use for those that read while they strive to become better at this thing called SQL Server.
This page will serve as a landing page for each of the annual series and will be updated as new articles are added.
2019
- Find Index Create Date – 25 December 2019
- Index Audit Changes – 26 December 2019
- Easy Audit Index Changes – 27 December 2019
- Where is that Mask? – 28 December 2019
- What is the Merit of the Job? – 29 December 2019
- Get a List of Files with Data – 30 December 2019
- Negative Port Numbers – 31 December 2019
- Cannot Open Backup Device – 1 January 2020
- Creative Database Naming – 2 January 2020
- Creative Extended Event Sessions – 3 January 2020
- Creative XE Sessions – Funky Data – 4 January 2020
- Unicode, Emojis and Databases Oh My! – 5 January 2020
2018
- How To: XEvents as Profiler – 25 December 2018
- Upgrading From SQL Server Profiler – 26 December 2018
- How To: File Target use in Extended Events – 27 December 2018
- SQL Servers Black Box Recorder – Def Trace – 28 December 2018
- SQL Servers Black Box Recorder – system_health – 29 December 2018
- SQLs Black Box Recorder – sp_server_diagnostics – 30 December 2018
- Finding Installed Event Sessions – 31 December 2018
- Finding Application Session Settings – 1 January 2019
- Checking Your Memory with XE – 2 January 2019
- Event Tracing for Windows Target – 3 January 2019
- Automatic Tuning Monitoring and Diagnostics – 4 January 2019
- Short Circuiting Your Session – 5 January 2019
2017
- XE Permissions – 25 December 2017
- Best New(ish) SSMS Feature – 26 December 2017
- XE System Messages – 27 December 2017
- Correlate Trace and XE Events – 28 December 2017
- Audit Domain Group and User Permissions – 29 December 2017
- An Introduction to Templates – 30 December 2017
- Failed to Create the Audit File – 31 December 2017
- Correlate SQL Trace and Actions – 1 January 2018
- Dynamics AX Event Session – 2 January 2018
- Sharepoint Diagnostics and XE – 3 January 2018
- Change Default Logs Directory – 4 January 2018
- Common Tempdb Trace Flags – Back to Basics (Day of Feast) – 5 January 2018
2015
- Failed – 25 December 2015
- Failed – 26 December 2015
- Failed – 27 December 2015
- Failed – 28 December 2015
- Failed – 29 December 2015
- Log Files from Different Source – 30 December 2015
- Customize XEvent Log Display – 31 December 2015
- Filtering Logged Data – 1 January 2016
- Hidden GUI Gems – 2 January 2016
- Failed – 3 January 2016
- Failed – 4 January 2016
- A Day in the Stream – 5 January 2016
2013
- Las Vegas Invite – 25 December 2013
- SAN Outage – 26 December 2013
- Peer to Peer Replication – 27 December 2013
- Broken Broker – 28 December 2013
- Peer Identity – 29 December 2013
- Lost in Space – 30 December 2013
- Command N Conquer – 31 December 2013
- Ring in the New Year – 1 January 2014
- Queries Going Boom – 2 January 2014
- Retention of XE Session Data in a Table – 3 January 2014
- Purging syspolicy – 4 January 2014
- High CPU and Bloat in Distribution – 5 January 2014
2012 (pre-Christmas)
- Maint Plan Logs – 13 December 2012
- Service Broker Out of Control – 14 December 2012
- Backup, Job and Mail History Cleanup – 15 December 2012
- Exercise for msdb – 16 December 2012
- Table Compression – 17 December 2012
- Maintenance Plan Gravage – 18 December 2012
- Runaway Jobs – 19 December 2012
- SSRS Schedules – 20 December 2012
- Death and Destruction, err Deadlocks – 21 December 2012
- Virtual Storage – 22 December 2012
- Domain Setup – 23 December 2012
- SQL Cluster on Virtual Box – 24 December 2012
