Brian Larson

Brian
Larson

Brian Larson is chief of technology at Superior Consulting Services in Minneapolis. He's a frequent presenter on SQL Server business intelligence and the author of Delivering Business Intelligence with Microsoft SQL Server 2005 (McGraw-Hill/Osborne). Through a special arrangement with Osborne/McGraw-Hill, we invite you to preview a chapter from Brian's new book on Writing a New Script-MDX Scripting

Articles
Take Control of Your Reports with ReportViewer, Part 2 1
The ReportViewer control is a powerful tool for integrating reports into Windows and Web form applications. You can make it even more powerful if you're willing to write a few lines of Visual Basic .NET or Visual C# code.
Take Control of Your Reports with ReportViewer
If you need more report functionality than SSRS can offer, Visual Studio 2005's ReportViewer control might be just what you need.
The Case of Locating National's Treasures
A mysterious email message leads B.I. Powers to track down codes on National Manufacturing's reports and teach them how to use meaningful names.
The Case of the Wicked Wrist Rapper
Is foul play behind the excessive number of wrist injuries at a local manufacturing company? Can B.I. Powers convince the company's president to use Analysis Services to secure access to data?
The Case of the All-Inclusive Collection
A fanatical collector demands a report that will let her see everything in her collections. Can B.I. Powers provide the solution by modifying a Reporting Services parameter?
The Case of the Multitudinous Dates 1
A date with a fig lands B.I. Powers in an investigation of a mysterious fruit theft. Can Powers help the nutty culprit create a time dimension?
The Case of the Historical Conundrum
Mysterious security-log entries put B.I. Powers on the trail of a time traveler. Can Reporting Services’ history snapshots save the culprit from performing unnecessary work?
The Case of the Out-of-Date Cube
B.I. Powers turns up an OLAP cube that's dragging a company into the past. Is SQL Server 2005 behind the latency? Can Powers find a simple solution?
The Case of the Possessed Server
When mysterious SQL Server Agent jobs appear on a seemingly isolated server, a DBA engages B.I. Powers to discover the cause. Is dear departed Uncle Wally trying to contact his nephew?
The Case of the Good Data Gone Bad
The intrepid B.I. Powers is engaged to track down missing data. Is the data loss part of an international conspiracy? Or is the solution closer to home?
Developing Familiarity with BI
SQL Server 2005’s BI tools might seem intimidating to relational database developers. But three new tasks offer and easy introduction to automating data analysis and data mining.
The Case of the Missing Link 4
When SQL Server 2000 Reporting Services administrator Greg Parker goes missing for more than a week, B.I Powers, consulting detective, is called in to find the hapless employee.
Reporting Services: It's De-lightful 11
Read all about the new SQL Server 2000 tool that has customers singing Microsoft's praises. Reporting Services, slated for release to manufacturing by the end of the year, handles the complete reporting life cycle.

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
detetecitve dressed in black looking at data
Sep 24, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 7: Detecting Primary Replica Ownership

In my mind, there are two logical ways that you might want to have your code check to see if the Primary Replica of a given AG database is currently hosted on a particular server or not...More
Two women looking a man's computer monitor
Sep 17, 2014
Article

AlwaysOn Availability Groups and SQL Server Jobs, Part 6: High-Level Options and Rationale for Handling Batch Jobs

There are a couple of options for how we could handle batch jobs when Availability Groups are thrown into the mix....More
Sep 12, 2014
Sponsored

Managing a Healthy SQL Server Database: Three Principles We Overlook

In managing a database or sometimes numerous databases, we often get caught up in the day-to-day maintenance and lose sight of the other principles we know are critical to ensuring optimal performance. Here’s a quick refresher....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) ×