Stuff Computer Support People Love
For anyone who supports desktops, this document shows how to sarcastically please your IT department.
2001-04-24
3,671 reads
Articles
Using InterDev's Toolbox
If you've ever played around with the toolbox, you may have discovered one of InterDevs hidden gems. Did you know that the InterDev Toolbox allows you to add you own custom tabs? This feature allows you to access frequently used snippets of code in an instant
2001-04-24
3,059 reads
Introduction to DSN's
This article by Andy Warren is an introduction to DSN's; what they do, how they work, and where they are stored. Also pick up some ideas about how using a File DSN might save you a lot of administration!
2001-04-23
8,416 reads
Analysis Services Enhancements
In SQL Server 2000, Microsoft has closed the gap between its multidimensional database offering, OLAP Services, and the rest of the market place.
2001-04-22
4,377 reads
Automatically Gathering Server Information Part 4
The fourth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-22
5,896 reads
Index Server COM Object Programming in Visual Basic
Jon Winer talks about his adventures with Index Server and provides some hints to help you avoid some common problems.
2001-04-22
4,282 reads
2001-04-22
5,208 reads
Quickly Disconnect Users
Nothing is more annoying than having to disconnect users one by one. With this script, you will be able to quickly disconnect them with a few keystrokes.
2001-04-21
18,052 reads
Automatically Gathering Server Information Part 3
The third part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-20
11,201 reads
Process Tracking
It is not always possible to run a process on a set schedule. This article by Steve Jones looks at a technique for ensuring that your processes can run on whenever you need them to without any loss of data.
2001-04-18
4,734 reads
Blogs
I like KQL and I like managing my test data – are they mates?
By HeyMo0sh
Test Data Management (TDM) is essential in software development to ensure your application runs...
Full-Text Search in SQL Server: A Comprehensive Guide
By Rohit Garg
Introduction Full-Text Search in SQL Server is a feature that provides linguistic search capabilities...
Reading JSON Data with Python
By Steve Jones
Recently I’ve been looking at archiving some data at SQL Saturday. As a start,...
Forums
Summarizing Raw Sales Data with Group Summaries and Final Summary
Greetings, I need to transform data returned in a query from several tables as...
Subscription to Oracle DB not working after upgrading subscriber to Oracle 19c
Hi Replication and publisher configured on the same sql server 2022 version. Subscription to...
Script to Merger duplicate indexes
Hello, I am trying to firgure out how to merge duplicate indexes using a...
Question of the Day
The Query Traceflag
If I want to enable a trace flag for a specific query, how do I do it?
See possible answers