The importance of automating processes can’t be overestimated. Most things start out as a manual procedure until you work out exactly how things should happen, but many times they stay that way ...

Every professional programmer (and DBA) should have a library of books on SQL fundamentals. There are many SQL titles to choose from, and a lot of them are very good. But this month's column will ...

SQL, which stands for Structured Query Language, is a standardized programming language used for managing and manipulating relational databases. It allows users to interact with databases, perform ...

Get ready to scale out SQL Azure databases beyond today's 50GB limit with the Transact-SQL and ADO.NET elastic sharding features, which are coming in the 2011 SQL Azure Federation Community Technology ...

It’s easy to wonder if the new version of a product is really any different than the previous one, especially when it’s as established as SQL. Given the expense and effort needed to upgrade, it’s a ...