www.sqlpass.org    Professional Association for SQL Server

March 2011 - Andy Novick on Database Development

Topic:

Database Development With Visual Studio 2010

Date:

Tuesday, March 8, 2010 6:15

Location:

Great Bay Community College

Speaker:

Andy Novick, MVP
 

Andy Novick is a SQL Server MVP and consultant who builds business applications with SQL Server and the .Net technologies from Microsoft. Andy's writing includes the books Transact-SQL User Defined Functions and SQL Server 2000 XML Distilled as well as numerous web articles and web videos. You can read more at his web site www.NovickSoftware.com. When he’s not computing Andy enjoys coaching Youth Baseball and the occasional movie with his wife, Ulli.

Topic:

Database Development With

 

Database development has been a hodgepodge of ad hoc techniques from the beginning. The Visual Studio Database Professional Edition, a.k.a The Data Dude, gives us a new tool for developing and testing databases. Visual Studio 2010 is the third iteration of Data Dude technology and database development is no longer an exclusive product.

This presentation introduces database development with Visual Studio. This will demonstrate development of the schema, integration with source control, build processes, and development of Unit Tests. Testing databases has always been difficult and new techniques are now available to developers to build them and automate regression testing

 

Sponsor:

 

Alexander Technology Group

RSVP:

Please RSVP to the meeting so we can plan pizza and giveaways/raffles/etc. Send an e-mail to seacoastsql@straightpathsql.com to RSVP or sign up for meeting notices by e-mail.

 

November 2010

Topic:

Giving Back to Great Bay College

Date:

Tuesday, November 16, 2010 6:15

Location:

Great Bay Community College

Speaker:

Group Event - Paul Nielsen will be here also

 

Paul Nielsen, SQL Server MVP, Author, Blogger and Speaker was up in September to talk about some interesting (some would say crazy, but I liked them) database design concepts. He'll be here again to help out on the database design aspects of the college's project. He promised us to steer us towards an old fashioned Relational Database but we'll see what we come up with that works best.

Topic:

Working to help Great Bay With a Database Design & Application Need

 

The school does private trainings and corporate trainings in addition to their regular course offerings. They need a simple database and application that can track courses, faculty, clients and prospects (companies looking for corporate training and individuals looking to be trained). They would also like to explore the ability to track a couple other business opportunities - rentals of space, open enrollment classes (non credit courses like small engine repair), space rental (like our meeting!) and private corporate training. They hope to use this to track this information, track the scheduling of rooms and also to be able to pull financial reports, e-mail reports by interest, etc. for marketing and other operational reporting needs. Jennifer Scotland from the Business & Training office will be here on Tuesday to discuss some of the details on what she is hoping to see. She provided some more details of what she expects the tables to look like. If you request that info when you RSVP, I'll send it along to you in an e-mail.

 

We are fortunate to have them in our area and we are really fortunate to have this great space provided to the group for free. Now is our chance to give back, say thanks and learn as we work together and with a guru like Paul Nielsen!

 

Sponsor:

 

Alexander Technology Group

RSVP:

Please RSVP to the meeting so we can plan pizza and giveaways/raffles/etc. Send an e-mail to seacoastsql@straightpathsql.com to RSVP or sign up for meeting notices by e-mail.

 

September 2010

Topic:

eXtreme Database Design

Date:

Thursday, September 23, 2010 6:15

Location:

Great Bay Community College

Speaker:

Paul Nielsen

  Paul Nielsen, author of the SQL Server Bible series, believes SQL is the romance language of data. A data modeler and database developer, he’s worked with databases since 1981 and has been a Microsoft SQL Server MVP since 2004. As a consultant, Paul specializes in complex database designs (object-oriented, temporal, and abstract) and has worked in the financial, airline, manufacturing, insurance, non-profit, and research industries. Involved in the SQL Server community, Paul has several projects in www.CodePlex.com, including autoaudit, regularly presents at most SQL Server conferences, and was the lead editor of SQL Server MVP Deep Dives, in which 53 SQL Server MVPs contributed chapters with all author proceeds going to War Child International. You can read more at his website, www.SQLServerBible.com.

Topic:

eXtreme Database Design

 
This session pushes the data modeling envelope with research in applying object-oriented design to SQL Server, including class inheritance, domain classes with integrity, decorator classes for additional attributes, and transparent data overlays for data that changes from perspective to perspective. Also learn how to tackle another difficult database design involving temporal data—data that changes depending on the effective date of the query. This session assumes that you design SQL databases and that you want to see patterns that go beyond the traditional one-to-many relational database, but that you still value data integrity and normal SQL querying.

Sponsor:

Alexander Technology Group

RSVP:

Please RSVP to the meeting so we can plan pizza and giveaways/raffles/etc. Send an e-mail to seacoastsql@straightpathsql.com to RSVP or sign up for meeting notices by e-mail.

 

August 2010

Topic:

What Are You Waiting For?

Date:

Tuesday, August 10, 2010 6:15

Location:

Great Bay Community College

Speaker:

Thomas LaRock

 
Thomas LaRock  is a seasoned IT professional with over a decade of technical and management experience. Currently serving as a Senior DBA for Confio Software, Thomas has progressed through several roles in his career including programmer, analyst, and DBA. Thomas holds a MS degree in Mathematics from Washington State University and is a member of the Usability Professional’s Association. Thomas currently serves on the Board of Directors for the Professional Association for SQL Server (PASS), and is also a SQL Server MVP. Thomas can also be found blogging at http://thomaslarock.com and is the author of DBA Survivor: Become a Rock Star DBA (http://dbasurvivor.com).

Topic:

What Are You Waiting For?

 
It’s a simple question, right? But how often do you have the answer, especially for your SQL statements? Thomas LaRock  from Confio Software will teach you how proper response time analysis plays a key part in the overall performance tuning process. You will learn how to define, measure, and analyze performance issues as well as implementing changes and how to make sure those changes continue to have the desired effects.

Sponsor:

Confio Software

RSVP:

Please RSVP to the meeting so we can plan pizza and giveaways/raffles/etc. Send an e-mail to seacoastsql@straightpathsql.com to RSVP or sign up for meeting notices by e-mail.

 

July 2010

Topic:

As a DBA, Where Do I Start?

Date:

Tuesday, July 13, 2010 6:15

Location:

Great Bay Community College

Speaker:

Mike Walsh

 
Mike is the President and co-founder of the Seacoast SQL Server User Group. He has been working with SQL Server for over 10 years in many roles but always leans on his DBA experience. Mike currently works full time as a SQL Server DBA/Engineer for EBSCO Publishing in Ipswich, MA. He consults part time on a limited basis helping with "fun" performance challenges or Database Administration troubleshooting. He has shared presentations at a few regional events, volunteers with the Professional Association of SQL Server users and tries to give back to the SQL community in various ways.

Topic:

As a DBA, Where Do I start?

 


Help! I’m a new DBA, Where Do I Start?!  You've always wanted to get into the DBA position. The good news is you got it - the bad news is you have no idea what to do first. What's important, what's not a big deal, and what can get you fired if you're not careful? If your answer wasn’t, “update my resume”, then this session is a good start. We’ll chat about a natural priority for the overwhelming flood waiting in our offices. By focusing on a few words ending in “ity” we’ll realize what is most important. Through the interaction, examples and demos you’ll leave feeling ready to attack your environment. Be warned – along the way to knowing where to start, you may get that feeling in your stomach that makes you logon to the VPN to check a few things out.

This session is great for new DBAs, DBAs starting out at a new company, Developers wanting to know what makes a DBA tick or those unfortunate system administrators playing the role of "accidental" DBA.

Sponsor:

TBD

RSVP:

Please RSVP to the meeting so we can plan pizza and giveaways/raffles/etc. Send an e-mail to seacoastsql@straightpathsql.com to RSVP or sign up for meeting notices by e-mail.

 

June 2010

Topic:

Profiling: It's Okay in SQL Server

Date:

Tuesday, June 8, 2010 6:15

Location:

Great Bay Community College

Speaker:

Jack Corbett

 
Jack is a SQL Server professional currently serving with New Tribes Mission in Sanford, FL. Jack has been working with SQL Server for over 10 years and has worked with versions 6.5 to 2008. Jack is active in the SQL Server Community as co-President of OPASS, a member of the 2010 PASS Summit Program Committee, and has spoken at several user groups and SQLSaturdays. Jack also blogs regularly about SQL Server and the SQL Server Community at http://wiseman-wiseguy.blogspot.com

Topic:

Profiling: It's Okay in SQL Server

 

Learn how to use SQL Server Profiler/Trace to troubleshoot SQL Server performance and errors. This session will cover how to use Profiler to capture SQL Server events, creating server-side traces, creating custom templates, saving trace data, and interpreting trace data.

Sponsor:

TBD

RSVP:

Please RSVP to the meeting so we can plan pizza and giveaways/raffles/etc. Send an e-mail to seacoastsql@straightpathsql.com to RSVP or sign up for meeting notices by e-mail.

 

May 2010

Topic:

ETL Patterns And Practices

Date:

Tuesday, May 4, 2010 6:15

Location:

Great Bay Community College

Speaker:

Larry Barnes

 

Larry Barnes is the founder of Stonemeadow Solutions and has been working with SQL Server since 1.0 first shipped in 1989. Larry has been a developer, architect, consultant, standards committee member, practice director and fellow during his 30+ years in the industry.

Larry joined Microsoft in 1995, was the BI Director for the New England District and co-founded the popular “Bob and Larry” seminar series. He moved to Avanade, Microsoft’s joint venture with Accenture, in 2000 where he founded Avanade’s Global BI Practice. Larry’s last role at Avanade was BI fellow where his responsibilities included BI solutions, Strategic engagements and analyst/press communications.

Prior to Microsoft, Larry was a Principal at Working Set Inc, a consulting firm focused on database solutions. Larry developed SQL Services, DEC’s first client/server database interface and was a founding member of the ODBC standard’s committee.

Larry has published multiple books and articles on SQL Server, has presented at many Microsoft conferences. His current focus areas are the Microsoft BI stack, ETL Frameworks and Master Data Management.

Topic:

ETL Patterns And Practices

 

Dimensions, Facts, SCD I, SCD II…sometimes the terms get in the way of simple concepts. The failure to recognize these concepts results in different implementations for what is a basic set of ETL patterns. In this session we start by introducing an ETL Framework and the best practices and patterns used to reduce your ETL TCO. We introduce standard Data warehousing data modeling constructs, map them to core set of ETL patterns and review a set of SSIS ETL Framework compliant templates that implements each pattern. We’ll finish off by demonstrating an SSIS code generator that uses Active Metadata to generate these templates.

Sponsor:

TBD

RSVP:

Please RSVP to the meeting so we can plan pizza and giveaways/raffles/etc. Send an e-mail to seacoastsql@straightpathsql.com to RSVP or sign up for meeting notices by e-mail.

 

April 2010

Topic:       

Understanding Execution Plans

 

 Date:

 

Tuesday, April 13, 2010 6:00PM

 

 

Speaker:

 

 

 

 

Grant Fritchey

Grant Fritchey, SQL Server MVP, works for an industry-leading engineering and insurance company as a DBA. He’s done development of apps in languages such as Visual Basic, C#, and Java, and has worked with SQL Server since version 6.0. Grant spends a lot of time involved in the SQL Server community, including speaking, blogging, and he is an active participant in the SQLServerCentral.Com forums. He is the author of SQL Server Execution Plans, and SQL Server 2008 Query Performance Tuning Distilled.

Location:

Great Bay Community College

Overview:

 

 

 

 

 

 

 

 

 

 

Sponsor:

Attendees will be introduced to the wealth of data contained within the execution plans generated by SQL Server. From the simplest "SELECT *" query to complicated joins, the icons and properties that allow you to understand what is occurring within your query will be explained. You will leave knowing what kinds of execution plans you have available and what they can be used for. You'll learn about graphical execution plans; what do the icons mean and how are they related; how much information is available and how to access and interpret it. All this information will be used to help you understand what's happening within your queries so that you can identify and fix poor performance in your own environment.

 

Attunity - Attunity provides real-time data integration and event capture software that enables seamless access and delivery of data across heterogeneous sources. A pioneer in federated data access and real-time change-data-capture (CDC) technologies, Attunity’s software has been deployed at thousands of organizations worldwide and is the choice of partners including Microsoft, Oracle, IBM, and HP.

October 2010 Meeting

Topic:

SSIS Design Patterns

Date:

Tuesday, October 5, 2010 6:15

Location:

Great Bay Community College

Speaker:

Andy Leonard

 

Andy Leonard is an architect with Molina Medicaid Solutions, a SQL Server database and Integration Services developer, a SQL Server MVP, a PASS Regional Mentor, and an engineer. Andy is co-author of Professional SQL Server 2005 Integration Services and SQL Server MVP Deep Dives, and regularly blogs for SQLBlog.com. His background includes web application architecture and development, VB, and ASP; SQL Server Integration Services (SSIS); and data warehouse development using SQL Server 2000, 2005 and 2008.

Topic:

SSIS Design Patterns

  This session is normally for experienced SSIS developers but Andy will cover topics that will help us all. Attend and learn the Parent-Child SSIS design pattern, how
to leverage less-than-well-documented characteristics of SSIS to centralize logging, and how to pass variable
values between parent and child packages by value and by reference. Incremental loads and performance topics will be touched as well.

Sponsor:

Alexander Technology Group

RSVP:

Please RSVP to the meeting so we can plan pizza and giveaways/raffles/etc. Send an e-mail to seacoastsql@straightpathsql.com to RSVP or sign up for meeting notices by e-mail.

 

Seacoast SQL Server Users Group

The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. From local user groups and special interest groups (SIGs) to webcasts and the annual PASS Community Summit � the largest gathering of SQL Server professionals in the world � PASS enables knowledge sharing, in-depth learning, access to the Microsoft SQL Server team, and the ability to influence the direction of SQL Server technologies. PASS was founded in 1999 by Microsoft and CA and continues to enjoy executive level endorsement from both organizations. As the number one user community for Microsoft SQL Server, Microsoft looks to the PASS community for valued feedback, input, and inspiration. PASS Mission Empower the global Microsoft SQL Server community to connect, share, learn and be inspired through networking, knowledge sharing, peer-based learning, and the ability to influence the direction of Microsoft SQL Server products and services.

Seacoast SQL Sponsors



 

PASS Sponsors

sql_micro_sm.gif 

sql_ca_sm.gif 

     
cage-aids
cage-aids
cage-aids
cage-aids