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

Eight SQL Server Signs the Illuminati Exist

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
Dec 2, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 16: Job Synchronization Checkup Logic

With Linked Servers configured to allow cross-host or cross-box communication between the servers you’re using to host your AlwaysOn Availability Groups, it’s time to start looking at some scripts that can be used to regularly check whether or not SQL Server Agent jobs are correctly synchronized across all servers in your topology....More
Abstract illustration of linked SQL Servers
Nov 18, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 15: Setting Up Linked Servers

Learn about setting up Linked Server definitions to let two (or more) servers in an AlwaysOn Availability Group talk to each other and check up on job statuses of jobs running on each other....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) ×