Search
Friday, April 18, 2014 ..:: Home ::.. Register   Login
 Sponsors

 PASS - Summit & Annual Sponsor

 Microsoft - Annual Sponsor

Virteva - January 2014 Meeting Sponsor

Digineer - November 2013 Meeting Sponsor

Pragmatic Works

Pluralsight - Hardcore Developer Training

SQL Power Tools

Dell Compellent - November 2012 Meeting Sponsor

Quest Software - SQL Saturday Sponsor

Blackdog Innovative Solutions - SQLSaturday Sponsor

Magenic - October 2012 Meeting Sponsor

Magenium Solutions - July 2012 Meeting Sponsor

Emergent Networks - May 2012 Meeting Sponsor

TechFuse - April 2012 Meeting Sponsor

Confio - March 2012 Meeting Sponsor

True Source - February 2012 Meeting Sponsor

Superior Consulting Services - Julyl 2011 Meeting Sponsor

Book Sponsor

Benchmark Learning - January 2011 Meeting Sponsor

Microsoft UGSS - quarterly sponsors

redgate - Aug 2010 Meeting Sponsor

Fusion-IO - April 2010 Meeting Sponsor

idera - March 2010 sponsor

EMC - August Meeting Sponsor
Intertech .NET and Java Training
 Pearson Education - Summit 2009 Sponsor

Wrox Press - User Group Program & Sponsor

TechSmith - Sponsor

O'Reilly - Sponsor

Wrox Press - User Group Program & Sponsor 
 

 

 

 


  
 Welcome

As a part of the national PASS organization, the Minnesota SQL Server User Group (PASSMN) serves the Minnesota SQL Server community. PASSMN is a forum to exchange knowledge and ideas to better understand, develop, implement and support existing and future SQL Server technologies. Our technical sessions provide a professional, fun and educational environment for all levels of expertise and areas of interest. 

If you're interested in becoming part of PASSMN, please take a moment to register
. By registering with the site, you'll be notified about upcoming events along with any changes to the standard schedule. You will also have access to all of the features and benefits of being a member of the strongest SQL Server user community in Minnesota. 

We are committed to providing the best SQL Server content in the Twin Cities and surrounding area. If you have any suggestions for the group, or if you are interested in presenting, 
please contact us! We value all feedback and will continue to strive to meet the highest standards.


  
 Announcements
April PASSMN Meeting & Newsletter - Monday, April 07, 2014
 

http://minnesota.sqlpass.org/Portals/70/PASSMNLOGO_white.gif

http://minnesota.sqlpass.org/Portals/70/ic_twit_36.png

http://minnesota.sqlpass.org/Portals/70/ic_lkdin_36.png

http://minnesota.sqlpass.org/Portals/70/ic_fbk_36.png

April PASSMNMeeting &Newsletter

Sponsored by Star Collaborative

 

Location:

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

Date:

April 15, 2014

Time:

4:00 PM - 6:00 PM

 

Please click here for meeting details and to RSVP

 

Presentation: Are You Following Your Own Best Practices?

 

Abstract: Everyone has their own best practices that they try to follow. But often times we aren’t sure how well we are following our own or industry best practices.  In this session we’ll go into monitoring and managing best practices throughout your environment.  The session will look at how to create a solution using policy based management and other tools to report on your compliance to best practices.

                                                                                                                                                                                          

About Jason: Jason Strate is Solution Architect with Pragmatic Works. He has been working with SQL Server for more fifteen years. His experiences include architecting and implementing transactional and data warehousing solutions on Microsoft Data Platform technologies, including SQL Server and Parallel Data Warehouse. A recipient of the Microsoft Most Valuable Professional award for SQL Server since 2009, he also has achieved the Microsoft Certified Master for SQL Server certification.

 

Networking Events

 

PASS Summer Picnic on Saturday June 21st

PASSMN summer picnic planned for June 21st, likely at Hyland Park in Bloomington. Picnic will be a potluck; PASSMN will provide sodas and ice cream desserts.                                                                         

 

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 questions will be kept anonymous.


 


4:00 PM - 6:00 PM


http://minnesota.sqlpass.org/Portals/70/PASSMNLOGO_white.gif

http://minnesota.sqlpass.org/Portals/70/ic_twit_36.png

http://minnesota.sqlpass.org/Portals/70/ic_lkdin_36.png

http://minnesota.sqlpass.org/Portals/70/ic_fbk_36.png

April PASSMN Meeting & Newsletter

Sponsored by Star Collaborative

 

Location:

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

Date:

April 15, 2014

Time:

4:00 PM - 6:00 PM

 

Please click here for meeting details and to RSVP

 

Presentation: Are You Following Your Own Best Practices?

 

Abstract: Everyone has their own best practices that they try to follow. But often times we aren’t sure how well we are following our own or industry best practices.  In this session we’ll go into monitoring and managing best practices throughout your environment.  The session will look at how to create a solution using policy based management and other tools to report on your compliance to best practices.

                                                                                                                                                                                          

About Jason: Jason Strate is Solution Architect with Pragmatic Works. He has been working with SQL Server for more fifteen years. His experiences include architecting and implementing transactional and data warehousing solutions on Microsoft Data Platform technologies, including SQL Server and Parallel Data Warehouse. A recipient of the Microsoft Most Valuable Professional award for SQL Server since 2009, he also has achieved the Microsoft Certified Master for SQL Server certification.

 

Networking Events

 

PASS Summer Picnic on Saturday June 21st

PASSMN summer picnic planned for June 21st, likely at Hyland Park in Bloomington. Picnic will be a potluck; PASSMN will provide sodas and ice cream desserts.                                                                         

 

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 questions will be kept anonymous.

 read more ...

March PASSMN Meeting & Newsletter - Thursday, March 13, 2014

http://minnesota.sqlpass.org/Portals/70/PASSMNLOGO_white.gif

http://minnesota.sqlpass.org/Portals/70/ic_twit_36.png

http://minnesota.sqlpass.org/Portals/70/ic_lkdin_36.png

http://minnesota.sqlpass.org/Portals/70/ic_fbk_36.png

March PASSMN Meeting &Newsletter

Sponsored by Star Collaborative

 

Location:

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

Date:

March 18, 2014

Time:

4:00 PM - 6:00 PM

 

Please click here for meeting details and to RSVP

 

Presentation: Practical SQL Server Cardinality Estimation

 

Abstract: What is cardinality estimation and why should you care? In this session we'll cover the mechanics behind cardinality estimation and why it is so very critical to overall query performance. We'll cover concepts applicable to the last few major versions of SQL Server and also preview cardinality estimator changes being introduced in SQL Server 2014.

                                                                                                                                                                                          

About Joe: Joe Sack is the owner of Sack Consulting LLC (SackHQ.com). With over 17 years of experience in the industry, Joe is a consultant, author, speaker, SQL MVP, and SQL Server Microsoft Certified Master specializing in performance tuning, scalability, high availability and disaster recovery.

 

Networking Events

 

PASSMN Tabletop Gaming & Pizza Night on April 1st, 6:00pm-9:00pm

Who's better at managing resources in Settlers of Catan, a developer or a DBA? Developers, ever feel like going medieval on your resident DBA? Challenge him or her to a game of Carcassonne instead! Maybe more motivated by Magic or Munchkin? Join us for an evening of pizza and tabletop gaming. Bring your favorite game, or show up empty-handed and see what's available. Free parking available in the attached parking ramp. Pizza will be provided by PASSMN. Click here for details and to RSVP.

 

PASS Summer Picnic on Saturday June 21st

Tentatively looking at Hyland Park in Bloomington, more details will be available soon.   

 

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 questions will be kept anonymous.

 read more ...

February PASSMN Meeting & Newsletter - Monday, February 10, 2014
 

http://minnesota.sqlpass.org/Portals/70/PASSMNLOGO_white.gif

http://minnesota.sqlpass.org/Portals/70/ic_twit_36.png

http://minnesota.sqlpass.org/Portals/70/ic_lkdin_36.png

http://minnesota.sqlpass.org/Portals/70/ic_fbk_36.png

February PASSMNMeeting &Newsletter

Sponsored by Kroll Ontrack

 

Location:

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

Date:

February 18, 2014

Time:

4:00 PM - 6:00 PM

 

Please click here for meeting details and to RSVP

 

Presentation: Subqueries for Superheroes

 

Abstract: Strictly for beginners, this session explores the lowly subquery, sidekick of the T-SQL world. Learn the different types of subqueries, how they can help you, how they can hurt you, even how they can help you to avoid that nasty DISTINCT operator.

                                                                                                                                                                                          

About Tracy: Tracy McKibben has been working with database products for over 20 years, starting with FoxBase running on Xenix. Over the years, he has worked with all flavors of FoxPro, some Clipper and dBase, and starting somewhere around 1995, SQL Server.  He has even dabbled with Oracle, though he has tried to block out all memories of that experience. At present, he is the Senior SQL Server DBA and the DBA Team Supervisor for Pearson VUE. When not tinkering with databases, he is likely to be found pointing her camera at something, pretending to be a photographer, or working on his model railroad.

 

Bowling at Sky Deck on March 4th, 6:00pm-9:00pm

Join PASSMN for an evening of food, drink, and bowling at Sky Deck in the Mall of America. We've negotiated a rate of $5 per person for 2 hours of bowling, providing each person orders a food or drink item from the menu. Come on out for some informal networking fun and friendly competition!

 

Tabletop gaming night on April 1st, 6:00pm-9:00pm

Calling all tabletop gamers - International Tabletop Day is April 5th. To celebrate, PASSMN is hosting an evening of tabletop gaming. Join us at the Pearson VUE offices at 5601 Green Valley Drive, Bloomington (SW corner of 494 & 100). Some of the developers from Pearson will be participating - bring your favorite tabletop game and get ready to show those developers who's boss!

 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 questions will be kept anonymous.

 read more ...

January PASSMN Meeting & Newsletter - Tuesday, January 14, 2014

http://minnesota.sqlpass.org/Portals/70/PASSMNLOGO_white.gif

http://minnesota.sqlpass.org/Portals/70/ic_twit_36.png

http://minnesota.sqlpass.org/Portals/70/ic_lkdin_36.png

http://minnesota.sqlpass.org/Portals/70/ic_fbk_36.png

January PASSMN Meeting &Newsletter

Sponsored by Virteva

Location:

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

Date:

January 21, 2014

Time:

4:00 PM - 6:00 PM

 

Please click here for meeting details and to RSVP

 

Eureka! Visual deep dive into storage internals

 

Abstract: Sometimes half the battle in computing is just to see what's happening. We will take a visual tour of physical database storage structures, using live demos with the freeware application SQL Server File Layout Viewer and our old friends the DBCC commands as guides. See what happens in a data file when you convert a table from a heap to a clustered index! See fragmentation and the havoc wrought by Shrink! Marvel at the behavior of multiple files and filegroups! Index Rebuilds! Eureka!

 

About Merrill: 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.

 

 

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 questions will be kept anonymous.

 read more ...

December PASSMN Meeting & Newsletter - Tuesday, December 10, 2013

 

December PASSMN Meeting & Newsletter

Sponsored by McKinley Consulting

 

Location:

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

Date:

December17, 2013

Time:

4:00 PM - 6:00 PM

 

Please click here for meeting details and to RSVP

 

New Speaker Lightning Talks

 

Have you ever found your SQL Server to be low on drive space? 

