What it is Page Life Expectancy (PLE)
Which cup will you prefer to go the less
number of times to the coffee maker?image was taken from hereLet us...
2018-06-21
235 reads
Blog Posts
Dates and Times in SQL Server: DATENAME()
Last time we looked at DATEPART(). This post is all about the DATENAME() function. So many similarities There are many...
2018-06-20
932 reads
New Session: Profiling Your Data
Data Quality is a huge issue, especially now with more and more data being created daily. According to Micro Focus...
2018-06-20
280 reads
Overview of SQL Server 2017 Docker containers on Linux machine
SQL Server 2017 is the biggest release and most important releases in the Microsoft product history simply because of the...
2018-06-20
1,415 reads
SQL Server Patching within an Always On Environment
SQL Server Patching with the introduction and adoption of Always On has changed. The traditional method by waiting for Service...
2018-06-20
196 reads
Understanding Cosmos DB
Cosmos DB is an awesome product that is mainly used for large-scale OLTP solutions. Any web, mobile, gaming, and IoT application that...
2018-06-20 (first published: 2018-06-11)
3,558 reads
Updating to SQL Change Automation
The SQL Change Automation release was early this week. This is replacing ReadyRoll and our DLM Automation products, rolling them...
2018-06-20
1,039 reads
What is an Event-Less Extended Event Session?
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-06-20 (first published: 2018-06-11)
1,740 reads
Changing the Collation of the Instance, the Databases, and All Columns in All User Databases: What Could Possibly Go Wrong?
Demystifying What “sqlservr -q” Actually Does
(last updated: 2019-01-07 @ 02:25 EST / 2019-01-07 @ 07:45 UTC )
For various reasons, people sometimes find themselves...
2018-06-19 (first published: 2018-06-12)
8,801 reads
Deploying to Azure Without Writing JSON Arm Templates
Reading Time: 6 minutes (not a minute longer)
TLDR; ARM templates are a great way to deploy to Azure, setting up...
2018-06-19
399 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
Question of the Day
RegEx Functions IV
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', 'i') AND BusinessEntityID IN (7,8)See possible answers