Additional Articles


Technical Article

Extract data from sp_who for specific database

sp_who (and sp_who2) work great for a quick view of what's going on in the system, and can be filtered by user, but there's no way to filter by database. This quick stored procedure provides data on which users are accessing a specific database.

You rated this post out of 5. Change rating

2004-09-13

997 reads

Technical Article

Get back list of failed dts packages

This is a fairly basic script that gets back a list of steps within dts packages that failed within the last 24 hours. The reason I wrote this script, is that if you call a dts package from a dts package on another server via a scheduled job on that same server, both the package […]

You rated this post out of 5. Change rating

2004-09-13 (first published: )

129 reads

Technical Article

Script to show user indexes tables(Sql 2000)

This script is supported only in SQL SERVER 2000, This shows only indexes created by users in tables.Parameter @tabela--> You can put the table name and get the information about users indexes in this table.OrYou can put nothing (NULL) and see all tables on the schema and how many indexes each table have.

You rated this post out of 5. Change rating

2004-09-10 (first published: )

239 reads

Technical Article

Script to automatically restore needed log-backups

Given a backupfile with a lot of sequential log-backups, this script automatically restores just those backups out of the file, which are necessary to bring the database up to a given timelag relating to the original database.Params are path to backupfile, name of the db to restore to, timelag in minutes.

You rated this post out of 5. Change rating

2004-09-08 (first published: )

1,635 reads

Blogs

Creating a GitHub Actions Self-Hosted Runner

By

I had to demo the Flyway Autopilot system recently and created a GitHub Actions...

Migrating from Azure PG Single Server to Flex with Azure VM and pg_dump/restore

By

This is more complicated than using the Azure Migration method, but because it’s maxed...

PowerShell (and T-SQL) and Elastic Jobs

By

I’ve covered how to create Elastic Jobs in the portal (this one is important...

Read the latest Blogs

Forums

Avoiding duplicates stop and restart an ssis package that is using batch inserts

By Neo

Hi, I an using VS 2022 to build a package that selects and then...

Contracting DBA - Permissions for initial analysis

By StephenSQL

Accidental DBA here.  After looking at all the work that needs to be done,...

How to convert run_date and run_time columns to datetime from SQL Agent systable

By Lord Slaagh

Hello SSC, Hope you are all having a great Monday! I am trying to...

Visit the forum

Question of the Day

AG Rules for Databases

Which of these is not a requirement for a database to be added to an Availability Group (AG)?

See possible answers