CISL 1.1.0: cstore_doMaintenance (Columnstore Maintenace Solution Explained)
After the initial release of the SQL Server Maintenance Solution in CISL 1.1.0, I felt that a separate blog post...
2016-01-24
648 reads
Notes from the January 2016 MagicPASS Meeting
I did my presentation on automated restores for the second time, changed a few things. It was/is a presentation with...
2016-01-22
655 reads
Notes from SQLSaturday #480 in Nashville
Late posting, so reduced notes!
Speaker party was good. Room was loud when full due to wood walls and nothing to...
2016-01-22
634 reads
The SQL Server Security Model, Part 1: Logins [Foundations Friday]
How secure are your databases?
No, not your network. Just your databases. If your company is like most, the strongest security...
2016-01-22
773 reads
Using Change Tracking in SSIS
Recently, I wrote about how to get started with SQL Server change tracking, and I demonstrated a design pattern I...
2016-01-22
2,675 reads
What Do You Want?
It’s that time of year, planning for PASS Summit 2016. We’ve already put out the Call for Volunteers, which closes...
2016-01-22
389 reads
Overview of Published Articles – 2015Q4
Here is an overview of the articles I published in the final quarter of 2015:
Integrated Logging with the Integration Services Package...
2016-01-22
501 reads
Foundations Friday starts now
Earlier this month, my friend Tim Ford (b|t) proposed an idea:
A 2016 challenge to technical bloggers: 1 introductory level blog...
2016-01-21
449 reads
Push Button Deployments
I worked in an Agile team in 2000 and we deployed changes to our web platform every Wednesday for over...
2016-01-21
531 reads
Easy Installing .NET 3.5 for SQL Admins
Rule "Microsoft .NET Framework 3.5 Service Pack 1 is required" failed.
This is a common problem and relatively easy fix for...
2016-01-27 (first published: 2016-01-21)
1,481 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
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