More in Audience

  • Mar 14, 2015

    For Data Quality, Intelligent Rules Add Value to the Golden Record 6

    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
  • man sprinting through datacenter
    Oct 30, 2013

    SQL Server High Availability with Amazon EC2

    DataKeeper Cluster Edition from SIOS Technology can be used to provide a SQL Server high availability solution within the Amazon EC2 environment....More
  • New business intelligence diagram
    Oct 29, 2013

    Old BI vs. New BI 3

    A very common reference to business intelligence approaches has emerged, comparing "old BI" to "new BI."...More
  • Oct 22, 2013

    Other Tools For Measuring I/O? 1

    There are a few different ways to monitor the I/O workload of a server. The easiest for the database administrator to use will always be Performance Monitor because that is built into the Windows OS....More
  • Sep 23, 2013

    Integrating MongoDB and Open Source Data Stores with Power Pivot

    Business users don't care where data is stored or where it's coming from. By using data integration tools, you can expose MongoDB data stores to users through Excel, enabling Power Pivot models and Power View visualizations....More
  • Sep 5, 2013

    Virtual Clustered SQL Servers Get a Big Feature in VMware 5.5 1

    There are a lot of folks out there who have SQL Server clusters setup under Hyper-V and VMware. One of the issues on the VMware side of things has been the MPIO configuration....More
  • Aug 30, 2013

    Database Mail Tip: Notifying Operators vs. Sending Emails

    I recently discovered that to improve SQL Server's Database Mail functionality, it's more effective to send alerts and notifications to Operators than to email addresses....More

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.


From the Blogs
Nov 3, 2015

Climb the Steps Toward Data Quality Success

Melissa Data's Data Quality Analyst Joseph Vertido explains how Gartner defines the critical data quality steps to prevent bad data from entering your systems in the first place, and then keep it clean over time....More
Sep 29, 2015

Data Breaches and Insider Threats

I’ll sound a bit like Captain Obvious for bringing this up, but it’s important to remember that security encompasses a lot more than protecting sensitive data from the specter of outsider threats like hackers. Properly implemented security policies also account for threat-models that include insiders – or people within your organization....More
Sep 15, 2015

Setting Up Additional Checks to Ensure Regular Transaction Log Backups 1

There’s simply no way to overstate the importance of regular Transaction Log Backups. Not only do they help protect from disaster, but regular execution of T-Log backups on Full (and Bulk-Logged) Recovery databases helps keep thing “fit and trim”. Most of the time, setting up a Notification for when T-Log Backup Jobs fail is enough to let you know when something goes wrong....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×