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

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.
SQL Server Gets PHP Support, Java Support on the Way
Today Microsoft has released a driver to allow PHP developers to connect directly with SQL Server and Azure SQL Database.

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
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
Sep 1, 2015

Stop Using INFORMATION_SCHEMA and SysObjects for Exists Checks 3

Code like this isn’t optimal: IF EXISTS(SELECT * FROM sys.objects WHERE name = N'TableToDrop' AND type = 'U')         DROP TABLE TableToDrop; GO Neither is this: IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'TableToDrop')         DROP TABLE TableToDrop; GO Yet, I see both of those used all of the time – over and over again. Even though it’s 2015.  ...More
Aug 27, 2015

A Replacement for Maintenance Plan Backups 1

This blog post is a bit of a ‘repeat’ – since I already covered much of the rationale behind this post in Part 23 of my multi-part series on AlwaysOn Availability Groups and SQL Server Agent Jobs. But, I also figured that this is enough of an important topic to merit its own blog post....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) ×