SQLPSX is Finally Getting Updated
The most current code is now on Github, with the Codeplex version being depreciated. You can read all about the...
2016-08-16
526 reads
Script for creating test data for odds ratio
Make sure you have a working version of SQL Server 2016.
USE [master]
GO
/****** Object: Database [WorldHealth] ******/
CREATE DATABASE [WorldHealth]
CONTAINMENT = NONE
ON PRIMARY
(...
2016-08-16
419 reads
Recipe for an awesome (free) SQL Server workstation
Windows 10. Where we're going we don't need legacy software, but if you do, then download PowerShell 5.0 instead.
SQL Server...
2016-08-16
144 reads
Remember the Alamo (with a SQL Saturday nearby)
This past weekend was the first SQL Saturday in San Antonio, TX. I was lucky enough to get the chance...
2016-08-15
560 reads
Query Store, Force Plan and Dropped Objects
I love the Query Store. Seriously. It’s a huge leap forward in the capabilities of Azure SQL Database and SQL...
2016-08-23 (first published: 2016-08-15)
1,810 reads
Temper, Temper
Possibly the single most influential event in my career happened over 25 years ago. I lost my temper at a...
2016-08-15
1,058 reads
What is Enterprise Architecture?
This is an interesting question. Lets look at couple of definitions starting with Wikipedia’s definition
“Enterprise architecture (EA) is "a well-defined...
2016-08-15
508 reads
Does sp_rename on a column preserve the ms_description?
Did some checking as couldn't find help in the MSDN documentation. My test on SQL 2016 shows that since the...
2016-08-15
89 reads
Does sp_rename on a column preserve the ms_description?
Did some checking as couldn't find help in the MSDN documentation. My test on SQL 2016 shows that since the...
2016-08-15
402 reads
SQLSaturday Indianapolis Wrap-Up
This weekend, I attended SQLSaturday in Indianapolis for the first time. It’s one of the larger events in the Midwest...
2016-08-15
473 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