There are a few terms that often are confused in SQL Server. These are locking, blocking, and deadlocks. These are all very different from each other.
Locking is a normal and desirable process. Blocking is also normal, but is less desirable. Deadlocking is not a normal process and is never desirable.
Read moreUsing keyboard shortcuts lets you do more work faster. One of the best ways to work faster is to utilize your keyboard and the shortcut options it provides. Here are some basic keyboard shortcuts that will help make your SQL work faster and more efficient.
Read moreWell, as TechEd 2013 came to a close, I left both excited and overwhelmed at the same time. I feel that I know more than I did before I came and that I don’t know nearly enough.
Typically, Microsoft announces some big thing at TechEd each year. In 2012, it was the unveiling of the final features to be released with Windows 8 and Server 2012. These were both known quantities, but the feature parade was stunning nonetheless.
This year Microsoft did not disappoint. They announced the upcoming release of Windows Server 2012 “R2” and System Center “R2.”
Read moreOne of the most difficult concepts for me as I was learning database syntax was joins. Of course, I tried reading and understanding articles and books that dealt with this topic. In almost every case, I was faced with the Venn diagram examples.
Read moreMicrosoft recently released Exchange Server 2013, an improved messaging platform that provides quite a few interesting features at various levels. There are major changes, and organizations will have to rethink the way they plan to maintain or integrate messaging in their infrastructure. The level of changes is not as dramatic as those seen between 2003 and 2007, but as you will see, certain things are dealt with differently. As of now, very few organizations have Exchange 2013 running, so it is certainly going to be interesting to see how this iteration of the product will interconnect with existing messaging solutions soon.
Read more