Brian Larson

Brian
Larson
15

Brian Larson is a technology author and the Chief Technology Officer/Owner at Superior Consulting Services in Minneapolis, Minnesota. He has presented at national conferences and events including SQL Server Connections, the PASS Summit, and the Microsoft BI Conference. As a consultant to Microsoft, Larson contributed to the original code base of SQL Server Reporting Services.
 
He has worked in the computer industry since 1985 and has been a consultant creating custom database applications since 1989. Larson is an MCSE: Business Intelligence 2012 and a Microsoft Certified Database Administrator (MCDBA). He is also the author of “Microsoft SQL Server 2012 Reporting Services: 4th Edition” and “Delivering Business Intelligence with SQL Server 2012: 3rd Edition” as well as co-author of “Visualizing Data with Microsoft Power View” all from McGraw-Hill Professional.

Articles
Effective Data Visualization - The Eradication of Ruler Reports

Effective Data Visualization – The Eradication of Ruler Reports

I once had an efficiency consultant tell me that he went into an office looking for a ruler left out on someone’s desk. This was a sure sign that person received one or more reports that were so large and so complex, it was necessary to lay a ruler across the report in order to read it properly. These “ruler reports” were the first candidates to be redesigned and replaced.

Power Tools – Microsoft’s Business Intelligence Toolbox
Which is the right Microsoft Power Tool for your job: Power Query, Power Pivot, Power View, Power Map, Power BI or Power Q&A?
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
May 18, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 24: Synchronizing SSIS Packages

In my previous post I covered options for adding “If-checks” into SSIS Packages – or SQL Server Maintenance Plans (which are, effectively, specialized SSIS packages). Once you’ve tackled that process, you’ll need to tackle something else when it comes to managing SSIS packages in conjunction with AlwaysOn Availability Groups. Or, more specifically, you’ll actually need to tackle two tasks....More
May 13, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 23: Maintenance Plan Backups and SSIS Packages

In my last post, we took a look at some of the details involved in actually implementing backups against databases being hosted in AlwaysOn Availability Groups. In addition to providing a high-level overview of how sys.fn_hadr_backup_is_preferred_replica() works, I also mentioned that integrating it into backups managed by SQL Server Maintenance Plans isn’t as easy as what you’ll run into with other types of backups....More
Apr 28, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 22: Executing Backups

Ultimately, there are a number of ways that DBAs can regularly create backups of their databases. Some of the more common options for managing backups include:...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) ×