Converting SQL SERVER DateTime? Test it thoroughly….
Today one of my user complained that a report was missing one particular ticket from the output. The report in...
2012-03-08 (first published: 2012-02-28)
4,295 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,410 reads
SQL Server Agent Job Steps
To list a SQL Server Agent Job Steps use the T-SQL example below.
This example displays the step id, SQL Server...
2012-02-28
1,986 reads
Learn Mirroring with me at SQLRally
I just found out that I will be speaking at SQLRally Dallas in May. I submitted 3 sessions. As an...
2012-02-27
674 reads
I’m Going to SQL RALLY!
Hello Dear Reader, I’ve just received great news I’M HEADED TO SQL RALLY 2012! But I didn’t get here on...
2012-02-27
765 reads
Backing up a Certificate
If you create your own certificate in SQL Server, you need to make sure that you back it up immediately....
2012-03-07 (first published: 2012-02-27)
10,823 reads
Another 24 Hours of PASS
Nothing like a 24 hour barrage of SQL Server training for FREE!!! Did I mention it was free?
The PASS Data...
2012-02-27
617 reads
Most DBAs Don’t Seem to Know that Transaction Logs Can be Tuned
I was very surprised to see the results of my latest poll, which asked “When was the last time you...
2012-03-06 (first published: 2012-02-27)
4,835 reads
A Script A Day - Day 23 - Find an Object In Job Steps
Today’s script is one which saves me a lot of time on occasion. On large systems with lets say more...
2012-02-27
786 reads
End-User Microsoft BI Tools – Clearing up the confusion
Given two types of underlying data sources (a data warehouse and a OLAP cube built from the data warehouse) there...
2012-02-27
5,928 reads
Blogs
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Force join by longest possible choice
Title pretty much says it. I want to join to a table that has...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Question of the Day
RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers