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
New Power BI Designer unifies the “power” tools
Jun 3, 2015
Article

Power BI Preview Gaining Market Momentum

As summer nears, the Power BI Preview is making bigger waves with every weekly release. Popular data sources and a plethora of Power BI Designer enhancements are being released at light speed pace. Check out the highlights on what has been released and what we might see next....More
Evolution of SQL Server continues
Jun 3, 2015
Article

What is Coming in SQL Server 2016 for Business Intelligence 1

Over the past few years we did not hear anything from Microsoft about SQL Server on-premises business intelligence enhancements. The extended cricket-chirping silence left us speculating about the future of Reporting Services, Analysis Services and other key technologies that are being used today to power critical decision making solutions. Good news, the waiting and wondering is over. Microsoft recently announced significant SQL Server on-premises upgrades for business intelligence in numerous presentations at both //build and Ignite conferences....More
May 28, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 25: Final Remarks on Backups

In the last few posts (posts 19 – 24) I’ve covered some high-level concerns and reviewed some details about how to implement and manage database backups against AlwaysOn Availability Group databases. Most of the information I’ve provided was pretty basic or elementary – along with some additional guidelines for things to watch out for when managing backups. Which is to say that backups are never something you can simply take for granted and they’re never something you just take lightly....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) ×