Master Data Services stops working after an upgrade
Recently some SQL Server instances at a client were upgraded to the latest cumulative update of SQL Server 2012 service...
2013-11-27
2,693 reads
Connection pooling and the DBA
Here’s a great article that I came across while on my cookie break. The demonstration is so simple and straightforward....
2013-11-27
1,167 reads
Identifying Columns to Create Index via T-SQL
To identify columns on which you need to create indexes for fine tuning query performances you can run the T-SQL...
2013-11-27
1,478 reads
Wasted Space Per Database For Fill Factor: Quick Tip
As I keep looking for answers on Fill Factor... I keep finding interesting Metrics to look into. Looking my own...
2013-11-27
2,582 reads
HammerDB SQL Server Benchmarking Utility
Mike Fal
Everyone here knows how much I enjoy using the DVDstore database benchmarking utility to benchmark a SQL Server instance....
2013-11-26
1,794 reads
Disaster Recovery Planning
As a SQL Server DBA it is absolutely vital you regularly take backups of the databases you look after. If...
2013-11-26
457 reads
SQL Server Data Tools (SSDT) – October 2013 update
Since my last post about the SSDT update for August, there have been two updates, each containing one fix:
The September...
2013-11-26
1,199 reads
SQL Cruise competition, and the winner is …
Earlier this month SQL Cruise, (an initiative created by Tim Ford (B|T)) and Dell Software announced a competition to win...
2013-11-26
733 reads
The World Needs More A/B Testing
Have you ever been told that it’s ok to fail? Did it ever feel like it was really ok to...
2013-11-26
487 reads
Review: The Year Without Pants
The Year Without Pants by Scott Berkun is about a former manager/now speaker and writer going to work for WordPress...
2013-11-26
498 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
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