Can a Company Skimp on the DBA’s Salary?
Most people in IT will tell you they are under-paid and over-worked. Few of us
David Speight
https://www.linkedin.com/in/davidspeight/
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
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
Update Data Source Password Power BI
It’s password rotation day at my company today and I discovered that some of our
Change Data Capture (CDC) Setup, Update, Reenable
There is a great post on MSSQLTIPS on how to RESTORE a database and keep
Install Certificate for TLS In Transit End-to-end Encryption
Today I need to install SQL Server on a new development server. Even though “it’s