Looking Back at Summit 2015
Last week was the 2015 PASS Summit in Seattle. It’s the largest SQL Server specific gathering of data professionals in...
2015-11-03
675 reads
Configuring the Azure SQL Database Firewall
Azure SQL Database is a Platform as a Service (PaaS) that provides a relational database for use over the internet....
2015-11-03
607 reads
ScriptDom Visualizer
Writing code to generate TSql using the ScriptDom is hard. There is a seemingly bewildering array of objects you can...
2015-11-03
527 reads
ScriptDom Visualizer
Writing code to generate TSql using the ScriptDom is hard. There is a seemingly bewildering array of objects you can use and where you use different types is unclear,...
2015-11-03
20 reads
ScriptDom Visualizer
Writing code to generate TSql using the ScriptDom is hard. There is a seemingly bewildering array of objects you can...
2015-11-03
19 reads
ScriptDom Visualizer
Writing code to generate TSql using the ScriptDom is hard. There is a seemingly bewildering array of objects you can...
2015-11-03
29 reads
Goodness-of-Fit Testing with SQL Server, part 2.1: Implementing Probability Plots in Reporting Services
By Steve Bolton
…………In the first installment of this series of amateur self-tutorials, I explained how to implement the most basic...
2015-11-03
1,303 reads
A Mess of Nested Transactions
Transactions are an area that I often find are used badly, or not used at all. Transactions without any error...
2015-11-03
858 reads
DLM Dashboard moves to 50 Databases – For FREE
I love DLM Dashboard. It’s the product that I’ve written myself, in various ways since SQL Server 6.5. My versions...
2015-11-03
742 reads
PASS Summit 2015 Recap
Last week was the annual PASS Summit in Seattle. The Summit is the predominant educational and networking event for SQL...
2015-11-03
619 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