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
An option when creating new AlwaysOn Availability Groups is to specify Backup Preferences.
It’s also something you can easily configure once the Availability Group has been set up as well – by simply right-clicking on the Availability Group and selecting Properties – then navigating into the Backup Preferences tab. ...More
The quest for the Golden Record to achieve a single, accurate and complete version of a customer record is worth the pursuit to attain survivorship. Record matching and consolidation are only the beginning. Melissa Data takes a new approach. Learn how to apply intelligent rules based on reference data to make smarter and better decisions for data cleansing....More
On SQL Servers where Availability Groups (or Mirroring) isn’t in play, I typically recommend keeping a combination of on-box backups along with copying said backups off-box as well. Obviously, keeping databases AND backups on the SAME server is the metaphorical equivalent of putting all of your eggs in one basket – and therefore something you should avoid like the plague....More