Stacia Misner

Stacia Misner is a SQL Server Pro contributing editor, a SQL Server MVP, a consultant, educator, mentor, and author specializing in business intelligence solutions since 1999, with more than 25 years of experience in information technology.
Stacia is the author and co-author of eight books about business intelligence, including Microsoft SQL Server 2008 Reporting Services Step by Step and Introducing SQL Server 2008 R2. Stacia provides consulting and custom education services through Data Inspirations.

Articles
Implement Kerberos Delegation with SSRS 3
With a basic understanding of how the Kerberos pieces fit together and a step-by-step implementation guide, you can easily and correctly configure Kerberos for your SQL Server Reporting Services (SSRS) environment.
travel suitcase
Touring the Tablix in SQL Server Reporting Services
The tablix provides a lot more flexibility for your data layout than its counterparts provided in earlier versions of SQL Server. Not only do you have more flexibility, but you have the option of rearranging the layout rather than starting a new layout if you discover that a matrix would be better than a table or vice versa.
SQL Server Reporting Services diagram
Understanding SQL Server Reporting Services Authentication 3
Configuring authentication in SSRS isn't always a straightforward task because it occurs at multiple points and involves multiple technologies. This guide will show you the basics so you can get started.
SQL Server Parallel vs Sequential Package Properties screenshot
Designing SSIS Packages for High Performance 1
Designing a SQL Server Integration Services (SSIS) package, the choices you make can affect its performance. Here’s how to find and fix performance bottlenecks in your package’s design.
Use Checkpoints to Restart Failed SSIS Packages
With checkpoints, you can skip past completed tasks whenever you need to restart a failed SQL Server Integration Services (SSIS) package, saving time. However, configuring checkpoints correctly is crucial.
SSRS 2008 R2 and SharePoint 2010 Integration 4
Install and configure SSRS in SharePoint integrated mode for easier report management
Use Properties to Improve Report Presentation
Push the envelope on report design by using BIDS properties to refresh and paginate onscreen reports, keep data regions together on a page, and produce multicolumn reports.
paint brush and bright colored paint on canvas
Enabling Information-Management Policies
Learn how to configure document auditing and expiration features in MOSS 2007.
SSRS and MOSS 2007: Deploying the Power
Deploy SSRS and MOSS 2007’s information-integration features to help business users find what they need, analyze results, and share their insights for better decision making.
Creating Alerts
MOSS includes a self-service alert system that users can set up themselves to find out when a new report is available or when a favorite report has changed. But you should still know how the system works so that you can show others how to use it.
Information Integration: SSRS and MOSS 2007 3
SSRS and MOSS integration promises better information access and report administration, but what will you have to do to make it work? This first article of a two-part series shows you how to set up SSRS and MOSS's information-integration environment.
What Can I Accomplish with Other SharePoint Technologies? 3
You can achieve the best information-integration experience by using MOSS, but don’t despair if you have Windows SharePoint Services 3.0 (WSS) or MOSS Standard Edition.
The Differences Between Authentication Modes 3
To select the appropriate authentication mode for your MOSS Web application configuration, here’s a quick guide to the differences between the available modes.
Migrating Reporting Services to MOSS

If you’re already using Reporting Services and are planning to move your reports to MOSS, you should be aware the migration process is entirely manual. There is no migration utility provided to move your reports to the MOSS server, and you won’t be able to use the RS.exe utility to automate the process of publishing reports to MOSS. Instead, you’ll use the deploy command in Business Intelligence Development Studio to copy reports from a Report Server Project to MOSS.

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 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
Jan 22, 2015
blog

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

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
Dec 16, 2014
Sponsored

Eight SQL Server Signs the Illuminati Exist 1

Make no mistake about it, the signs that the Illuminati exist are all around us. You can find their markings on our buildings, on our currency and even in our music videos. That’s right, they’re everywhere!...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) ×