Dan English's BI Blog

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

Posts Tagged ‘passmn’

PASSMN November 2013 Meeting

Posted by denglishbi on November 15, 2013

The next Minnesota SQL Server User Group meeting is on Tuesday, November 19. This month Mark Vaillancourt will be doing a presentation on the art of presenting.

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 Digineer.

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

Agenda:

  • 4:00-4:30 : Registration / Networking / Announcements
  • 4:30-4:45 : DANGER: The Art and Science of Presenting by Mark Vaillancourt
  • 6:45-7:00 : Prizes / Giveaways

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

Presentation

DANGER: The Art and Science of Presenting

Abstract: Is there a great difference in the brain chemistry of someone fleeing a hungry mountain lion and someone presenting to a group of colleagues in a corporate board room? The answer is: NO. Over the past decade, a lot has been learned about the chemistry of the brain and why humans react the way we do to events in our environment. The concept of EQ (Emotional Intelligence) is a compelling and growing concept that applies this knowledge in a set of learnable, improvable skills for leading human beings. While EQ is often applied to corporate leadership, the parallels to presenting are fantastic. This session will explain the basics of EQ and demonstrate how you can apply it to make your presentations better in the following areas: * Crafting better slide decks * Preparing yourself for presenting * Delivering your content * Dealing with the unexpected Understanding and practicing the concepts of EQ can make your presentations a better experience for everyone in the room–including you

About Mark: Mark Vaillancourt is an Information Management consultant for Digineer, a Microsoft partner based in Plymouth, MN. He has been working with SQL Server for 5 years and holds the MCITP – Business Intelligence Developer 2008 certification. With a background in Theater and Improvised Comedy, Mark makes sure that his presentations are both informative and fun.

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

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:

Agenda:

  • 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

Presentation

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 »

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:

image

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 »

PASSMN July 2013 Meeting

Posted by denglishbi on July 20, 2013

The next Minnesota SQL Server User Group meeting is on Tuesday, July 23. This month SQL Server and Pragmatic Works founder Brian Knight is in town and will present.

Brian Knight is in town doing his two-day SSIS Master training course, something else to check out if you are available – http://pragmaticworks.com/LearningCenter/Workshops/DataIntegration/7-23-2013_MinneapolisMasterSSISWorkshop.

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 Pragmatic Works.

Pragmatic Works

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

Live Meeting:

Agenda:

  • 5:00-5:30 : Announcements / Registration / hospitality / networking
  • 5:30-6:45 : Data Visualization Moves, by Brian Knight
  • 6:45-7:00 : Prize giveaways

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

Presentation

Ninja Data Visualization Moves by Brian Knight

 

Abstract: PowerPivot and Power View brings with it some amazing business intelligence and data visualization enhancements. Watch how you can improve data cleansing with Excel 2013 and some of the new features integrated into Excel and the other Office tools to visualize data better than ever before. See how the new PowerPivot and Power View features in Excel 2013 take your data to the next level of visualization. We’ll also show how you can visualize map data with GeoFlow and tie disparate data together with Data Explorer.

About Brian: Brian Knight, SQL Server MVP, MCITP, MCSE, MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.com, BIDN.com and SQLShare.com. He ran the local SQL Server user group in Jacksonville (JSSUG). Brian is a contributing columnist at several technical magazines and does regular webcasts at PragmaticWorks.com. He is the author of more than a dozen SQL Server books. Brian has spoken at conferences like PASS, SQL Connections and TechEd and many Code Camps. His blog can be found at http://www.bidn.com.

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

PASSMN July 2013 Meeting

Posted by denglishbi on July 2, 2013

The next Minnesota SQL Server User Group meeting is on Tuesday, July 23. This month SQL Server and Pragmatic Works founder Brian Knight is in town and will present. 

