This past Tuesday, I got a chance to speak at the Minnesota SQL Server User Group. It was a great turn out and I wish I had more time to stay for the happy hour. I'll definitely need to make more meetings than I do, specially since I am traveling less now. My topic for … Continue reading PASSMN Presentation Follow-Up: Strategies for SQL Server Index Analysis
It's time for a monthly reminder to review you SQL Server environment. Hopefully over the last few months of this post not being published you've still been going through and performing your monthly SQL Server environment checklists. As with anything, just because it appears to be running well, doesn't mean that there isn't an unknown … Continue reading May 2015 – SQL Server Monthly Maintenance Checklist
In the past year, I've done a few presentations for Pragmatic Works Training on the T’s. If you aren't familiar with Training on the T's, it is a free training program offered by Pragmatic Works that delivers hour long training sessions over lunch on every Tuesday and Thursday. Right now there are more than 340 sessions available … Continue reading 12 Webcasts from Pragmatic Works Training On The T’s
The holidays are upon us and it's the first Monday in December. That means it's time once again to take a look at your SQL Server environment and verify that things are where you want it to be. And where you need it to be. The aim is to be sure that while SQL Server … Continue reading December 2013 – Monthly SQL Server Checklist
This month, Jorge Segarra (Blog | @SQLChicken) is running T-SQL Tuesday on the cloud. T-SQL Tuesday is a monthly blogging event where a number of us in the SQL Server community gets together to blog on a central topic. As mentioned, the topic is on the cloud, or as Jorge put it: Cloud. It’s the juggernaut buzzword in … Continue reading T-SQL Tuesday – Cloud Atlas – #TSQL2sDay
Earlier this month, I presented a session for Pragmatic Works Training on the T's on the selecting the clustered index for a table in a SQL Server database. In the session, titled How Do Non-Clustered Indexes Improve Performance?, in this session I discussed the patterns around non-clustered indexes and why you might choose which patterns for … Continue reading Webcast Follow-Up: How Do Non-Clustered Indexes Improve Performance?
Earlier this month, I presented a session for Pragmatic Works Training on the T's on the selecting the clustered index for a table in a SQL Server database. In the session, titled Choosing Your Clustered Index, in this session I discussed the patterns around choosing clustered indexes and why you might choose one pattern over another. … Continue reading Webcast Follow-Up: Choosing Your Clustered Index
It's not the first Monday of October, instead it's the second Tuesday (oops, had Wednesday in here originally). As we are all busy from time to time, last week's post managed to slip my mind. I was wrapped up with preparing for a birthday and Parallel Data Warehouse training. Many of you, though, are probably … Continue reading October 2013 – Monthly SQL Server Checklist
I'm not old, but I did turn 40 today. If you ask my kids, they are likely to say that I've gotten crabby over the past few years. I haven't shaken my fist at any pesky teenagers, but I've sure complained about thumping cars a time or two. Since a birthday is a time for … Continue reading I’m 40 and I’ve Had Enough
With today's SQL Server instances, there easily be anywhere from a dozen to a hundred databases on a single SQL Server instance. In fact, on my laptop, I currently have almost two dozen databases and these are just from working on projects. Setup a SharePoint server and add a few sites and you'll easily see … Continue reading Can You Dig It? – Find All Plans for a Database
Strate SQL 