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