Brian Knight is in town doing his two-day SSIS Master training course, something else to check out if you are available – http://pragmaticworks.com/LearningCenter/Workshops/DataIntegration/7-23-2013_MinneapolisMasterSSISWorkshop.

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 Pragmatic Works.

Pragmatic Works

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

Live Meeting:

Agenda:

  • 5:00-5:30 : Announcements / Registration / hospitality / networking
  • 5:30-6:45 : Data Visualization Moves, by Brian Knight
  • 6:45-7:00 : Prize giveaways

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

Presentation

Ninja Data Visualization Moves by Brian Knight

Abstract: PowerPivot and Power View brings with it some amazing business intelligence and data visualization enhancements. Watch how you can improve data cleansing with Excel 2013 and some of the new features integrated into Excel and the other Office tools to visualize data better than ever before. See how the new PowerPivot and Power View features in Excel 2013 take your data to the next level of visualization. We’ll also show how you can visualize map data with GeoFlow and tie disparate data together with Data Explorer.

About Brian: Brian Knight, SQL Server MVP, MCITP, MCSE, MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.com, BIDN.com and SQLShare.com. He ran the local SQL Server user group in Jacksonville (JSSUG). Brian is a contributing columnist at several technical magazines and does regular webcasts at PragmaticWorks.com. He is the author of more than a dozen SQL Server books. Brian has spoken at conferences like PASS, SQL Connections and TechEd and many Code Camps. His blog can be found at http://www.bidn.com.

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

PASSMN April 2013 Meeting

Posted by denglishbi on April 15, 2013

The next Minnesota SQL Server User Group meeting is tomorrow Tuesday, April 16. This month the two presentations will be on (1) HortonWorks sandbox demo and (2) NoSQL.  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 Robert Half Technology.

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

Live Meeting:

Agenda:

  • 4:00-4:15 : Announcements / Registration / hospitality / networking
  • 4:15-4:30 : HortonWorks Sandbox Demo, by Bill Preachuk
  • 4:30-5:45 : Rules of Engagement: NoSQL is SQL Server’s Ally, by Rick Krueger and Dave Valentine
  • 5:45-6:00 : Prize giveaways

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

Presentations

HortonWorks Sandbox Demo (by Bill Preachuk, Emergent Networks)

HortonWorks provides a free downloadable Virtual Machine image that promises you “Go from Zero to BIG DATA in 15 minutes!“ In this short presentation we’ll discuss What the Sandbox is, Where to get it, How to install it, and How to get it up & running. Then we’ll fire up our trusty rusty VMware environment, step through the web-based GUI and run a few of the included tutorials.

Bill Preachuk serves on the Board of the PASSMN User Group and is responsible for SQL Saturday Minnesota 2013. He is a SQL Server 2008 MCTS, and is employed as a DBA/Data Warehouse Designer at Emergent Networks. Bill has been in IT since 1991 and has presented at Analytics conferences, PASS User Group meetings and SQL Saturday events in the Twin Cities and Iowa.

Rules of Engagement: NoSQL is SQL Server’s Ally (by Rick Krueger and Dave Valentine)

When should you favor a NoSQL store over SQL Server, or consider polyglot persistence? In military and police operations, the rules of engagement determine when, where, and how force shall be used. As the “data police”, we are responsible for determining when, where, and how data is stored. As SQL Server professionals, it tends to be our first choice, even when there are other data storage options that are a ‘more natural’ fit. In this session, Rick and Dave will start with the NoSQL basics, and then dive into the different categories of NoSQL stores while explaining what each type is well suited for.

Rick Krueger is the President of Premier Applications, Inc., and a SQL Server indie based in the Twin Cities with 18 years of software and database development experience, working with SQL Server since 1998 (6.5). Don’t let his developer credentials (MCPD) and background fool you, he knows a thing or two about SQL, and is currently focusing on data architecture and database development.

Dave Valentine is a Development DBA with over 10 years of experience with SQL Server and Development technologies, specializing in Business Intelligence and ingenious solutions. Dave has also been an Adjunct Professor at Metropolitan State University for the past 10 years educating students in Database Management, Web Development, and Java Programming.

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

