Quick Tip: Taking a Database Offline
An interesting database option which is hidden from Enterprise Manager in SQL Server 7.0 is offline.
Tuning SQL Server Memory in 2 Minutes
You cannot do a proper tuning job on SQL server in two minutes, but you can get a good idea of how well a server is set up. This article will show you how to quickly evaluate the efficiency of memory usage on your server.
VMWare
VMWare is a software product that is great for testing new ideas without having to purchase and install a separate machine.
SQL Server 2000 Black Book
A review of the SQL Server 2000 Black Book from the Coriolis Black Book series.
Using the Dynamic Properties Task
In SQL Server 7.0 Data Transformation Services (DTS), dynamically configuring packages was difficult. With the aid of a new Dynamic Properties task in SQL Server 2000, this assignment is easy.
More About the Fixed Database Roles
This article by Andy Warren provides an introduction to some of the fixed database roles and things to consider when using them.
Cell Phone Horror Stories
These are some stories that show the downside of everyone having cell phones.
Getting The Best From The Index Tuning Wizard
The Index Wizard is a handy tool shipped as part of the SQL 7 Profiler that can analyze a set of SQL queries and suggest index changes that could improve their performance.
Using DTS Global Variables
Global variables are a little known solution in Data Transformation Services (DTS). Often packages become "stale", where you must develop a package for each client.
Case Statement Tricks
The CASE statement is a very flexible tool. Here are just a few of the tricks you can work with it.
Blogs
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Forums
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
What's the Date?
Comments posted to this topic are about the item What's the Date?
Two New Shortcuts for Fabric Lakehouse Developers: The Fabric Modern Data Platform
Comments posted to this topic are about the item Two New Shortcuts for Fabric...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers