2019-11-16
18 reads
Blog Posts
Getting Started with SQL Prompt 10
This week we released SQL Prompt 10, which is an exciting milestone for us. I remember when I discovered this little gem for Database Weekly and sent it over...
2019-11-15
133 reads
Rounding Out PASS Summit 2019
If you are like me, when certain events end, it is a bittersweet time. You’ve enjoyed your time with people you consider family, got to learn some new things...
2019-11-15 (first published: 2019-11-08)
461 reads
The Right Consultant Is Worth All The Money
Hiring consultants is like buying a new washing machine. In other words, you get what you pay for some times. A couple of months ago, my washer and dryer...
2019-11-15
9 reads
The SQLSaturday pitch to host facilities
Not being able to find a good, affordable venue to host a SQLSaturday is a show-stopping problem that is common to a lot of events, especially SQLSaturdays getting started...
2019-11-15 (first published: 2019-11-05)
192 reads
Building an Azure Sandbox
It’s that time of the year again. No, not fall, although I do love the weather change that’s around the corner. It’s time for me to rebuild my Azure...
2019-11-14 (first published: 2019-11-06)
657 reads
Create a PowerShell Notebook for Azure Data Studio with PowerShell
The latest update to the ADSNotebook PowerShell module I blogged about here now enables the creation of PowerShell notebooks with PowerShell. You can install the module with or if...
2019-11-14
28 reads
Focusing on Business Value
This was a fun talk with David Atkinson at Redgate. We talk satellites, finance, and more. Including some early history of the company. We are talking about how to...
2019-11-14 (first published: 2019-11-08)
240 reads
Transaction log Information gathering
Here are the different ways to know the tlog file related information sys.dm_db_log_stats – Provide summary of tlog information SELECT * FROM sys.dm_db_log_stats(db_id()) sys.dm_db_log_info -DMV function for VLF information...
2019-11-14
113 reads
What's New in SQL 2019? at BRSSUG
Thanks to everyone who joined the BRSSUG for a night all about SQL Server 2019! We got off into tangents and use cases for Big Data Clusters, columnstore, graph...
2019-11-14
57 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