Viewing Deployed XEvent Metadata
Today will be the first of a few introductory level posts about Extended Events.
When dealing with Extended Events, there are...
2015-09-02
801 reads
Pro SQL Server Wait Statistics available now!
Remember that blog post from April this year that I announced working on my first ever SQL Server related book...
2015-09-02
1,566 reads
Monitoring of free space in database files
Monitoring of the size of database files is one of the important DBA tasks and this process should be automated....
2015-09-02
659 reads
10 DAX Calculations for your Tabular or Power Pivot Model (Part 1)
If you’ve read my blog for a while you may have seen the following posts:
Ten MDX Calculations For Your Cube...
2015-09-02
1,095 reads
Better Test Data Domains with SQL Data Generator
I’ve been working more with SQL Data Generator (SDG) because it solves some problems that many software developers have with...
2015-09-01
919 reads
CISL – Columnstore Indexes Scripts Library, Release 1 (“Ortus”)
I am glad to announce the very first release of the CISL – Columnstore Indexes Scripts Library, with codename “Ortus”.
Go on...
2015-09-01
598 reads
Join Me for Free #PowerPivot Training w/ @ExcelBIPASS Sept 10 – 12p CDT
I’m excited to be able to say that coming up next week on Thursday September 10, I’ll be presenting my...
2015-09-01
801 reads
Shredding Extended Event Actions
Are you rolling the dice with your love/hate relationship with XML? Tune in to see how you can ease your XML frustration along with increasing your free time to...
2015-09-01
29 reads
Shredding Extended Event Actions
The other day I wrote about that torrid love/hate relationship DBAs tend to have with working with XML. In that...
2015-09-01
762 reads
Time for T-SQL Tuesday #70!
Here is your invitation for T-SQL Tuesday #70, and the topic is: Strategies for managing an enterprise We define “enterprise” in...
2015-09-01
868 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