Abstract: Have you ever found your SQL Server to be low on drive space?  You know shrinking databases should be avoided when possible, but you can’t immediately add disk capacity and you want to avoid any production problems.  Which database do you shrink first?  Come join Ryan as he shares a script that will help you make that decision.  The data it provides can also be useful for database-size reporting and capacity planning. In addition, Ryan will be sharing a script to help clone a user’s rights.  This script can help unwind gnarly permissions, even resolving nested roles, through the use of a recursive CTE.

About Ryann: Ryan Snee has a BA in Computer Science from St. John’s University, and is currently a Database Administrator at Starkey Hearing Technologies.  He has been working with SQL Server for 5 years, and holds an MCITP: Database Administrator 2008 certification.

 

Favorite techniques used in T-SQL stored procedures 

Abstract: Presenting on some favorite techniques used in T-SQL stored procedures, including uisng @RunDate to provide timestamp consistency, tracking whodoneit with SUSER_SNAME(),  APP_NAME(), and Host_Name(), and making use of DB_NAME()  to maintain same code across multiple databases

About Maria: Maria Barnes is an Application Developer and the President of Barnes Business Solutions, Inc., a Microsoft partner based in Mound, MN.  She has been working with SQL Server for 10 years and holds the MCTS – SQL Server 2008, Database Development certification.  Maria has experience developing applications with Microsoft Access, C#, and Visual Basic, using SQL as a very capable backend.  She has given several Access User group presentations in the Chicago area, but this is her first SQL presentation.

 

Checklists Only Want to Help 

Abstract: Checklists Only Want to Help - Complex, repeated tasks, from flying an airplane and removing an appendix to monitoring your SQL Server or installing an upgrade, use checklists to ensure better and more consistent outcomes.  Could you use a checklist to help get better results on something you do?  How do you develop an effective checklist and what should you include?

About Paula: Paula Merns has been working in IT since 1995 and jumped with great pleasure to SQL in 2000, by way of Oracle. Since then she has worked as a developer and ETL specialist primarily in SQL Server for direct mail marketing firms.  She now works as Programmer/Database Analyst for Dunwoody College of Technology, an employer who values connection with peers.

 

An Introduction to Integration Services (SSIS) 2012 Parameters 

Abstract: In versions of SSIS prior to 2012 the most common way to set the value of a property within a package at run time, such as a connection string, was to use package configurations.  There are some shortcomings of package configurations as well as many ways to use them, which can lead to frustration on how exactly to implement them.  The project deployment model with SSIS 2012 introduced parameters, which provide a more straightforward approach to setting properties at run time.  This presentation will cover how to use parameters as well as configure them at run time for multiple environments.

About Andy: Andy Bolk is an Information Management Consultant with Digineer and has been an ETL developer for 12 years, starting with SQL Server 2000 and DTS.  He is also an avid Vikings and Twins fan.

 

A way to grant permissions that could make your life easier as a DBA. 

Abstract: In this short lightning talk, we will share a way to grant permissions that could make your life easier as a DBA. Based on our experience, with a little planning upfront and this simple concept, you could potentially save yourself hours in management on the backend.

About Mark: Mark Classen is a mechanic who started working in IT a bunch of years ago, bouncing around from discipline to discipline on the Microsoft side of things until he found a home in the MSSQL space. He's been involved with SQL for close to 10 years in roles from admin to design to development. His overriding goal in all professional engagements is to be paged as little as possible because it cuts into his time to prepare and eat bacon. His fiancée and he also like to ride motorcycles to where they can have someone else cook the bacon.

About Jennifer: Jennifer McConnell started out in IT as a VMS Administrator (Does she really wants to admit that?) before finding her calling in SQL Server for the last 8 years. She has primarily been on the admin side along with some development and design. Her most recent adventure finds her in a position that allows her to obtain BI Design, BI Support and Healthcare Analytics experience as well. Along with cooking, dancing and riding her Harley, she enjoys trying new and crazy things like this presentation stuff with her bacon-loving fiancée.

 

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.

Special Call for Local Speakers

We are experimenting with a new format to our meetings and we need your help!  To encourage the growth of our local SQL presentation talent, we are hoping to fill 15 to 30 minutes per meeting with a fairly new and local speaker.  If you are interested in presenting, but not for a full hour, we encourage you to give this shorter, less formal format a try and share what you know.  If you are interested let us know at support@mnssug.org or contact any of the board members directly.

 

Happy Holidays from the PASSMN Board of Directors and Best Wishes for 2014!!!!

 read more ...

November PASSMN Meeting & Newsletter - Tuesday, November 12, 2013

 

http://minnesota.sqlpass.org/Portals/70/PASSMNLOGO_white.gif

http://minnesota.sqlpass.org/Portals/70/ic_twit_36.png

http://minnesota.sqlpass.org/Portals/70/ic_lkdin_36.png

http://minnesota.sqlpass.org/Portals/70/ic_fbk_36.png

November PASSMN Meeting & Newsletter

Sponsored by Digineer

 

Location:

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

Date:

November  19, 2013

Time:

4:00 PM - 6:00 PM

 

Please click here for meeting details and to RSVP

 

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

 

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.

Special Call for Local Speakers

We are experimenting with a new format to our meetings and we need your help!  To encourage the growth of our local SQL presentation talent, we are hoping to fill 15 to 30 minutes per meeting with a fairly new and local speaker.  If you are interested in presenting, but not for a full hour, we encourage you to give this shorter, less formal format a try and share what you know.  If you are interested let us know at support@mnssug.org or contact any of the board members directly.

 read more ...

October PASSMN Newsletter - Monday, October 14, 2013

 

 http://minnesota.sqlpass.org/Portals/70/PASSMNLOGO_white.gif
http://minnesota.sqlpass.org/Portals/70/ic_twit_36.png
http://minnesota.sqlpass.org/Portals/70/ic_lkdin_36.png
http://minnesota.sqlpass.org/Portals/70/ic_fbk_36.png
 October PASSMN Newsletter
 
This Month...
There will be no meeting this month, October.  Our next meeting will be on November 19th.
 
Board Nominations
Nominations for the PASSMN Executive Board are now open. If you are interested in nominate yourself (or someone else), please send an email to support@mnssug.org or contact any of the board members directly
 
Our SQLSaturday #238 was a completed success!!!
It was a great event thanks all of the organizers, volunteers, speakers, sponsors, and all of the attendees that participate.  We hope that everyone enjoyed the event.  Thanks again to everyone that made this a great day!
 
Special Call for Local Speakers
We are experimenting with a new format to our meetings and we need your help!  To encourage the growth of our local SQL presentation talent, we are hoping to fill 15 to 30 minutes per meeting with a fairly new and local speaker.  If you are interested in presenting, but not for a full hour, we encourage you to give this shorter, less formal format a try and share what you know.  If you are interested let us know at support@mnssug.org or contact any of the board members directly.
 read more ...

SeptemberPASSMN Meeting & Newslette - Tuesday, September 10, 2013

 

 http://minnesota.sqlpass.org/Portals/70/PASSMNLOGO_white.gif
http://minnesota.sqlpass.org/Portals/70/ic_twit_36.png
http://minnesota.sqlpass.org/Portals/70/ic_lkdin_36.png
http://minnesota.sqlpass.org/Portals/70/ic_fbk_36.png
September PASSMN Meeting & Newsletter
Sponsored by MidDel Consulting
MidDel Consulting
 
Location:
Date:
September 17, 2013
Time:
4:00 PM - 6:00 PM
 
 
Presentation
 
5 Ways to Improve Performance through Indexing
 
Abstract: Sometimes the hardest performance issues in your environment have simple solutions. One of these simple solutions is through properly indexing the database. In this session, we’ll look at five ways that performance of a database can be improved through indexing. When we finish, you’ll be armed with scripts and methodologies that you can put into place today to improve database performance.
 
About Jason: Jason Strate is database architect with Pragmatic Works. He has been working with SQL Server for more fifteen years. His technical focuses include administration and development of OLTP environments. Jason is a recipient of the Microsoft Most Valuable Professional (MVP) Award for SQL Server since July, 2009. 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.
 
SQLSaturday #238 - The 4th Annual Minnesota Edition!
Mark your calendars for October 12th, 2013 at Keller Hall on the University of Minnesota Campus!
SQLSaturday is a training event for SQL Server Professionals and those wanting to learn about SQL Server.
This year's event will feature 40 sessions in 8 tracks and 350+ attendees. Uffda!
Ready to Register?
Ready to be a Presenter (why yes you are…)
Do you have questions?
See you there!
 
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.
Special Call for Local Speakers
We are experimenting with a new format to our meetings and we need your help!  To encourage the growth of our local SQL presentation talent, we are hoping to fill 15 to 30 minutes per meeting with a fairly new and local speaker.  If you are interested in presenting, but not for a full hour, we encourage you to give this shorter, less formal format a try and share what you know.  If you are interested let us know at support@mnssug.org or contact any of the board members directly.
 read more ...

August PASSMN Meeting & Newsletter - Friday, August 09, 2013

 

 http://minnesota.sqlpass.org/Portals/70/PASSMNLOGO_white.gif

http://minnesota.sqlpass.org/Portals/70/ic_twit_36.png

http://minnesota.sqlpass.org/Portals/70/ic_lkdin_36.png

http://minnesota.sqlpass.org/Portals/70/ic_fbk_36.png

August PASSMN Meeting & Newsletter

Sponsored by RBA

 

Location:

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

Date:

August 20, 2013

Time:

4:00 PM - 6:00 PM

 

Please click here for meeting details and to RSVP

 

Presentations

 

Performance Issue Patterns

 

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.

 

SQLSaturday #238 - The 4th Annual Minnesota Edition!

Mark your calendars for October 12th, 2013 at Keller Hall on the University of Minnesota Campus!

SQLSaturday is a training event for SQL Server Professionals and those wanting to learn about SQL Server.

This year's event will feature 40 sessions in 8 tracks and 350+ attendees. Uffda!

Ready to Register?

Ready to Sponsor the Event?

Ready to be a Presenter (why yes you are…)

Do you have questions?

See you there!

 

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.

Special Call for Local Speakers

We are experimenting with a new format to our meetings and we need your help!  To encourage the growth of our local SQL presentation talent, we are hoping to fill 15 to 30 minutes per meeting with a fairly new and local speaker.  If you are interested in presenting, but not for a full hour, we encourage you to give this shorter, less formal format a try and share what you know.  If you are interested let us know at support@mnssug.org or contact any of the board members directly.

 read more ...

July PASSMN Meeting & Newsletter - Tuesday, July 16, 2013

 

 http://minnesota.sqlpass.org/Portals/70/PASSMNLOGO_white.gif
http://minnesota.sqlpass.org/Portals/70/ic_twit_36.png
http://minnesota.sqlpass.org/Portals/70/ic_lkdin_36.png
http://minnesota.sqlpass.org/Portals/70/ic_fbk_36.png
July PASSMN Meeting & Newsletter
Sponsored by Pragmatic Works
 
Location:
Date:
July 23, 2013
Time:
5:30 PM - 7:00 PM
 
 
Presentations
 
Ninja Data Visualization Moves by Brian Knight
 
Abstract: PowerPivot and PowerView 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 PowerView 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.
 
