Query Store custom SSMS performance dashboard
As most of you might know, I am a big fan of the Query Store feature inside SQL Server 2016....
2016-11-08 (first published: 2016-11-02)
3,265 reads
DotNine SQL Server and more
DBCC CLONEDATABASE and sensitive data
Just over 2 months ago Service Pack 2 for SQL server 2014 was released. Included in this Service Pack is...
2016-09-28
1,772 reads
Broadening Horizons: From DBA to Data Science #2 Math Fundamentals
In the previous article in this blog series I told you my plans of expending my horizons towards the Data...
2016-06-06
1,549 reads
Broadening horizons: from DBA to Data Science #1
As an IT professional we are used to spending a lot of time learning about new technologies or how we...
2016-06-09 (first published: 2016-06-02)
4,860 reads
SQL Server 2016 – It just runs faster SQL Server Engineer Blog Post Overview
In March the CSS SQL Server Engineers started to blog about various new enhancements made to the SQL Server Engine...
2016-04-22 (first published: 2016-04-13)
3,052 reads
SSMS Preview Plan Comparison Tool and Plan Viewer Optimizations
With the February release of the SQL Server Management Studio (SSMS) Preview Microsoft introduced a nice new tool inside SSMS,...
2016-04-06
709 reads
Talking about the Query Store at SQLBits!
From the 4th till the 7th of May 2016 one of the biggest SQL Server conference in the world will...
2016-03-29
772 reads
SQL Server Management Studio Preview
You may have heard that SQL Server Management Studio (SSMS) is now available as a stand-alone installation package outside of...
2016-03-18
717 reads
Session Based Wait Statistics in SQL Server 2016
As you probably know I am very fond of SQL Server Wait Statistics (shameless book link) and the options they...
2016-03-14
2,623 reads
Pro SQL Server Wait Statistics available now!
Remember that blog post from April this year that I announced working on my first ever SQL Server related book...
2015-09-02
1,565 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
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