Build a portfolio of SQL projects, starting small and then moving to more complex ones. Showcasing these on platforms like ...

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 ...

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 ...

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 ...

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 ...

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.

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 ...

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 ...