Tyler Chessman is a technology specialist for Microsoft, helping customers evaluate and adopt Microsoft's business intelligence (BI) platform. He's the author of the book Understanding the United States Debt (CreateSpace).
Estimated execution plans are very useful when trying to see how complex and large a query is. However, these plans aren't always generated. Find out why estimated execution plans aren't generated in certain situations.
How can you use SQL Server 2005 Reporting Services to deploy reports when Windows Authentication isn’t available—and without the risk of one partner seeing another’s data? Here’s how to set up custom authentication and filtering for Web-based reporting.
Are you wondering about alternatives for providing reports in a non-Windows–authenticated environment? One effective approach is the use of the Report Server Web service. Here are the pros and cons of this solution.
Windows Server 2012 or Windows Server 2012 R2 Standard Edition is a great way to save thousands on licensing—and save yourself some serious headaches when deploying SQL Server AlwaysOn Availabiliity Groups....More
While I believe that NoSQL can have some places where it legitimately makes sense, I also believe that NoSQL is also the patently wrong choice for a number of different types of applications or use cases....More
Initial word on the street is that SQL Server 2014 has been very stable so far—which is probably why it went to release so quickly and bypassed what would typically have been another pre-release....More