The first article in a series about moving your data from one server to another. Steve Jones has some techniques he's used for upgrading hardware, replacing existing servers, or just moving to a different server.
The first part of this series provides a road map for a very cool application using an under-utilized companion of the SQL Server 2000 database platform.
In this series by Quest Software's Kevin Kline, he shows you some tips to performance tuning T-SQL. This was contributed by Quest from their recent webcast. This white paper discusses various T-SQL discovery, optimization and tuning techniques using the SET and DBCC commands.
How many databases do you manage that have a NULL owner? Hopefully none, but if you have one, want to know how to fix it, or just need a few minutes break from work, dig in and read how I solved this annoying issue.
This article is the first of a multi-part series detailing the SQL Server Upgrade process from the technical, logistical and business perspective.
There may be more ways than you realize to determine the version and service pack of SQL Server. This quick article by Dinesh Priyankara will show you 3 of those methods.
If your shop is even close to the typical Micosoft SQL Server environment there are several people that can (and do!) make changes to the production environment, a change management system is in place, that change management system uses Source Safe to store database scripts, and what's in Source Safe does not match what's on the SQL Server. This utility by Bill Wunder will archive your SQL scripts and DDL into Source Safe easily and efficiently. All for the price of $0 (yes, free!).
In his travels, Christopher Duncan has come to recognize a great many similarities between programmers and musicians. Both have the fire, passion and soul of the artist. And all too often, both are aweful when it comes to the business end of things. Business - you know, that aspect of your work where they actually pay you at the end of the day?
A new series that examines how you audit activity in SQL Server. The first part looks at simple data auditing in a table.
Disk space is getting cheaper everyday. Why should you worry about the amount of space your data is consuming? This article by Neil Boyle presents some great reasons why you should be concerned.
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Hi everyone I am looking at building a query to determine how much time...
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Comments posted to this topic are about the item Hidden Heroes
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers