I have two new articles up on Database Trends & Applications magazine.  I'd love to get your thoughts and feedback!Welcome to the Weird, Wild World of SQL Server LicensingNot long in the past, SQL Server licensing was an easy and straightforward process. You used to take one of a few paths to get your SQL Server licenses. The first ...

Ok, I have to admit the painful truth. I'm reliably slow to the finish line. This year, I got my slides into PASS HQ by the skin of my teeth, the weekend before the event was to begin.  Although I could say with a straight face ''I uploaded my slides!''.  I have to be honest that I wasn't surprised when many of my attendees said that ...

In last month's column, ''2012 Might Really Be the End of the World as We Know It,'' I described a number of major developments in the IT industry that are likely to disrupt the life of database professionals everywhere.  I categorize those four disruptors - virtualization, cloud computing, solid state drives (SSD), and advanced ...

I read too much, and that, my friends, is an entirely separate topic for a blog post. But I thought I'd share with you a little more about what I'm reading because sometimes, if I'm lucky, it might be something you'd enjoy too. So I'm going to start sharing what I'm reading at least once per week, partly so that I don't firehose too many ...

I have scripts that re-create my databases for testing and development purposes. But sometimes I want to take the data from a set of tables and move it as well – I could use SSIS, or a SELECT INTO statement, but what if I want to “re-set” the data to a point in time? In other words, load it with some “base data”? I thought this might be a good ...