How to reset the SA password in SQL Server
Getting locked out of a SQL Server can happen in a number of ways. You could inherit a server that...
2013-11-28 (first published: 2013-11-21)
6,891 reads
Notes from SQLSaturday in Oregon Nov 16, 2013
I wanted to take time to thank our sponsors, speakers and volunteers for making #sqlsat265 a big success. Over 400...
2013-11-21
584 reads
What Happens In Vegas…
…stays in Vegas, except when it comes to chocolate. After walking more than 1500 miles over the past 9 months,...
2013-11-21
520 reads
#SQLRelay 2013 R2 – Week 2
If you haven’t heard of SQL Relay and you live in the UK then shame on you. SQL Relay is...
2013-11-21
977 reads
Fill Factor and wasted space: Quick Tip
This is a little excessive, but here's a quick script to show you your fill factors per table that are...
2013-11-21
923 reads
Speaker Idol Competition at the Hammond .NET User Group
Here's the link to download the sample scripts and meme-tastic slidedeck from my presentation "SQL Server Indexes in Your Ill-Begotten...
2013-11-20
535 reads
Backups and Consistency
I wrote about transactional consistency recently. Why do we need this?
Imagine that I have an orders table and an ordersdetail...
2013-11-20
1,049 reads
Which C-level executive will be the big data champion? | ITworld
In your environment, who do you see being the Big Data champion? it probably depends on the goals of what...
2013-11-20
303 reads
Automated Permissions Auditing With Powershell and T-SQL: Part 6
Everybody still with me? Have you tried the script from Part 5? Did you notice how SLOW the Active Directory...
2013-11-20
794 reads
A pattern to do beginning of period calculations.
Beginning of period calculations are common things. Rolling month reports, queries to pull everything from last month etc require beginning...
2013-11-20
777 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