Roman Rehak is a developer, author, and speaker working at Competitive Computing in Burlington, Vermont. He is an MCSD, an MCDBA, an MCSA, and an active member of Professional Association for SQL Server (PASS).
The Native XML Web Services feature in SQL Server 2005 removes dependency on IIS to help you create robust, feature-rich enterprise database solutions. Here’s how the feature works, how to implement it, and how to code client applications.
The Database Maintenance Plan Wizard makes creating maintenance plans easy, but making less-optimal (or erroneous) choices is also easy. Follow these guidelines and avoid these gotchas when creating maintenance plans.
Digital Magazine Archives
Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.
High-quality data is key to uncovering meaningful insights and new opportunities. Melissa Data has recently released a new tool, Data Profiler, to help companies that are dealing with large quantities of data and need a full spectrum of solutions that work....More
Don't forget to migrate Power BI for Office 365 content before you leave for the holidays. Deprecation of Power BI for Office 365 starts at the end of December 2015. Here is what you need to know to successfully move your business intelligence content to the latest and greatest version of Microsoft Power BI....More