Dan English's BI Blog

Welcome to my random thoughts in regards to Business Intelligence, databases, and other technologies

Archive for August, 2013

PASSMN August 2013 Meeting

Posted by denglishbi on August 13, 2013

The next Minnesota SQL Server User Group meeting is on Tuesday, August 20. This month SQL Server MVP and Microsoft Certified Master Joe Sack will be presenting on resolving performance issues.

Be sure to register so that your name badge will be available for you at the Microsoft Technology Center when you arrive.Minnesota SQL Server Users Group

The sponsor for this month’s meeting is RBA.

Location: 3601 West 76th Street, Suite 600 Edina, MN 55437

Live Meeting:


  • 4:30-5:00 : Registration / Networking / Announcements
  • 5:00-6:00 : Performance Issue Patterns by Joe Sack
  • 6:00-6:15 : Prizes / Giveaways

Please click here for meeting details and to RSVP for the event


Performance Issue Patterns by Joe Sack

Abstract: While a SQL Server professional may encounter various one-off situations over the course of a career, there are also several shared patterns and scenarios.  In this session we’ll walk through a few of these patterns interactively – where I’ll reproduce the issue and we’ll work through the scenario until we get to the root cause.

About Joe: Joe Sack is a Principal Consultant with SQLskills. He has worked as a SQL Server professional since 1997 and has supported and developed for SQL Server environments in financial services, IT consulting, manufacturing, retail and the real estate industry.  Prior to joining SQLskills he worked at Microsoft as a Premier Field Engineer supporting very large enterprise customer environments. He was responsible for providing deep SQL Server advisory services, training, troubleshooting and ongoing solutions guidance. His areas of expertise include performance tuning, scalability, T-SQL development and high-availability.  In 2006 Joe earned the “Microsoft Certified Master: SQL Server 2005” certification and in 2008 he earned the “Microsoft Certified Master: SQL Server 2008” certification. In 2009 he took over responsibility for the entire SQL Server Microsoft Certified Master program and held that post until 2011.

Posted in Training | Tagged: , , | Leave a Comment »

Minnesota Microsoft BI User Group 2013 Q3 Meeting–Sep 10

Posted by denglishbi on August 12, 2013

The next MN Microsoft Business Intelligence User Group is coming up on Tuesday, September 10. This meeting we will have two presentations starting out with a presentation on master data management (MDM) and master data services (MDS) and then a presentation on parallel data warehouse (PDW). Please register so that we can have your name badge pre-printed.image

Are you planning to attend the PASS 2013 Summit October 15 – 18 in Charlotte, NC? Use the MS BI User Group discount code and receive 10% off!

Your chapter: Minnesota Microsoft BI User Group

Unique Discount Code: SUM156CH

To register for PASS 2013, click here: http://www.sqlpass.org/summit/2013/

Here is the remaining schedule for the quarterly meetings this year:

2013 Meeting Schedule

  • Tuesday, September 10
  • Tuesday, December 3

MN Microsoft BI User Group 2013 Q3 Meeting

Sponsored by:


Date: Tuesday, September 10, 2013

Check In: 2:30 PM Event Time: 3:00 PM – 6:00 PM

Location: Microsoft Technology Center – 3601 76th St W, Suite 600 Edina MN 55435 (in LOW 1, 2, and 3)

Please Register Now (Please register so that we can have your name badge pre-printed)


  • 2:30-3:00 : Registration
  • 3:00-3:15 : Microsoft BI User Group Updates & Announcements
  • 3:15-4:15 : Master Data Management and Microsoft Master Data Services
  • 4:15-4:30 : Break
  • 4:30-5:45 : Recognizing The Parallel Data Warehouse (PDW) Workload
  • 5:45-6:00 : Social and Networking


Session 1: Master Data Management and Microsoft Master Data Services

As your organization grows, one challenge will be the management of data between systems and organizational units. With MDS, Microsoft gives you the ability to have one accurate source of non-transactional data. This data can then be used within applications, other databases, and ETL processes. By leveraging data stewards to help manage the data repository, you ensure that your MDS data is up-to-date and accurate.

