Reducing Size of Overprovisioned Columns
A while ago, the company I worked for acquired another subsidiary. The database we inherited
Basic TSQL
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
SELECT @@SERVERNAME on AWS RDS
I have a lot of legacy code that uses SELECT @@SERVERNAME and then performs an
Cannot Alter Column Because it is Replicated Error
Last week a colleague texted, wondering how to ALTER a COLUMN NAME because they were