PASSMN February 2013 Meeting

Posted by denglishbi on February 13, 2013

The next Minnesota SQL Server User Group meeting is next Tuesday on February 19.  This month the two presentations will be on (1) rules-based backup and index maintenance and (2) database corruption.  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 Emergent Networks.

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

Date/Time: Tuesday, February 19 from 4 to 6 p.m.

Live Meeting:
• URL: https://www.livemeeting.com/cc/usergroups/join?id=SRR9DN&role=attend&pw=zd%3F9c.2KJ
• Meeting ID: SRR9DN
• Entry Code: zd?9c.2KJ

Agenda

  • 4:00 – 4:10 : Registration / hospitality / networking
  • 4:15 – 5:15 : Presentation: Shoveling Frogs into a Wheelbarrow
  • 5:15 – 5:45 : Presentation: An Overview of Database Corruption
  • 5:45 – 6:00 : Announcements and prize giveaways

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

Presentations

Shoveling Frogs into a Wheelbarrow (by Merrill Aldrich)

If you face managing over a hundred, or perhaps thousands of databases, automation, standards and a “policy-based” mindset are critical. In this session we’ll do a walk-through of a rules-based backup and index maintenance solution suitable for zillions of smaller databases, and talk at a high level about features and techniques for multi-server management including monitoring, performance data collection, jobs automation, PowerShell and PBM. (The core of it will be a walkthrough of the solution athttp://sqlblog.com/blogs/merrill_aldrich/archive/2012/08/01/rules-driven-maintenance.aspx and the update published athttp://sqlblog.com/blogs/merrill_aldrich/archive/2013/01/16/update-to-rules-driven-maintenance.aspx)

Merrill Aldrich is a SQL Server DBA with one of the largest credit unions in the US, located in the Seattle area. He’s currently responsible for corralling a sprawling and very diverse collection of ISV-provided SQL Server databases that together serve the organization’s 800,000 members. In a past life he was trained in Architecture, designed buildings, and taught three-dimensional modeling and building information modeling.

Blog: http://sqlblog.com/blogs/merrill_aldrich/default.aspx

Twitter: @onupdatecascade

An Overview of Database Corruption (by James Larson, United Health Group)

An Overview of Database Corruption that will include warning signs, causes and scenarios with repair options

James Larson is a Database Consultant\ Team Lead at United Health Group. Has over 15 years of experience with SQL Server. James also has 4 years of experience developing applications with Visual Basic 6.0. James has been working in the Health Care field for over 8 years and currently holds a Microsoft SQL Server 2008, Implementation and Maintenance Certification.

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

PASSMN Special December 2012 Meeting

Posted by denglishbi on November 29, 2012

Next week the Minnesota SQL Server User Group is having a special meeting on Wednesday, December 5.  The presentation will be on Big Data.  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 special meeting is Microsoft Technology Communities.

image

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

Date/Time: Wednesday, December 5 from 5:30 to 7:00 p.m.

Agenda

  • 5:30 – 5:45 : Registration / hospitality / networking / food!
  • 5:45 – 6:45 : Hadoop’s Role in a Big Data Architecture
  • 6:45 – 7:00 : Announcements / Networking

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

Presentations

Jim Walker talks Hadoop, Big Data and Microsoft Tools

Jim Walker, Hortonworks, is a recovering developer, professional marketer and amateur photographer with nearly twenty years experience building products and developing emerging technologies. During his career, he has brought multiple products to market in a variety of fields, including data loss prevention, master data management and now big data. At Hortonworks, Jim is focused on accelerating the development and adoption of Apache Hadoop.

And don’t forget, the SQL Lunch that was scheduled for October was rescheduled and will be next month for Friday, December 14 from 11:30 to 1:30 with me as the host – SQLFriends Lunch–Dec 14.

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

PASSMN November 2012 Meeting

Posted by denglishbi on November 14, 2012

The next Minnesota SQL Server User Group meeting is next Tuesday on November 20.  This month the presentation will be on SQL Server database locking and blocking.  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 Dell Compellent.

Compellent

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

Date/Time: Tuesday, November 20 from 4 to 5:30 p.m.

Live Meeting:
• URL: https://www.livemeeting.com/cc/usergroups/join?id=8DFJJB&role=attend&pw=Z-%3B%7D*t4%2Cn
• Meeting ID: 8DFJJB
• Entry Code: Z-;}*t4,n

