Paul Turley

Paul
Turley

Paul Turley is a SolidQ mentor and SQL Server MVP. He's an active member of the SQL Server community and director of the Oregon SQL user group. He has authored or coauthored 12 books, including the SSRS, BI, and database reporting series from Wrox.

Articles
Getting Started with Datazen, Microsoft’s New Mobile Dashboard Platform
Microsoft Datazen is a robust, enterprise-scale server-hosted mobile dashboard platform that works on every mobile platform – the iPad and iPhone, Windows desktop, tablet and phone, Android devices and HTML5 with full fidelity. To use Datazen, you don’t need SharePoint, a cloud subscription, Office or any other software.
Setting Up a Datazen Server
In this article, second in the series, we setup the Datazen server in preparation for designing basic dashboards in Part 3. Later on, we’ll explore advanced designs and dashboard interactions using parameters and drill-through navigation. If you haven’t already, read the first article to understand the server components and tools you’ll need to get started.
SSAS Tabular-Part 3: Tabular Model Administration

This is the third article in the four part series about designing SSAS Tabular models.  In this article you will learn how to manage and secure a deployed model on the server.

Part 1 - Getting Started with SSAS Tabular

SSAS Tabular-Part 4: Deep Dive DAX

This is the fourth and final article in the four part series about designing SSAS Tabular models.  We go deeper into the DAX language to define more advanced measures and KPIs.

Part 1 - Getting Started with SSAS Tabular

SSAS Tabular-Part 2: Easy DAX: Getting Started with Data Analysis Expressions
In this second in a series of four articles about designing and using Tabular models, you will learn how to get started with Data Analysis Expressions. In the articles that follow, we will add more sophisticated features to deliver production-scale solutions.
Starting Your Modeling Career with Analysis Services Tabular Models Part 1
Microsoft's introduction of the xVelocity in-memory analytics engine in 2010 is a significant game-changer for business intelligence and data management. The availability of this impressive technology and its future application in new product features will change the way you store and consume data, and it's at the heart of SSAS Tabular.
illustration of data mining in old underground mine shaft
Getting Started with Data Mining in SQL Server 2
Use the Data Mining Model Designer in SQL Server Data Tools (SSDT) and the data mining add-ins for Excel 2013 to mine data in SQL Server.
Custom Programming to Enhance SSRS Reports
One of the most compelling capabilities in SQL Server Reporting Services (SSRS) is the ability to extend report features with custom code and programming extensions.

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