T-SQL Tuesday #121: Gifts Received This Year
Closing out 2019’s T-SQL Tuesday, Mala (blog | twitter) is asking us to reflect on the past twelve months:
This is a time for material gift giving, for many of...
2019-12-11
18 reads
Blog Posts
How Serverless is Working in Azure SQL Database
When Azure SQL Database introduced the serverless option, I decided to try it. I moved one of my databases to the tier, though I had to move to a...
2019-12-10 (first published: 2019-11-27)
1,055 reads
Install ALL Things SQL Server… What?
Does your server look like this? Many of us have inherited a SQL Server instance that has all SQL Services installed. Someone, maybe even you, went through the SQL...
2019-12-10 (first published: 2019-11-26)
912 reads
Online, Resumable, and WAIT_AT_LOW_PRIORITY operations in SQL Server
ONLINE operations in SQL Server were simple to understand for years — we got ONLINE index rebuilds in SQL Server 2005. That was it for a while. Then, things...
2019-12-10
540 reads
Speakers wanted for the Richmond (VA) SQL Server Users Group – 2020
Are you a speaker in SQL Server topics? Come on out to Richmond, VA to speak to our user group. There are several topics that we are interested in...
2019-12-10
36 reads
Speakers wanted for the Richmond (VA) SQL Server Users Group – 2020
Are you a speaker in SQL Server topics? Come on out to Richmond, VA to speak to our user group. There are several topics that we are interested in...
2019-12-10
34 reads
The Gift of the SPN
Every once in a while there is an extremely valuable tool that comes along. While the footprint and use frequency of this tool may not be that big, the...
2019-12-10
14 reads
T-SQL Tuesday #121 Gifts received
I am hosting 2019’s last T-SQL Tuesday of the year. I chose to ask people to write on gifts they had received – by way of community, relationships, or...
2019-12-10
17 reads
T-SQL Tuesday #121: Gifts received for this year
It’s T-SQL Tuesday time again! This edition is hosted by Malathi (blog|twitter) and the subject is looking back at the past year. So what do I have to be...
2019-12-10
16 reads
T-SQL Tuesday #121: Gifts received for this year
At the end of 2019, Mala (b|t) invites us to write about the gifts we’ve gotten during the year. I’ve been gifted with a lot of things this year personally...
2019-12-10
6 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