2001-10-08
1,972 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
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,490 reads
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,713 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,799 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,159 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,731 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,511 reads
2001-09-11
2,989 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,059 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,825 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...