Technology is ever changing and very few areas are stable. This makes information technology interesting, but challenging. T-SQL or Transact-SQL is one area that is stable. There is also a vast use of T-SQL and many career options.
Read moreThe excitement of the new .NET Framework 4.6 and Visual Studio 2015 is in the air. The scheduled release date has arrived. Here are some exciting new features that will be sure to change the .NET developer community. Although there are many more, I have picked 10 favorites.
Read moreReporting Services, a feature in SQL Server that supports reporting, can be installed in one of two modes: SharePoint Integrated or Native (non-SharePoint) mode. This option appears at the time of installation and can be changed later. Once selected, the mode determines where users will view deployed reports.
Read moreMicrosoft’s SQL Server query optimizer uses a cost-based approach by deciding on the “good enough” way — not necessarily the best way to retrieve results. This is because considering all possibilities for retrieving the data might be inefficient.
Read moreYou can do more work faster by using keyboard shortcuts. To help, here are a dozen more keyboard shortcuts that will help make your SQL work faster and more efficient.
Read more