Microsoft's Analytic Platform System (APS) has been a favorite platform of mine over the last few years. It provides a solution to many of the scale and performance concerns that exist with right-sizing a data warehouse for today and tomorrow. One of the interesting nuances of the platform is the lack of documentation and client tools … Continue reading Download Analytic Platform System Tools and Books Online
I've wrapped up my session at my first session at this year's PASS Summit. My session this Thursday was The Plan Cache Whisperer: Performance Tuning SQL Server [DBA-313]. The session appears to have gone really well and the content has been uploaded to the PASS Summit for download. To provide access to the materials now, the slide deck … Continue reading PASS Summit Session Follow-up: The Plan Cache Whisperer
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
Earlier this year, my buddy Dan recommended that I read The Checklist Manifesto: How to Get Things Right. The recommendation was actually more of a demand. When we had been talking about my need to increase the productivity of my time, he wanted me to drop everything and read this now. Exactly what a busy … Continue reading Book Review: The Checklist Manifesto: How to Get Things Right
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
When you are an aspiring DBA, there are many things that come with that job role that you’ll have to consider as part of the job. You will need to look at disaster recovery, high availability, platform performance, security and a variety of other areas that are critical to the keeping the platform up and … Continue reading One Piece of Advice For the Aspiring DBA #DBAJumpStart
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?
Strate SQL 