Category: PASSMN

My Remaining 2014 Presentation Schedule

Greetings. Since I do a fair amount of presenting, I like to keep people up to date on when and where I will present. Below are the presentations I have left in 2014.

SQL Saturday Winnipeg – November 22

In addition to serving on the committee that is organizing Winnipeg’s first SQL Saturday, I will be giving two presentations:

Analysis Services Terms and Concepts for the DBA

MDX Trek: First Contact

Minnesota BI User Group – December 2

I will be presenting a Case Study along with someone I worked with at a client. This is a make-up for September when a back spasm prevented me from delivering this presentation.

Case Study: Monitoring SSAS Usage with Extended Events

How do you measure the success of a Self Service Business Intelligence initiative? While the answer to that question has several components, a vital one is Adoption. Are people using the assets created for that initiative? Since Business Intelligence is using data to make better decisions, why not use data to help answer this question? At Capella University, we did just that.

This case study will describe how we used Analysis Services Extended Events to track the usage of Tabular Models that Capella built for Self Service BI users. We will demonstrate the following:

The business case for capturing asset usage

The particular goals Capella had in this case

How easy it is to get started with SSAS Extended Events (far easier than it looks)

The end-to-end solution created: from the event trace itself thru to the Power Pivot model created for analysis

Lessons learned (some learned the hard way)

We hope you will come away from this presentation with less trepidation around SSAS Extended Events as well as a foundation you can use for your own solution.

Minnesota SQL Server User Group (PASSMN) December Meeting – December 16

I will be participating in an Improv-style group presentation based on the format of the TV Show Whose Line is it Anyway? with other speakers from the Twin Cities.

 

Pragmatic Works Free Training Series – December 18

 

Analysis Services Terms and Concepts for the DBA

This is a make-up for September when a back spasm prevented me from delivering this presentation.

 

So, that’s it for the rest of 2014. Overall, it has been a pretty busy year as far as presenting goes. I hope to continue that in 2015.

PASSMN July Meeting: Ask The Experts Panel

The annual Ask The Experts panel has arrived for the Minnesota chapter of PASS. I am especially excited for this one since I will have the honor of serving on the panel for the first time. This is really a great milestone for me and fits so well with my goals to have an impact in the community.

Thanks to Superior Consulting for sponsoring this month’s meeting.

Location:

8300 Norman Center Drive, 9th Floor, Bloomington, MN  55437

Date:

July 19th, 2011

Time:

3:00 – 5:00

 

Please click here for meeting details and to RSVP

Ask the Experts

After the popularity of the past "Ask the Experts" discussions, we decided to bring back the forum for a third straight year. PASS members will have the opportunity to pose any burning questions they might have about SQL Server to our expert panel. We will round things out with a couple tips or tricks about SQL Server from each of our panel experts.  This year’s discussion will be moderated by Jason Strate.

The Panel:

  • Lara Rubbelke, Microsoft
  • Dan English, Superior Consulting Services
  • Mark Vaillancourt, Digineer
  • Bill Preachuk, Emergent Networks
  • Zach Mattson, Patterson Companies

Upcoming Presentations

I am delighted to announce that I will be presenting an Introduction to SQL Server Reporting Services Report Models at two different events in October. I have implemented report models at clients and seen how they can be a great way to empower users to be more self-sufficient.

The events are:

Twin Cities Code Camp

This takes place on October 9th and 10th at the University of Minnesota in Minneapolis. This is my first time presenting at this semi-annual event.

SQL Saturday 58 – Minnesota

This event takes place on FRIDAY October 29th at Mystic Lake Casino in Prior Lake, Minnesota. This is Minnesota’s first SQL Saturday. Hazzah! I affectionately refer to it as SQL Friturday. Yeah. We’re a little different here in Minnesota. Well…I’m a lot different, but most people are a little different. The schedule for this is not yet posted but I have verbal confirmation that my session was accepted.

I am learning a lot more about report models while creating this presentation. The old adage really holds true: “You can pick your friends and you can pick you nose. But you can’t pick your friend’s nose.” Wait. That’s not the one. It’s this one: “If you want to learn a lot about a subject, do a presentation on it.” Yeah. The second one.

September PASSMN Meeting: Kalen Delaney Presents

Tuesday, September 21, 2010

5-7 PM

Description:

Isolation vs Concurrency: What Are the Choices? with Kalen Delaney

Meeting sponsor: Microsoft UGSS

Note Location Change Below

Location: 8000 Norman Center Drive, 9th Floor, Bloomington, MN  55437

No Live Meeting Due to Location Change

Agenda:

5:00 –5:15 : Announcements
5:25 –6:45 : Isolation vs Concurrency: What Are the Choices?
6:45 –7:00 : Survey Collection and Giveaways

Presentation:

Isolation vs Concurrency: What Are the Choices?

What does it mean to have data isolation? In this presentation, we’ll look at the four different ANSI isolation levels and the new one, Snapshot Isolation, added in SQL Server 2005 to see how much isolation each provides and what behaviors—such as Dirty Reads, Nonrepeatable reads, and Phantoms—are possible in each level. We’ll discuss what consistency might mean to your applications and what the trade-offs are as you choose a higher isolation level to enable greater isolation and consistency. We’ll also discuss the difference between the optimistic and pessimistic concurrency models and look at the relationship between isolation level and concurrency models to see how the various isolation levels work in either an optimistic or a pessimistic manner.

Kalen Delaney has been working with SQL Server for almost 23 years and provides advanced SQL Server training to clients around the world, using her own custom-developed curriculum. She has been a SQL Server MVP since 1993 and has been writing about SQL Server almost as long.

Kalen has spoken at dozens of technical conferences, including every PASS conference in the US, since the organization’s founding in 1999. She is a contributing editor and columnist for SQL Server Magazine and the author or co-author of several of the most deeply technical books on SQL Server, the most recent being SQL Server 2008 Internals, from Microsoft Press. Kalen blogs at sqlblog.com, and her personal website and schedule can be found at www.SQLServerInternals.com.

Click Here to Register

August PASSMN Meeting: Ask The Experts Panel

Ask the Experts Panel Discussion

Start Date/Time:
Tuesday, August 17, 2010 3:00 PM

End Date/Time:
Tuesday, August 17, 2010 5:00 PM

Description:

Meeting sponsor:

Red Gate Software makes ingeniously simple tools for over 500,000 Microsoft technology professionals working with SQL Server, .NET, and Exchange.  The company’s product line includes tools for comparing, synchronizing, backing up and recovering SQL Server databases; understanding and fixing .NET code problems; and email archiving for Exchange.

Location: 8300 Norman Center Drive, 9th Floor, Bloomington, MN  55437

Please click here for meeting details and to RSVP

Live Meeting

·         URL: https://www.livemeeting.com/cc/usergroups/join?id=HCC36W&role=present&pw=W%3E%2Bx%3C9%2B%21B

·         Meeting ID: HCC36W

·         Entry Code: mwD{j|\4B

Speakers:

·         Lara Rubbelke, Microsoft

·         Jason Strate, Digineer

·         Eric Strom, RBA Consulting

·         Tim Plas, Virteva

Agenda:

3:00 –3:15 : Announcements
3:15 –3:25 : Sponsor
3:25 –5:00 : Ask The Experts Panel

After the popularity of last years "Ask the Experts", we decided to bring back the forum this year. PASS members will have the opportunity to pose any burning questions they might have about SQL Server to our expert panel. We will round things out with a couple tips or tricks about SQL Server from each of our panel experts.

The Panel:

Lara Rubbelke brings her passion for architecting, implementing and improving SQL Server solutions to the community as a Data Platform Technology Specialist for Microsoft. This is a role that is a pre-sales role for SQL Server. Her expertise involves both OLTP and OLAP systems, data management, performance tuning, encryption, ETL, and the Business Intelligence lifecycle. Compliance and configuration management are near and dear to her heart. She is an active board member and advocate of the Minnesota chapter of PASS (Professional Association for SQL Server) and regularly delivers technical presentations at local, regional and national conferences, user groups and webcasts. Notably, Lara has presented at Tech Ed, the PASS Summit, the Minneapolis SQL Server Launch, and delivered numerous webcasts on MSDN and TechNet. Lara authored a number of the Microsoft whitepapers and was a contributing author of "Expert SQL Server 2005 Development" (lead author Adam Machanic).

Jason Strate, Digineer Inc, is a database architect and administrator with over twelve years of experience. He is Microsoft MVP (Most Valuable Professional) for SQL Server. His experience includes design and implementation of both OLTP and OLAP solutions as well as assessment and implementation of SQL Server environments for best practices, performance, and high availability solutions. Jason is a SQL Server MCITP and participated in the development of Microsoft Certification exams for SQL Server 2008. Jason enjoys helping others in the SQL Server community and does this by presenting at technical conferences and user group meetings. Most recently, Jason has presented at the SSWUG Virtual Conferences, TechFuse, SQL Saturdays, and at PASSMN user group meetings. Jason is an active blogger with a focus on SQL Server and related technologies.

Eric Strom is a Database Consultant at RBA Consulting and is a member of the Minnesota PASS Board. He has been a SQL Server DBA since 2001 and specializes in performance tuning. Eric studied database theory at the University of Minnesota to earn a B.S. in Computer Science. He loves exchanging ideas with peers and is always looking for a good discussion.

Tim Plas is a Principal Consultant at Virteva, in Mpls MN. His current focus areas are operational-DBA services, storage, server virtualization, cloud computing, & providing level-3 escalation support for IT managed services. His SQL emphasis is on monitoring, management, and high availability.  Previous specialties in his 25+ years in the IT field have included Citrix/TS (app hosting), LAN’s / WAN’s / network security, DB architecture, systems architecture & design, app development, systems-level programming, & various IT mgmt roles. Tim has held a variety of MS certifications since 1994.

July PASSMN Meeting

Dude! Itzik Ben-Gan… Dig it!

Start Date/Time:
Tuesday, July 20, 2010 5:00 PM

End Date/Time:
Tuesday, July 20, 2010 7:00 PM

Query Tuning Tips with Itzik Ben-Gan

Meeting sponsor: Digineer

Location: 8300 Norman Center Drive, 9th Floor, Bloomington, MN  55437

Live Meeting

·         URL: https://www.livemeeting.com/cc/usergroups/join?id=7DGRT6&role=attend&pw=h*ZR%248%25%2Fd

·         Meeting ID: 7DGRT6

·         Entry Code: h*ZR$8%/d

Agenda:

5:00 –5:15 : Announcements
5:15 –5:25 : Sponsor
5:25 –6:45 : Query Tuning Tips (Itzik)
6:45 –7:00 : Survey Collection and Giveaways

Presentation:

Query Tuning Tips

Given a SQL Server querying problem there’s much that you can do to enable a good performing solution. Tuning involves arranging an optimal physical environment, e.g., by creating supporting indexes, as well as writing the query in a way that it would get an optimal execution plan. Many factors can affect the efficiency of the solution including the availability of indexes, data distribution and density, and others. In different scenarios, a different solution could be the most efficient for the same querying problem. Query tuning could be considered an art. This session will provide various tips to do efficient query tuning and demonstrate those through specific tuning examples.

Itzik Ben-Gan is a Mentor and Co-Founder of Solid Quality Mentors. A SQL Server Microsoft MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL Querying, Query Tuning and Programming. Itzik is the author of several books including Microsoft SQL Server 2008: T-SQL Fundamentals, Inside Microsoft SQL Server 2008: T-SQL Querying and Inside Microsoft SQL Server 2008: T-SQL Programming. He has written many articles for SQL Server Magazine as well as articles and whitepapers for MSDN. Itzik’s speaking activities include TechEd, DevWeek, SQLPASS, SQL Server Magazine Connections, various user groups around the world, and Solid Quality Mentors’ events to name a few. Itzik is the author of Solid Quality Mentors’ Advanced T-SQL Querying, Programming and Tuning and T-SQL Fundamentals courses along with being a primary resource within the company for their T-SQL related activities..

PASSMN June Meeting: What’s New In SSRS 2008 R2

I have been lax in promoting my local SQL users group, so here goes. Oh, by the way, it’s Lara’s fault that I am a SQL Server consultant. Thanks Lara!

June PASSMN Meeting & Newsletter
Sponsored by Magenic

There will be books, shirts and other swag at the end of the meeting!

Location:    8300 Norman Center Drive, 9th Floor, Bloomington, MN  55437
Date:     June 15th, 2010
Time:    3:00 – 5:30

Please click here for meeting details and to RSVP.

Registration has changed with the move from our previous hosting site and you will be required to log into http://www.sqlpass.org in order to register for our events. If you have any issues with this, please contact support@mnssug.org.

What’s New in SQL Server 2008 R2 Reporting Services

Lara Rubbelke (Twitter | Blog), Microsoft

Amp up your Reporting Services with the many great enhancements in SQL Server 2008 R2. Lara will take you on a tour of all that is new in R2 including collaboration features, new visualizations, rendering enhancements, and new data sources. After this session you will wonder why they call R2 an "interim" release!

Questions for presenters?
If you have any questions you would like our presenter to answer in the meeting, feel free to submit them ahead of time to support@mnssug.org or to any of the board members before the meeting. All question askers will be kept anonymous.

Other News
•       Live Meeting
   o    Beginning in 2010 meeting, you will now be able to join monthly meetings virtually through Live Meeting. This is a great opportunity to stay connected that has been provided to us by PASS.
•       SQL Azure Presentation
   o   Presented by Mike Benkovich at Twin Cities Cloud Computing User Group (TCCCUG)
   o   July 8th, 2010
   o   Click Here for more information
•       PASS Summit 2010
   o    Registration for PASS Summit 2010 is now open. Register for only $1,395 until June 30. Tap into your 2009 or 2010 training budgets to take advantage of the low rate for PASS Summit.