SQL Engine basics: Caching data
SQL Server engine does an excellent job to optimize query performance and it has different methods to achieve this goal, one of these methods is the data caching.Data caching...
2019-07-05
43 reads
Blog Posts
Taxing Travels
It was a long weekend of travel for me not too long ago, starting at 4:30am on Friday and ending at 7:30pm Sunday night. This was for SQL Saturday...
2019-07-05
30 reads
Using the Announcement/News Part of SQLSaturday
One of the interesting but not often used features of the SQLSaturday tools is the announcement/news (in the admin tools, its Message Center | Announce News) to do mini-blog...
2019-07-05 (first published: 2019-06-15)
159 reads
Where do you do your database development? Hopefully not production
Here are three scenarios, if you work with SQL Server either as a provider of database environments (DBA) or a consumer of database environments for your application (developer) then...
2019-07-05
20 reads
Where do you do your database development? Hopefully not production
Here are three scenarios, if you work with SQL Server either as a provider of database environments (DBA) or a consumer of database environments for your application (developer) then...
2019-07-05
8 reads
Why I Take Pictures at Conferences
Why do I take pictures of screens at conferences? Let me count them up for you! Read on...
2019-07-05
113 reads
AWS SSM PowerShell Script Automation
SSM Overview
I’ve found that working with a large number of environments in AWS can provide some interesting challenges for performing various tasks, in a way that scale.
When you begin...
2019-07-04
3,336 reads
Azure Databricks – create new workspace and cluster
In this post, I will quickly show you how to create a new Databricks in Azure portal, create our first cluster and how to start work with it. This...
2019-07-04
97 reads
Job History – Back to Basics
An important part of any DBAs job is to ensure database related jobs are running prim and proper. Sometimes that just doesn't happen. When jobs are being overlooked, it...
2019-07-04 (first published: 2019-06-20)
462 reads
SQL Server Containers Are Boring
Not really, but sort of. The beauty of containers, at least in a dev/test environment, is the ability to spin them up while you need them and then throw...
2019-07-04 (first published: 2019-06-17)
553 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