Tag: PASSMN

My Remaining 2014 Presentation Schedule

By on • ( 3 Comments )

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

By on

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

By on

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

By on

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

By on

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.