Measuring My Career

I’m going to do a shorter editorial on this, but really I think this deserves more treatment here.
I saw Brent...

How to resequence column based on numeric prefix using TSQL

Beginning in version 2005, SQL Server is making manipulation of  partitioned set of rows easier by using Window Functions (ROW_NUMBER(), aggregate functions...

SQL Server 2014 Deprecated Features

SQL Server 2014 Deprecated Features – Database Engine
Everyone looks at the new features when trying to determine when to upgrade from...

Azure SQL Database Elastic Scale Part 1 - What is Sharding?

Azure SQL Database Elastic Scale Part 1 - What is Sharding?
MARCH 19, 2015

This week, Microsoft introduced an update to Azure SQL Database Elastic Scale Preview. This update is good...

Azure SQL Database Elastic Scale Part 1 - What is Sharding?

Azure SQL Database Elastic Scale Part 1 - What is Sharding?MARCH 19, 2015

This week, Microsoft introduced an update to Azure SQL...

Stupid T-SQL Tricks – Part 2: Retrieving Columns Set to the Current DEFAULT CONSTRAINT Value

“Heeeeeere’s Johnny!” – Ed McMahon introducing Johnny Carson for the Tonight Show
If you’re old enough to remember the Tonight Show hosted...

ALTER SCHEMA TO ADD PERMISSIONS

I’m sure some of you have wanted to do this:
ALTER SCHEMA Steve AUTHORIZATION Steve

You realize this doesn’t work, and you...

24HOP Russian Edition

Spoke at 24HOP Russian edition.
Interesting experience.
It is difficult to determine mood of audience if there is no visible audience  🙂
And...

Women in Technology

Warning: rant forthcoming.
I don’t get the women in technology problem. Oh, I understand and see the problem. I also understand...

Women in Technology

Warning: rant forthcoming.
I don’t get the women in technology problem. Oh, I understand and see the problem. I also understand...