SQLSaturday #238 - The 4th Annual Minnesota Edition!
Mark your calendars for October 12th, 2013 at Keller Hall on the University of Minnesota Campus!
SQLSaturday is a training event for SQL Server Professionals and those wanting to learn about SQL Server.
This year's event will feature 40 sessions in 8 tracks and 350+ attendees. Uffda!
Ready to Register?
Ready to be a Presenter (why yes you are…)
Do you have questions?
See you there!
 
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.
Special Call for Local Speakers
We are experimenting with a new format to our meetings and we need your help!  To encourage the growth of our local SQL presentation talent, we are hoping to fill 15 to 30 minutes per meeting with a fairly new and local speaker.  If you are interested in presenting, but not for a full hour, we encourage you to give this shorter, less formal format a try and share what you know.  If you are interested let us know at support@mnssug.org or contact any of the board members directly.
 read more ...

June PASSMN Meeting & Newsletter - Monday, June 10, 2013

Location:

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

Date:

June 18, 2013

Time:

4:00 PM - 6:30 PM

 

Please click here for meeting details and to RSVP

                                                                                                                                                                                          

Presentations

 

Contained Databases, the what, why and where, by Jim Dorame

Abstract: SQL Server 2012 Now has Contained Databases, what are they and why do I care.  This presentation will explain what a Contained Database is, how to create them and what gotchas there are when dealing with them. 

About Jim: He is currently the Database Systems Manager for a large scale educational assessment corporation. He has been working with technology for over 20 years and specifically with Microsoft SQL Server since version 6.5. He decided to start giving back to the community that has provided me with so much information in the past.

 

The Architect’s View by Lara Rubbelke

Abstract: I have the opportunity to meet with customers in a wide variety of industries, public and private, small and large.  Often I am working with architects who are designing future data ecosystems to meet current and impending demands, and many of these architects are already deeply engaged in “the changing world of data”.  Come learn what is top of mind with the architects in these organizations, and how they are designing solutions, and what you should know about the solutions that you may be soon be implementing and supporting.

About Lara:  She brings her passion for data solutions to customers as a Technical Architect for Microsoft at the Minneapolis Microsoft Technology Center. Her expertise involves Big Data, OLTP and OLAP systems, data management and the Business Intelligence lifecycle. She regularly delivers technical presentations at local, regional and national conferences and events. Notably, Lara is a regular presenter at TechEd, PASS Summit, numerous SQL Server Launches, and has delivered several MSDN and TechNet webcasts.

 

 

SQLSaturday #238 - The 4th Annual Minnesota Edition!

Mark your calendars for October 12th, 2013 at Keller Hall on the University of Minnesota Campus!

SQLSaturday is a training event for SQL Server Professionals and those wanting to learn about SQL Server.

This year's event will feature 40 sessions in 8 tracks and 350+ attendees. Uffda!

Ready to Register?

Ready to Sponsor the Event?

Ready to be a Presenter (why yes you are…)

Do you have questions?

See you there!

 

Your SQLFriends in Minneapolis want to have lunch with you!

When: Friday June 28th 11:30-1:30

Where: Hell's Kitchen in Minneapolis

Please join 15-30 of your best SQLFriends and our guest, Mark Vaillancourt for great food, lively discussion and fun laughter! Ask Mark anything about SQL, BI, presenting, being a PASS regional mentor.  Your questions, his answers

Go to SQLFriends.org to reserve your place. (We are limited to the first 30 people.) http://sqlfriends.org/events/sqlfriends-lunch-minneapolis-june-2013/

 

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.

Special Call for Local Speakers

We are experimenting with a new format to our meetings and we need your help!  To encourage the growth of our local SQL presentation talent, we are hoping to fill 15 to 30 minutes per meeting with a fairly new and local speaker.  If you are interested in presenting, but not for a full hour, we encourage you to give this shorter, less formal format a try and share what you know.  If you are interested let us know at support@mnssug.org or contact any of the board members directly.

 read more ...

May 2013 PASSMN Meeting - Tuesday, May 14, 2013

 

 

 
May PASSMN Meeting & Newsletter
Sponsored by 

 

Location:
Date:
May 21, 2013
Time:
4:00 PM - 6:00 PM

 
                                                                                                                                                                                          
Presentations
 
SSMS 2012 - Tips, Tricks and New Features, by Rizwan Hassan
Abstract: There are certain features in SSMS 2012 that we are unaware of and new features that learned while using SSMS 2012. I would like to share those features with you!!!
About Rizwan:  Rizwan Hassan started as System Administrator and evolved into SQL DBA Administrator.  Rizwan have worked at Virteva and Kroll Ontrack.  He is currently working at General Mills as SQL DBA. Responsible for 600 SQL instances with 3000 databases. 
 
SQL Server Security and Data Security, by Ross McNeely
Abstract: The presentation will walk through the requirements to secure SQL Server, and how to implement data security requirements. Ross decided to discuss both SQL Server Security and Data Security due to the amount of confusion that often occurs during the security phase of a project. Some of the topics included are SQL Server configuration, table/execution permissions, OLAP security, and using a security data model. The presentation will cover a large amount of material in a short time span, but hopefully you will find it informative.
About Ross: Ross McNeely is a BI Practice Manager at C2 IT Solutions. As a Business Intelligence consultant Ross have installed and secured SQL Server instances for various customers. Ross has presented at several SQL Saturday in Minnesota, Wisconsin, and Iowa. Regardless if you have a beginner, intermediate, or advanced skill set, Ross will provide a solid foundation for each topic. Please join Ross McNeely for a fun and informative meeting.
 
SQLSaturday #238 - The 4th Annual Minnesota Edition!
Mark your calendars for October 12th, 2013 at Keller Hall on the University of Minnesota Campus!
SQLSaturday is a training event for SQL Server Professionals and those wanting to learn about SQL Server.
This year's event will feature 40 sessions in 8 tracks and 350+ attendees. Uffda!
Ready to Register?
 Ready to be a Presenter (why yes you are…)
Do you have questions?
See you there!
 
Your SQLFriends in Minneapolis want to have lunch with you!
When: Friday June 28th 11:30-1:30
Where: Hell's Kitchen in Minneapolis
Please join 15-30 of your best SQLFriends and our guest, Mark Vaillancourt for great food, lively discussion and fun laughter! Ask Mark anything about SQL, BI, presenting, being a PASS regional mentor.  Your questions, his answers
Go to SQLFriends.org to reserve your place. (We are limited to the first 30 people.) http://sqlfriends.org/events/sqlfriends-lunch-minneapolis-june-2013/
 
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.
Special Call for Local Speakers
We are experimenting with a new format to our meetings and we need your help! To encourage the growth of our local SQL presentation talent, we are hoping to fill 15 to 30 minutes per meeting with a fairly new and local speaker. If you are interested in presenting, but not for a full hour, we encourage you to give this shorter, less formal format a try and share what you know. If you are interested let us know at support@mnssug.org or contact any of the board members directly.
 read more ...

April 2013 PASSMN Meeting - Tuesday, April 09, 2013

 

April PASSMN Meeting & Newsletter

Sponsored by Robert Half Technology

 

Location:

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

Date:

April 16, 2013

Time:

4:00 PM - 6:00 PM

 

Please click here for meeting details and to RSVP

                                                                                                                                                                                          

Presentations

 

HortonWorks Sandbox Demo, by Bill Preachuk

Abstract: 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.

About Bill: 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

Abstract: 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.

About Rick: 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.

About Dave: 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.

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.

Special Call for Local Speakers

We are experimenting with a new format to our meetings and we need your help!  To encourage the growth of our local SQL presentation talent, we are hoping to fill 15 to 30 minutes per meeting with a fairly new and local speaker.  If you are interested in presenting, but not for a full hour, we encourage you to give this shorter, less formal format a try and share what you know.  If you are interested let us know at support@mnssug.org or contact any of the board members directly.

 read more ...

March PASSMN Meeting & Newsletter - Tuesday, March 12, 2013

 

March PASSMN Meeting & Newsletter

Sponsored by True Source

 

Location:

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

Date:

March 19, 2013

Time:

4:00 PM - 6:00 PM

 

Please click here for meeting details and to RSVP

 

Presentations

 

Problematic Restore Scenarios, by Jeff Joy

Abstract: You know the drill - Restore the last full backup, last differential backup and all subsequent transaction log backups up until the desired point in time of recovery.....but not always!  There are situations many DBAs are unaware of that can confuse, complicate, and even prevent a successful point-in-time restore.

About Jeff: Jeff Joy is a Sr. Database Consultant performing SQL Server Engineering at UnitedHealth Group. He has been working with SQL Server for eleven years and has a varied background including - 9 years as a Cryptologic Linguist (Russian) for the USAF, 13 long years in Retail Management that inspired a career change, 5 years as a Software Developer and 6 years as a SQL Server DBA.

 

 

An Optimistic Approach, Snapshot Isolation in SQL by Paul Timmerman

Abstract: Until 2005, SQL Server was a very pessimistic RDBMS. However with the introduction of the Read Committed Snapshot database option and the new Snapshot Isolation level, that is no longer the case. After a high level look at all SQL Server isolation levels, we’ll spend the majority of this session discussing the implementation of optimistic concurrency control in SQL Server. We’ll look at the benefits and drawbacks of using an optimistic isolation level and discuss use cases where it may or may not be appropriate. Come learn how to put one of the more powerful, but least understood, aspects of SQL Server to work for you!

About Paul: Paul Timmerman is the lead SQL Server DBA at Hennepin County Medical Center in Minneapolis, Minnesota. Paul has over a decade of experience in enterprise database administration and is currently the Chapter Leader of the Minnesota SQL Server User Group, PASSMN. 

 

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.

Special Call for Local Speakers

We are experimenting with a new format to our meetings and we need your help!  To encourage the growth of our local SQL presentation talent, we are hoping to fill 15 to 30 minutes per meeting with a fairly new and local speaker.  If you are interested in presenting, but not for a full hour, we encourage you to give this shorter, less formal format a try and share what you know.  If you are interested let us know at support@mnssug.org or contact any of the board members directly.

 read more ...

February PASSMN Meeting & Newsletter - Monday, February 11, 2013

 

February PASSMN Meeting & Newsletter

Sponsored by Emergent Networks

 

Location:

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

Date:

February 19, 2013

Time:

4:00 PM - 6:00 PM

 

Please click here for meeting details and to RSVP

 

Shoveling Frogs into a Wheelbarrow

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 at http://sqlblog.com/blogs/merrill_aldrich/archive/2012/08/01/rules-driven-maintenance.aspx and the update published at http://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 that will include warning signs, causes and scenarios with repair options

James Larson, United Health Group                                                                   

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.

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.

Special Call for Local Speakers

We are experimenting with a new format to our meetings and we need your help!  To encourage the growth of our local SQL presentation talent, we are hoping to fill 15 to 30 minutes per meeting with a fairly new and local speaker.  If you are interested in presenting, but not for a full hour, we encourage you to give this shorter, less formal format a try and share what you know.  If you are interested let us know at support@mnssug.org or contact any of the board members directly.

 read more ...

January PASSMN Meeting - Tuesday, January 08, 2013

 

January PASSMN Meeting & Newsletter
Sponsored by TEKsystems
TEKsystems

Location:
Date:
January 15, 2013
Time:
4:00 PM - 6:00 PM

 
Understanding Disk I/O
Mike Matthews, Dell Compellent.
SQL Server is an I/O intensive application. Overall performance is greatly impacted by the underlying disk subsystem. In this presentation, we'll discuss the characteristics of disk I/O, how SQL Server interacts with the disk subsystem, and how to measure and monitor the performance of your storage.
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.
Special Call for Local Speakers:
We are experimenting with a new format to our meetings and we need your help! To encourage the growth of our local SQL presentation talent, we are hoping to fill 15 to 30 minutes per meeting with a fairly new and local speaker. If you are interested in presenting, but not for a full hour, we encourage you to give this shorter, less formal format a try and share what you know. If you are interested let us know at support@mnssug.org or contact any of the board members directly.

 

 read more ...

