|
|
Sponsor: Digineer
Date: August 16th, 2011
Time: 3:00 PM – 5:00 PM
Location: 8300 Norman Center Drive, 9th Floor, Bloomington, MN 55437
Live Meeting:
Agenda:
- 3:00-3:15 : Registration / hospitality / networking
- 3:15-3:30 : Announcements etc.
- 3:30-4:45 : The Creepy DBA, How to Stalk Your Users – Jason Strate
- 4:45-5:00 : Closing comments/prize giveaways
Presentation:
The Creepy DBA, How to Stalk Your Users
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!
Jason Strate (B/T), Digineer Inc, is a DBA with over fifteen years of experience. He is a recipient of the Microsoft Most Valuable Professional (MVP) 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. Jason is a SQL Server MCITP and participated in the development of Certification exams for SQL Server 2008.
Last Tuesday was the July 2011 PASSMN Meeting – Ask the Experts. I got this great idea during the meeting to write up my notes with all the links to the web sites referenced. I took good notes and that night I got home and after my family went to bed I was going to start typing them up. Then I saw this:
Dan English (Blog/Twitter) beat me to the punch, and not only did he beat me to the punch, he did a much better job than I would have. Thank you Dan!
Here are his links and notes:
Here’s your chance to have your burning questions answered….
Sponsor: Superior Consulting
Date: July 19th, 2011
Time: 3:00 PM – 5:00 PM
Location: 8300 Norman Center Drive, 9th Floor, Bloomington, MN 55437
Click here to RSVP
Live Meeting:
Agenda:
- 3:00-3:15 : Registration / hospitality / networking
- 3:15-3:30 : Announcements etc.
- 3:30-4:45 : Ask the Experts
- 4:45-5:00 : Closing comments/prize giveaways
Ask the Experts Panel:
- Lara Rubbelke, Microsoft (Blog/Twitter)
- Dan English, Superior Consulting Services (Blog/Twitter)
- Mark Vaillancourt, Digineer (Blog/Twitter)
- Bill Preachuk, Emergent Networks (Blog)
- Zach Mattson, Patterson Companies (Twitter)
This years discussion will be moderated by Whoopi Goldberg Jason Strate (Blog/Twitter).
Sponsor: PASS
Date: June 21st, 2011
Time: 3:00 PM – 5:00 PM
Location: 8300 Norman Center Drive, 9th Floor, Bloomington, MN 55437
Live Meeting:
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
Presentation:
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.
Mark will briefly review the topical coverage of the paper, including the formal definition of a relation. Mark 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.
The discussion will be led by Mark Knutson who began his career programming IBM mainframes. Mr. Knutson is now programming team lead and database administrator at Hennepin Faculty Associates (The doctors of Hennepin County Medical Center), presiding over a modest, but fully up to date, SQL Server system.
Presentation:
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.
Dan McCreary is a Minneapolis-based data consultant with a focus on helping organization use innovative technologies. Dan has over 25 years experience in the IT industry including working for Bell Labs and Steve Jobs at NeXT computer, and is an "invited expert" of the world-wide web consortium. Dan was the founder of Eagan-based Integrity Solutions which employed over 75 people before being sold to Vance Opperman’s KeyTech. Dan has also consulted for many Minnesota organizations including the CriMNet project, the BCA, the Department of Pubic Safety, the Department of Education, the Department of Revenue, Thrivent Financial and Syntactica. Dan is currently working on projects for the US Department of State, NueMeta and JPMorgan. He has a BA in Physics from Carleton College and a MSEE from the University of Minnesota
Sponsor: PASS
Date: June 21st, 2011
Time: 3:00 PM – 5:00 PM
Location: 8300 Norman Center Drive, 9th Floor, Bloomington, MN 55437
Live Meeting:
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
Presentation:
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.
Mark will briefly review the topical coverage of the paper, including the formal definition of a relation. Mark 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.
The discussion will be led by Mark Knutson who began his career programming IBM mainframes. Mr. Knutson is now programming team lead and database administrator at Hennepin Faculty Associates (The doctors of Hennepin County Medical Center), presiding over a modest, but fully up to date, SQL Server system.
Presentation:
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.
Dan McCreary is a Minneapolis-based data consultant with a focus on helping organization use innovative technologies. Dan has over 25 years experience in the IT industry including working for Bell Labs and Steve Jobs at NeXT computer, and is an "invited expert" of the world-wide web consortium. Dan was the founder of Eagan-based Integrity Solutions which employed over 75 people before being sold to Vance Opperman’s KeyTech. Dan has also consulted for many Minnesota organizations including the CriMNet project, the BCA, the Department of Pubic Safety, the Department of Education, the Department of Revenue, Thrivent Financial and Syntactica. Dan is currently working on projects for the US Department of State, NueMeta and JPMorgan. He has a BA in Physics from Carleton College and a MSEE from the University of Minnesota
Date: May 17th
Time: 4:00 – 6:00
Location: 8300 Norman Center Drive, 9th Floor, Bloomington, MN 55437
Live Meeting:
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.
Date: April 19th, 2011
Time: 3:00 PM – 5:00 PM
Location: 8300 Norman Center Drive, Bloomington, MN 55437
RSVP Here
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
Live Meeting Info:
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:
On 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.
Date: March 15th, 2011
Time: 3:00 PM – 5:00 PM
Location: 8300 Norman Center Drive, Bloomington, MN 55437
Sponsor: Magenic
RSVP Here
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
Live Meeting Info:
Presentation: SQL Azure – Relational Data in the Cloud 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.
Date: March 15th, 2011
Time: 3:00 PM – 5:00 PM
Location: 8300 Norman Center Drive, Bloomington, MN 55437
Sponsor: Magenic
RSVP Here
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
Live Meeting Info:
Presentation:
SQL Azure – Relational Data in the Cloud
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.
Reminder – PASSMN Meeting today – 3 PM Today!
Location: 8300 Norman Center Drive, Bloomington, MN 55437
Sponsor: Digineer
RSVP Here
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
Live Meeting Info:
Presentation:
High Availability & DR Options for SQL Server
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.
|
|
