Search
Wednesday, April 16, 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.