Attaching All Databases with PowerShell–Attaching Missing Databases
I wrote a PowerShell script recently to actually accomplish a task I that I needed. What’s more, this was the...
2014-06-03
1,296 reads
I wrote a PowerShell script recently to actually accomplish a task I that I needed. What’s more, this was the...
2014-06-03
1,296 reads
2014-06-02
1,410 reads
2014-05-30
352 reads
I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love...
2014-05-30 (first published: 2014-05-28)
1,738 reads
Manual deployments and configuration of software is akin to creating works of art. Not exactly what Steve Jones would like to see if we are to practice software engineering.
2014-05-29
114 reads
I saw this years ago in a presentation from Aaron Bertrand. At the time I thought it was super cool...
2014-05-29
1,662 reads
2014-05-29
1,368 reads
I wrote a PowerShell script recently to actually accomplish a task I that I needed. What’s more, this was the...
2014-05-27
1,311 reads
After some issues with a recent Windows patch, Steve Jones is concerned about the future of software updates.
2014-05-27
371 reads
2014-05-27
1,429 reads
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
Comments posted to this topic are about the item The Costs of Multiple Platforms
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