As you will see in this chapter, companies use SQL Server for many types of applications and on most tiers now. Gone are the days when you would second guess yourself choosing to use SQL Server over a ...

Microsoft announced today that SQL Server 2008 R2 is released to manufacturing just 20 months after SQL Server 2008, the platform on which it is built. SQL Server 2008 R2 (codenamed Kilimanjaro) ...

SQL Server 2005, now available as a "community technology preview," is an odd beast. For those who believe their databases should be little more than simple data access routines with business logic ...

Microsoft's SQL Server toolbox is a morass of acronyms, from SMO to SSMS to SOS, and differentiating one from the other can be a challenge. I recently caught up with Vicky Harp, lead program manager ...

New BI and reporting features in SQL Server 2008 R2 hit the mark, but other additions leave SQL Server shops wanting more With Microsoft SQL Server 2008 R2, Microsoft begins to fully realize its ...

Using SSDT means we don't just shout orders at the database; instead, we plan what we're going to say. For almost 13 years, Microsoft has tried to make Visual Studio a place where developers can do ...

Well, in version R2, the tool offers a new way of looking at managing your server databases. Here's what you'll drool over. I've mentioned the SQL Server Utility briefly in past posts, but I want to ...