Presenting at SQL Saturday #111
On Saturday, April 14, 2012, I’ll be presenting “Table Vars and Temp Tables – What you NEED to know!” at SQL...
2012-03-28
706 reads
A Discussion of SQL Server-Related Topics
SQL Server 2012 Performance Test: Truncate a Date/Time to Different Parts
SQL Server 2012 introduces several new date/time functions that allow you to build a date/time from the individual parts of...
2012-03-15
2,953 reads
T-SQL Tuesday #028 – Jack of All Trades, Master of None?
This month, Argenis Fernandez (blog, @DBArgenis) is hosting our monthly T-SQL Tuesday, and he wants to know: Are you specialized?...
2012-03-13
947 reads
Presenting at SQL Saturday #110
On Saturday, March 10, 2012, I’ll be presenting “Table Vars and Temp Tables – What you NEED to know!” at SQL...
2012-02-28
1,402 reads
Comparing Inline and Multi-Statement Table-Valued Functions
Table-Valued Functions. What a wonderful addition to SQL they make. They take parameters, do some work, and return a result...
2012-02-15
80,882 reads
Presenting at SQL Saturday #96
I’m honored to have been selected to present two sessions at SQL Saturday #96 in our nation’s capital, Washington DC...
2011-11-02
788 reads
Presenting at SQL Saturday #87
On Saturday, October 29, 2011 at 2:45 pm, I’ll be presenting “Table Vars and Temp Tables – What you NEED to...
2011-10-27
699 reads
I’m a winner!
Actually, I only submitted the winning entry; Denali CTP3 SQL Server 2012 is the real winner. After having a blog...
2011-10-26
810 reads
PASS Summit 2011 recap
Recap of my first ever SQL PASS Summit – 2011:
Saturday, Oct 8 – Travel day – I flew from Richmond VA to the...
2011-10-17
1,459 reads
T-SQL Tuesday #23 – Joins
There is something wrong in the SQL force today… here it is the first Tuesday of a month, and we’re...
2011-10-04
795 reads
Blogs
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Forums
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
Question of the Day
UNISTR Basics
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