top stories

Browse By Category

Review: DBArtisan XE

By Michael Otey, 07/26/2010

Learn how DBArtisan XE tackles the problem of heterogeneous database management, including managing SQL Azure databases....

At TechEd 2010 I had the opportunity to talk with several of the development tools vendors. So many vendors mentioned that database design should be in the hands of developers rather than DBAs that it’s looking like a trend. An ominous trend based on the supposition that DBAs don’t really understand coding and the development process....

Solution to Determine Academy Award Best Picture

By Itzik Ben-Gan, 07/23/2010

Itzik presents a fun challenge that will help improve and polish your T-SQL skills....

Cloud Computing: It's Not Quite Ready, but You Need to Be

By Brian Moran, 07/22/2010

Brian explains why you'll eventually have to make cloud computing work for you, whether you like it or not....

SQL Server Database Engine Basics

By Louis Nguyen, 07/21/2010

Although the SQL Server database engine is the core service for processing data, it's often misunderstood. However, knowing how the database engine retrieves and modifies data is helpful....

Migrating Data from Database to Database

By Carl Ganz Jr., 07/20/2010

Use this stored procedure to copy data from a source server to a target server while leaving the existing objects and database structures in place....

AutoAudit

By Kevin Kline, 07/20/2010

Dynamically create audit trail triggers using this set of T-SQL scripts....

T-SQL Deep Dives: Create Efficient Queries

By Itzik Ben-Gan, 07/08/2010

Coming up with a T-SQL query that not only works but also performs well can be challenging. Here are some tips and techniques on how to efficiently perform some common querying tasks....

SQL Server 2008 R2 Express Installation Options

By Michael Otey, 06/25/2010

SQL Server 2008 R2 Express is packaged differently than previous versions of SQL Server Express--learn how, where, and what you should be downloading, and why....

How the New Database Security Law Affects You

By Brian Moran, 06/24/2010

Several months ago, Massachusetts passed a sweeping new data security law that will have a profound impact on the way the United States, and perhaps the rest of the world, manages and develops data-centric applications. Oddly, most people in the business and technical communities don’t seem to know about it....