Automatically Gathering Server Information Part 5
The fifth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
Stuff Computer Support People Love
For anyone who supports desktops, this document shows how to sarcastically please your IT department.
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
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!
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.
Automatically Gathering Server Information Part 4
The fourth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
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.
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.
Automatically Gathering Server Information Part 3
The third part of Steve Jones's series on having SQL Server automatically report information to a DBA.
Blogs
CONCAT_WS Function Truncates Text
I was writing some dynamic SQL that generates some SQL statements to load my...
Flyway Desktop Projects for My PoC
By Steve Jones
In a previous post, I set up the basic databases for the PoC project...
Daily Coping 30 Jan 2023
By Steve Jones
Today’s coping tip is to plan something fun and invite others to join you....
Forums
Track Insert/Update/Delete Operations in Sql Server DB Table
Hi Team, I have a requirement to track any insert/update/Delete operations happened against Database...
Microsoft SQL over IPSEC VPN TPLink routers - 2 locations
Hi Experts. We recently set up a second location. our software at our first...
Trouble moving from a 2017 SQL Express DB on one HP laptop to another HP laptop
I am trying to migrate a DB from an old dying laptop to a...
Ask SSC