Validating a Set of Database Scripts using DLM Automation
The basis of all the DLM Automation from Redgate is a series of PowerShell cmdlets. They might look intimidating or...
2016-12-09 (first published: 2016-11-28)
1,902 reads
Database Clone
There are a bunch of ways you could create a database clone. Backup and restore is one method. Export/Import is...
2016-12-19 (first published: 2016-11-28)
2,637 reads
Notes From SQLSaturday Orlando 2016
This year we held our 10th SQLSaturday, a very nice milestone to hit. I’ll reflect in a separate post on...
2016-11-28
732 reads
Easy to read CHECKDB
If you ask a senior DBA what are the top 5 most important commands in T-SQL you’ll probably see DBCC...
2016-12-05 (first published: 2016-11-28)
2,492 reads
How to backup local SQL database and restore to Azure SQL database
Hi friends, recently I was finding a way on taking backup of local database and restore that database to Azure...
2016-11-28
982 reads
A Better Way to Execute SSIS Packages with T-SQL
There are several ways to execute SSIS packages that have been deployed to the SSIS catalog, and my favorite way...
2016-12-02 (first published: 2016-11-28)
3,948 reads
Monday Coffee 2016-11-28
MCSA SQL Server 2016
The new SQL 2016 MCSA exams are out and joy of joys, the DBA path no longer...
2016-11-28
436 reads
How to Change an Analysis Services Instance to Tabular Mode
One of my client accidentally set up an SQL Server Analysis Services in multi-dimensional mode instead of Tabular mode. In this...
2016-11-28
1,462 reads
Bree's first blog post... Amazing training deals
Gethyn will be getting me to update this every week, there are some awesome training deals available for £750 + VAT....
2016-11-28
384 reads
A DBA’s Developer Experience and After-Thoughts
After 10+ years of a dedicated DBA, for the past 17 months, I have purposely chosen to work as a...
2016-12-01 (first published: 2016-11-28)
1,905 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