I recently spent more time than I’d care to admit troubleshooting a T-SQL query that seemed to run fine most of the time but occasionally returned an error that, on the surface, didn’t make any sense. As I ruled out several of the more obvious possible causes, the error became one of those things that […]

I’m speaking at SQL Saturday #272 in Nashville, TN on January 18, 2014. My session is based on a presentation by Mike Walsh at PASS Summit 2013. Hope to see you there!

My last post described a trap for the unwary when using latitude and longitude values stored as the float data type in SQL Server, which left me wondering why anyone would use the float data type for this purpose. I questioned whether the float data type offers any advantages over the exact numeric types (decimal […]

I often work with geospatial data, primarily points on the Earth’s surface represented by longitude-latitude pairs. Typically, a table will have columns for longitude and latitude stored as one of the number data types, usually decimal or numeric. Occasionally, though, I see longitude and latitude values stored in columns defined with the float data type […]

At yesterday’s Women in Technology Luncheon panel discussion, several panelists spoke about the importance of speaking up when we encounter bias, prejudice, discrimination, and harassment and the likelihood that silence in such situations will be perceived as implicit approval of inappropriate language or conduct. However, the discussion unfortunately did not cover one of the major […]

On this the eve of the final day of PASS Summit 2013 (my second PASS Summit), I can say with confidence that this conference, like last year’s event, counts as one of the most significant professional development experiences of my career. I have learned so much from people who know more about SQL Server than […]