Once you have a query that is returning the data you like in SSMS you have a few options to move the result set into a format that you can use in other tools.
The simplest way is to select all results and then copy & paste them into whichever… Read more
I am hugely excited to have been selected to present at Live 360, November 17 – 21 in Orlando, FL.
Live! 360 brings together five conferences, and the brightest minds in IT and Dev, to explore leading edge technologies and conquer current… Read more
Walk & Talk #001 – Unknown or Null Values
Ride with us in this video as we head to Richmond, Virginia to present to their user group.
This is the first official Walk & Talk, but you’ll notice we’re not exactly walking along.
Through this video we talk about and… Read more
Blacklist vs Whitelist
I think just about everyone is familiar to some degree with the concepts of a blacklist and whitelist.
If not, the easiest way I can summarize them is as follows:
A blacklist is a list of what can not access something you… Read more
Is a demo always needed?
One of my more popular presentations I have been doing as of late is my “The Spy Who Loathed Me – An Intro to SQL Server Security” one. What is intriguing as that is is completely demo… Read more
I had an idea a few years back about a training event unlike any other. One where you could bring family, all have fun, and yet still learn about SQL Server from top people in the industry. After years of working… Read more
I just heard that I was selected to present at SQL Saturday in Columbus! I’m excited to be going back, and add another tick mark to the list of events we have been to. In reviewing recent and upcoming events though, I have come… Read more
SQL Server 2014 was officially released in April 1st, 2014. You can download the 120 day Enterprise edition trial version here: http://technet.microsoft.com/en-US/evalcenter/dn205290
As with previous version of SQL server, there are three primary editions of SQL Server 2014 available.
As a some of you may already know, I am now offering SQL Server boot camps with the first one being this July in Washington DC. Over the last couple of weeks since I announced this I’ve had a few questions as to why I am offering a boot camp Read more
What would your reaction be if, one day, all that old data you’ve been holding onto for years suddenly got up and walked out?
I’m not talking about unsecured data being hacked, personnel issues, malware in your network, or even HVAC systems with too much access… Read more
Recently while working with a client I was faced with some seriously convoluted code to count the number of days between a couple of dates.
Usually this is not a big issue, a simple datediff() works, but this also had to take… Read more
Why bother encrypting?
As a SQL Server DBA I am primarily responsible for making sure my client’s data is protected and available amongst other things. In many cases I have gone to clients and projects to find that sensitive data is not… Read more
I was going through some notes I had from previous projects and came across a sample script for created a Type 2 Slow Changing Dimension (SCD) in a database or data warehouse.
A Type 2 SCD is one where new records are added, but old ones are marked as archived… Read more
Last night a client tried to ruin a script to enable Read_Committed_snapshot on a SQL database. There were so many connections that kept popping up, even after restarts, that they were not able to change the setting.
As a fix I provided the script below.
Basically it uses the active… Read more
I was doing some simple tuning of procedures for a client when I came across some delete statements that I wanted to look into some more. They were filtering based on values in a temp table.
In a majority of cases I have come across at clients a row is… Read more