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
Last Monday, I presented a session for Pragmatic Works Training on the T's on the Microsoft's Parallel Data Warehouse. In the session, titled Recognizing the Parallel Data Warehouse (PDW) Workload, I discussed the role for MPP and PDW in the enterprise and the types of workloads that it can assist with. The abstract for the sessions … Continue reading Webcast Follow-Up: Recognizing the Parallel Data Warehouse (PDW) Workload
A few weeks back spoke at a Pragmatic Works Training on the T's on indexing that was titled 5 Ways to Improve Performance through Indexing. The abstract for the sessions is: Sometimes the hardest performance issues in your environment have simple solutions. One of these simple solutions is through properly indexing the database. In this session, we’ll look … Continue reading Q&A From “5 Ways to Improve Performance through Indexing”
It's the first Monday of September and it's time to check up on your SQL Servers. In truth, it's the second Monday, but for my peers here in the United States, it's the first Monday workday of the month. The end result, though, is this reminder post is coming a week later than usual for … Continue reading September 2013 – Monthly SQL Server Checklist
Earlier today, I presented a session for Pragmatic Works Training on the T's; which occur every Tuesday and Thursday. In the session, I talked about using SQL Audit (which is based on extended events) and building your own extended event sessions, titled Building Security Audits with Extended Events. In the session, I discussed the need for security … Continue reading Webcast Presentation Materials: Building Security Audits with Extended Events
I can't believe it's already August. I had planned to get to the lake more this year, spend more time on the deck, and countless other things that have already slipped by this summer. It's an easy trap to fall into. Just make a deal with yourself that, I'll go to the lake next weekend, … Continue reading August 2013 – Monthly SQL Server Checklist
As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work's Training on the T's, I received a large number of questions that there wasn't time to answer. Instead of just a re-cap of all of the questions, instead I've opted to put together a post per topic. Hopefully, this will … Continue reading Security Questions: Recommended Security Book
Strate SQL 