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
Blog Posts
A Script A Day - Day 21 - The HAVING Clause
Today’s post is about the HAVING clause which specifies a search condition for a group or an aggregate. HAVING is...
2012-02-27
558 reads
A Script A Day - Day 22 - Database Backup
Today’s script follows on from Day 16’s script which was about database restores. In a backwards way the script is...
2012-02-27
617 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
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
2012-02-27
15 reads
2012-02-27
14 reads
2012-02-27
13 reads
2012-02-27
21 reads
Detect Worst Performing SQL Queries – Part 3
Best way to tune production server is to find out what are the queries executed in a particular duration and...
2012-02-27
888 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