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 firstname.lastname@example.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 email@example.com or contact any of the board members directly.
Happy Holidays from the PASSMN Board of Directors and Best Wishes for 2014!!!! read more ...