Wesley Brown

Wes use to be a pretty good DBA now he is in management.
  • Interests: Collecting old computers
  • Skills: I talk a lot.

Technical Article

Differential Backups of all Databases

This is the SP I schedule to do diff backups on the DB's that I can. I still need to add errorchecking to see if there is a full available before I do a diff. I'll add that when I get time. This stored procedure is designed to take 4 parameters @bksrv : This is […]

(2)

You rated this post out of 5. Change rating

2001-09-06

1,544 reads

Technical Article

Stored Procedure to Backup all Databases

This is the script I use to backup all my DB's this does fulls and dumps them locally to disk then spools them off to FTP. This stored procedure is designed to take 4 parameters @bksrv : This is the name or the IP address of the spooler or backup server to send to. @user […]

(1)

You rated this post out of 5. Change rating

2001-09-06

4,600 reads

Blogs

Take Time to Gain Perspective

By

Probably the best piece of advice I ever received is to take time to...

The Fringe Festival

By

I was lucky enough to take a vacation a decade ago in Edinburgh with...

Demo for Parameter Sniffing and Memory Grant Feedback

By

Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...

Read the latest Blogs

Forums

Learn From History

By Grant Fritchey

Comments posted to this topic are about the item Learn From History

The SQL Server MCP Server

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The SQL Server MCP Server

The Hidden Danger of Wildcard Operators In Join Operations

By sabyda

Comments posted to this topic are about the item The Hidden Danger of Wildcard...

Visit the forum

Question of the Day

The SQL Server MCP Server

How do I get an MCP server for my SQL Server 2025 database from Microsoft?

See possible answers