SSMS 21 and My Favorite 4 New Features
GREAT NEWS TEAM! The new SQL Server Management Studio (SSMS) Version 21 is here, ready
DBA Tasks
Restore Snapshot on AWS RDS MSSQL
Today I discovered some information and configuration changes we made on a development server need
SQL Server Database Mail Configuration
Today I want to be able to use database mail to send alerts to my
Upgrade MSSQL Server on AWS RDS
As of this week I have completed all the prerequisites that I need to upgrade
TempDb Monitor for Snapshot Data
Recently I enabled one of my databases to use SNAPSHOT ISOLATION LEVEL and today I
Reducing Size of Overprovisioned Columns
A while ago, the company I worked for acquired another subsidiary. The database we inherited
SET UP PARAMETER GROUP on AWS RDS
When I create a new RDS Server using MS SQL Server, a default PARAMETER GROUP
Archive System-Versioned Temporal Table History Data
I am a big fan of SYSTEM-VERSIONED TEMPORAL TABLES and the way they automatically store
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