Tag: PASS

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.

My PASS Summit Submissions

Alrighty then. For the first time in my career, I tossed up some submissions for the PASS Summit. Both are topics I have a passion for and I would absolutely LOVE that chance to present either one…or…dare I say…both? Well, here they are. Here’s looking at you, PASS.

Empowering Your Users With Report Models

Who really knows your data better: You or the marketing manager that spends a lot of time tracking sales from yesterday, last week, etc? How much quicker could that marketing manager get the information she needs if she could create her own reports? With the power of Report Models, she could do just that without having to write a single SQL statement. This presentation will discuss how to create, maintain and secure SSRS Report Models. It will also show some tips and tricks learned through real-world experience implementing and supporting report models for clients.

Where Do You Want To Go Tomorrow?

You dress differently for a wedding than you do for baseball game, right? …Right? Even with mundane, everyday tasks like getting dressed, your future destination has an impact on your current behavior. Whether you realize it or not, even the simple act of getting dressed in the morning involves a little planning. Doesn’t your professional future deserve some planning, too? This presentation will discuss the power of Professional Development Plans and the building of your very own brand through blogging, presenting and effective use of social media like Twitter. I will show you how you can use all of the above to take ownership of your future and turn your job into a career.