If you've just started writing SQL Server queries, there's a good chance you probably wrote a query, saw it return the right ...

I’m often called upon to investigate problems with an unfamiliar SQL Server database. So I need to gather information about the server and its databases quickly. With this in mind, I have a set of ...

With every release of SQL Server come the new Microsoft certification exams. In 2000 we had the MCDBA. In 2005 and 2008 we had the MCTS and the MCITP. Now in 2012 we have the MCSA and the MCSE. (Not ...

Microsoft has made some big promises for SQL Server 2008, a major update of its enterprise database product. No precise date has yet been announced for the launch, but the new features have caught the ...

What’s your average success rate of getting a SQL statement right on the first try? In best case, you botched a simple statement without side effects and just have to try again with correct syntax or ...

Microsoft strengthened its hand in the database market Thursday by releasing the first 64-bit version of SQL Server. The product should help Microsoft address a broader segment of the database market, ...