SSC Editorial: Turn Out the Lights
This ran a couple weeks ago (Turn Out The Lights) to see if I could spark a discussion about how/when/why...
2016-01-29
1,054 reads
Easy way to test log shipping or availability groups setup
Have been working through the fantastic training resources from Brent Ozar’s Everything Bundle and on the recommended resources they mention...
2016-01-29
814 reads
PASS Board 2016: Update #1
Hello everyone. Just because I’ve moved on to the executive committee doesn’t mean I’m walking away from these reports. I...
2016-01-29
901 reads
First foray into presenting
It’s been a while since I’ve posted as the run up to Xmas last year and this January have been...
2016-01-29
792 reads
Easy way to test log shipping or availability groups setup
Have been working through the fantastic training resources from Brent Ozar’s Everything Bundle and on the recommended resources they mention...
2016-01-29
601 reads
SQL Server Management Studio Setup and Configuration
This is my first #entrylevel blog post. The challenge identified by the tags #entrylevel and #Iwanttoshare was started by Tim...
2016-01-28
1,577 reads
SQL Server Principals – Back to Basics
A fundamental component of SQL Server is the security layer. A principle player in security in SQL Server comes via principals.
Related Posts:
Easy Permissions Audit January 21, 2019
SQL...
2016-01-28
430 reads
SQL Server Principals – Back to Basics
Prelude in SQL Minor
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to...
2016-02-03 (first published: 2016-01-28)
3,324 reads
Memory Fundamentals for SQL Server - Virtual Memory, /3GB Switch
Just a few days back I was asked a very basic question related to AWE and /3GB switch.I was surprised...
2016-01-28
4,859 reads
Save the date: SQLSaturday Iowa City
Q: True or False – Iowa has one of the world’s longest-running SQL Server conferences?
A: True! SQLSaturday #19 was held in the fall of...
2016-01-28
1,021 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