It's the first Monday of the October and it's time to do a monthly checkup. If you are like me, you may be headed out to the PASS Summit next week and a vacation the week after. That means that the checklist is even more important this month for me, because there will be other … Continue reading October Monthly SQL Server Checklist
First day of the month and first Tuesday of the month. Yup, the list is late this month because for myself, and probably a fair number of other readers, Monday was a holiday. First day back this month, though, and it's time to check up on everything and make certain that we are earning our … Continue reading September Monthly SQL Server Checklist
Follow the rest of this series at the Can You Dig It? - Plan Cache series introduction post. It’s been a while since the last plan cache series post. In the last few posts, I was focusing on specific attributes. Instead of continuing on that vein, I want to cover a use case that fit … Continue reading Can You Dig It? – Researching Index Scans
First day of the month and first Monday of the month. The list is coming out a bit late due to these, hopefully you were more on top of this that I was. As I mentioned back in June, the premise of this post is help DBAs maintain their environments by getting together a monthly … Continue reading August Monthly SQL Server Checklist
It’s a new month, and time to check out your SQL Servers to make sure everything is configured and working properly. Originally, I had planned to put this out on the first Monday of every month. The trouble is, yesterday was a US holiday and I was likely jet skiing. Did I just give away … Continue reading July Monthly SQL Server Checklist
Tomorrow is time for part two of my presentations this month on Extended Events for the PASS DBA Virtual Chapter. If you missed the first part of this series, you can watch it before hand here. Below are the details on the event and the session description… Extended Events, Work Smarter Not Harder – Part … Continue reading PASS DBA Virtual Chapter Tomorrow
I’ve thought about doing this for a while now and it seems to be about that time. It’ll be a small list to start with, but I’ll add more in the months ahead. Part of the reason I plan to start small is I’ll be adding companion pieces to this list as time goes on. … Continue reading June Monthly SQL Server Checklist
Use extended events; they work - and make you appear magical. -- "Write a SQL blog post in 11 words or less" via Thomas Larock (Blog | @SQLRockStar)
About a year ago, I started playing around with CLR and my desire to disable xp_cmdshell for my clients. As a result, I had created the CodePlex project FileSystemHelper. I blogged about it back then and had meant to get back to it with a number of updates but that never really happened. Along the … Continue reading FileSystemHelper Update and Release
A few PASS Summit’s ago, I became interested in the information available in the Plan Cache. As part of that interest, I started digging into the plan cache to find out what is there and available to be pulled out. Some of those investigations led to a few presentations; which have in turn led to … Continue reading Can You Dig It? – Plan Cache Series
Strate SQL 