T-SQL Tuesday #28 – Jack of all Trades, Master of None

It’s that time of the month again, T-SQL Tuesday Tuesday. This month Argenis Fernandez, MCM, and big round SQL teddy-bear...

CREATE ROLE

SQL Server 2012 RTMs

This past week the big news in the SQL Server space was the release to manufacturing of SQL Server 2012.

Old, but stable

This Friday Steve Jones wants to know about the older versions you are running in your production environments. Are you still using SQL Server 2000?

Traveling More Than Expected

For a guy that was looking to not travel much, it seems that I’ve got way more on my plate...

Why Support WIT

First, only support Women in Technology if you want to. It’s an idea that appeals to some, but not to...

Scaling Out

Steve Jones likes Service Broker as a scale out technology, but it hasn't caught on. He thinks more people should take a look at this technology and implement it in places where it fits well.

Backing up a Certificate

If you create your own certificate in SQL Server, you need to make sure that you back it up immediately....

Data Gravity

Does data have gravity? Will the law affect how applications are built and deployed? Steve Jones has a few thoughts.

Enabling Filestream in SQL Server 2012

Filestream is a cool feature, albeit one that’s cumbersome to use in SQL Server 2008 and R2. However the FileTable...