While SQL Server Reporting Services provides an easy way to upload an RDL file into Reporting Services, it doesn't provide an easy way to extract the RDL file. Fortunately, you can use the ReportService2010 web service to do this....More
A recap of this week's news on SQL Server Pro, including insights on SQL Server 2014 adoption, Microsoft's new Analytics Platform System that's bringing a data culture to every organization, and new third-party business intelligence solutions....More
In the news today is a survey of databases in use, the release of Forerunner Mobilizer to manage SQL Server Reporting Services across mobile devices, and OpenShift by Red Hat's plans to add SQL Server support to its cloud platform.
I know all the Microsoft buzz is about Power BI and Excel these days, but customers need real-world, professional business intelligence solutions that meet their complex real world requirements today....More
Despite similar intentions and high-level goals, the ways in which AlwaysOn Failover Cluster Instances and AlwaysOn Availability Groups tackle high availability and disaster recovery are quite different....More
While AlwaysOn Availability Groups are a powerful solution that let DBAs tackle both high availability and some disaster recovery concerns from within a single, unified, set of technologies and tooling, AlwaysOn Availability Groups also come with a number of challenges....More
For some businesses, conducting a health check can be cumbersome, time-consuming, and the results, well, frustrating. However, a health check can be easy and rewarding for any business that wants to improve server performance, especially if you take the time to find the right solution provider....More