Search
Thursday, October 02, 2014 ..:: Home » Announcements ::.. 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 
 

 

 

 


  
 Announcements
September PASSMN Meeting & Newsletter - Wednesday, September 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

September PASSMN Meeting &Newsletter

Sponsored by vRad

 

 

 

Location:

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

Date:

September 16, 2014

Time:

4:00 PM - 6:00 PM

 

Please click here for meeting details and to RSVP

 

Checklists for Better Coordination and Performance of SQL tasks

 

Abstract: 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.  Can checklists help get better results on something you do? The answer is probably YES. Given that, how do you develop an effective checklist and what should you include in it? Should you just google for the "best" checklist?

About Paula Merns: I have been working in IT since 1995 starting with help desk for Compaq Computers. In 2000, by way of Oracle, I switched to SQL Server support and database management.  Since then I have worked as a developer primarily in SQL Server. Programming is a constant both scripting tasks and creating interfaces to databases for non-technical customers.  I now work as Instructor and Programmer/Database Analyst for Dunwoody College of Technology. I also continue to take classes toward a Master's in Data Science at the University of St. Thomas.

Correlated Concatenation with XML

 

Abstract: Since SQL Server 2005, a popular method for concatenating values across multiple rows has been to use the built-in XML functions. Of course they work well for the simple case involving a single field, but with one small trick, they can be used to make multiple, correlated lists based on different fields.

About Riley: Riley Major is an Enterprise Architect at Manna Freight Systems, Inc., of Mendota Heights, MN. He’s been in the trenches with SQL Server for 14 years, focusing mostly on development and architecture. Riley cut his teeth on SQL Server 7, but has been on a syntactical sugar high since SQL Server 2005. He’s written or architected over a half million lines of SQL still in active use. Riley is particularly grateful that technology has saved him from having to use his law degree.

PASS Summit 2014

The countdown to the world's largest gathering of SQL Server and BI professionals starts now. Seattle, WA Nov 4-7

PASS Summit is your conference – planned and presented by the SQL Server community for the SQL Server community.

Join 5,000 SQL Server and BI Professionals from over 50 countries and 2,000 different companies to take your SQL Server skills to the next level!!

Save $150 using the PASSMN discount code. [USNCS28]

 

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

August PASSMN Meeting & Newsletter - Thursday, August 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

August PASSMN Meeting & Newsletter

Sponsored by Tail Wind Informatics

 

 

 

Location:

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

Date:

August 19, 2014

Time:

4:00 PM - 6:00 PM

 

Please click here for meeting details and to RSVP

 

Spatial Data Deep Dive

 

Abstract: A deep dive into the SQL Server Spatial Data Types, the Bing Spatial Data Services, and Spatial Analysis.

About Ross: Ross McNeely is the Principle Consultant & BI Practice Manager at Tail Wind.  Ross has been working with MS SQL Server BI stack for over a decade.  Enterprise Information Management and Business Intelligence are Ross’ primary focus.

PASS Summit 2014

The countdown to the world's largest gathering of SQL Server and BI professionals starts now. Seattle, WA Nov 4-7

PASS Summit is your conference – planned and presented by the SQL Server community for the SQL Server community.

Join 5,000 SQL Server and BI Professionals from over 50 countries and 2,000 different companies to take your SQL Server skills to the next level!!

Save $150 using the PASSMN discount code. [USNCS28]

 

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

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

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

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

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

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


  
 Documents Minimize
 TitleOwnerCategoryModified DateSize (Kb) 

    
Copyright 2009 by PASS Chapters Portal   Terms Of Use  Privacy Statement