Rod Trent


Rod Trent is the owner of, a Microsoft BackOffice administrators’ Web site and training company. He is an enterprise systems management expert for and a freelance technology author. His most recent book is Admin911:SMS (Osborne/McGraw-Hill).

PSA: SQL Server 2005 Reaches End-of-Life April 12, 2016
SQL Server 2005 is set to be retired next year. You have less than 6 months to migrate.
Microsoft Ignite: Data is Sexy
Microsoft is investing significant resources to develop concepts and technologies to manage the massive amounts of accumulating data.
Big Data Speaks a New Language as Microsoft's Revolution Acquisition Completes
Microsoft today has confirmed it has finalized the acquisition of Revolution, bringing the R language to Big Data and to SQL Server.
IT/Dev Connections 2015 is a Deeply Technical, Community-Driven Conference

If you can only attend one technology conference this year, IT/Dev Connections 2015 could possibly your best bet.

IT/Dev Connections 2015 Call for Sessions Now Open!
The call for session proposals is now open for IT/Dev Connections 2015!
Rackspace Extends SQL Server 2014 to its Managed Private Cloud
Rackspace has announced that it is making SQL Server 2014 available as part of its Managed Private Cloud.
Cumulative Update 4 for SQL Server 2012 SP2 Now Available
The latest cumulative update is available for SQL Server 2012 SP2.
Manage MDS Data for SQL 2014 Inside Excel with This New Add-in
A new add-in for Microsoft Excel users provides MDS access and functionality within the Office product.
Microsoft Connects Power BI to On-Premises SQL with Preview Tool
A new client connects SQL Server Analysis Services instance directly with Power BI Analysis Services.
CU5 for SQL Server 2014 Brings Fixes and Enhanced Support for Azure SQL Database 1
CU5 has released and amid the accumulated updates Microsoft is providing some useful functions for Azure SQL Database management.
Monitor SQL Server 2014 for Proactive Management and Minimal Downtime
Microsoft has released an updated Management Pack that adds new functionality to monitoring SQL Server 2014.
IT/Dev Connections 2015 Registration Opens!
Some think it might be difficult to improve on the 2014 event, but IT/Dev Connections 2015 is going to be even better.
SQL Server PHP and JDBC Drivers Released to GA
The drivers for PHP and JDBC for SQL Server spent just around a month in beta and are now publicly available.
Hottest Technologies of 2015? You Decide
In less time than it takes to "Like" the latest Facebook post about Six Million Dollar Man lunch boxes, you can help us shape the top technology trend predictions for 2015.
Auditing for Azure SQL Database Exits Preview
After just 3 months in preview, Auditing for Azure SQL Database is now publicly available.

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) ×