SQL in the City Sydney in Two Weeks
It’s two weeks to our next SQL in the City Summit, this time in Sydney. I’m excited to be going back, though it’s a quick trip for me. Likely...
2019-09-13
55 reads
Blog Posts
How I Troubleshoot SQL Server Execution Plans
Watch this week’s video on YouTube. Today I’m concluding my series on SQL Server execution plans by sharing the specific steps I take when troubleshooting a slow performing query....
2019-09-12 (first published: 2019-08-27)
1,830 reads
Local Database CI Builds with Jenkins in a Container
In two previous posts, I’ve showed how to configure Jenkins in a container as well as how to add the SQL Change Automation plugin. This post looks at an...
2019-09-12 (first published: 2019-08-26)
625 reads
MSDB Size growing
msdb is growing due to queue. their is a great blog to help to reduce this How to reduce MSDB size from 42Gb to 200Mb query to get object...
2019-09-12
53 reads
NO RDPing!!! dbatools to the Rescue
So you hear this spread across the Twitterverse and Blogosphere. You should not RDP your SQL Servers to do administrative work. My nature has always been to troubleshoot issues...
2019-09-12
18 reads
Speaking Engagements End 2019
Currently I have two conferences in the pipeline. The first is our local DataMinds Connect, the biggest Microsoft data platform conference of the BeNeLux. I’ll be giving a session...
2019-09-12
18 reads
Speaking Engagements End 2019
Currently I have two conferences in the pipeline. The first is our local DataMinds Connect, the biggest Microsoft data platform conference of the BeNeLux. I’ll be giving a session...
2019-09-12
7 reads
SQL Security Principals and Permissions 101 at September '19 BRSSUG
Great attendance and great meeting last night for the September '19 BRSSUG meeting, great to see lots of new faces at the meeting following our successful SQLSaturday event in...
2019-09-12
43 reads
Training – Learning Data Science
You should never stop learning, especially within the IT industry. There are many fields to move into nowadays within the data space, you still have your classic / cloud...
2019-09-12
229 reads
Are My SQL Server Indexes Being Used?
Indexes can be incredibly beneficial to your database performance; however, they do come with a cost—indexes both consume storage space and affect insert performance. Therefore, it is important as...
2019-09-11 (first published: 2019-08-28)
2,808 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