Free Online SQL Server Training for the Week of November 10, 2013
If you’re a training provider and I’ve missed you, please drop me a line at brian {dot} kelley {at} sqlpass...
2013-11-07
1,597 reads
Configuring the RecycleTime SSRS Setting
If you administer a SQL Server Reporting Services server, chances are you’ve had users complain the report manager is loading...
2013-11-07
4,580 reads
Transparent Data Encryption’s Dirty Little Secret
Remember when you were eight years old, how exciting it was to order some of those amazing products that were...
2013-11-07
939 reads
hacked
ugggh.
My Drupal site in AWS EC2 was hijacked and is being used by the hijackers to do port scans.
Who said...
2013-11-06
607 reads
One Database Mirror disconnected case
Today I got a database mirror case, I was told the all databases were in disconnected\in recovery status on both...
2013-11-06
1,266 reads
Transactionally Consistent
What does this mean? I had someone ask me in a session recently, and I think I have a good...
2013-11-06
1,103 reads
Murder They Wrote
For those of you that know me, you know that I enjoy learning, and passing on what I have learned...
2013-11-06
802 reads
How to find empty tables in SQL Server : Quick Tip
These quick tips are short and sweet. They are nothing more than an explanation and some code. If you have...
2013-11-06
567 reads
SQL Saturday Dallas
I've been to five SQL Saturdays so far and this was my first year to attend the Dallas conference. Therewere...
2013-11-06
410 reads
Physical Join Operators by Ami Levin
For those who don’t know the three physical join operators are Hash Match, Loop Join and Nested Loops. Understanding these...
2013-11-06
686 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