Developers love database programming tips, tricks, and workarounds—especially those that slash development time or boost application performance. Here's a collection of such nuggets for developing SQL ...

I've been working with SQL Server for over 20 years now, Generally, I limit my tools to the things I might expect to find in a given client environment. My toolbox typically includes the tools that ...

Failing that, you might try hitting your favorite P2P to see if you can download a SQL Server CD ISO from somewhere. I'm not sure if the client tools are available seperately, but a brief google ...

In this second delve into data cleanliness (read the first, How clean is your data?, here), we’ll test-drive the data profiling tool provided with Microsoft SQL Server. Other profiling tools have ...

I installed SQL Server 2008 SP1 recently to bring my server up to build 10.0.2531 and after 30 minutes I was in business. I tested out SSMS and Reporting Services and ...