December PASSMN Meeting - Tuesday, December 11, 2012

December PASSMN Meeting

Sponsored by Pragmatic Works

Location:

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

Date:

December 18, 2012

Time:

4:00 PM - 6:00 PM

 

Please click here for meeting details and to RSVP

Extended Events: Work Smarter Not Harder

Jason Strate, Pragmatic Works

Of the many ways to monitor your SQL Server environment, Extended Events is one of the newer platforms that can help you investigate and resolve performance problems. In this special 90-minute session, we’ll review Extended Events and learn the ins and outs of how to get and analyze detailed information on the errors and events that occur within SQL Server. With a few T-SQL statements, you can research in minutes issues that used to take weeks to investigate.

 read more ...

Special December PASSMN Meeting! - Wednesday, November 28, 2012

Sponsored by Microsoft Technical Communities

Location:

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

Date:

December 5, 2012

Time:

5:30 PM - 7:00 PM

Note – we will be serving food, so come hungry! 

 

Please click here for meeting details and to RSVP

 

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.

 read more ...

November PASSMN Meeting - Wednesday, November 07, 2012

November PASSMN Meeting

Sponsored by Dell Compellent

Location:

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

Date:

November 20, 2012

Time:

4:00 PM - 5:30 PM

Please click here for meeting details and to RSVP

Eventbrite - November PASSMN Meeting

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. 

 

 

 read more ...

SQL Saturday #149 is almost here! - Monday, September 17, 2012

 

SQL Saturday is coming on September 29, 2012 at University of Minnesota.  Learn more and sign up for this tremendous SQL learning opportunity here!

 read more ...

August PASSMN Meeting - Monday, August 06, 2012

August PASSMN Meeting & Newsletter

Sponsored by Digineer

Location:

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

Date:

August 21, 2012

Time:

4:00 PM - 6:00 PM

 

Please click here for meeting details and to RSVP

 

MDX Trek: First Contact

Mark Vaillancourt, Digineer

Cube space; the final frontier. In this Star Trek themed introduction to MDX, we will discuss the fundamentals of cube structure and vocabulary, including tuples, members, sets, hierarchies, and more. We will introduce and demonstrate the basic syntax of MDX with queries that include navigating hierarchies and even some time-based expressions. This session will give you the tools you need to write simple, yet meaningful, MDX queries in your own environment.

 read more ...

July PASSMN Meeting - Tuesday, July 10, 2012

July PASSMN Meeting

Sponsored by Magenium Solutions

Location:

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

Date:

July 17, 2012

Time:

4:00 PM - 7:00 PM

 

Please click here for meeting details and to RSVP

 

O, there’s my data: The Open Data Protocol (OData)

Steve Hughes, Magenic

Earlier this year, Mark Souza from the SQL Server product team spoke at our user group.  During the Q&A I asked about interacting better with Oracle.  Mark mentioned that OData would be the best way to handle this.  I will be discussing what OData is and what tools are involved.  I will also explore how to create an OData feed and how to interact with it using tools such as PowerPivot, SSIS, and SQL Azure.  I will also examine the impact of OData for data professionals, both good, bad and ugly.  In the end, you should understand how OData works and where it can help us expose our data appropriately to our users.

Optimizing Microsoft SQL Server Performance in a Virtual Environment

Denny Cherry, independent consultant

In this session we'll look over some of the things which you should be looking at within your virtual environment to ensure that you are getting the performance out of it that you should be.  This will include how to look for CPU performance issues at the host level.  We will also be discussing the Memory Balloon drivers and what they actually do, and how you should be configuring them, and why.  We'll discuss some of the memory sharing technologies which are built into vSphere and Hyper-V and how they relate to SQL Server.  Then we will finish up with some storage configuration options to look at.

 read more ...

Jes Schultz Borland's Filegroup Presentation Material Available - Wednesday, June 20, 2012

 Jes Schultz Borland's Filegroup Presentation material is available for download here (note you must be a registered user).

 read more ...

May PASSMN Meeting - Monday, May 07, 2012

May PASSMN Meeting

Sponsored by Emergent Networks

Location:

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

Date:

May 15, 2012

Time:

4:00 PM - 6:00 PM

 

Please click here for meeting details and to RSVP

Introducing Microsoft's Big Data Solution

Lara Rubbelke, Microsoft

Welcome to the world of Big Data! Hive, Pig, Sqoop, HDFS, MapReduce… Discover how to gain new insight from your data by integrating Hadoop with SQL Server. Join this introduction to fundamental Big Data concepts and terms. Learn how others are leveraging Hadoop and how the Microsoft Big Data Solution fits within the data platform ecosystem.

 read more ...

April PASSMN Meeting - Wednesday, April 04, 2012

April PASSMN Meeting

Sponsored by Techfuse 2012 - May 16th & 17th

Location:

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

Date:

April 17, 2012

Time:

4:00 PM - 7:00 PM – Note we are shifting times again to get the best speakers we can!

 

Please click here for meeting details and to RSVP

SQL 2012 Discussion and Q+A

Ted Kummert, Microsoft and Mark Souza, Microsoft

SQL2012 discussion covering the following topics:

  • Running your Business and Mission Critical environments
  • BIG Data and scaling breakthrough insights throughout your organization
  • Unlock New Insights With Pervasive Data Discovery Across the Organization
  • Adopting the Cloud on your own terms

Apply T-SQL Magic

Itzik Ben-Gan, SolidQ

When a new version of SQL Server is released, with most of the new T-SQL features that are introduced you can usually quickly tell what their benefits are and what you can use them for. But with some features, it can take some time before people start discovering their true value and what you can do with them. Such is the APPLY operator that was added in SQL Server 2005. Initially it seemed just like an ordinary language element with a couple of uses, but with time people found very creative and interesting uses for it. This session describes the APPLY operator, and focuses on advanced, creative uses.

 read more ...

March PASSMN Meeting - Monday, March 05, 2012

March PASSMN Meeting & Newsletter

Sponsored by Confio

Location:

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

Date:

March 20, 2012

Time:

3:00 PM - 5:00 PM – Note we will be starting promptly at 3:00p, to enable our speaker to catch a flight

 

Please click here for meeting details and to RSVP

 

Choose Your Own Adventure: Performance Tuning

Jason Strate, Digineer and Thomas LaRock, Confio Software

Life is all about choices, and when it comes to SQL Server it is no different. If you don't have a methodology for researching questions and resolving issues then you need to get one, and soon. Join Microsoft MVPs Jason Strate from Digineer and Thomas LaRock from Confio Software as they help guide you while YOU make the choices in this interactive performance tuning adventure.

 read more ...

Discounted Training for PASSMN Members! - Tuesday, February 28, 2012

Benchmark Learning is offering a discount for PASSMN Members on two SQL Courses!  

Itzik Ben-Gan’s Course

Advanced T-SQL Querying, Programming and Tuning for SQL Server 2005, 2008 and 2012

http://www.benchmarklearning.com/Courses/CrsDetail.aspx?C=SQMTASQLPrg2012

April 16 – April 20, 2012

Benchmark Learning in Edina

 

Kalen Delaney’s Course

SQL Server 2008 Architecture, Internals and Tuning

http://www.benchmarklearning.com/Courses/CrsDetail.aspx?C=NHSQLPerTun08

July 23 – July 27, 2012

Benchmark Learning in Edina

 

Discounts for both classes:

  • 10% discount for PASS MN members
  • Additional 5% discount (for a total of 15%) for 3 or more registrations from the same company
  • Please contact Benchmark for these discounts
 read more ...

February PASSMN Meeting - Tuesday, February 07, 2012

February PASSMN Meeting

Sponsored by

True Source

Location:

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

Date:

February 21, 2012

Time:

4:00 PM - 6:00 PM – Note new starting time!

 

Please click here for meeting details and to RSVP

 

Geographic Visualizations Using Maps in SSRS

Brian Larson, Superior Consulting Services

This session will explore the many and varied uses of the map report item in Reporting Services. From providing geographic analytics to diagramming locations on a warehouse floorplan, the map report item – when combined with SQL Server spatial data types - can be used in a variety of ways to create spatial representations of your data. We may even look at a game or two created using the map report item.

Brian Larson, as a contract member of the Reporting Services development team, contributed to the original code base. Brian is the Vice President of Technology for Superior Consulting Services. Brian has presented at national conferences and events and is the author of “Microsoft SQL Server 2008 Reporting Services: 3rd Edition” and “Delivering Business Intelligence with SQL Server 2008: 2nd Edition” both from McGraw-Hill Professional.

 

 read more ...

January 2012 PASSMN Meeting - Monday, January 09, 2012
  • Location:  3601 West 76th Street, Suite 600 Edina, MN  55437
  • Date:  January 17th, 2011
  • Time:  3:00 PM - 5:00 PM

Please click here for meeting details and to RSVP

Writing Better Queries

Joe Webb, WebbTech Solutions

Transact-SQL is not a very difficult language to learn. As long as the syntax is correct, it can be quite forgiving. However to truly get the best performance from your SQL Server, careful consideration should be given to the structure and logic of the queries. In this session, we'll discuss some Transact-SQL tips and tricks that can be employed to help you write better queries, allowing your server to perform better.

 

 read more ...

Special Ops Tour - Friday, December 09, 2011

CALLING ALL SQL Server PROFESSIONALS:

 

SQL Server 2012 is the most important release ever of SQL Server with its’ mission critical, breakthrough insight and cloud on your terms features. Do your part to bring the SQL Server 2012 roadshows  to your city and get on stage with Microsoft! This March, Microsoft is teaming with PASS to bring you the SQL Server 2012 Special Ops Tour – a cross-country roadshow that will take us to 12 cities across America. This is your tour, and we want to highlight you –the SQL Server operative, your company, and the great work you are doing through opportunities to be featured on our media channels, stage time at roadshow events, and exclusive networking session.

 

Take our survey at www.specialopstour.com today, and help shape our course of action. Familiarize yourself with CTP3 to prep for the Solutions Contest and check back in December for details and how to submit!

 

ACTION REQUIRED:

-          Visit the preview site (www.specialopstour.com) and cast your votes for your city

-          Download and get to know CTP3 in preparation for upcoming solutions contest

-          Check back for details on how to be featured!

Coming in December:  Special Ops Contest

In the coming weeks, you'll have the opportunity to enter a high-profile contest where we'll identify 12 SQL Professionals with the best IT solutions on SQL Server 2012. So get ready to share your killer SQL Server 2012 skills.

 read more ...

December PASSMN Meeting - Friday, December 02, 2011
  • Location:   3601 West 76th Street, Suite 600 Edina, MN  55437
  • Date:   December 20th, 2011
  • Time:     3:00 - 5:00 PM

Note: We will be meeting in a new location starting this month 

Please click here for meeting details and to RSVP

SQL Server 2012 Feature Panel Discussion

Featuring:

Steve Hughes, Magenic Technologies

Steve Hughes is Principal Consultant at Magenic Technologies. His area of expertise is in data and business intelligence architecture on the Microsoft SQL Server platform. He was also the data architect for a SaaS company which delivered a transportation management solution for fleets across the United States. Steve has co-authored two books and regularly presents on SQL Server and data architecture.

