Weekly reading #22
A little bit late but it is here! It is Wednesday already and we are preparing for #DPS2019 which will be in August in Bangalore. Meanhwile I received another...
2019-07-24
34 reads
A simple powershell script to look up server hardware and OS information
This is a simple powershell script to query and display hardware and OS information from a remote computer.It uses CIM (Common Information Model) that is available since Powershell version...
2019-07-23
2,703 reads
Collecting Server Performance Metrics: Performance Monitor
Whether you’re a DBA/administrator looking to tune a server, planning for hardware updates, or looking to make a move to the cloud there are a few key performance metrics...
2019-07-23
154 reads
Introduction to SQL Server Execution Plans
Watch this week’s episode on YouTube! I nearly always use execution plans as the starting point for SQL query performance troubleshooting. In this multi-part series, I plan to review...
2019-07-23
234 reads
Introduction to SQL Server Execution Plans
Watch this week's video on YouTube
Part 1: Introduction to Execution Plans
Part 2: Overview of Statistics
Part 3: Reading an Execution Plan
Part 4: Commonly Troublesome Operators
Part 5: Troubleshooting Execution Plans
I nearly...
2019-07-23
26 reads
Introduction to SQL Server Execution Plans
Watch this week's video on YouTube
Part 1: Introduction to Execution Plans
Part 2: Overview of Statistics
Part 3: Reading an Execution Plan
Part 4: Commonly Troublesome Operators
Part 5: Troubleshooting Execution Plans
I nearly...
2019-07-23
14 reads
Kubernetes Pipelines
This post continues looking at some of the Kubernetes concepts I’ve been learning with the 50 days of Kubernetes (K8s). Specifically in this post, I’m writing and thinking about...
2019-07-22
35 reads
2019-07-22
24 reads
Top Modern Data Warehouse questions
Below are the top 15 questions I am seeing from customers looking to build a modern data warehouse in the cloud, and the blogs that I have wrote that...
2019-07-22
977 reads
Importance of Testing
I’ve always said if you’re running a script for the first time in a production environment, you’re doing it wrong. Testing is fundamental to technology, yet it is one...
2019-07-22
27 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