Have you ever found yourself with the need to copy SQL Server logins from one server to another? It'll come in handy if you're setting up a failover site, building a replacement server, setting up a ...

It's not 2008 anymore. Joey details the ins and outs of upgrading these aging Microsoft servers, including licensing changes, support options and potential pitfalls. It was a simpler time. A decade ...

Microsoft extended support for all editions of SQL Server 7.0 ended on Jan. 11. Considering that this edition was initially replaced 11 years ago by SQL Server 2000 (and there have been three more ...

SQL Server 2000 is at the end of its product lifecycle and will lose its "extended support" from Microsoft on Tuesday, April 9. The loss of extended support means no more security updates will be ...

In SQL Server 2005, Microsoft introduced the Upgrade Advisor. This was a great idea to be able to analyze your current SQL Server in a safe environment and start the planning process of an important ...

This month’s collection of fixes from Microsoft includes 86 patches — but at least there were no zero-day bugs.

Microsoft on Friday posted Service Pack 4 for SQL Server 2000, the first service pack update for the company's flagship database server since early 2003. The major new feature of the service pack is ...

So, my client and their subcontractor(s) have found themselves in a bit of a pickle, as no one bothered to spec or price a DB for a software implementation, so now I've been handed the bag. The client ...