A placement firm’s “guaranteed” replacement
I have heard large placement firms say they are better than smaller firms because “They offer the client a guaranteed...
2013-08-20
625 reads
Trigger Status
Have you ever spent hours looking at an issue only to have your investigation hindered by a trigger? I know...
2013-08-20
1,183 reads
Data Purity issue after upgrading SQL 2000 to later versions
In SQL Server versions prior to 2005, it was possible to have invalid data values into a database. That can...
2013-08-20
930 reads
Pointers For SQL Saturday Attendance
I recently got an email from another SQL Saturday organizer asking for "pointers for getting more attendees" to their upcoming...
2013-08-20
501 reads
SQL Server – Why is the ‘sa’ Login Account Disabled & How to Enable ‘sa’ Login Account
Ever noticed and wondered why the well-known SQL Server system administrator (sa) login is in a disabled state? The reason...
2013-08-20
749 reads
SQL Saturday 250 – Pittsburgh – Advice for My Presentation on Monitoring and Baselines
I’ll be presenting at SQL Saturday 250 in Pittsburgh on Baselining and Monitoring. This is my first public presentation, and...
2013-08-20
780 reads
SQL Server – Get SQL Server Service Account using T-SQL
SQL Server service account information is stored in Windows Registry database. You can get this information from Services Console or...
2013-08-20
2,508 reads
PASS Summit 2013 - You Ain't From Around Here Are Ya?
I know what y'all are thinkin', what's Charlotte got to do with SQL Server? Just hear me out. There's a...
2013-08-20
1,298 reads
SQLCMD – Database Backup and Restore – Automation – Quickest and Simplest method
In today’s world we rely more on third party tools to do a Backup and Restore of databases. Most of...
2013-08-19
4,450 reads
Backup your Windows Azure SQL Databases – Yes,you should !
Care about RPO’s and RTO’s? Then you should be backing up your Windows AzureSQL Databases(Formerly SQLAzure).
Windows Azure SQL Database is...
2013-08-19
1,547 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
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