Database Deployments in Uncontrolled Environments
The ideal is to make a change and see that change deployed to production, in a perfect world we would...
2016-09-29 (first published: 2016-09-20)
1,318 reads
Database Deployments in Uncontrolled Environments
The ideal is to make a change and see that change deployed to production, in a perfect world we would...
2016-09-20
44 reads
Database Deployments in Uncontrolled Environments
The ideal is to make a change and see that change deployed to production, in a perfect world we would...
2016-09-20
39 reads
Database Deployments in Uncontrolled Environments
The ideal is to make a change and see that change deployed to production, in a perfect world we would be told to work on something, write the code...
2016-09-20
9 reads
North Texas SQL Server User Group – September 2016 Follow
Thanks for attending my presentation on window functions in TSQL during the September 15, 2016. I hope you learned something you...
2016-09-19
399 reads
Be a good administrator
Administering SQL ServerBelow are the topics every Administrator has to keep up with.Backup / Restore:Understand the backup / restore options SQL Server...
2016-09-19
192 reads
Quick Script – Finding Most Recent Backup
Recently I have had to restore a number of databases into our training environment. Looking up each backup individually would...
2016-09-27 (first published: 2016-09-19)
1,332 reads
Data Governance Policy
What is a Data Governance Policy?
Data governance policy is concerned with how an organization collects, stores, accesses and maintains its...
2016-09-19
2,421 reads
Be a good administrator
Below are the topics every Administrator has to keep up with. Backup / Restore: Understand the backup / restore options SQL Server provides for you. Implement those on your...
2016-09-19
13 reads
Be a good administrator
Below are the topics every Administrator has to keep up with. Backup / Restore: Understand the backup / restore options SQL Server provides for you. Implement those on your...
2016-09-19
14 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