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
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.
Microsoft's Azure SQL Database-as-a-Service Improvements Highlighted at Pass Summit 2014
At the Pass Summit today, Microsoft kicked off the event with announcements around upcoming improvements to Azure SQL and also unveiled a Machine Learning free-for-all.
Cumulative Update 4 Released for SQL Server 2014
Microsoft has released SQL Server 2014 CU4, and it contains over 50 hotfixes.
Azure SQL Database Pricing Altered by Microsoft Before General Availability

During the Azure SQL Database Preview period, Microsoft took feedback from testers and developed new pricing schemes, a new performance offering, and enabled hourly billing.

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
Feb 25, 2015
Commentary

Data Profiling to the Rescue by Pushing Metadata Boundaries 1

Don’t let bad data sneak up on you when and where you least expect it. Ferret out bad data with Melissa Data’s newest Profiling Component for SSIS. Learn how to take control of your data using knowledge-base-driven metadata. The truth shall set you free!...More
Feb 16, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 18: Health Checks for Availability Groups 1

Now that we’ve outlined the process to let servers in a SQL Server AlwaysOn Availability Group "talk to each other" by means of setting up linked servers, it’s possible to set up some additional or improved checks on Availability Group Health....More
Feb 11, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 17: Creating Jobs to Check on Synchronization

In my previous post, I provided a high-level outline of the core logic (and rationale behind that logic) that would be needed to set up regular synchronization checks on SQL Server Agent Jobs for servers where AlwaysOn Availability Groups have been deployed. In this post, I’ll walk through the steps--and the code--needed to setup those checks....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) ×