T-SQL Tuesday #47 – SWAG
It’s T-SQL Tuesday time, the second Tuesday of the month when we all coordinate our blog posts on a particular...
2013-10-08
993 reads
Data Warehouse Maturity Model
I have talked about the Business Intelligence Maturity Model (see Business Intelligence Maturity Assessment), but I wanted to dig further into...
2013-10-08
2,253 reads
Azure Account and Spending Limits
If you’ve been working with Azure for a while you probably signed up before they had the ability to create...
2013-10-08
821 reads
Setting the Default View on a SharePoint Library
There could be a number of reasons why you would want to change the default view on a SharePoint library....
2013-10-08
797 reads
Benchmark SQL Server Wait Statistics
One of the secret weapons in performance tuning with SQL Server is understanding wait statistics. Every time a process (spid)...
2013-10-08
1,999 reads
TSQL Tuesday #47 - Your Best SQL Server SWAG
The host for T-SQL Tuesday #47 is Kendal Van Dyke (blog|twitter), and his topic of choice is about the best...
2013-10-08
976 reads
TSQL Tuesday #47 - SWAG - Where Does He Get Those Wonderful Toys?
Where does he get all those wonderful toys? In the line made famous by Jack Nicholson’s Joker in the original...
2013-10-08
1,530 reads
New Job Checklist
I started a new job a month ago, but didn’t want to just figure things out as they came to...
2013-10-08
848 reads
T-SQL Tuesday #47: Your Best SQL Server SWAG
It’s time for T-SQL Tuesday again and this time Kendal Van Dyke is asking for Your Best SQL Server SWAG....
2013-10-08
759 reads
T-SQL Tuesday #47: SWAG SWAG SWAG
This month we probably have the easiest topic I have ever seen for a TSQL Tuesday blog party. That isn’t a slight, but rather is something of a good...
2013-10-08
10 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