Coming soon: Minion Backup, featuring table based scheduling!
The MidnightDBA team is announcing the release of a new, free backup solution for SQL Server: Minion Backup arrives on June...
2015-05-20
976 reads
Putting the ORM debate to bed
Hopefully this should put the ORM debate to bed, either use an ORM or don't but please don't access tables directly…
There are obviously reasons behind all of this but...
2015-05-20
7 reads
SQL Server Virtualization Stairway Level 3 at SQLServerCentral
The third Level in my Stairway to Virtualization series is now live at SQL Server Central! In this Level, we will...
2015-05-20
478 reads
SQL Server 2016 public preview arriving this summer
SQL Server 2016 was recently announced. Top new features include:
Always Encrypted protects data at rest and in motion. With Always...
2015-05-20
708 reads
Refactoring Mistakes Are Why We Write Tests
I wrote a short piece the other day trying to show how one can use tSQLt to test code. It’s...
2015-05-29 (first published: 2015-05-20)
5,692 reads
SQL F.A.D. – Daily Identity Reset - WaterOx Consulting
Reading Time: 3 minutesSometimes you have to do some things considered pretty strange in your...
The post SQL F.A.D. – Daily Identity...
2015-05-20
376 reads
HealthySQL - A Comprehensive Guide to Healthy SQL Server Performance
On an otherwise uneventful, other than the normal busy,
plate full, heading towards the US holiday weekend, middle-of-the-week, over
the hump day,...
2015-05-20
1,122 reads
SqlSaturday 377, Kiev, May 23 - only 3 days left
Hello everyone!
As you may already know - on 23rd May in Kiev will be held SqlSaturday 377.
Hurry up!
You can meet many...
2015-05-20
473 reads
SQL Agent Job Wrapper Part 2 – Adding Error Generation to the Cmdlet
Last week I posted Creating a SQL Agent Job Wrapper with PowerShell and SMO. In that post I created a...
2015-05-27 (first published: 2015-05-20)
5,339 reads
Adding new users & groups in windows
I do a lot of testing with security in SQL Server. And of course to do a thorough job of...
2015-05-20
712 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
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...
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