T-SQL Tuesday #82–Azure SQL Database
It’s T-SQL Tuesday time and this month we have Jeffrey Verheul giving us the topic of the cloud, or Azure...
2016-09-13
602 reads
Bringing Database Devops to DevConnections
Another alliteration post. Maybe I’ll make all my titles tongue twisters to test your talents?
This is my new favorite session....
2016-09-13
641 reads
Migrating to Azure - Quirks & Tips
Recently I have moved a dozen websites and web apps to Azure. Some are small apps used by a few...
2016-09-13
199 reads
Columnstore & Memory-Optimised Workshop in Redmond (10.31-11.02 2016)
I am so happy that I can finally announce the very first Columnstore & Memory-Optimised Tables Workshop in the USA: on...
2016-09-13
532 reads
Budgeting for SQL Saturdays
We’ve been doing SQLSaturdays for eight years at Louisville now. We’ve had a quite a wide range of budgets depending on...
2016-09-13
608 reads
What is a SARGable predicate?
‘SARGable’ is a weird term. It gets bandied around a lot when talking about indexes and whether queries can seek on indexes. The term’s an abbreviation, ‘SARG’ stands for...
2016-09-13
16 reads
What is a SARGable predicate?
‘SARGable’ is a weird term. It gets bandied around a lot when talking about indexes and whether queries can seek...
2016-09-13
179 reads
What is a SARGable predicate?
‘SARGable’ is a weird term. It gets bandied around a lot when talking about indexes and whether queries can seek...
2016-09-13
1,740 reads
Interview Questions for Companies
In this article I will be posting interview questions by companies. Whenever I am facing any interview or someone shares...
2016-09-13
337 reads
Azure: Creating a BACPAC from an On-Premises SQL Server Database
So to start, what’s a BACPAC?
Per the Azure documentation
When you need to create an archive of an Azure SQL database,...
2016-09-13
1,249 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