Ajay Nangia, Microsoft

Ajay Nangia is a Data Platform Technology Specialist at Microsoft. In this role, Ajay enables customers and partners to develop, deploy, and support solutions based on Microsoft’s Database Technologies.  Ajay has a long history of working with SQL Server - from its internals to application and BI development on the platform. 

 

 read more ...

October PASSMN Meeting Materials - Monday, November 28, 2011

 Dan English's presentation materials from the October 2011 meeting are available on the resources page.  Note they are also availible via his blog - which has the most comprehesive coverage here.  He has also uploaded the video to vimeo here.  Thank you Dan!

 read more ...

October PASSMN Meeting - Wednesday, September 28, 2011

Meeting Sponsored by Superior Consulting Services

  • Location: 8300 Norman Center Drive, 9th Floor, Bloomington, MN  55437
  • Date: October 18th, 2011
  • Time: 3:00 - 5:00

Please click here for meeting details and to RSVP 

Introduction to BI Semantic Model & Delivering Self-Service Reporting with “Crescent”

 

Dan English, Superior Consulting Services

There are a lot of changes coming in the next release of SQL Server “Denali” with Analysis Services and PowerPivot along with new powerful BI functionality being added. This presentation will introduce the new BI Semantic Model concept, talk about the different options you have with Analysis Services in SQL Server “Denali” (SQL11), go over the new features in Analysis Services – including PowerPivot, go over developing models, and dive into the new self-service reporting authoring tool “Crescent”. Along the way there will be demonstrations of the new features and functionality so you can get a feel for what is coming.  By the end of the session you will have a full understanding of what lies ahead and you can start preparing your roadmap for delivering BI content within your organization.

 read more ...

September 2011 PASSMN Meeting - Friday, September 02, 2011

Sponsored by Visi

  • Location: 8300 Norman Center Drive, 9th Floor, Bloomington, MN  55437
  • Date: September 20th, 2011
  • Time: 3:00 - 5:00 

Please click here for meeting details and to RSVP 

Introduction to Denali AlwaysOn and Column Store Technologies

Ajay Nangia, Microsoft

The session will talk about the new High Availability and Disaster Recovery solution being introduced in SQL Server “Denali”. It will provide an overview about the new features and capabilities such as utilization of secondary databases for a better return on hardware investment and how to simplify HADR deployments.  It will also introduce the new column-based accelerator for vast improvements in query performance.

 

 read more ...

August 2011 PASSMN Meeting - Thursday, July 28, 2011

 Sponsored by Digineer

Location:

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

Date:

August 16th, 2011

Time:

3:00 - 5:00 

 

Please click here to RSVP

 

 

Jason Strate, Digineer

Do you know when your users are using the production login accounts from their workstations?  Are you aware of changes being made to the development servers that may impact future deployments?  Has the new Junior DBA start giving out access like candy?  As DBAs, we are responsible for knowing and acting on all of this and much more.  Fortunately, SQL Server provides a number of features that you can use to monitor and track user activity.  In this session, we’ll look at these features and demonstrate how you can use them to the extent that your users find you creepy!

The Creepy DBA, How to Stalk Your Users

 read more ...

July 2011 PASSMN Meeting - Thursday, July 07, 2011

 

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 

Meeting sponsor:  Superior Consulting

 

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

 

 read more ...

June PASSMN Meeting - Tuesday, June 07, 2011

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

Date:  June 21st, 2011T

Time:  3:00 – 5:00

Please click here for meeting details and to RSVP

Agenda:

2:45-3:00 : Registration / hospitality / networking

3:00-3:15 : Announcements etc.

3:15-3:45 : “11 Pages that Changed the World” (relational DB’s) – Mark Knutson

3:45-4:45 : NoSQL – Dan McCreary

4:45-5:00 : Closing comments/prize giveaways 

 

 

11 Pages that Changed the World

Mark Knutson, Hennepin Faculty Associates

In 1970, the widely implemented database products were based either on a network or an inverted tree structure. E. F. Codd, an IBM research mathematician, presented a paper to the Association of Computing Machinery proposing a database management system based on mathematical objects called relations.

I will briefly review the topical coverage of the paper, including the formal definition of a relation. I will also place the paper in historical context and review how IBM's response to it shaped the DBMS product landscape that we see today.

NoSQL

Dan McCreary

This presentation will discuss the "NoSQL movement", a new set of data solutions that leverage non-relational data stores. These data stores are frequently designed to leverage thousands of commodity processors, are "schema free", use simple key-value stores or document stores and are often associated with web-scale "BigData" challenges.  This presentation will cover the key business factors and technology issues driving this movement.

 read more ...

May 2011 Meeting Slides - Sunday, May 29, 2011

The May 2011 meeting slide decks are available for you to download....click on the resources tab and they are there.  Note, you have to be logged in to get to the resources tab.

 read more ...

May PASSMN Meeting - Thursday, May 05, 2011

Date:  5/17/11
Time:  4:00 PM - 6:00 PM
Location: 
8300 Norman Center Drive, 9th Floor, Bloomington, MN  55437

Please click here for meeting details and to RSVP

 

Agenda:

4:00-4:15 : Registration / hospitality / networking

4:15-4:30 : Announcements etc.

4:30-5:00 : Andy Lohn:  Twitter – a Swiss Army Knife for the SQL Server Professional

5:00-6:00 : Ted Krueger:  SSIS: The DBA Multiplier

6:00-6:15 : Closing comments/prize giveaways

 

Presentation:

 

Twitter – a Swiss Army Knife for the SQL Server Professional

 

Andy Lohn, Medtronic

 

Andy will be giving an overview of Twitter and will demonstrate multiple ways in which SQL Server Professionals can leverage twitter.  The SQL Community is very active on twitter, so don’t miss out on this great resource.  Andy’s presentation will give you the twitter basics, how and where to find SQL Server resources, hash tags that help, how to network with and get help from SQL Server MVPs and other tools that maximize the twitter experience.

 

Andy Lohn works as a SQL Server Development DBA for Medtronic.  He has been working with SQL Server since 1998.  Since that time, he has had many titles, ranging from Operational DBA to Special Projects Lead.  His specialties include TSQL, Performance tuning, working with very large databases and creating repeatable, scalable solutions.

 

Presentation:

 

SSIS: The DBA Multiplier

 

Ted Krueger, Magenic Technologies

 

Ever wanted to create clones of yourself to get all your work done faster? I will demonstrate how SSIS can help you perform your DBA tasks as if there were more than one of you. You will leave the session knowing how to use SSIS to automate tasks such as performance monitoring above (and below) the normal health checks and transporting databases from one environment to another.  This presentation will not only start ideas on how SSIS can help you daily as a DBA but as a Developer, we’ll see just how SSIS can be controlled conditionally so the outcome becomes much more than static imports and exports. We’re going to take SSIS and make it a standard tool for your administrative tasks and development tools!

 

Ted Krueger has been working in development and database administration for over a decade.  Ted currently works for a respected consulting company, Magenic Technologies as a valued Database Professional resource.  He is a PASS Region Mentor, Friends of Red Gate member and community mentor.  Specialties range from High Availability and Disaster / Recovery setup and testing methods down to custom assembly development for SQL Server Reporting Services.  Ted blogs and is also one of the founders of LessThanDot.com technology community.  Some of the articles focused on are Backup / Recovery, Security, SSIS and working on SQL Server and using all of the SQL Server features available to create stable and scalable database services.

 read more ...

April 2011 PASSMN Meeting - Sunday, April 10, 2011

"SQL DBA careers, including The Path to Microsoft Certified Master: SQL Server 2008"

 

Date:     April 19th, 2011
Time:     3:00 – 5:00
Location:     8300 Norman Center Drive, 9th Floor, Bloomington, MN  55437


Agenda:
  • 2:45-3:00 : Registration / hospitality / networking
  • 3:00-3:15 : Announcements etc.
  • 3:15-4:25 : Joe Sack:  The Path to Microsoft Certified Master: SQL Server 2008
  • 4:25-4:45 : Jacquie Garberg:  Get the career you want…keep the one you have!
  • 4:45-5:00 : Closing comments/prize giveaways
  • 5:00+ :  Jason Strate:  Becoming and Being a SQL MVP 

 

Presentation:
The Path to Microsoft Certified Master: SQL Server 2008
Joe Sack, Microsoft

Joe will be giving an in-depth talk on the SQL MCM Certification program. He'll discuss how the SQL MCM Certification program format use to look and how it looks today. He'll also describe the benefits of a SQL MCM Certification and how to prepare for it.

Joe Sack works for Microsoft as a SQL Server Dedicated Support Engineer in the Premier Field Engineering team and is also the acting Program Manager for the Microsoft Certified Master SQL Server program. Since 1997, he has been developing and supporting SQL Server environments for clients in financial services, IT consulting, manufacturing, retail and the real estate industry. He is the author of SQL Server 2008 Transact-SQL Recipes, SQL Server 2005 T–SQL Recipes and SQL Server 2000 Fast Answers for DBAs and Developers.

Presentation:
Get the career you want…keep the one you have!
Jacquie Garberg, Benchmark Learning

Do you know where you are heading with your career?  Are you on the journey to somewhere or just getting by?  Does your organization see the value you bring to the table?  What do companies look for in a SQL DBA professional? Jacquie will focus on career topics, with an interactive discussion.  She will also provide the latest tips and tricks to help you “stay on track” so that your career doesn’t get derailed.

Jacquie Garberg joined Benchmark Learning in August 2007 as a Career Development Manager.  Jacquie’s passions include career coaching, mentoring and skill development. Additionally, Jacquie has a background in Career Counseling and Human Resources. Jacquie graduated from the University of Wisconsin–La Crosse with a Bachelor’s Degree in Business Administration and maintains a GCDF certification.  She is currently an active member with MN Career Development Association (MCDA), MN High Tech Association (MHTA) and serves on the iSeek Advisory Committee and IT Workforce Collaborative.  Jacquie also advocates for individuals who have Autism as a member of the Autism Society and other related organizations.

Presentation:
Becoming and Being a SQL MVP
Jason Strate, Digineer

For those willing to stay a little later than our usual closing time, Jason Strate will tell us what the MVP award is, what’s involved in becoming an MVP, and what it the benefits are for the MVP program.

Jason Strate, SQL Server MVP, is a DBA with over twelve years of experience. His experience includes delivering both OLTP and OLAP solutions as well as assessment and implementation of SQL Server environments for best practices, performance, and HADR solutions. He is a SQL Server MCITP and participated in the development of Microsoft Certification exams for SQL Server 2008. Jason has presented at the SSWUG Virtual Conferences, TechFuse, SQL Saturday events, and at PASSMN user group meetings.

 

 

 read more ...

March 2011 PASSMN Meeting - Thursday, March 03, 2011

“SQL Azure – Relational Data in the Cloud

Meeting sponsor:  Magenic

Date:      March 15th, 2011
Time:     3:00 PM - 5:00 PM
Location:      8300 Norman Center Drive, 9th Floor, Bloomington, MN  55437

Please click here for meeting details and to RSVP

 

Agenda:

  • 2:45-3:00 : Registration / hospitality / networking
  • 3:00-3:15 : Announcements etc.
  • 3:15-4:45 : Steve Hughes:  SQL Azure – Relational Data in the Cloud
  • 4:45-5:00 : Closing comments/prize giveaways 

Presentation:

SQL Azure – Relational Data in the Cloud

Steve Hughes, Magenic

