Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Latest Blog Posts

SQLSaturday Orlando Marketing Plan-Part 47


  • 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…

Read more

0 comments, 76 reads

Posted in SQLAndy on 25 September 2014

An Amazing Conference

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

0 comments, 4,441 reads

Posted in The Voice of the DBA on 25 September 2014

Convert UK Postcode to Latitude/Longitude/Northing/Easting using SQL CLR

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

0 comments, 79 reads

Posted in SQL Server Rocks! on 25 September 2014

Presto Chango

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

6 comments, 67 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 25 September 2014

SQL Server 2014 Cardinality Estimator

SQL Server 2014 Cardinality Estimator

The SQL Server 2014 cardinality estimator has been improved to increase the quality of SQL Server query plans in both OLTP and data warehousing solutions.  The cardinality of a field refers to the number of unique values that are populated in the table.  Gender would…

Read more

0 comments, 133 reads

Posted in Business Intelligence and Enterprise Architecture on 25 September 2014

Taking control of the ‘sa’ account for SQL Server 2012

As a DBA, it is perfectly normal to forget your password from time to time. No need to hold your breath or panic. In case of emergency that you need to recall your password or the ‘sa’ password, no need to panic because you can do it via the backdoor…

Read more

0 comments, 121 reads

Posted in Coffee and SQL on 25 September 2014

Why Have a Nom Com?

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

8 comments, 143 reads

Posted in The Voice of the DBA on 25 September 2014


Hello Dear Reader!  The PASS Board of Director elections are upon us again.  We have 3 spots open and 4 great candidates.  A lot has been written about this election already.  Andy Warren has sounded off, Brent Ozar as well.  There are blogs by the candidates and many…

Read more

2 comments, 79 reads

Posted in SQLBalls on 24 September 2014

Still time to get a SQL Server tattoo

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

0 comments, 126 reads

Posted in The Voice of the DBA on 24 September 2014

Four Things PASS gets Right

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.

The Summit

The Summit is a premier conference for SQL Server professionals.… Read more

0 comments, 4,387 reads

Posted in Databases – Infrastructure – Security on 24 September 2014

Thoughts on PASS Board Nomination Process: #passvotes

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

20 comments, 74 reads

Posted in The Scary DBA on 24 September 2014

SQLSaturday Orlando Marketing Plan-Part 46

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

0 comments, 82 reads

Posted in SQLAndy on 24 September 2014

What I know about batch files

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

19 comments, 92 reads

Posted in SQLStudies on 24 September 2014

A SQLServerCentral DR Event

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

0 comments, 126 reads

Posted in The Voice of the DBA on 23 September 2014

Vote for Grant Fritchey

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

0 comments, 209 reads

Posted in @chuckboycejr on 23 September 2014

PASS Chapter Leaders - Remember To Talk About Elections With Your Chapters!

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

0 comments, 76 reads

Posted in Kendal Van Dyke on 23 September 2014

Why I’m Only Casting One Vote This Year in the PASS Election

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

10 comments, 4,689 reads

Posted in SQLAndy on 23 September 2014

The Magic Alt Button

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

7 comments, 88 reads

Posted in Koen Verbeeck on 23 September 2014

SQL Server Query Performance Tuning

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

0 comments, 105 reads

Posted in The Scary DBA on 23 September 2014

Launching PASSWatch

I’ve wanted to do this for a while, decided to make the time commitment and see what happens. See the first post about it at

Read more

1 comments, 142 reads

Posted in SQLAndy on 22 September 2014

Newer posts

Older posts