Brian Larson

Brian
Larson
14

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
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
Mar 17, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 21: Assigning Backup Preferences

An option when creating new AlwaysOn Availability Groups is to specify Backup Preferences. It’s also something you can easily configure once the Availability Group has been set up as well – by simply right-clicking on the Availability Group and selecting Properties – then navigating into the Backup Preferences tab.  ...More
Mar 14, 2015
Commentary

For Data Quality, Intelligent Rules Add Value to the Golden Record 5

The quest for the Golden Record to achieve a single, accurate and complete version of a customer record is worth the pursuit to attain survivorship. Record matching and consolidation are only the beginning. Melissa Data takes a new approach. Learn how to apply intelligent rules based on reference data to make smarter and better decisions for data cleansing....More
Mar 12, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 20: Avoiding Backup Fragmentation

On SQL Servers where Availability Groups (or Mirroring) isn’t in play, I typically recommend keeping a combination of on-box backups along with copying said backups off-box as well. Obviously, keeping databases AND backups on the SAME server is the metaphorical equivalent of putting all of your eggs in one basket – and therefore something you should avoid like the plague....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) ×