JSON and the NoSQL “advantage” over SQL Server

First what is JSON?

JSON: JavaScript Object Notation.
JSON is syntax for storing and exchanging text information, similar to XML.
JSON is smaller...

Killing me softly with Service Broker…

A few days ago, I found a very interesting behavior regarding Service Broker on a
customer system. The main thing is...

Maintenance Plan Owner

We all inherit things from time to time through our profession.  Sometimes we inherit some good things, sometimes we inherit some things that are not so good.  Other times...

Speaking at PASS Summit 2012

It’s about that time again, PASS Summit 2012 is right around the corner in Seattle, WA. It will be held...

SQLRally 2012 Eval Scores

I was just browsing the results of the presentations at SQLRally 2012. I ended up with a evaluation average of...

Unable to activate a Windows 2003 VM on Hyper-V behind a proxy

Ok, so this is not strictly a post about SQL itself (and it's about a fairly old OS), but I...

Excellent SSIS 2012 Upgrade Video

This presentation gives an excellent overview of the process of upgrading SQL Server 2008 SSIS packages to work with SQL...

Using SQL Server 2012 FileTables

SQL Server 2012 allows you to store file/directories in a special table called FileTable that builds on top of SQL...

Inspirational Database Administration Requirements

 
Just as a society’s civilization is mostly nurtured by its culture, I believe that DBA work quality is mostly determined...

SQL Server 2012 Installation Guide

This article walks the user through installation of SQL Server 2012 on a Windows Server 2008 system using the SQL...