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
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
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
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
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
How many calls – A T-SQL Question
I got a call from a friend recently that was looking for some query help. He was actually using Access,...
2011-12-22
1,307 reads
The #Meme15 Round-Up
The first round of #meme15 has finished. In total, there were eighteen people that participated. If there were more, I...
2011-12-22
848 reads
A SQL Server Christmas Card
Merry Christmas everyone!
DECLARE @hohoho char(100)
DECLARE @bells smallint
DECLARE @tiers smallint
DECLARE @maxtiers smallint
SELECT @hohoho = ' ', @tiers = 1, @bells = 1, @maxtiers = 6
PRINT @hohoho
WHILE @tiers...
2011-12-22
812 reads
PASS Summit 2011 Eval Results
My presentation on Professional Development Plans ended up being ranked 47th out of 190, with an overall score of 4.63....
2011-12-22
649 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