As data continues to explode, DBAs must constantly stay a step ahead by finding new ways to improve database efficiency and performance. Managing data in today’s complex IT environment requires ...

New features for Visual Studio come from all manner of sources, with IDE extension author extraordinaire Mads Kristensen being near or at the top of the list. He solicits feature feedback regularly ...

SQL Server guru Denny Cherry is going to be telling stories during his upcoming session "Things You Should Never Do In Microsoft SQL Server" at the Nov. 17-22 Live! 360 conference at the Royal Pacific ...

Maximize your SQL Server performance – right now! Optimizing SQL Server performance is challenging work. And while you can find a lot of info on general performance problems, there hasn’t been much ...

Arranging SQL data so that you can effectively analyze it requires an understanding of how to use certain SQL clauses and operators. These tips will help you figure out how to build statements that ...

A SQL Server expert gives his take on the absolute, No. 1, very worst thing IT pros can do when it comes to indexing. Consultant, author and Microsoft MVP Denny Cherry travels the world helping ...

SQL is a convenient way to manage and query your data, but badly written queries can tie up your database. Here are seven common SQL traps and how to avoid them. Database developers have it tough.

Russell Smith is a technology consultant and trainer specializing in management and security of Microsoft server and client technologies. He is a Microsoft Certified Systems Engineer with more than 15 ...

When it comes to assigning value to different components in today’s IT environment, it would be a serious mistake to underestimate the value of data and databases. Whether you are looking to reduce ...