• Interests: SQL, Biztalk, .NET

Technical Article

Create an audit trigger on a table

Sometimes you need an audit trigger on a table. I have created a generic trigger that will work for (almost)every table. if the audit table is not there yet, It will copy the table structure (but strip identity attributes) and put all the data in an AUDIT_ table.I believe this will work for almost every […]

5 (5)

You rated this post out of 5. Change rating


1,599 reads

Technical Article

Restore Backup and all TRANLOGS in a specific DIR

Many DBA's have a Maintenance plan running that creates a backup every night and a transaction log backup every hour.Restoring them to another server (for whatever reason) can be a tedious job. That is why I wrote this T-SQL script.It will read the contents of a backup directory created by the maintenance plan and create […]

5 (1)

You rated this post out of 5. Change rating


903 reads

Technical Article

Generate Insert/Update/Delete Sprocs for a table

A week ago I posted this script. It was a much simpeler version without error checking. Now all the sprocs return the same errors.    0 THERE WERE NO ERRORS  -99 UNEXPECTED NR OF RECORDS AFFECTED  0 THE SQL ERROR NUMBER Also with the insert statement the @ID is set. So you can retrieve the […]

You rated this post out of 5. Change rating


387 reads

Technical Article

Generate Insert/Update/Delete/Get  SPROCS

This is a script that creates Insert / Update / Delete and Get stored procedures for a specific table.It will only work for tables with a unique primary key.Have a look at what is does, and if you like it, Vote for it. Maybe there are tons of sprocs out there that perform the same […]

4 (1)

You rated this post out of 5. Change rating


269 reads

Technical Article

Log DISK IO statistics per Database file!!!

Well, ever wanted to know what was happening on disk....You could with FN_vitrualfilestats....Here is a NICE SPROC that samples all databases and puts it in a table. You can choose if you want to Retain values in the table or that it must be cleaned every time the sproc runs.( Put this data in a […]

You rated this post out of 5. Change rating


896 reads

Technical Article

Stored Proc with optional parameters

Sometimes people want a Stored Proc with optional parameters. A lot of times people will use a coalesce for this. The problem with optional paremeters is that the query plan will never be an exact mach for that specific query. ( You never know what paremeters are filled..... )To solve this problem look at the […]

You rated this post out of 5. Change rating


439 reads

Technical Article

INSERTS that will STAY after a ROLLBACK is issued

Sometimes it is usefull to log stuff in SQL server while stored procs are running. If a long stored proc runs you sometimes want to be able to log a message in a loggin file. But what if a rollback occurs.... The message is lost as well.Here is a method to set up a seperate […]

You rated this post out of 5. Change rating


724 reads


T-SQL Tuesday: Encryption and Data Protection


I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...

Parameterize your Databricks notebooks with widgets


Widgets provide a way to parameterize notebooks in Databricks. If you need to call...

FDD 2023 – Session Materials


You can find the slides for my session at Future Data Driven summit at...

Read the latest Blogs


Alwyason availability group can set primary role permanently?

By SQL Galaxy

Hi. Two node windows clusters Node1 and Node2 and configured alwayson availability group. Will...

need some help with spilt raw data

By mxy

Hello,   I am trying to split data, looks like there is some special...

Backing Up a Restoring Database

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Backing Up a Restoring Database

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers