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.

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
Sep 29, 2015

Data Breaches and Insider Threats

I’ll sound a bit like Captain Obvious for bringing this up, but it’s important to remember that security encompasses a lot more than protecting sensitive data from the specter of outsider threats like hackers. Properly implemented security policies also account for threat-models that include insiders – or people within your organization....More
Sep 15, 2015

Setting Up Additional Checks to Ensure Regular Transaction Log Backups 1

There’s simply no way to overstate the importance of regular Transaction Log Backups. Not only do they help protect from disaster, but regular execution of T-Log backups on Full (and Bulk-Logged) Recovery databases helps keep thing “fit and trim”. Most of the time, setting up a Notification for when T-Log Backup Jobs fail is enough to let you know when something goes wrong....More
Sep 1, 2015

Stop Using INFORMATION_SCHEMA and SysObjects for Exists Checks 3

Code like this isn’t optimal: IF EXISTS(SELECT * FROM sys.objects WHERE name = N'TableToDrop' AND type = 'U')         DROP TABLE TableToDrop; GO Neither is this: IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'TableToDrop')         DROP TABLE TableToDrop; GO Yet, I see both of those used all of the time – over and over again. Even though it’s 2015.  ...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) ×