Intro to the Social DBA with a bit of #SQLHelp
Are you a Social DBA?
No I don’t mean that you are a DBA and attend a myriad of merry mixers,...
2015-10-06 (first published: 2015-09-28)
2,507 reads
Deployed Session Settings
Deployed Session Settings are stored within the system databases and then exposed via system catalog views. These settings help define a session. This article shows how to access those...
2015-09-28
17 reads
Deployed Session Settings
You may recall that I wrote about how to look at the deployed session metadata. Today, I will be talking...
2015-10-05 (first published: 2015-09-28)
1,237 reads
SSMS Connection Information
If you work with a number of different instances and have lots of connections open in Management Studio (SSMS) it...
2015-10-05 (first published: 2015-09-28)
2,103 reads
Advanced SSIS Training Course Preview
If you are looking for some end-of-year training before the new budget year rolls around, consider joining Andy Leonard and...
2015-10-02 (first published: 2015-09-28)
2,037 reads
Power Bi, PowerShell and SQL Agent Jobs
Continuing my series on using Power Bi with my DBA Database I am going to show in this post how...
2015-10-01 (first published: 2015-09-28)
4,293 reads
Why I Don't Use the Architect Title
I get nervous when I see the title "architect" in IT job roles.
I've had this title before as an employer's...
2015-09-28
473 reads
Table partitioning
What is partitioning.
To start with partition is the feature provided by SQL server in which very large tables are split...
2015-09-28
546 reads
SQL Saturday as an Attendee
Last week I did something that many people have already done. However this was my first experience, and I really...
2015-09-25
663 reads
Thoughts on the 2015 PASS Election
We had a decent election this year. Thanks to all four candidates – Argenis Fernandez, Jen Stirrup, Ryan Adams, and Tim...
2015-09-25
678 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