Archives: August 2014
Let’s raise some money, people.
TL;DR Donate to Doctors Without Borders, the Argenis Without Borders campaign.
What started out as a joke has grown, and we’re really looking to raise some money for this charity. I did my part
I started shopping, and I’ll be rainbow decked for the… Read more
This is part of a series of tips for speakers to make your presentations better.
I wanted to give some specific SQL Server presentation items that have bothered me recently. These aren’t big things, but they do cause problems for attendees, and that might mean the difference between someone learning… Read more
A few friends challenged me yesterday, including Grant Fritchey and Aaron Bertrand. Last night, when I got to the Denver SQL Server User Group meeting, Todd Kleinhans was ready to take the challenge and asked if I’d participate.
I was speaking, but happy to do it afterwards. Here we… Read more
I was looking to write a new test with the tsqlt framework recently. I wanted to isolate a stored procedure’s logic and planned on using the FakeFunction procedure available in tsqlt.
I wrote my test, using a template from the Pluralsight course on tsqlt and the documentation. I tried to… Read more
I’ve been working on some skills, trying to grow some of my T-SQL, and started to mess with the PIVOT operator. This is a T-SQL construct that helps you turn row data into column data. It’s part of the SELECT query, and comes about in the FROM clause. There… Read more
I just saw this, but you should be aware. There’s a potential Denial of Service/Elevation of Privilege bug in SQL Server. Here’s the bulletin:
There are QFE and GDR patches for versions since 2008, but you need to read carefully to determine which one to install on your systems. Read more
It’s aimed more at executives, and certainly talks about the disconnect… Read more