Stuff Computer Support People Love
For anyone who supports desktops, this document shows how to sarcastically please your IT department.
For anyone who supports desktops, this document shows how to sarcastically please your IT department.
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
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!
In SQL Server 2000, Microsoft has closed the gap between its multidimensional database offering, OLAP Services, and the rest of the market place.
The fourth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
Jon Winer talks about his adventures with Index Server and provides some hints to help you avoid some common problems.
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.
The third part of Steve Jones's series on having SQL Server automatically report information to a DBA.
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.
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers