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

Get all user information at the database level

This is based on Clint Herring's work and was better than what I was using ;). It has one user definded variable @path that is where to store the files generated. It will make one file per database and one master file to restore all user permissions into that database. Used mostly for DR and […]

You rated this post out of 5. Change rating

2005-03-30 (first published: )

1,015 reads

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, […]

You rated this post out of 5. Change rating

2004-10-26 (first published: )

981 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 […]

You rated this post out of 5. Change rating

2004-10-25 (first published: )

608 reads

Technical Article

yet another backup script usp_backup

I wrote this to backup to a network share you can set the backup to spool to the local disk first then it will move it to another drive or to a unc just fine. Directory to hold and move to are not optional but if you set them to the same path it won't […]

You rated this post out of 5. Change rating

2004-09-06 (first published: )

377 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)

You rated this post out of 5. Change rating

2004-09-01 (first published: )

1,736 reads

Technical Article

Backup Transaction Logs on all Databases

Here we go again. This is the last in my backup series that I use to do backups of the databases. As far as I know this should only kick out errors when there really is one. This stored procedure is designed to take 4 parameters @bksrv : This is the name or the IP […]

5 (1)

You rated this post out of 5. Change rating

2001-09-06

853 reads

Blogs

Are ABORT_AFTER_WAIT's victims logged?

By

In SQL Server, using the KILL command to terminate a session results in an...

Part 2: The Modern Azure Data Warehouse – ADF and ADLS

By

In today’s data-driven world, having the right tools to manage and process large datasets...

A New Word: Flichtish

By

flichtish – adj. nervously aware how much of your self-image is based on untested...

Read the latest Blogs

Forums

Backup with Checksum Show No Issues, While DBCC CHECKDB Reports Errors

By IT researcher

I took a backup with the CHECKSUM option, which was successful and showed no...

Realities of Predictive Analysis

By Louis Davidson (@drsql)

Comments posted to this topic are about the item Realities of Predictive Analysis

Linked Server Product Name?

By Brandie Tarvin

Just came across something weird. Was wondering if anyone else has ever seen this....

Visit the forum

Question of the Day

Creating Statistics on XML

I have a table in SQL Server 2022 that is an XML data type. I have an index on this column and want to create statistics using CREATE STATISTICS for some of the data in the column. What should I do?

See possible answers