SQL Server 2012 RC0 and beyond
Since the stable and mainly feature-complete versions of SQL Server 2012 have been available, I have been heads-down on multiple...
2011-12-25
747 reads
Blog Posts
Top 10 SQL Server Posts for 2011
2011 is nearly over. It’s time to list the Top 10 viewed SQLServer-DBA.com posts for the year , based on Views.
System...
2011-12-24
829 reads
Basics QA on Extended Event
Basics QA on Extended Event
I am learning Extended Event so this is my first blog on extended event, There is...
2011-12-23
1,800 reads
Data Driven Subscription failed with timeout error
One fine day, one of our data driven subscription which was running fine, failed with timeout error.
library!WindowsService_118!eb4!12/20/2011-07:30:01:: i INFO: Handling...
2011-12-23
1,216 reads
Re-blog – December 16 – December 22
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2011-12-23
528 reads
SQL Saturday #104: Colorado Springs
January 8th, 2012 will be the first SQL Saturday for 2012. 104 SQL Saturdays is an amazing number for our...
2011-12-23
762 reads
SQL Server 2012 (“Denali”): New Security Features
SQL Server 2012 has many new security features, and three of the bigger new features are: Default Schema for Windows Groups,...
2011-12-23
1,971 reads
SQL Server Sample Databases – All Versions
Many of you DBAs DB Devs and BI Devs in these days can have some changes from one SQL Server...
2011-12-23
1,461 reads
Tis The Season to be Giving...#SQLFamily
Indeed the Holiday Season is traditionally a season of giving, and being charitable to those who are less fortunate. Although giving...
2011-12-23
1,691 reads
2011 What A Great Year
What A Diffrince A Year Makes
In January I posted up my new years list basically, stuff I wanted to learn in...
2011-12-22
1,035 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