Rod Trent

Rod
Trent

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

Articles
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
May 18, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 24: Synchronizing SSIS Packages

In my previous post I covered options for adding “If-checks” into SSIS Packages – or SQL Server Maintenance Plans (which are, effectively, specialized SSIS packages). Once you’ve tackled that process, you’ll need to tackle something else when it comes to managing SSIS packages in conjunction with AlwaysOn Availability Groups. Or, more specifically, you’ll actually need to tackle two tasks....More
May 13, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 23: Maintenance Plan Backups and SSIS Packages

In my last post, we took a look at some of the details involved in actually implementing backups against databases being hosted in AlwaysOn Availability Groups. In addition to providing a high-level overview of how sys.fn_hadr_backup_is_preferred_replica() works, I also mentioned that integrating it into backups managed by SQL Server Maintenance Plans isn’t as easy as what you’ll run into with other types of backups....More
Apr 28, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 22: Executing Backups

Ultimately, there are a number of ways that DBAs can regularly create backups of their databases. Some of the more common options for managing backups include:...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) ×