I recently had the challenge of migrating an installation of Microsoft Team Foundation Server 2010 from a shared SQL Server...
2014-02-27 (first published: 2014-02-24)
2,888 reads
I am honored to be the very first presenter of the new PASS chapter in Lafayette, Louisiana this Tuesday, presenting...
2014-02-23
606 reads
I will be speaking and whiteboarding for Data Architecture Virtual Chapter meeting on February 27, 2014 on the fitting topic...
2014-02-23
468 reads
Wrote this email exchange with some developer colleagues about to embark on performance tuning.
Subject: bag o' tricks from DMV talk
From: A. Developer
Hey...
2014-02-12 (first published: 2014-02-05)
2,083 reads
After the restore of a database, or perhaps a bare-metal restore of a Windows server running SQL Server, unique IDs...
2014-01-30
1,125 reads
If you've already configured your local machine's PowerShell environment to interact with your Azure subscription (see here: http://www.windowsazure.com/en-us/documentation/articles/install-configure-powershell/), then you can...
2014-01-30 (first published: 2014-01-27)
1,726 reads
I often use these scripts to check on the backups of all databases in an unfamiliar SQL Server instance, regardless...
2014-01-22
546 reads
I was recently approached by a client who was running SQL Server 2008 with some databases in SQL 2000 compatibility...
2014-01-15
1,140 reads
I know this might seem like an odd topic on a SQL Server blog, but it's a common and critical...
2014-01-07
1,162 reads
Assuming you're in a case-insensitive ("CI" in the collation name) column, this UPDATE statement:
UPDATE tablefoo
set foo = 'Z'
where foo = 'z'
will just...
2013-12-20 (first published: 2013-12-16)
1,800 reads
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Comments posted to this topic are about the item The Microsoft SQL Year in...
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Comments posted to this topic are about the item Your Value from a Conference
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers