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 ...

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 ...

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 ...

Help! My SQL Server Log File is too big!!! Your email has been sent Overgrown transactional log files can turn into real problems if they are not handled properly. Today SQL Server consultant Tim ...

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 ...

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 ...

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 ...

Microsoft made available for download on September 20 a Customer Technology Preview (CTP) test build of a first update to its SQL Server 2012, the latest version of its database. Microsoft released to ...

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 ...