Rant: Applying Common Sense in IT
I was watching a training video last night and the instructor made the statement we hear all the time:
"Test this...
2012-08-23 (first published: 2012-08-17)
4,616 reads
Blog Posts
Script to find orphaned/unreachable job steps within your SQL jobs
SQL jobs are great as the SQL agent job engine allows for very granular control over jobs that are created...
2012-08-23
2,620 reads
SQL Server 2005 Diagnostic Information Queries (August 2012)
Here is the August 2012 version of my SQL Server 2005 Diagnostic Information Queries, with some minor tweaks and improvements....
2012-08-23
1,102 reads
Tips For Minimizing Deadlocks in SQL Server
Database servers are configured in such a way that they can service multiple requests from multiple users. Obviously this increases...
2012-08-23
2,488 reads
Transparent Data Encryption (TDE) with Database Mirroring
Database security is essential for the organisations working in healthcare and financial sector because the databases in such organisations contain...
2012-08-23
1,750 reads
24 Hours of PASS, Fall 2012
It’s time to get your learn on again. The schedule for the Fall 24 Hours of PASS is up and...
2012-08-22
704 reads
I Think I Need A Writing Table
I’m writing this Friday evening in Cleveland at the hotel, relaxing after the speaker dinner and getting ready for SQLSaturday...
2012-08-22
703 reads
I’m Speaking at SQLSaturday #156–Providence
I’m excited to be back on the speaking circuit. I was able to attend SQLSaturday #122 – Louisville thanks to Idera...
2012-08-22
733 reads
I’m Speaking at SQLSaturday #156–Providence
I’m excited to be back on the speaking circuit. I was able to attend SQLSaturday #122 – Louisville thanks to Idera and the ACE program. Now I’m on...
2012-08-22
20 reads
Lost in Translation – Deprecated System Tables – sysdepends
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-08-22
1,236 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
Question of the Day
RegEx Functions II
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') AND BusinessEntityID IN (7,8)See possible answers