PASS DATA COMMUNITY SUMMIT 2025
My ninth year at the Pass Data Community Summit started off with the obligatory photo
Basic TSQL
SSMS 21 and My Favorite 4 New Features
GREAT NEWS TEAM! The new SQL Server Management Studio (SSMS) Version 21 is here, ready
SQL Server Database Mail Configuration
Today I want to be able to use database mail to send alerts to my
Reducing Size of Overprovisioned Columns
A while ago, the company I worked for acquired another subsidiary. The database we inherited
Rollup Selection
Today I have a collection of fictitious vegetable companies. I have been tasked with creating
Move Table to Another, New or Different File Group
This week I’m working on reorganizing some of the tables in a database. I want
Change Data Capture (CDC) Setup, Update, Reenable
There is a great post on MSSQLTIPS on how to RESTORE a database and keep
Quick Sheet – Date Time Formats
My quick reference for TSQL date/time formats that I use often. More information may be
Trigger Only Updates One Row
Recently I was asked to look at a TRIGGER and was told it had stopped
Create an Audit for Data Using a Temporal Table
Recently someone has been changing data in a table on a legacy application written more