Check Your Azure Account Usage
It is absolutely not cool or fun to pay money to learn new technology. One of the main complaints people...
2013-08-27
789 reads
SharePoint SSRS “The permissions granted to user ‘Domain\User’ are insufficient for performing this operation”
Not too long ago I ran into a crazy situation where just about everything that could have gone wrong with...
2013-08-27
1,578 reads
How to Tell If Your Users are Connecting to the Availability Group Listener
You've spent a lot of time planning and building out a new SQL Server 2012 environment complete with Availability Group...
2013-08-29 (first published: 2013-08-27)
2,441 reads
Query Stats
DBAs rarely use the full potential of sys.dm_exec_query_stats. It’s common to see the queries for looking at the most expensive...
2013-09-04 (first published: 2013-08-27)
3,771 reads
A Rickety Stairway to SQL Server Data Mining, Part 14.2: Writing a Bare Bones Plugin Algorithm
By Steve Bolton
…………As I’ve said many times throughout this series of amateur mistutorials, SQL Server Data Mining (SSDM) is one...
2013-09-02 (first published: 2013-08-26)
2,782 reads
SQL – Identify & Drop Duplicate Index
This post explains the simple steps to identify a duplicate indexes in all the databases. The duplicate index are more than...
2013-08-26
897 reads
SQL Saturday 223 OKC
This past weekend I made the relatively short (about 3 hours) trip to the Oklahoma City area to attend and...
2013-08-26
812 reads
Backup Your Certificate for TDE
If you’ve enabled TDE, you need to be sure you have a copy of the certificate that protects the Database...
2013-09-03 (first published: 2013-08-26)
1,884 reads
Last Weeks Top “Reading” Links #46
It’s Monday, it’s time for weekly round-up #46. As an introduction, if you follow me on twitter (@StrateSQL), you’ll know that throughout the...
2013-08-26
769 reads
Make the PASS Summit Work For Your Employer
It was pointed out to me that since PASS is such a huge networking event, any employer would be crazy...
2013-09-02 (first published: 2013-08-26)
1,964 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
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