A Script A Day - Day 7 - Memory Queries
Today's script is a collection of a few memory queries I've collected from various sources over the years. These queries are by no...
2012-02-07
2,338 reads
Chris McGowan
A Script A Day - Day 6 - Drop and Create Database Snapshots
Today's Script will drop all database snapshots and create a database snapshot for all online read writeable user databases. I...
2012-02-06
3,897 reads
A Script A Day - Day 5 - Database Owner Permissions
Today's script will list all principals with membership in the db_owner fixed database role.
/* ----------------------------------------------------------------- Database Owner Permissions ----------------------------------------------------------------- For more SQL resources, check...
2012-02-05
1,134 reads
A Script A Day - Day 4 - Estimated Time Left
Today's script allows you to keep track of how long left a statement has before it completes. I find this useful...
2012-02-04
489 reads
A Script A Day - Day 3 - Live Change Data Edit Template
Today's script is a template I use for the occasions when a data edit is required to be run against...
2012-02-03
571 reads
A Script A Day - Day 2 - Database Mail Troubleshooting
Today's script is a collection of simple queries I have saved for a time when I need to troubleshoot database...
2012-02-02
490 reads
A Script A Day - Day 1 - Database File To Volume Mapping
Today is the 1st February 2012 and as promised here is the first of script in my "A Script A Day"...
2012-02-01
583 reads
Database 101
I had an interesting phone call this morning from our professional services team. They are carrying out what I can...
2012-01-26
615 reads
Venting Frustration
We as DBA’s face an ever growing list of things to do and services to support. We work in high...
2012-01-25
598 reads
A Script a Day
In February I will be starting a series of Blog Posts I'm calling a "A Script a Day". Each day...
2012-01-24
622 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers