Reminiscing
Steve Jones has been working with SQL Server for 10 years. Join him for a stroll down memory lane.
2004-05-31 (first published: 2002-05-23)
5,787 reads
Articles
SQL Server 2005 Beta 2 Gets Close
Microsoft began taking sign ups for participation in the SQL Server 2005 Beta 2 program this week at its Microsoft TechEd show here as the long-awaited test version of the product gets close to availability.
2004-05-29
3,783 reads
Database Tools for SQL Database Editing Released
Apex SQL Tools has released Apex SQL Edit 3.0, database Tools for database editing. Apex SQL Edit is an integrated development environment (IDE) for SQL Server including powerful editing capabilities, deployment capabilities, full integration with Visual Source safe as well as SQL Server Reporting services and much more.
2004-05-28
539 reads
Microsoft to Step Up Server Product Release Schedule
Microsoft Corp. is planning to deliver updates to its Exchange Server product every two years and is considering a similar move to deliver SQL Server updates in a more timely manner, company officials said at the TechEd 2004 conference.
2004-05-28
3,793 reads
Change Management in Your Database
SQL Server has no change management integrated with the native tools. This means that each person must develop their own method of handling changes, or live with the chaos that will inevitably ensue. There are a number of articles written about various ways to handle change management and Dinesh Asanka shares his here. Read on and see if this helps you get a handle on changes in your environment.
2004-05-27
7,233 reads
Replication Gotcha - Columns with Defaults
Some days the simplest things go wrong. On this particular day Andy tried to remove a column that was part of an article in a transactional publication, wound up in an inconsistent state that required a snapshot to fix. Deeper investigation reveals the cause and a work around.
2004-05-25
7,556 reads
Every DBA Should Know Which Databases are be Backed Up
Do you know which of your databases are being backed up? Everyone answers "Yes", but I'm sure that there are times that someone creates a new database and you don't know about it. I know in my job, with hundreds of servers, it happens. Here's a technique for keeping track of those databases from Leo Peysakhovich.
2004-05-24
13,493 reads
Don't Get Left Behind
Production DBAs may be a dying breed. At least according to some sources. While we're not sure that we agree with that, there is definitely a trend that should have you working on your career. The day of the DBA that only manages the operational data store is waning. Today's DBAs need to be flexible and have a number of other skills. Brian Knight looks at a few of the skills that you might to add to your arsenal to be prepared for the future of SQL Server.
2004-05-21
10,943 reads
Quest Central For SQL Server (Freeware)
Quest Central® for SQL Server is an integrated database management solution designed to enable administrators to manage complex database environments and simplify everyday tasks. Quest Central for SQL Server provides DBAs with a set of tools to achieve higher levels of availability and reliability, leverage and extend native SQL Server administration capabilities, and adds multi-server and change management capabilities to make database management easier.
2004-05-21
649 reads
Creating a System Stored Procedure
Creating a system stored procedure isn't hard. You're always cautioned from making changes to the system, depending on the system for a particular functionality, etc., and you should be cautious. However adding system stored procedures to your servers can be beneficial and make your administration much more convenient. Read on the see how easy this can be to do.
2004-05-20
13,991 reads
Blogs
KDA: Echoes of Deception - Case 7
By Zikato
A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and...
Do This Before You Contact Your SQL Server Consultant
Say you need outside help. You’ve exhausted all the things that you could do...
Microsoft MVP 2026: Ten Years on the Data Platform
I’m honored to announce that I’ve been renewed as a Microsoft MVP for the...
Forums
Implicit Conversions Cripple SQL Server
Comments posted to this topic are about the item Implicit Conversions Cripple SQL Server
BIT_COUNT() III
Comments posted to this topic are about the item BIT_COUNT() III
The Mythical Bus Accident
Comments posted to this topic are about the item The Mythical Bus Accident
Question of the Day
BIT_COUNT() III
In SQL Server 2025, I run this code:
select bit_count(-1)What is returned? See possible answers