In my previous life I was a production DBA which meant my primary responsibility was recovery. I also took my job role to be that of a general SQL Server expert. I stayed general because no one person can possible be an expert in every facet under the SQL Umbrella. A few years ago I [...]
Many of you have some awareness regarding the 24 Hours of PASS events that I have helped to promote previously. When I was asked to help arrange for the upcoming event I targeted the list of current Summit speakers. This made logical sense to me since we want to make it a Summit preview. So [...]
I returned from Nashville yesterday, having been there for four days to take part in SQL Saturday as well as the most recent in-face PASS Board meetings. This was my first ever trip to Nashville and I had really just one goal in mind as a tourist: to find some good music. I managed to [...]
Just about one year ago PASS launched a brand new concept in training: 24 consecutive one hour presentations done live by remote presenters around the globe. I still remember the PASS board meeting when Rick Heiges (blog | twitter) suggested the format. Some were skeptical but overall we mostly said “Do you think that can [...]
We wanted to bring our bikes on vacation this year, so that we could ride as a family along the Cape Cod Rail Trail. We needed a bike rack for the four bikes, but before that we needed to have a hitch put on our car. So we made an appointment to have the work [...]
I have been giving presentations of one form or another for many years now. In fact, you could go back to my days in college when I took a public speaking course, and that was half a lifetime ago (but it is still relevant). Over the years I have learned a handful of things when [...]
In case you missed it I wanted to let everyone know that we are planning on doing our third 24 Hours of PASS. I sent out a call for abstracts recently to the people that have been selected to present at the PASS Summit in November (about 70 people in total). I got back about [...]
Welcome back to SQL University. This week the topic is capacity planning. As your DBA Coach it is my role to help you understand the different levels for the subject at hand. Capacity planning is a subject that applies to just about everything in life; how much money is left in your bank account, how [...]
Welcome back to this week’s installment for SQL University. The topic this time is all about indexing. I know, I know. It sounds incredibly exciting, right? I mean, what could possibly be more exciting than a comprehensive review of a B-tree? Or a lively discussion about having a heap or a clustered index?
Lots of things, [...]
I have been working for Confio Software for almost six full weeks now. Two of those weeks I was on the road, which means I have been working at the office for the other four weeks. And by “at the office” I mean “the spare bedroom located next to my bedroom that was redesigned by [...]