Query Plan Oddities: Two Identical Missing Indexes
Brent demos a single query plan that asks for 2 identical indexes on the same table.
The Case of the Shrinking CFO, err Database
Shrink SQL Server databases quickly and with virtually no contention.
Why Haven’t You Upgraded SQL Server?
Kathi Kellenberger wonders what's keeping your business from upgrading.
Cascading Update and Delete for SQL Server 2017 Temporal Tables
Ameena Lalani looks at cascading updates and deletes when using temporal tables in SQL Server.
Securing Reporting Services Reports
Learn how you can get the userid of someone connected to Reporting Services and use that information to determine if they can view the report.
VMs for Development
Many technical people use Virtual Machines to build their own lab or test environment. Today Steve Jones asks how you've built your setup.
New Azure SQL Database Standard Tier Sizes
Tim Radney of SQLskills talks about the various Standard tiers available in Azure SQL Database – what they get you, and how much they cost.
Data Security Policies
Does your organization have policies around data security? Perhaps they should, or perhaps you should ask for some to be created and education available for users.
Different Ways to Find SQL Server Orphaned Users
SQL Server orphaned users are a common thorny issue in auditing. In this post, Jeffrey Yao provides a few different ways of identifying orphaned users covering various scenarios.
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
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
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
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