SSMS 21 and My Favorite 4 New Features
GREAT NEWS TEAM! The new SQL Server Management Studio (SSMS) Version 21 is here, ready
Basic TSQL
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
Directly Import data from AWS S3 to SQL Server 2022
Today I wanted to show my team how we might be able to use one