Database Maintenance Plans: A Primer
Databases and newborns have a lot in common. They both require constant care. They both require constant monitoring. They also...
2014-10-20 (first published: 2014-10-14)
7,039 reads
Blog Posts
DevDev
There has been a gigantic shift in attitudes between development and operations, the devops movement, to create a streamlined, automated...
2014-10-20
44 reads
DevDev
There has been a gigantic shift in attitudes between development and operations, the devops movement, to create a streamlined, automated...
2014-10-20
53 reads
DevDev
There has been a gigantic shift in attitudes between development and operations, the devops movement, to create a streamlined, automated and high performing team of developers and infrastructure techs...
2014-10-20
9 reads
Last Weeks Top “Reading” Links #105
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-10-20
748 reads
Minion Reindex arrives this Friday!
Edit: Minion Reindex has arrived, and it’s getting fantastic notes! The MidnightDBA team is announcing the release of a new,...
2014-10-20
1,134 reads
SQL Server Security Benchmarks
If you’re not familiar with the Center for Internet Security, here’s the organization’s mission statement:
The Mission of the Center for...
2014-10-20
875 reads
2014-10-20
5 reads
2014-10-20
15 reads
2014-10-20
7 reads
Blogs
Ten Years of PowerShell
Ten years ago, I published a post about filming a Pluralsight Play by Play...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
T-SQL Tuesday
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Forums
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
RegEx Functions II
Comments posted to this topic are about the item RegEx Functions II
Question of the Day
RegEx Functions II
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') AND BusinessEntityID IN (7,8)See possible answers