Agenda

  • 4:00 – 4:10 : Registration / hospitality / networking
  • 4:10 – 4:15 : From our Sponsor – Overview of Dell Compellent SAN
  • 4:15 – 5:15 : Introduction to SQL Server Locking and Blocking
  • 5:15 – 5:30 : Announcements and prize giveaways

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

Presentations

Introduction to SQL Server Locking and Blocking (Kirby Richter, Dell Compellent)

What is locking?  What is blocking?  Why should you care?  You want to update a million rows on production, you need to know what type of locks will happen so you can plan accordingly!

You are tuning a query and the normal duration is 1 second but recently it’s been taking over a minute.  Is your process being blocked?

Let’s face it blocking is very common and as a good DBA you need to recognize when blocking is an issue and how to deal with it.  This presentation will cover most of the gory details and includes several fun demos.  You will learn how to check and monitor locking and blocking and how to deal with common issues.

And don’t forget, the SQL Lunch that was scheduled for October was rescheduled and will be next month for Friday, December 14 from 11:30 to 1:30 with me as the host – SQLFriends Lunch–Dec 14.

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

PASSMN October 2012 Meeting

Posted by denglishbi on October 10, 2012

The next Minnesota SQL Server User Group meeting is next Tuesday on October 16.  This month there will be two presentations, one on a SQL database maintenance plans and the other on a new feature that was added in SQL Server 2012, Data Quality Services (DQS).  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 GroupThe sponsor for this month’s meeting is Magenic.

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

Date/Time: Tuesday, October 16 from 4 to 6 p.m.

Live Meeting:
•URL: https://www.livemeeting.com/cc/usergroups/join?id=H8JST2&role=attend&pw=rz%26R*ZSN9
•Meeting ID: H8JST2
•Entry Code: rz&R*ZSN9

Agenda

•4:00-4:15 : Registration / hospitality / networking
•4:15-4:45 : Ola Hallengren’s SQL Server Maintenance Solution
•4:45-5:45 : Data Quality Services
•5:45-6:00 : Announcements and prize giveaways

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

Presentations

Ola Hallengren’s SQL Server Maintenance Solution (Rizwan Hassan, DBA at Kroll Ontrack)

DBAs are inconstantly using SQL Server standard maintenance and custom maintenance plans to maintain SQL environments. Ola Hallengren has been generous enough to contribute his maintenance plans which are not only effective, but also can be customized to meet small to large SQL environments. These plans have won SQL Server Magazine 2011 Gold Community Choice and Silver Editors’ Best awards. The Ola’s maintenance plans cover:

  • SQL Server Backups
  • SQL Server Integrity Checks
  • SQL Server index and Statistics Maintenance

Data Quality Services (Jeff Prom, Senior Consultant at Magenic) – As the old adage goes, ‘Garbage in, garbage out.’ Stop spending hours manually cleansing your data, and start using Data Quality Services! DQS is the new data quality tool provided with SQL Server 2012. In this session we will cover topics such as creating a knowledge base, data cleansing, data matching, and using 3rd party knowledge bases (Reference Data). We will talk about installation, show how to use the DQS tool, the Excel Add-in, and how to integrate DQS into your SSIS packages.

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

 
Follow

Get every new post delivered to your Inbox.

Join 89 other followers