Kill spids that are idle
Ever wanted to get rid of users who are sitting idle for long periods of time? Here's a script that removes spids idle for a variable period of time.
2001-10-03
4,541 reads
Steve Jones
- Interests: yoga, reading, biking, snowboarding, volleyball
- Twitter: @way0utwest
- Website: https://www.voiceofthedba.com
- LinkedIn: https://www.linkedin.com/in/way0utwest
- Bluesky: way0utwest.bsky.social
- Threads: @way0utwest
Telemarketing Revenge
If you are like me, you probably get lots of telemarketing calls. Here's a good one to use the next time you get called by a phone company.
2001-10-01
2,738 reads
The Sysadmin Price List
Implement this and I guarentee your tech support call volume will drop!!! (Or you'll soon be retiring)
2001-09-25
2,821 reads
Introducing IQReference
IQReference is an online reference platform using well known, published materials. Read about this exciting and benefical product.
2001-09-24
3,201 reads
Find The Baseball Players
Or how to query for a particular type of customer. This article examines how you may query for particular rows that match one condition, but may not match another.
2001-09-19
3,755 reads
Trim Backup Files
This script runs within a DTS package. It searches the backup directory stored as a global variable in the script and trims all backup files older than some number of days. the script includes logging to the C: drive so you can trace the effects of the script. You need to create the global variables […]
2001-09-12
1,540 reads
2001-09-11
3,009 reads
An Alternative to Windows NT
Left over from the Y2K fiasco, but a good corporate memo that might still be useful as an alternative to XP.
2001-09-10
2,081 reads
Windows 2000 Professional Certification Exam for Executives
Give this test to your boss...only if he has a sense of humor!
2001-08-27
2,850 reads
What's a DBA? - An Overview
Ever wonder what a DBA does? Ever had someone ask you what your job entails? Here's an overview of what a DBA does. Reader feedback will be used to update this article over time.
2001-08-24
9,159 reads
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Choose the Second One
Comments posted to this topic are about the item Choose the Second One
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers