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
In my previous post, I provided a high-level outline of the core logic (and rationale behind that logic) that would be needed to set up regular synchronization checks on SQL Server Agent Jobs for servers where AlwaysOn Availability Groups have been deployed. In this post, I’ll walk through the steps--and the code--needed to setup those checks....More
Now that we’ve outlined the process to let servers in a SQL Server AlwaysOn Availability Group "talk to each other" by means of setting up linked servers, it’s possible to set up some additional or improved checks on Availability Group Health....More
Make no mistake about it, the signs that the Illuminati exist are all around us. You can find their markings on our buildings, on our currency and even in our music videos. That’s right, they’re everywhere!...More