This T-SQL Tuesday is brought to us by Jens Vestergaard (b | t), and we are asked to share our favorite SQL Server tools. Hint Profiler will not be on the list. But where do you start there are so many tools out there. In alphabetical order here are my top
Problem For good database design, it is not idea to have everything in your PRIMARY filegroup so you can do partial backups, piecemeal restores, and for performance to separate your tables and indexes. You need different filegroups when looking at separating your indexes and tables and partitioning. Creating all these
I had two SQL Saturdays this month SQLSaturday Chicago and SQLSaturday Rochester both of which were very cold. Hopefully, the winter SQLSaturdays are over, for now, I want it to be spring and see no more snow for awhile. I know I’m a baby, but I’m used to North Carolina
Problem I’ve noticed on demo machines that sometimes Telegraf doesn’t start on the first try, and this seems to not happen on most of my production servers, but they have a lot more memory and CPU power. So I figured I would write a quick blog post and provide a
I had two SQL Saturdays this month SQLSaturday Cleveland (which was very cold) and SQLSaturday Tampa (which had very nice weather). Now for the adventurous parts of both trips. Well besides worrying about snow, Cleveland was in Hyland Software and there was the really cool slide that I may or may not have went down 6
Problem We need a way to collect performance metrics for all our SQL Servers (Windows and Linux) into one system and display that information in a way our DBAs can read it. Also, we would like to keep the cost down. I know this blog looks really long and may
This month Aaron Bertrand (b | t) has given us a Dealer’s Choice on the T-SQL Tuesday topic. I’m of course going to take the chance to talk about something I’m passionate about. It’s not something people would consider fun but it’s what I enjoy spending my spare time on. Warning
We Speak Linux I am super excited to be to have launched this website. We Speak Linux is a place for Windows Administrators and SQL Server DBAs to learn more about the Linux operating system. There are plenty of good sources for information about Linux on the internet, but with
vs. The week of SQLSaturday Nashville would prove to be a most eventful week. Monday I would be on my work to work riding on a two-lane road a dump truck would decide to turn into the passenger side of the car. Thankfully no one was hurt. But it did result
Earlier this week the folks at PASS reached out to last year’s speakers asking us to share a story of how speaking at PASS impacted us professionally or personally. At first we I received the email saying I had been selected I was at a speaker’s dinner for a SQL