Daily Coping 21 Nov 2022
Today’s coping tip is to revisit a coping tip from the past and see if it helped you.. I came up with this one after I tried to do...
2022-11-21
16 reads
Sale on SQL Server 2022 Query Performance Tuning
Just a quick post to let you know that there’s a great sale right now at Springer on my brand new, completely rewritten, query performance tuning book. Get your...
2022-11-21
61 reads
Leaving (or minimizing) Twitter
Fairly short post here. Due to the recent events around Twitter (which I will not get into), I’m making an effort to reduce or completely cease my activity on...
2022-11-21
42 reads
Session Materials – PASS Data Community Summit and Cloudbrew
You can find the slides and demo scripts for my sessions at Cloudbrew (Snowflake) and PASS Data Community Summit (Migrate SSIS skills to ADF) in my Github repo. If...
2022-11-19
23 reads
PASS Summit 2022 - Day 3 in Pictures
Other PASS Summit 2022 Days - Pre-Cons | Day 1 | Day 2
--
Day 3 of Summit 2022 was "Community Day" with a "community keynote" given by the amazing Kimberly Tripp (@kimberlyltripp)...
2023-01-02 (first published: 2022-11-19)
213 reads
Daily Coping 18 Nov 2022
Today’s coping tip is to be creative, cook, draw, write, paint, make, or inspire. While I do play some guitar, I’m not much for painting. Certainly I write a...
2022-11-18
19 reads
PASS Summit 2022 - Day 2 In Pictures
Day 2 of Summit 2022 started earlier than usual with the "Breakfast with the Microsoft team: SQL Futures and Strategy" - the food was good and the conversations with...
2022-11-30 (first published: 2022-11-18)
235 reads
In SQL Server 2022, set your transaction log file autogrowth rate to 64 MB
A late-breaking change that arrived in SQL Server 2022 is an important one that could be a new line item in your health checks.
The basics:
Starting with SQL Server 2022,...
2022-11-30 (first published: 2022-11-17)
593 reads
2022 PASS Data Community Summit Recap: Power BI Meets Programmability – XMLA, TOM, C#
Thank you to everyone who made it out to PASS Data Community Summit! I have greatly enjoyed meeting so many fellow data nerds and have learned so much from...
2022-11-18 (first published: 2022-11-17)
29 reads
SQL Server 2022 is Here!
SQL Server 2022 becoming generally available was announced on Nov 16th 2022. This is the most Azure-enabled release of SQL Server yet, which is pretty exciting. A major Azure-enabled...
2022-11-17
33 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