In this presentation we will cover MDS from start to finish including installation, creating models/entities, working with data, using the Excel add-in, security, hierarchies, views, versions, and business rules. After this presentation, you will have a good understanding of what master data management is, what MDS does, how to use it, and how to get started with your own MDS project


Jeff Prom, Data Architect , Silver Bay Realy Trust Corp – Jeff Prom is a Data and BI Developer with over 15 years of experience. From a wide variety of industries, he has worked with corporations both large and small including several global fortune 50 companies. Jeff is an active member in the SQL community and regularly speaks and attends user groups and conferences. He has earned MCTS certifications for Database Development, Administration, and BI. Jeff is currently employed at Silver Bay Realty Trust Corp as a Data Architect.

Session 2: Recognizing The Parallel Data Warehouse (PDW) Workload

If you are like many, you’ve been hearing a lot about Parallel Data Warehouse (PDW) lately. PDW is Microsoft’s appliance solution with SQL Server 2012 that allows massively parallel processing (MPP) of database workloads.  But how do you know that you have a workload that requires or could benefit from MPP over the standard symmetric multiprocessing (SMP) architecture?  In this session, we’ll review that question and more with a run through of how to identify MPP workloads?  As part of the session, we’ll also review some of the key components and differentiators of the PDW platform.


Jason Strate, SQL Server Database Architect, Pragmatic Works – Jason Strate is a SQL Server database architect with Pragmatic Works. He is also a Microsoft SQL Server MVP and MCM. He has over 15 years of experience developing, architecting, and managing data platforms.  As a PASS community member, Jason has lead user groups, organized SQL Saturdays, and is currently a Regional Mentor for PASS’s North Central US region.  Jason is a well-known presenter and author on SQL Server and data platform topics.  He has been author or editor on five books and blogging at www.jasonstrate.com.  He’s also presented at the PASS Summit, TechEd NA, dozens of SQL Saturdays, and other SQL Server community events.  And if that isn’t enough, he’s never been too far away from the karaoke after parties which may include an occasional unicorn.

Sanjay Kaul, Technology Specialist, Microsoft – Sanjay Kaul is a Technology Specialist at Microsoft who specializes in helping customers envision, design, and deploy data life cycle, data warehouse, and business intelligence focused solutions using the Microsoft platform. In his 12th year at Microsoft, Sanjay has spent time in Microsoft’s consulting group, enterprise SQL Server sales, SQL Server & BI Architect at the Microsoft Technology Center in Minneapolis, before moving to his current role of Data Warehouse Technology Specialist. With all the experience gained in the industry ranging from data architecture, disaster recovery planning, governance, database optimization, and data warehousing, his goal is to gain a deep understanding of the customer’s needs and help create solutions that exactly meet their needs.

Posted in Training | Tagged: , , | Leave a Comment »

Final Call for the MN SQL Saturday 238 Speakers

Posted by denglishbi on August 10, 2013

This is the final call to submit your sessions for the Minnesota SQL Saturday event coming up in October. The speaker abstracts can be submitted through Tuesday, September 13 and then the fun begins to start selecting the sessions and setting up the official schedule.image

So far on 47 sessions have been submitted by 27 different speakers and 12 of those submitted more than one session.

If we do a breakdown of the current list that has been submitted it looks like the following so far:


Just a word of warning, if you have only submitted 1 session you might want to review the list that has already been submitted.  If your topic is a duplicate the chances of you making the final cut might be tough, particularly if the duplicate submission speaker only submitted 1 as well:)

So if you were holding out to submit a session to speak your time is up, time to submit.  If you already submitted, time to review the full list and re-evaluate your submission(s) to secure your spot.

Call for Speakers

Submitted Sessions

Good luck to all the speakers that submitted and can’t wait for the big event.

Posted in SQL Server, Training | Tagged: , , , | Leave a Comment »