This session will review SQL Azure capabilities and tools.  We want to look at what we can do on the platform and what may be some shortcomings of the platform at this point.  We will take time to evaluate what place SQL Azure has within our data environments and some viable use cases for using it.  Finally, we will crack open the SQL Azure Reporting CTP to get a “first look” at this latest offering from Microsoft.

Steve Hughes is Principal Consultant at Magenic Technologies. His area of expertise is in data and business intelligence architecture on the Microsoft SQL Server platform. He was also the data architect for a SaaS company which delivered a transportation management solution for fleets across the United States. Steve has co-authored two books and regularly presents on SQL Server and data architecture.

 read more ...

February 2011 Meeting Slides - Wednesday, February 16, 2011

As Tim mentioned, his slide decks are available for you to download....click on the resources tab and they are there.  Note, you have to be logged in to get to the resources tab.

 read more ...

February 2011 PASSMN Meeting - Sunday, February 06, 2011


“High Availability & DR Options for SQL Server 

Meeting sponsor:  Digineer

Date: February 15th, 2011

Time: 3:00 - 5:00 PM

 

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

Please click here for meeting details and to RSVP

Agenda:

  • 2:45-3:00 : Registration / hospitality / networking
  • 3:00-3:15 : Announcements etc.
  • 3:15-5:00 : Tim Plas:  High Availability & DR Options for SQL Server

Presentation: 

High Availability & DR Options for SQL Server

Tim Plas, Virteva

A comparison of SQL HA & DR options, by a practitioner who has implemented & managed all the SQL HA and DR approaches (& various combinations thereof). Tim is an operational DBA, charged with keeping SQL servers up & running & optimized, for managed-services customers. We will compare trade-offs between the various SQL HA & DR options: for complexity, usability, hardware requirements, licensing, failover speed, initial costs, ongoing support costs, staff skill requirements, etc.

Also, as you may be aware, Microsoft has announced a set of very powerful “AlwaysOn” features for the upcoming version of SQL (“Denali”), features popularly referred to as “HADRON”  (“High Availability Disaster Recovery always ON”).  We’ll provide a brief overview of those features now, and will have a full presentation on that later in the year.

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

 

 read more ...

January 2011 PASSMN Meeting - Tuesday, January 11, 2011

“Error Logs and Deadlocks, Oh My!” and “Seeking SQL Server Secrets”

Sponsor: Benchmark Learning

Date: January 25th, 2011

Time: 5:00 - 7:00 PM

Location: 8000 Norman Center Drive, Bloomington, MN  55437 – We will be meeting in the 8000 building this month. 

Please click here for meeting details and to RSVP

Agenda:

  • 4:30-5:00 : Registration / hospitality / networking
  • 5:00-5:15 : Announcements etc.
  • 5:15-6:00 : Jason Strate:  Error Logs and Deadlocks, Oh My!
  • 6:00-7:00 : Kalen Delaney:  Seeking SQL Server Secrets

Presentation:

 

Error Logs and Deadlocks, Oh My!

Jason Strate, Digineer

 

Tired of turning to the SQL Server error log to find out what’s happened?  Would you rather just know about a deadlock when it’s occurred rather than later in the day when the manager as you why HRs bonus distribution application failed?  Find out how to get this information and more delivered to your inbox so that you can head off issues instead of drowning in them.  In this session we’ll look at Event Notifications and find out how to stop having to monitor SQL Server error logs today.

Jason Strate, SQL Server MVP, is a DBA with over twelve years of experience. His experience includes delivering both OLTP and OLAP solutions as well as assessment and implementation of SQL Server environments for best practices, performance, and HADR solutions. He is a SQL Server MCITP and participated in the development of Microsoft Certification exams for SQL Server 2008. Jason has presented at the SSWUG Virtual Conferences, TechFuse, SQL Saturday events, and at PASSMN user group meetings.

 

Presentation:

 

Seeking SQL Server Secrets

Kalen Delaney, SQLearning

 

Many experienced DBAs are aware that there are many undocumented commands and traceflags in SQL Server, and some DBAs may even keep track of all references to such options whenever they read about them in an article or blog posts, or hear about them at a conference. In this session, I’ll not only tell you about some of my favorite undocumented features, I’ll also tell you some of my tricks for discovering more undocumented secrets.

Kalen Delaney has been working with SQL Server for 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. Kalen 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 www.sqlblog.com and her personal website and schedule can be found at www.SQLServerInternals.com.

 read more ...

PASS Summit 2010 Live Keynote Streaming - Friday, November 05, 2010

Don't miss out on your chance this year to check out the keynote presentations at this year's PASS Summit 2010.  You can register here - http://www.sqlpass.org/summit/na2010/livekeynotes.aspx.  Besides the keynote they will also be streaming the Women In Technology Luncheon.

Day 1:

Ted Kummert will open Day 1 of PASS Summit 2010 by highlighting continued innovation across Microsoft’s business and information platform.  Kummert will explore Microsoft’s key technical investments that help solve the toughest issues for various roles across an organization, from IT Professionals to developers. Kummert will explore Mission Critical applications, getting the most out of your datacenter, and the accessibility of Business Intelligence in an effort to deliver on Microsoft’s vision of enabling data platform customers to be more efficient through integrated tools. Some exciting product announcements will also be shared exclusively with PASS attendees so you won’t want to miss out!

Day 2:

Quentin Clark will pick up where Day 1 leaves off—showcasing a deep dive on the next version of SQL Server. Clark will share how features in this upcoming product milestone continue to deliver on Microsoft’s Information Platform vision—including improved support for the business and IT needs of mission-critical applications. Clark will also demonstrate how developers can leverage new industry-leading tools with powerful features for data developers and a unified database development experience.

Day 3:

You voted, and the results are in: Dr. David DeWitt will be speaking on Query Optimization 101 during the most anticipated keynote of PASS Summit 2010!

“In two short years, giving a keynote at the PASS Summit has become a highlight of my year,” noted Dr. DeWitt, Technical Fellow with Microsoft’s Jim Gray Systems Lab. “This year, I am excited to have the opportunity to talk about SQL query optimization, why it is hard to always produce good plans, and new technologies that offer the promise of better plans in future releases of SQL Server.”

Query optimization is the process of compiling a SQL query into an executable plan that is as efficient as possible. While the basic fundamentals for cost-based query optimization were first described in a seminal paper by Pat Selinger of IBM Research in 1979, optimizing complex queries continues to be very challenging 30 years later. In this talk, David DeWitt will describe the fundamentals of query optimization, why it remains a very hard problem today, and present several recent research results that promise to improve the quality of plans produced in the years to come.

 read more ...

SQL Saturday 58 Minnesota Feedback Survey - Friday, November 05, 2010

Hopefully the majority of you were able to attend our event last week.  We had an amazing turnout with right around 250 people in attendance along with our sponsors of the event.  Last year we had around 100 in attendance at our PASSMN SQL Summit event, so we were all amazed at the response this year.  Next year we are looking at doing it again, but before we start in on the planning for that we would like to get everyone's feedback and comments.

If you could take a couple of minutes and answer a few questions in regards to the event we would be extremely grateful - SQL Saturday 58 Minnesota Feedback Survey.  After all, this is event is all about the community, so your feedback and comments are extremely valuable to us.

Thanks again for making last week such a wonderful event!

 read more ...

PASSMN 2011 Executive Board - Wednesday, November 03, 2010

I am pleased to announce the new Minnesota SQL Server User Group (PASSMN) 2011 Executive Board:

  • Jason Strate, Digineer*
  • Gordon D’Souza, Solution Design Group*
  • Tim Plas, Virteva
  • Andy Lohn, Medtronic
  • Steve Hughes, Magenic

* Incumbent

Yep, that is right, my name is not on the list this year.  After two years I have decided to open up the spot to someone new and I will be shifting my focus over to the local Microsoft BI User Group.  We do not need to vote this year since we had exactly five nominees and five positions that need to be filled and assigned.  Congratulations to everyone that will be part of next year’s board.  Thanks so much for being involved and helping make this such a great SQL community.

In December we will get together and distribute the role assignments for the new board members.  A special shout and thanks goes out for the existing PASSMN 2010 Board that consisted of myself, Jason Strate, Mark Rocco, Gordon D’Souza, and Eric Strom.  Great job and thanks for all of the hard work you have done to make this such a great user group.

 read more ...

SQL Saturday 58 Follow up - Monday, November 01, 2010

It was a great event and I want to thank all of the organizers, volunteers, speakers, sponsors, Mystic Lake staff, and all of the attendees that showed up to participate.

I hope that everyone enjoyed the event.  I have posted a little follow up about the event here - SQL Saturday 58 – Minnesota: Follow up & Lessons Learned.

Thanks again to everyone that made this such a great day!

 read more ...

SQL Saturday 58 Download Materials - Monday, November 01, 2010

The session downloads and material will be made available over the next week or so and uploaded to the scheduling area on the site http://sqlsaturday.com/58/schedule.aspx.  Simply click on the session and the download button should be available if the materials have been uploaded.  As an example you can take a look at my session here - http://sqlsaturday.com/viewsession.aspx?sat=58&sessionid=2481.

Hope you all enjoyed the event and thanks for making it an extra special day.

 read more ...

Inside Scoop on SQL Saturday 58 - Wednesday, October 27, 2010

Just posted a blog providing some additional information about the event.  Check it out here - Inside Scoop on SQL Saturday 58 – Minnesota.

Hope to see you there!

 read more ...

SQL Saturday 58 After Party - Monday, October 25, 2010

We have planned an after party for the event at Mc Hugh’s Grille & Bar, 5715 Egan Dr, Savage, MN (Phone: 952-226-5800). They will be ready at 5 p.m. and their happy hour goes till 6 p.m. The section in the back will be reserved for us.

This event is a place where we can relax after a long day of jamming our heads full of knowledge. If you have the time, please stop by to hangout and chat with some like-minded people.

 read more ...

2011 PASSMN Executive Board Nominations - Saturday, October 23, 2010

