Use PowerShell to automate your Azure DB creation
Why create your databases manually if you don’t have to? If there is one thing that I hate to do...
2016-07-20
853 reads
Multi-tenant databases in the cloud
For companies that sell an on-prem software solution and are looking to move that solution to the cloud, a challenge...
2016-07-20
1,185 reads
The new SQL Server Management Studio
Ok, so this is old news I know, but I’ve had a busy couple of months and am only getting...
2016-07-20
1,387 reads
Want to be able to read your database between restores?
When restoring a database there are times when it would nice to restore a bit, check what’s been restored so...
2016-07-20
779 reads
Day 1: Agile Fundamentals: Scrum, Kanban, Lean and XP
It's week 3 of my jammed packed training schedule this July. This week I'm producing course 918 Agile Fundamentals: Scrum,...
2016-07-20
673 reads
SSRS 2016 Book Nearly Done… My Brain is now Jell-O
(first excerpt from the upcoming book) “Professional SQL Server 2016 Reporting Services and Mobile Reports” from Wrox Press is content...
2016-07-20
520 reads
Extended Event Help Queries
When working with Extended Events, there are times when a little more information is, well, helpful. You know you want to use extended events to try and monitor...
2016-07-19
12 reads
Extended Event Help Queries
Enjoy this article re-publication from my original work at SQL Solutions Group.
When working with Extended Events, there are times when...
2016-07-19
671 reads
SQL – MultiServer SQL Inventory – PowerShell
Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of...
2016-07-19
762 reads
Adding the ReadyRoll Extension in VSTS
As I’m doing a little development with ReadyRoll, I’m documenting some of the things I learn about the product.
A few...
2016-07-19
704 reads
Blogs
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Force join by longest possible choice
Title pretty much says it. I want to join to a table that has...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
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