Quick Tip: Accurate Log Shipping Status
Here’s a quick reminder for those of you using log shipping, and checking the SSMS report “Transaction Log Shipping Status”...
2012-08-16
892 reads
Blog Posts
Replication and TFS
So, we’ve had this issue lately at work with our TFS build/deploys causing a significant amount of contention and only...
2012-08-16
2,339 reads
Speaking at 24 Hours of Pass
24 Hours of PASS (24HOP) has been around a few years now, but this will be my first time participating...
2012-08-16
568 reads
SQL Saturday 151 BI Pre-con: Stacia Misner
Hello Dear Reader, SQL Saturday 151 Orlando is picking up steam. The Pre-Con’s have been named and they are fantastic. ...
2012-08-16
744 reads
Unwanted dependency between different parts of the code
Small systems tend to grow with new functionality and new access points. When the system grows, the need for data...
2012-08-16
1,139 reads
Where’s My Certificate Backup?
If you’re like me, you take advantage of the default backup paths in SQL Server. It makes my code cleaner,...
2012-08-16
1,961 reads
#meme15: Reasons I Like My Job
When Jason ( B | T ) posted this assignment, I thought it would be a fun topic to write on. Before I...
2012-08-15
510 reads
At the End of One Chapter and the Beginning of a New Chapter
I have been told by hundreds of DBAs that I have the best DBA job in the world as Director...
2012-08-15
1,125 reads
Being Right, the Other Side
I read an excellent article by Camille Fournier about the importance of recognizing that being right is not the only...
2012-08-15
844 reads
Dealing with negative session ids
Hello? Mr. DBA? Have you got a moment?
So there you are, enjoying one of the few quiet moments of your...
2012-08-15
5,322 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