o    Nominations for the PASSMN Executive Board are now open. If you are interested in running, please click the link below and fill out the nomination survey. The nominations will be open until October 31st.
o    Nominate yourself (or someone else) here (
http://www.surveymonkey.com/s/FY9RTJS)

 read more ...

SQL Saturday 58 - Minnesota - Schedule Released - Saturday, October 23, 2010

The final arrangements are being made and the event is nearly here.  The schedule has been released - http://sqlsaturday.com/58/schedule.aspx and the sponsors have been posted - http://sqlsaturday.com/58/sponsors.aspx.

An extra special thanks goes out to all of the speakers, PASSMN board members, our sponsors, and Mystic Lake Casino for making this event possible.

 read more ...

$200 Chapter PASS Summit 2010 Discount - Tuesday, September 14, 2010

Thinking about heading out to the national PASS Summit 2010?  Well guess what, there is an additional $200 discount code you can use which is available to chapters of PASS.

$200 off registration for Chapter members only by using discount code CHM10.

PASS Chapter Discount Code CHM10 - $200 Off!

Register now for the world's best SQL Server conference, November 8-11, 2010, Seattle, WA

http://www.sqlpass.org/summit/na2010/default.aspx

Plus there is a contest going on amongst all of the chapters, so please make sure you associate yourself with our Minnesota SQL Server User Group (PASSMN):

Each registrant must identify their Chapter during the registration process. Each Chapter with three or more identified paid registrations (see contest details) is automatically entered to win a free set of PASS Summit 2010 session DVD recordings. Each registered PASS Summit member who identifies the winning Chapter during registration is eligible to win the prize.

Plus – here’s where the bragging rights come in to play: the Chapter with the most qualified registrations also wins a free set of PASS Summit 2010 session DVD recordings for each PASS Summit registered member and can claim official status as the best represented Chapter of the conference!

The winning Chapter will be announced at the PASS Summit 2010 Chapter Luncheon on Nov 11.

 read more ...

SQLSaturday #58 - Minnesota 2010 - Friday, August 13, 2010

Hello Twin Cities, are you ready for a free all day non-stop SQL Server event?  Well guess what, you are in luck then because we are going to be having our 2nd annual PASSMN event and this year it will be under the ever famous SQLSaturday label.  The official name is now SQLSaturday #5 – Minnesota 2010 and it will be held on Friday, October 29.  Did I do a typo there?  Nope, that is right, a SQLSaturday on a Friday.  We are a little crazy up here in the north and like to change things up a bit.

So what do you need to know?  Here is some of the key information to get you started:

The web site is active and ready for business.  We are actively looking for sponsors for the event and speakers.  Please visit the site and take a look.  For sponsorship information we have three levels designated – Bronze, Silver, and Gold and the details can be found here – Sponsorship Plan.  We are also looking for volunteers, so during the registration submission you will see a spot on the form to let us know if you are interested in helping out at the event (like registration, directing traffic, collecting evaluations, coordinating the event, etc.).

So head on over to the site and let’s get this party started!  I hope to see you there and feel free to reach out to me if you have any questions and there is a contact us email address for this event as well – sqlsaturday58@sqlsaturday.com.

Please spread the word – SQLSaturday #58 – Minnesota 2010 – let’s make this a fantastical SQL event!

 read more ...

PASSMN Videos on Vimeo - Friday, August 06, 2010

So far this year we have been able to get a couple of our monthly meeting presentations recorded and have made them available on Vimeo.  You can check out the May and June presentations here:

We hope that you enjoy them!

 read more ...

Enter for a chance to win a trip to SQL PASS - Tuesday, July 27, 2010

The SQL PASS Summit is the largest conference for SQL Server and BI professionals in the world and will be held in Seattle November 8 - 11, 2009.
 
MSSQLTips and Idera are giving away a free all-expenses-paid trip to the 2010 SQL PASS SUMMIT to one lucky database professional.
 
Register today -
http://www.mssqltips.com/pass_giveaway_entry.asp 
 

 read more ...

PASS Summit 2010 - Wednesday, July 14, 2010

About Summit

PASS Summit is the world's largest, most-focused, and most-intensive conference for Microsoft SQL Server and BI professionals.

Organized by and for SQL Server and BI users, PASS Summit delivers the highest number of technical sessions, the largest number of attendees, the best networking, and the highest-rated sessions and speakers of any SQL Server event in the world.

PASS Summit is produced by the
Professional Association for SQL Server (PASS), an independent, not-for-profit association dedicated to supporting, educating, and promoting the Microsoft SQL Server community. Revenues from the PASS Summit and sponsorships are used to fund year-round community support and growth through initiatives such as global chapter growth, virtual chapters, educational support including exclusive technical articles, funding for local, chapter-run and community events, online events and webcasts, and many other actitivies that support our mission.

From the Board of Directors to the many people on the Volunteer Committee, Program Committee, Content Committee, Summit Ambassadors, Chapter Leaders, Regional Mentors, and more, PASS is made up of a group of passionate, dedicated, and enthusiastic SQL Server users, committed to furthering and growing the SQL Server community. Learn more about
PASS.

Learn more about PASS Summit:

PASS Summit 2010 Banner

 read more ...

MS TechEd & BI 2010 Conference Videos / Presentations - Wednesday, June 16, 2010

If you did or didn't make it down to New Orleans last week I just wanted to let you know that you can access all of the content (or at least a very large majority) at http://www.msteched.com/2010/NorthAmerica.  You can use the Browse By Subject to pull up all of the Business Intelligence content and switch between thumbnails and list (over 50 presentations available).  You also have the ability to download the videos and presentation material.  Very awesome and thanks Microsoft!

 read more ...

SQL Server 2008 R2 Launch Presentations - Monday, June 14, 2010

The content from the SQL Server 2008 R2 Launch event has been made available for download in the Resources-->Documents section.  Thanks to Lara for getting this all setup.

http://minnesota.sqlpass.org/Resources/Documents/tabid/1487/Default.aspx

 read more ...

Microsoft BI User Group Q2 2010 Meeting June 2, 3 to 6 p.m. - Monday, May 24, 2010

 

http://www.digitalconcourse.com/getdigi/dc4main.asp?p=210&confcode=2246

We are pleased to announce that we will be hosting the Microsoft BI User Group meeting at Microsoft Corporation, 8300 Norman Center Drive, Suite 950, Bloomington, Minnesota, 55437 from 3:00 pm 6:00 pm. We hope you will plan to attend this meeting where we have lined up a couple of exciting and informative speakers.
 
Agenda:
 
2:30-3:00
Registration
3:00-3:15
Microsoft BI User Group Updates & Announcements
- Hear about how the organization is growing and changing to better serve you!
- Agenda for the day and introduction of speakers
3:15-4:00
 
Presentation Topic: Taking BI — and the business — to the next level with SQL Server 2008, PerformancePoint 2010 and PowerPivot
 
Nilfisk-Advance is a leading global manufacturer of commercial and industrial cleaning equipment. In a very competitive industry, Nilfisk-Advance has been growing consistently primarily due to a strong focus on product development. To further improve Nilfisk-Advance’s position, a stronger, customer focused strategy was adopted. As a result, organizational performance management needed to brought to the next level. Over the years Nilfisk-Advance has built an EDW covering all aspects of key business functions – Sales, Delivery Performance, Inventory Mgmt, Supplier Performance, Service, Finance and Budgeting. This EDW has been an IT led initiative, primarily used to ease the pain for reporting. However, with the new business strategy comes a much stronger focus on performance measurement. Nilfisk-Advance is looking to leverage the EDW and Microsoft BI to enable cross-functional insights that have a strategic impact and enable the organization to consistently perform better. Listen to Ken Jensen, VP of IT, Nilfisk-Advance, on his journey to building an Enterprise Performance Management Solution. In his presentation, you will get to learn about the challenges, pains and successes of building an enterprise data warehouse and how best to leverage an EDW to truly deliver business value to enable strategy using Microsoft BI (SQL Server, PerformancePoint 2010 and PowerPivot).
 
 
About the speaker:
Ken Jensen is the head of IT for Nilfisk-Advance’s America’s operations. He has the overall responsibility for delivery of information and software solutions that optimize the efficiency of Nilfisk-Advance Americas. The latest accomplishments include roll-out of new ERP platform across North America, facilitate the largest Supply Chain restructuring in the history of Nilfisk-Advance, and roll-out of Field Service Management solution. He has formerly developed Business Intelligence strategies and implemented solutions to provide businesses with strategically important KPIs supported by detailed data analysis. His background as a consultant with Deloitte Consulting has laid the foundation for a successful career through excellence in leadership, dedication to the job and attention to the detail.
4:00-4:15
Break
4:15– 4:30
Microsoft Update
Update on the new developments with Microsoft BI
4:30 – 5:30
Presentation Topic: SharePoint and Performance Point 2010
 Performance Point 2010 is a key component of the Office 2010. It provides an array of Business Intelligence capabilities integrated into SharePoint including dashboards, scorecards, charts and reports that support ad-hoc analysis. It also facilitates the integration and delivery of diverse BI content from sources like Reporting Services and Excel Services. This presentation will be an introduction to PerformancePoint and a demonstration of how PerformancePoint can be used to create BI solutions that are integral to the overall SharePoint experience.
 
About the speaker:
Dave Sherman in a Senior Program Manager in the SharePoint Business Intelligence group. He joined Microsoft in 2006 and he has contributed to the development of both PerformancePoint 2010 and PerformancePoint 2007. Prior to joining Microsoft, he spent over five years with ProClarity Corporation. Dave has a BS from Boise State University and an MSCS from the University of Idaho.
5:30 - ???
Social and Networking: Meeting will adjourn with a networking opportunity. Enjoy this time to meet your speakers and other members of the community. Refreshments and food will be provided.
 
Date: Wednesday, June 2nd
 
 
 

Check In: 2:30 PM

Event Time: 3:00 PM – 6:00 PM
 
Location:

 

Microsoft Event Center
8300 Norman Center Drive
Suite 950
Bloomington, MN 55437

 

 read more ...

WROX April Free SQL Server Community Training - Thursday, April 15, 2010

Brian Knight

Advanced  SSIS tips and Tricks
April 20, 2010 11:00 a.m. EDT 
  
 
 
In this webinar SQL Server MVP, Brian Knight will show you some of the neat tips and tricks you can do in SSIS to handle larger scales of data, parallelism and restart ability. He'll also show you how to create work queues for multi-server processing of data and integrating data mining into your package.
 
Jessica Moss
SSIS scripting and custom components 
April 22, 2010 11:00 a.m. EDT 
 
Can't find an SSIS Task that does what you need? Script it! The Script Task, Script Component, and Custom Components in SSIS are extremely powerful and flexible. In this session by Jessica Moss you will learn how to customize SSIS functionality using Script objects, best practices for script development, script troubleshooting .
 
 
Rodney Landrum
Use SSRS and SSIS to create a DBA Repository
April 27, 2010 11:00 a.m. EDT 
 
At it's heart, the DBA Repository solution employs SSIS and SSRS and in late 2009 was updated for performance and resiliency. This session will cover the original solution, published in SQL Server Magazine, plus the latest enhancements which will delve into some interesting uses of package variables and MERGE in SSIS along with some new reports.
 
Bent Ozar
Virtualization and SAN Basics for DBAs
April 29, 2010 11:00 a.m. EDT 

 

·       Three things you should NEVER do when virtualizing SQL Server,
·       Three things you should ALWAYS do when using SQL Server on a SAN.
·       Three metrics you should always capture on every SQL Server whether it's virtual or SAN-connected or none of the above.
 
 read more ...

Free ebook: Introducing Microsoft SQL Server 2008 R2 - Thursday, April 15, 2010

We’re thrilled to publish another free ebook: Introducing Microsoft SQL Server 2008 R2, by Ross Mistry and Stacia Misner!

The book contains 10 chapters and 216 pages

http://blogs.msdn.com/microsoft_press/archive/2010/04/14/free-ebook-introducing-microsoft-sql-server-2008-r2.aspx

You can download the ebook in XPS format here and in PDF format here.

Enjoy!

 read more ...

24 Hours of PASS 2010 - Wednesday, April 07, 2010

 If you haven't heard already, they are doing it again and it is all free.

http://www.sqlpass.org/24hours/2010/

24 Hours of PASS is bringing an exceptional lineup of SQL Server and BI experts  from around the world to your computer in 24 back-to-back webcasts starting at 12:00 GMT (UTC) on May 19.

 read more ...

PASS AppDev VC Presents - PowerShell for Database Developers - Wednesday, April 07, 2010

PASS AppDev VC Presents - PowerShell for Database Developers

 
Date:     4/13/2010
Start Time:     12:00:00 PM
End Time:     1:00:00 PM
Timezone:     (GMT-05:00) Eastern Time (US & Canada)
 
PowerShell for Database Developers with Peter Schott
 

 

Powershell for Database Developers
 
This session will be a high-level introduction to Powershell. It will focus on getting started and introducing SQL Developers to some of the things that can be done within Powershell to help them in their jobs. 
 
Peter Schott
 
Peter Schott is currently working as a Development DBA for Fellowship Technologies, using SQL Server, SSIS, and Powershell (in his spare time).  He has worked with SQL Server since 1996, designing databases, writing reports, scripting, performance tuning, and moving around lots of data.
Peter blogs at 
Schott SQL.  (And is open to better names for his blog.)
 How do I view the presentation?
Attendee URL: 
Live Meeting link

 

 read more ...

SQL Server Internals and Architecture Live Meeting March 24 @ 12 EST - Sunday, March 21, 2010

Topic: SQL Server Internals and Architecture Date:March 24, Noon Eastern Time

 
Abstract:
Let’s face it.  You can effectively do many IT jobs related to SQL Server without knowing the internals of how SQL Server works.  Many great developers, DBAs, and designers get their day-to-day work completed on time and with reasonable quality while never really knowing what’s happening behind the scenes.  But if you want to take your skills to the next level, it’s critical to know SQL Server’s internal processes and architecture.  This session will answer questions like:
 
-       What’s different about 32- and 64-bit systems?
-       What are the various areas of memory inside of SQL Server?
-       How are queries handled behind the scenes?
-       What does SQL Server do with procedural code, like functions, procedures, and triggers?
-       What happens during checkpoints?  Lazywrites?
-       How are IOs handled with regards to transaction logs and database?
-       What happens when transaction logs and databases grow or shrinks?
 
This fast paced session will take you through many aspects of the internal operations of SQL Server and, for those topics we don’t cover, will point you to resources where you can get more information.  So strap on your silly, as we cover all these topics and more at speed with tongue planted firmly in cheek!
 
Prerequisites: Basic understanding of SQL Server operations and activities – such as transactions, queries, and preventative maintenance tasks like backup and recovery.

Speaker:
Kevin Kline is the Technical Strategy Manager for SQL Server Solutions at Quest Software. A Microsoft SQL Server MVP, Kevin is a founding board member of PASS and the author of popular IT books like “SQL in a Nutshell” (O’Reilly & Associates). Kevin is a top-rated speaker at industry trade shows and has been active in the IT industry for over 20 years.
 
Door Prize:
Kevin will have two copies of his "In a nutshell" book that will be raffled off to attendees. You must register no later than 5:00 PM Eastern on Tuesday, March 23rd to be included in the raffle.

Registration: You can attend the meeting without registering but if you want to be entered in the drawing, you must register at

 

 

 

Live Meeting Link (just paste into your browser):
https://www.livemeeting.com/cc/8000181573/join?id=344ND5&role=attend

 
 read more ...

Microsoft BI Conference $200 Discount - Wednesday, March 17, 2010

Are you a member of PASS?  Discount for #sqlpass members:$200 off BI Conference 2010 registration until Apr 30, promo code BIATCST33H http://cot.ag/9Zcui7

 read more ...

SSWUG.org Virtual Spring Conference April 7-9 - Sunday, March 07, 2010
SSWUG.org #SQL Server Virtual Conference April 2010: http://bit.ly/dfOALz three days of fun and all online
 
$25 off SSWUG.org virtual conference April 7-9 use coupon code MSMVP410S http://bit.ly/d5dzRS #SQL BI #Sharepoint .NET

 

 read more ...

North Central District Microsoft BI User Group 2010 Q1 Meeting – March 3 - Monday, February 22, 2010

North Central District Microsoft BI User Group 2010 Q1 Meeting

Date: Wednesday, March 3, 2010

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

Location: Microsoft Event Center 8300 Norman Center Drive Suite 950 Bloomington, MN 55437

Please Register Now

Agenda:

  • 2:30-3:00 : Registration
  • 3:00-3:15 : BI SIG Updates & Announcements
  • 3:15-4:00 : Leveraging SharePoint as a strategic platform for Planning, Budgeting and Business Performance Management
  • 4:00-4:15 : Break
  • 4:15-4:30 : Microsoft Update
  • 4:30-5:30 : In depth look at Microsoft PowerPivot to enable self-service BI
  • 5:30-??? : Social and Networking

 

 read more ...

WROX Free SQL Server Community Training – Feb/Mar 2010 - Thursday, February 11, 2010

Interested in getting some free training on SQL Server?  From a DBA and/or BI Developer standpoint?  Well you are in luck, just received an email today from Brian Knight and there is some free, yes FREE training coming up this month and next month.  Make sure you sign up early if you are interested because registration is limited.

SQL Server Global Webinar Series

Pragmatic Works, WROX, Red Gate Software and SQL Server Central have teamed up again with the best selling authors in the SQL Server industry.  It's not often you can get free training from the people that write the books.

Webinar Series: SQL Server 101 Series
New to SQL Server or trying to enter the field? This webinar series will walk you through the Microsoft SQL Server stack so that you can become a DBA or Business Intelligence (BI) developer.
Meet the Authors - Brian Knight, Jorge Segarra, Steve Jones, Brad McGehee, Patrick LeBlanc, Christian Bolton, Adam Jorgensen, Devin Knight

Webinar Series: Week of Business Intelligence
In these sessions you will learn how to design a data warehouse, load it using SSIS, place a cube on top of it using SSAS and report against it using SSRS. Finally, you'll see how to performance tune and scale the data warehouse using common techniques. All speakers have authored many of your favorite books from Wrox.
Meet the Authors - Joy Mundy, Brian Knight, Devin Knight, Adam Jorgensen, Paul Turley, Mark Stacey, Donald Farmer

* Registration Opens February 1st, 2010 and is limited to the first 1,000 people. Webinars traditionally fill quickly.

 read more ...

PASS DBA Virtual Chapter Live Meeting Event - 2/10: Top 10 Mistakes on SQL Server - Sunday, February 07, 2010

Topic: Top 10 Mistakes on SQL Server

Date: Feb 10th, Noon Mountain Time

Level: 200
Abstract: SQL Server encompasses a wide variety of domains –
administrative, development, and design. But despite years of experience with
relational databases, SQL Server practitioners frequently make the same mistakes
over and over again. Wouldn’t you like to learn about those mistakes before they
ever happen?  This session will answer questions like: 
·  What’s the most common Transact-SQL programming mistake and how do I fix it?
·   How do database designers cause problems for future generations of application
   developers and database administrators?
· Why do inexperienced database administrators make their own job more difficult
and less efficient?
 
There are a short list of mistakes that, if you know of them in advance, will
make your life much easier. These mistakes are the “low hanging fruit” of
application design, development, and administration. Once you apply the lessons
learned from this session, you’ll find yourself performing at a higher level of
efficiency and effectiveness than before.
 
Prerequisites: Basic understanding of SQL Server architecture, development,
design, and administration.
 
Speaker: Kevin Kline is the Technical Strategy Manager for SQL Server Solutions at Quest Software. A Microsoft SQL Server MVP, Kevin is a founding board member of PASS and the author of popular IT books like “SQL in a Nutshell” (O’Reilly & Associates). Kevin is a top-rated speaker at industry trade shows and has been active in the IT industry for over 20 years.
 
Door Prize:
Quest Software will be raffling off a Kindle and some books to those that RSVP for this event via the PASS Event site  (
http://www.sqlpass.org/Events.aspx). Note: you do not have to RSVP to attend the meeting. However, if you want to be entered in the raffle, you must RSVP no later than 5:00 PM Eastern on Tuesday, February 9th.

Live Meeting Link (just paste into your browser):
https://www.livemeeting.com/cc/usergroups/join?id=55PFCZ&role=attend
The next DBA Virtual Chapter Live meeting event will be on February 24th at Noon, Eastern.
 read more ...

SQL Server Training on DMVs - Sunday, January 24, 2010

Registration is now open for Quest’s virtual SQL Server training conference. Sign up today to get free education—right from the convenience of your desk.

Join SQL Server experts Kevin Kline, Brent Ozar and Ariel Weil—all from Quest Software—as they present tips and tricks to help you monitor your SQL Server environment with ease. You’ll learn how to use Dynamic Management Views (DMVs) to simplify troubleshooting and significantly enhance SQL Server performance.
 
Date: Wednesday, March 3, 2010
Time: 7:45 a.m. – 5 p.m. ET
 
Don’t miss this insightful, full-day event!

P.S. - Register by January 31 and be entered to win an Amazon gift card! (USA registrants only)
 read more ...

Microsoft BI Summit - Sunday, January 24, 2010

June 7-10, 2010

New Orleans, LA

Registration for the Microsoft Business Intelligence Conference includes:

  • 58 BI Sessions
  • Birds of a Feather Sessions
  • Hands-on Labs
  • Keynote Address
  • Attendee Party
  • Tech·Ed Partner Expo Access
  • Interactive Theaters

Register before February 28, 2010  and get the early bird rate of only $1,195 - $300 savings.

http://bi2010.eventpoint.com/registration
 

 read more ...

Presentation Downloads - Wednesday, December 16, 2009

Are you trying to find the materials from from a previous months presentation?  If so, check out the Resources -> Downloads section.  Many of the materials for the last few years have been added to the page.  With the search functionality, you can find old materials based on the descriptions of the events.

 read more ...

New Website for PASSMN - Tuesday, December 15, 2009

As you may have noticed, PASSMN has moved to a new website and hosting service.  One of the things the board has been looking at over the past year was how to better integrate our activities with the larger PASS organization.  As part of this goal, we are introducing a new website.

 read more ...

SQL Lunch - Deploying Report Builder 2.0 for Self-Service Reporting - Thursday, October 08, 2009

SQL Lunch - Deploying Report Builder 2.0 for Self-Service Reporting

Meeting URL:  https://www.livemeeting.com/cc/usergroups/join?id=95MQQM&role=attend

Date:  10/12/2009

Time:  11:30 AM CST

Meeting URL:  https://www.livemeeting.com/cc/usergroups/join?id=95MQQM&role=attend

Presenter: Tim Mitchell .Tim is a Microsoft SQL Server consultant, developer, speaker, and trainer.  He has been working with SQL Server for over 6 years, working primarily in database development, business administration, data integration, and automation.  He has earned a number of industry certifications and holds a Bachelor's Degree in Computer Science from Texas A&M at Commerce.

Tim is principal and senior data engineer for Tyleris Data Solutions, a business intelligence and data management consulting firm.  As an active member of the community, Tim has spoken at venues including SQL Saturday and the PASS Business Intelligence SIG, and is an active volunteer and speaker at the North Texas SQL Server User Group in Dallas.  Tim is an author and forum contributor on SQLServerCentral.com and has published dozens of SQL Server training videos on JumpstartTV.com.

Topic:  Deploying Report Builder 2.0 for Self-Service Reporting

For the DBA, creating and maintaining reports can take up a significant amount of time.  Constantly changing requirements, an endless stream of ad-hoc requests, and simple formatting changes all add up to a good deal of maintenance.  To lighten the load, Microsoft offers SQL Server Report Buider 2.0, an easy-to-use reporting tool for building published and ad-hoc reports using SQL Server Reporting Services.  In this SQL Lunch presentation, we'll look at the capabilities of Report Builder 2.0 and how it can be used with SSRS to allow users to create and maintain many of their own reports.

 read more ...


  
 Stay Connected

Join us on Facebook and LinkedIn


  
 PASS MN Daily Paper Minimize

    
Copyright 2009 by PASS Chapters Portal   Terms Of Use  Privacy Statement