A Script A Day - Day 26 - RESTART a Database Restore
Today’s script is another one based on database restores. There is a little known clause of the RESTORE DATABASE command...
2012-02-29
2,842 reads
Chris McGowan
A Script A Day - Day 27 - Missing Database Backups
Today’s script is one I have used many times in the past to check for missing backups. The script will...
2012-02-29
3,477 reads
A Script A Day - Day 24 - Object Qualification
Today’s script is one I use as an example to explain that there is method behind my standards that some...
2012-02-28
1,502 reads
A Script A Day - Day 21 - The HAVING Clause
Today’s post is about the HAVING clause which specifies a search condition for a group or an aggregate. HAVING is...
2012-02-27
545 reads
A Script A Day - Day 22 - Database Backup
Today’s script follows on from Day 16’s script which was about database restores. In a backwards way the script is...
2012-02-27
604 reads
A Script A Day - Day 23 - Find an Object In Job Steps
Today’s script is one which saves me a lot of time on occasion. On large systems with lets say more...
2012-02-27
767 reads
A Script A Day - Day 19 - Remove Virtual Subscriptions
Today’s script is to help replication performance. It was something I learned from my resident replication expert Paul Anderton. Below...
2012-02-25
3,450 reads
A Script A Day - Day 20 - User Database VLF Count
Today’s script will execute DBCC LOGINFO for all user databases. This is a script I use to monitor the number...
2012-02-25
2,635 reads
A Script A Day - Day 17 - Possible Poor Indexes
Today’s script is one I’ve taken from a job I use to collect possible poor indexes. I’ve tweeked it slightly...
2012-02-23
540 reads
A Script A Day - Day 18 - Viewing System Configuration
Today’s script is something I’ve learned today, it’s cool learning new stuff! When viewing server configurations in the past I’ve...
2012-02-23
553 reads
Blogs
Reverse Engineering a Physical Model Diagram
By Steve Jones
I recently wrote about a logical diagram with Redgate Data Modeler. That was interesting,...
Prepping for Certification, Part 3 of ?
By Brian Kelley
After I have understood the details for a certification test (part 1), including format...
SQL Training Black Friday Deals
By Brian Kelley
If you're looking for particular "Black Friday" deals, here is what I've seen advertised...
Forums
Best analysis approach to reduce data type length in multiple tables
Hello SSC, I hope everyone is having a happy and safe holiday season! I...
Do you separate data/log files and TempDB files on different disks using AWS EC2
Hello, I am receiving multiple direction on deploying SQL Servers in AWS EC2. ...
Service account being in local admin in AWS EC2 environment?
Hello, I am working with a company on their database administration. I am trying...
Question of the Day
A New Operator
In SQL Server 2025, what does this code return?
SELECT '1' || '0'See possible answers