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

yet another backup script using litespeed or native backup

Updated! Now supports both SQL Litespeed and native backup commands in one script! Several new bug fixes please see the header of the script. Error messages to add are now at the bottom of the script! This stored procedure will backup a single database or all databases it will also perform ether a full, diff, […]

2004-10-26 (first published: )

962 reads

Technical Article

Yet another restore script usp_restore

usp_restore - This will restore a backup performed with SQL LiteSpeed from DBAssocatesIT or by the standard backup database routines in SQL Server Please check below the declarations to find the user settable options for this script If the target database is currently in a loading status or cannot be read from this restore it […]

2004-10-25 (first published: )

607 reads

Technical Article

alert on blocking chains via email

This is a script I use to watch for blocking chains on a server there are four variables to be set. @Duration tells it how long to run. This will be an active thread for the duration. @IntervalSec how often to poll for blocking. @maxwaittime time in miliseconds a thread that is blocked that you […]

5 (1)

2004-09-01 (first published: )

1,679 reads

Technical Article

Proper Case User Defined Function

This is a little script I wrote before I saw Steve Jones write up on Tame Those Strings Part 7. This is a slightly diffent approach. It will take a string up to 255 chars and case every word first letter upper and the rest of the word lower. This ain't the best way but […]

2003-02-20

383 reads

Blogs

Query Store Hints in SQL Server 2022

By

Another neat little feature in SQL Server 2022 is Query Store Hints. This is...

Daily Coping 30 Nov 2022

By

Today’s coping tip is to learn a new skill from a friend or share...

Encrypting Your SQL Data Should be Your Default Option

By

Cyber-attacks and data breaches seem to be perpetually on the rise. Every week we...

Read the latest Blogs

Forums

dtexecui

By Anita Lakhani

I have some IT peeps that will run an SSIS package manually from a...

Technical support for SQL Server

By Ram

Hi, Do we have to pay for  opening a support ticket with Microsoft for...

Basic Checks on a New AWS RDS SQL Server

By Br. Kenneth Igiri

Comments posted to this topic are about the item Basic Checks on a New...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers