Latest Blog Posts
- We sent out a final you haven’t paid for lunch reminder on Wed, asked for a reply if they were planning to bring their own. 20 or so are, so far. We don’t mind that they do of course, but it’s really valuable information because it’s another block of…
I said that I’d write about some good things PASS does, and I’ll make it a point to do so. Despite my complaints and criticisms, I like the organization. I’ve been a part of it since October 1999, when the initial conference was in the basement ballroom of a hotel… Read more
Just a quick post this time. I had a requirement to convert a small number of UK based postcodes to their latitude/longitude locations so I could use that data within some Tableau dashboards that I’m working on. I had a look around to see what I could find and quickly… Read more
About six months ago, I wrote a post reviewing a book titled The Phoenix Project. In that post, I compared the events in the book to my experiences in my role as a production DBA. I also shared some ideas that I gained from the book to help improve… Read more
SQL Server 2014 Cardinality Estimator
I don’t want to get too deeply involved in the complaints and struggles of PASS, but I also want to ensure we have a healthy community. I want to have us continue to grow and prosper as data professionals who work with SQL Server. PASS has a mission, and it… Read more
Not for me, and perhaps not for you, but you can still encourage Jason Strate, Gareth Swanepoel, Ed Watson, and Kristen Benzel to go under the needle. If we raise $25,000 for Doctors without Borders, they’ll get tattoos.
We’re over the $10,000 mark, so we’re already going to have… Read more
PASS has taken a lot of heat recently. A few folks have pointed out that you only seem to hear when people are upset at PASS at something. So here’s my take on what PASS has done correctly.
Having very recently gone through the nomination process for the PASS Board, I thought I would share a few things about it. Overall, it was a great experience. I feel that I really had to stretch to meet everything required of me. It was quite difficult to put together all… Read more
Registration count after some cancellations now at 577, way above my goal of 500. We’ve decided not to spend on LinkedIn this week, our numbers are good and we’re not thinking it would drive a lot. Tough call. I’d like to find out, but agree it’s money we can spend… Read more
For a SQL Server guy it sometimes amazes me how often I’m in and out of batch files and how truly useful they can be. To that end here is all that I can remember about batch files (basically a text file that ends with .bat). Everyone seemed to like… Read more
We had a disaster at SQLServerCentral this past weekend. It wasn’t a big disaster, but it was an event that required a restore of data.
An Administrative Error
On Saturday, I was attending SQL Saturday #331 in Denver. In between my sessions, I was prepping a few demos and finished… Read more
Just a brief note to say that I will be voting for Grant Fritchey for the PASS Board and I encourage you to do the same. I have corresponded with Grant from time to time for several years and I know him to be an outstanding individual. He has authored… Read more
Last week before our monthly MagicPASS meeting I went through my usual routine of grabbing the PASS chapter deck and noticed that there are no slides mentioning the upcoming Board of Directors elections. I'm surprised because the elections are a great discussion topic for people who might not otherwise be… Read more
First, a reminder/disclaimer that I am serving on the PASS NomCom this year. The four candidates in the election are all qualified, I have no debate with that. I’ve waited until the slate was posted to make any public comment about the election. None of my comments here are based… Read more
Lately I have been using more and more the awesomeness of the Alt-button in SQL Server Management Studio (SSMS). What do I mean with this? While holding the Alt-button on your keyboard, you can select a block of text instead of lines of text.
Note that this is not an… Read more
The latest update to my book, SQL Server Query Performance Tuning was released last week. This is the fourth edition of the book, and the third edition that I’ve been responsible for. At the urging of my editor, Jonathan Gennick, I have completely restructured the book for this release. The… Read more