Philadelphia SQL Server User Group

September 2010 Meeting

                                                     September Phila SQL Server Users Group (PSSUG) Meeting

 
                                                Location:  Microsoft Malvern Office
45 Liberty Blvd
Malvern, PA

Wednesday, September 8th, 5:30 - 8:30pm
 
 
 
 Part 1 of 2 meeting focusing in on R2.
 
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SWAG Giveaways will be from PASS and Microsoft:   $50 Gift Card, Books, software, etc, etc...    
 
 
Our Meeting Sponsor:  Professional Association of SQL Server (PASS) (www.sqlpass.org) .    
 
 ----------
 
1st Session Presenter -  Muthu Ramanathan and Ravi (DBA) from Merrill Lynch - Concurency and performance in SQL Server.   Session will focus on real life experience focusing on locking behaviors and partitioning technique dealing with high concurrency applications.
 
 ----------
Keynote Speaker:   Muthu Ramanathan  (Microsoft Dedicated Support Engineer) - Overview of the new features and capabilities of SQL Server 2008 R2
 
Abstract:    Introduction and overview of the new and updated features and capabilities in the R2 release for SQL Server 2008.   This session is a 100/200 level session.   
 
These are the topics that would be covered.
    Trusted, Scalable platform
     IT & Developer Efficiency
     Self-Service Business Intelligence
     New Editions of SQL
 
Introduction to these features will be done.
1.      Complex Event Processing
2.      Application and multi-server management
3.      Sysprep
4.      Parallel Data Warehouse
5.      Master Data services
6.      Other R2 enhancements
7.      The presenters highlight feature.
 
BIO:  
Muthu Ramanathan is a Dedicated SQL Engineer @ Microsoft, currently onsite as a DSE with one of the leading investment banks in NJ. I have been with Microsoft for little under 3 years, dealing with Microsoft’s Premier customers and acting as a trusted advisor.
 
I have been working with SQL Server since version 4.2, when SQL shared very similar characteristics as Sybase. Right from my college days, I had the passion for Databases. My final college project of showcase is a prototype RDBMS that I built using “file locking” mechanism. Though it had some concurrency restrictions, the product is still in production in a small manufacturing industry.
 
My quest for databases leads me to explore DB2 on the Mainframe for a few years writing JCL and REXX systems programming. Then moved on to the open systems working for an Oracle VAR deploying the Oracle systems for various financial clients.
 
Strong passion for computers right from high school and deep interest in Operating systems & finance enlightened the path towards integrating business and technology.  Spent more than a decade’s time in corporate America, working for some prestigious financial clients, has definitely been a very interesting learning experience.  Contributing something back to the database world, will take me one step closer to fulfilling my dreams.
 
Some of my current projects include testing SQL 11 features, Parallel Data Warehouse (PDW) and tuning Oracle / ERP applications running on SQL Server.
 

August 2010 Meeting

August Phila SQL Server Users Group (PSSUG) Meeting
 
                                    Location:  Microsoft Malvern Office
45 Liberty Blvd
Malvern, PA

Wednesday, August 11th, 5:30 - 8:30pm
 
 
 
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SWAG Giveaways:   1 Xbox game, Books, software, etc, etc...    
 
 
Our Meeting Sponsor:  TEK Systems (www.TEKSystems.com)
 
Company Profile:   TEKsystems is the nation's largest IT staffing firm- ranked # 1 in the industry for its eighth consecutive year by an independent review run by IT Services Business Report!  TEKsystems is a member of Allegis Group, a privately held network of staffing and services companies. Allegis Group companies provide recruiting and staffing services to more than 9 out of every 10 Fortune 100 companies.  We offer the market's finest IT and communications talent specializing in:

- APPLICATIONS Staffing Services - We supply the skilled applications professionals you need for all phases of the software development life cycle.
- INFRASTRUCTURE Staffing Services - Whether you need assistance maintaining or supporting your network, need help with hardware installations, or simply need temporary help desk support, our contract employees are highly skilled in all areas of IT infrastructure.
- COMMUNICATIONS Staffing Services - Our employees are experienced and specialized in all facets of communications technology, including wireless, landline, broadband cable technology, and enterprise support.
 
 
1st Session Presenter -  Joe D'Antoni -  Configuring and Using Master Data Warehouse (MDW)
 
Abstract:  Joe will demonstrate how to setup management data warehouse, and how to use the reports within.
 
BIO:   Joe is a frequent speaker at PSSUG. He is a DBA with 10 years of experience and is currently a database engineer at Synthes in West Chester.
 
 
Keynote Speaker:   Meir Dudai  (SQL Server MVP) - The magic of replication: What’s new in SQL Server 2008 Replication?  
 
Abstract: Many organizations require challenging scalability and high availability solutions for database implementations. Replication in SQL Server 2008 is one of the most powerful tools: Peer-to-Peer, transactional and merge replication are now robust technologies that every DBA and system architect should be aware of. In the session, we will reveal the new replication features in SQL Server 2008. We will then demonstrate some real-life scenarios in which replication can provide an optimal solution for the business’s requirements.
 
 
BIO:   Meir Dudai is an MVP, involved in SQL Server projects since 1998. His background includes working as a senior consultant for SQL Server as a partner of Microsoft MCS. He is also the editor of SQLServer.co.il - the Israeli Portal for SQL Server DBAs and developers. Meir’s specialty is SQL Server Replication, which is his favorite feature in SQL Server. Meir is a regular speaker at various conferences and user group meetings, such as Microsoft Developer Academy, Teched and PASS Summit.

 

 

    October Phila SQL Server Users Group (PSSUG) Meeting
 
                                             Location:  Microsoft Malvern Office
    45 Liberty Blvd
Malvern, PA

Wednesday, October 13th, 5:30 - 8:30pm
 
 
 
Part 2 of 2 meeting focusing in on R2.
 
 
 
 
Meeting Agenda
SetFocus talk                                                               - drawing for MSDN License at 6pm           5:30-6:00
Kevin Goff (SQL MVP)                                               - SSRS 2008 R2                                                6:00-7:15
Muthu Ramanathan (Microsoft support Engineer) - SQL 2008 R2 Parallel Data warehouse      7:15-8:30+   
   (Note: We may have to move into the Atrium for the QA segment for Muthu's talk if we have to vacate the meeting room at 8:30)   
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SWAG Giveaways will be from SetFocus  - !!!! Important to note / Giveaway !!!
SetFocus will be giving away 1 free MSDN voucher, good for a free subscription, but you have to be there at 5:30 for the full talk to qualify for the drawing at 6:00 for it.    
 
Our Meeting Sponsor:  SetFocus.    
As a Microsoft Gold Certified Partner, SetFocus specializes in providing an in-depth hands-on training and career development/placement in .NET, SharePoint, SQL Server and MS Business Intelligence.   Since 1997, nearly 2000 SetFocus alumni have found rewarding careers as Programmers, Software Developers, Business Analysts, DBAs and other positions using Microsoft technologies.  SetFocus has ranked among Inc. 5000 Fastest Growing Companies in America for the past four years and has been received the Platinum Award in 2009 and 2010 for New Jersey’s Smartest Workplaces.
 --------------------------
 
 
Sponsor Presenter and 1st Session Presenter -  Kevin Goff
- SetFocus talk
- Cool Reporting Features in SQL 2008 R2.
 
Abstract:  In this presentation, I'll show about a half-dozen different report examples in SSRS 2008R2. Each report demonstrates different features in SSRS 2008R2 that are sure to please different business users. These new features include sales heat maps, sparklines, performance gauges, better page control, uses for the Tablix control, better charting, and new features for SharePoint 2010 integration.
Bio:  2010 SQL Server MVP 2005-2008 NET/C# MVP SQL Server/Business Intelligence senior instructor and courseware author - SetFocus, LLC Columnist for CoDe Magazine (Baker's Dozen Productivity Series)
----------
 
Keynote Speaker:   Muthu Ramanathan  (Microsoft Dedicated Support Engineer) - Parallel database in SQL Server 2008 R2
 
Abstract:   TBD 
 
BIO:    
Muthu Ramanathan is a Dedicated SQL Engineer @ Microsoft, currently onsite as a DSE with one of the leading investment banks in NJ. I have been with Microsoft for little under 3 years, dealing with Microsoft’s Premier customers and acting as a trusted advisor.
 
I have been working with SQL Server since version 4.2, when SQL shared very similar characteristics as Sybase. Right from my college days, I had the passion for Databases. My final college project of showcase is a prototype RDBMS that I built using “file locking” mechanism. Though it had some concurrency restrictions, the product is still in production in a small manufacturing industry.
 
My quest for databases leads me to explore DB2 on the Mainframe for a few years writing JCL and REXX systems programming. Then moved on to the open systems working for an Oracle VAR deploying the Oracle systems for various financial clients.
 
Strong passion for computers right from high school and deep interest in Operating systems & finance enlightened the path towards integrating business and technology.  Spent more than a decade’s time in corporate America, working for some prestigious financial clients, has definitely been a very interesting learning experience.  Contributing something back to the database world, will take me one step closer to fulfilling my dreams.
 
Some of my current projects include testing SQL 11 features, Parallel Data Warehouse (PDW) and tuning Oracle / ERP applications running on SQL Server.

 

                      November Phila SQL Server Users Group (PSSUG) Meeting
 
      Location:  Microsoft Malvern Office
45 Liberty Blvd
Malvern, PA
 
 Wednesday, November 10th, 5:30 - 8:30pm     
*   
*   
*
* Our Sponsor for November is  Liberty Personnel Services
*
Company Bio: 
Liberty Personnel Services, Inc. is a partnership, formed by recruiters throughout the region, with the guiding principles of professionalism, integrity and efficiency. We are committed to building long term relationships with our clients, job seekers, and our own employees. We are in the people business and believe that it is essential to be professional and fair with each person we work with.

Our clients include Fortune 500 companies and small corporations. They range from start up companies to companies over 100 years old. Companies use our services to find employees in many fields including, but not limited to: Information Technology, Engineering, Accounting / Finance, Architecture, Pharmaceutical, Clinical Research, Scientific, Medical Communications and Education, Manufacturing, and Administrative.
Liberty Personnel Services, Inc. is located at 410 Feheley Drive, King of Prussia, PA 19406 and their main phone number is 484-567-2098.
*
*
1st Session Speaker:    Said Salomon  - "Working with Service Broker" 
*
Abstract:    TBD
*
*
Bio:  Said Salomon has over 25 year experience as an Information Technology Professional.  I have a vast array of abilities in the field in the areas of: Network, Desktop Support, DBA, Staff Project Management, Application Software Development, Business Analysis and Quality Assurance.   Said carries Microsoft certifications as a MCTS, MCPS, and MCNPS, and multiple certifications from the Insurance Institute of America.   
*
*                                                                     
 
*
Keynote Session:   Joe Toscano - "SQL Server 2008 Partitioning:  Implementing a realistic sliding window"  
*
Abstract In this session Joe will first discuss the benefits and requirements of table partitioning in SQL 2008 and then go through the planning and implementation steps of partitioning an 11 million row sample table.  Once complete, we will then review in detail our sliding window requirements and see exactly how the partitioning toolbox commands (Split, Merge & Switch) can be used to implement our scenario.  You will get to see the actual partitioning code and the sliding window code.  No prior table partitioning experience is assumed.
*
Speaker Bio: Joe Toscano is an independent contractor who has been working with SQL Server since version 6.5 as a consultant, DBA, ETL Specialist, DW Architect, instructor and mentor.   Over the last few years he has focused on Business Intelligence projects leveraging the SQL Server BI stack, but has continued to work on SQL Development and SQL Administration projects. Joe has presented at numerous events including PASS, PSSUG and SQL Saturdays and has taught SQL Server classes for several Microsoft Partners along with Learning Tree International.   He thoroughly enjoy teaching and lecturing about various SQL Server topics. 
*
*
 

PSSUG Online Live Meeting Workshop Series

Date/Time:  Monday 10/18 at 6pm 

System Tables part 1

Presenters:  Jyotsna Sankuratri and Alex Grinberg

Please Join Jyotsna and Alex for a deep dive on System Tables.  Part 1 of 2.

Click here for Live Meeting Info

November Phila SQL Server Users Group (PSSUG) Meeting
 
Location:Microsoft Malvern Office
45 Liberty Blvd
Malvern, PA
 
Wednesday,November 10th, 5:30 - 8:30pm
*
*
*
*
* Our Sponsor for November is Liberty Personnel Services
*
Company Bio:
Liberty Personnel Services, Inc. is a partnership, formed by recruiters throughout the region, with the guiding principles of professionalism, integrity and efficiency. We are committed to building long term relationships with our clients, job seekers, and our own employees. We are in the people business and believe that it is essential to be professional and fair with each person we work with.

Our clients include Fortune 500 companies and small corporations. They range from start up companies to companies over 100 years old. Companies use our services to find employees in many fields including, but not limited to: Information Technology, Engineering, Accounting / Finance, Architecture, Pharmaceutical, Clinical Research, Scientific, Medical Communications and Education, Manufacturing, and Administrative.
Liberty Personnel Services, Inc. is located at 410 Feheley Drive, King of Prussia, PA 19406 and their main phone number is 484-567-2098.
*
*
1st SessionSpeaker: Said Salomon - "Working with Service Broker"
*
Abstract:TBD
*
*
Bio:Said Salomon has over 25 year experience as an Information Technology Professional. I have a vast array of abilities in the field in the areas of: Network, Desktop Support, DBA, Staff Project Management, Application Software Development, Business Analysis and Quality Assurance. Said carries Microsoft certifications as a MCTS, MCPS, and MCNPS, and multiple certifications from the Insurance Institute of America.
*
 
*
KeynoteSession:Joe Toscano -"SQL Server 2008 Partitioning: Implementing a realistic sliding window"
*
Abstract:In this session Joe will first discuss the benefits and requirements of table partitioning in SQL 2008 and then go through the planning and implementation steps of partitioning an 11 million row sample table. Once complete, we will then review in detail our sliding window requirements and see exactly how the partitioning toolbox commands (Split, Merge & Switch) can be used to implement our scenario. You will get to see the actual partitioning code and the sliding window code. No prior table partitioning experience is assumed.
*
Speaker Bio:Joe Toscano is an independent contractor who has been working with SQL Server since version 6.5 as a consultant, DBA, ETL Specialist, DW Architect, instructor and mentor. Over the last few years he has focused on Business Intelligence projects leveraging the SQL Server BI stack, but has continued to work on SQL Development and SQL Administration projects. Joe has presented at numerous events including PASS, PSSUG and SQL Saturdays and has taught SQL Server classes for several Microsoft Partners along with Learning Tree International. He thoroughly enjoy teaching and lecturing about various SQL Server topics.
*
*

 

    December Phila SQL Server Users Group (PSSUG) Meeting
                                                Location:  Microsoft Malvern Office
45 Liberty Blvd
Malvern, PA
 
 Wednesday, December 8th, 5:30 - 8:30pm     
*   
*
Our Sponsor for December is  SQL Sentry (www.sqlsentry.com)
 *
*
Vendor Session:   Peter Shire (SQL Sentry) - "SQL Sentry v5.5"
*
Peter will be covering SQK Sentry v5.5 for us.  This will be a virtual session format.  
*  
Performance Advisor
  • The Performance Advisor Global View provides a master list of performance metrics across all servers in your environment in one view, including Windows, SQL Server and SSAS metrics.
  • Performance Reporting, including global server performance, wait stats analysis, disk and database space, custom counter history, counter date range comparison reports, and more.
  • Automatic Disk Misalignment detection.
  • NTFS Mount Points are now displayed in the disk views.
 
General
  • SQL Sentry Server service threading optimizations to reduce memory footprint, and minimize possibility of collection delays affecting chaining, alerting, etc.
  • Reduced plan cache footprint for the SQL Sentry repository database.
  • Redesigned console alert notifications.
  • Redesigned wizards that have resize support.
  • Updated grids throughout.
To get anevaluation license of v5.5, simply go to http://sqlsentry.net/download-trial/trial.asp and complete the registration form.  Please contact support@sqlsentry.net if you would like an online demo or if you have any technical questions about the new version.
*
*
*
Keynote Sessions
 
1st Speaker:    Joe D'Antoni - "Deploying Data Tier Applications with VS 2010 and SQL Server 2008 R2" 
*
Abstract:    TBD
Bio:    Joe is a SQL Saturday presenter and presented recently at SQL Saturday NYC in November, and is a frequent speaker speaker at PSSUG.    He is a DBA with 10 years experience and a currently works as a database engineer with Synthes in West Chester.
*
*          
2nd Speaker:    Vince Napoli - "Analysis Services 101 and Dimension Keys and Attribute Relations" 
*
Abstract:    This session will step us through in how to create an Analysis Services cube from a Relational data source, and focus in Dimensions and creating and managing Dimension Keys and Dimension Attribute relations to support performance.        
Bio:  Vince is a Business Intelligence Architect with Anexinet in Blue Bell, and until recently, a BI Architect and Enterprise Architect at IMS.   He has worked with Data warehousing and business intelligence since 1996, with a focus and specialty on SQL Sever since 1999, and an BI Architect since 2001.   Vince is a frequent presenter at PSSUG, and has been a SQL Saturday and Code camp presenter in the philadelphia area.    
*                                                                                      
 
 
     January South Jersey SQL Server Meeting
 
          Location: Haddon Heights Public Library
608 Station Ave
Haddon Heights, NJ 08035

Tuesday, January 25, 5:30 - 8:30pm     
*   
*   
*   
* Our Sponsor for January is Worlco Computer Resources (www.worlco.com) providing swag and pizza for the meeting.    Compliments of:  

 

Gerry Lavine, Senior Partner

Worlco Computer Resources, Inc.

856-665-4700  x117

lavine@worlco.com

 

 

Meeting content  

-------------------------------------------------------------------------------------

Session Speakers

1) Bharat Kenjale - MS SQL Server: Knowing Tempdb

 

2) Mark Kromer (Microsoft) 

- SQL 11 Denali primary new features to look for by

- SQL Server 2008 R2 database monitoring tools by Mark Kromer of Microsoft

- High Availability in SQL Server 2008 R2 by Mark Kromer of Microsoft

 

 

------------------------------------------------------------------------------------- 

South Jersey Board Meeting to follow at end of meeting

- After the main meeting, the group’s board will get together for a short meeting to discuss future meetings.

- We can use additional help and anyone would is willing to volunteer is encouraged to join us.

- If someone is willing to help and cannot attend this meeting, just let us know…

 

February Phila SQL Server Users Group (PSSUG) Meeting
 
                                                Location:  Microsoft Malvern Office
45 Liberty Blvd
Malvern, PA

Wednesday, Feb 9th, 5:30 - 8:30pm     
*   
*   
*
 
 
Our Sponsor for February is:  Turnberry Solutions (www.turnberrysolutions.com)

Turnberry Solutions is an IT Professional Services firm with a proven track record of delivering large-scale Portal, Business Process Management (BPM), and Software Integration projects. Over the past decade, we have assembled a team of experienced engineers and project managers to provide services in the following areas:

  • Business and IT Strategy
  • Requirements Analysis and Project Management
  • Software Architecture, Design, and Development
  • Quality Assurance and Operational Support 
  
Meeting Sessions: 
 
1) Tour of new Technology Center (MTC) at Microsoft Malvern office
*
SQL Server and BI are two of our most prominent solutions available in our envisioning center.
*
Overview and tour by SQL Server lead from the MTC (Bill Emmert), who has over 10 years @ Microsoft in MCS and the SQLCAT team, kick-off the Feb 9th PSSUG with a brief intro presentation and then we all take the new steps downstairs to tour the MTC.
 
*
*
2) Keynote Speaker:  John Peterson -- Testing your Stored Procedures 
*
Abstract: 
Testing is an integral part of software development, and just about every software development project interacts with a database. While we create test fixtures for class methods, stored procedures are often overlooked. In this session, John will demonstrate how popular testing frameworks like nUnit and mSpec can be used to test your SQL Server Stored Procedures.
 
*
Bio:  I've been developing software for 20 years, starting with dBase, Clipper and FoxBase + thereafter, migrating to FoxPro and Visual FoxPro and Visual Basic. Other areas of concentration include Oracle and SQL Server - versions 6-2008.
 
From 1995 to 2001, I was a Microsoft Visual FoxPro MVP. Today, my emphasis is on ASP MVC .NET applications. I am a current Microsoft ASP .NET MVP.
 

Publishing

In 1999, I wrote the definitive whitepaper on ADO for VFP Developers. In 2002, I wrote the Absolute Beginner’s Guide to Databases for Que Publishing.
 
I was a co-author of Visual FoxPro Enterprise Development from Prima Publishing with Rod Paddock, Ron Talmadge and Eric Ranft. I was also a co-author of Visual Basic Web Development from Prima
 
Publishing with Rod Paddock and Richard Campbell.Education- B.S Business Administration – Mansfield University

- M.B.A. – Information Systems – Saint Joseph’s University
- J.D. – Rutgers University School of Law (Camden)In 2004, I graduated from the Rutgers University School of Law with a Juris Doctor Degree. I passed the Pennsylvania and New Jersey Bar exams and was in private practice for several years – concentrating transactional and general business law (contracts, copyrights, trademarks, independent contractor agreements, NDA’s, intellectual property and mergers and aquisitions.).
 

 --------------------------------------------------------------------------------------- 

SQL Saturday Planning Meeting (after regular meeting) at 9pm
There will be post meeting at the Ruby Tuesday at US202 and Rt 29 for the SQL Saturday planning committee.   If will be from 9pm-10pm to go over current planning activities for the SQL Saturday on March 5th at DeVry University.   All are welcome to attend.  
 
 

 

                  April Phila SQL Server Users Group (PSSUG) Meeting  
                                                Location:  Microsoft Malvern Office
45 Liberty Blvd
Malvern, PA

Wednesday, April 13th, 5:30 - 8:30pm     

 

 

*
Our Sponsor for April is:  Wolco Computer Resources  (http://www.worlco.com/)

Worlco is a Total Information Systems staffing organization founded in 1982. Our company specializes in Permanent Placement, Contract Consulting and Customized Staffing Solutions for Information Technology organizations and the technical pre-screening of the employment marketplace on behalf of the candidates we represent.  The company provides a full range of services relating to the computer industry. Through our business partners/affiliates, we are able to present a selection of qualified candidates when a client is interested in relocating individuals for specialized positions. The Worlco corporate offices are located in Cherry Hill, NJ.  

*

Meeting Sessions: 
1st Session:   Sebastian Miene - "Concurrency Control"
*
Abstract:   This is an encore presentation of Sebastian's SQL Saturday session.  This session will explain the different transaction isolation levels that SQL Server provides. You will see examples of different locking and blocking behaviors and you will gain insight into how the transaction isolation level affect query concurrency and performance.
*
Bio:  Sebastian Meine, PhD is a principal trainer and consultant with sqlity.net llc (http://sqlity.net). He specializes in T-SQL performance and SQL-TDD and shares his passion and knowledge regularly with audiences world-wide.
*
*
Keynote Speaker:  Steve Ranker 
Presenting "Enterprise BI ETL Archetecture and Development with SQL Server 2008 and Integration Services"
*
*
Abstract: 
Creating Dimensions -- The Member Table and Recurssive SQL with Common Table Expresions Child Parents Hierarchies -- Ragid Structures Loading Facts -- SQL Analytic Functions Time -- YYYYMMDD Maintaining Dimensions -- Approaches to Slow Change Putting Dimensions on Facts -- Ordering Events,Partition Switching, and Rollback Tall and Wide -- What's with the Pivot?  
* 

 

Bio:   Steve is a senior Business Intelligence consultant for Anexinet with a specialty Microsoft SQL Server BI product line.  
*

 

 

     April South Jersey SQL Server Meeting
 
          Location: Haddon Heights Public Library
608 Station Ave
Haddon Heights, NJ 08035

Tuesday, April 26, 5:30 - 8:30pm     
*   
*   
*   
Our Sponsor for April is DMI (www.dmipartners.com).
 
Sponosr Profile
Founded in 2003, DMi Partners is a Performance Marketing Agency that
delivers real, tangible results for clients through the development
and implementation of digital marketing programs. Whether you are an
college or university looking to maximize your recruitment strategy, a
financial services firm seeking a stronger link with customers and
prospects, or any other business that thrives on qualified leads, DMi
Partners can help you increase the productivity of your
digital
marketing program
, drive growth and build your bottom line.
*

Meeting content  

-------------------------------------------------------------------------------

Speakers

Sebastian Meine and Dennis Lloyd - "TDD – Thwarting Database Defects"

Abstract:  They will start with an "encore" of the subject, but if the audience is already familiar with the topic, they will move directly to a more advanced discussion.  Had questions from SQL Saturday?  Now's your chance to really dig deeper and hone your skills.   

*

TDD - It’s bad enough to spend hours finding and fixing database defects, explaining to the rest of the team what went wrong and trying to clean up the mess. It’s even worse when a defect causes the end-user to make a bad decision. Database defects are far too costly and most testing practices do not adequately detect or prevent them. This presentation introduces tSQLt, a framework for automated database unit testing. You’ll learn techniques to write SQL code that is resilient to defects and is easier to change and maintain.
*

 

Bio:  Sebastian Meine, PhD is a principal trainer and consultant with sqlity.net llc (http://sqlity.net). He specializes in T-SQL performance and SQL-TDD and shares his passion and knowledge regularly with audiences world-wide. If you want to get Dennis talking, ask him about database quality and testing. He enjoys sharing his experiences about software development, databases, agile practices and bioinformatics. You can find out more about what he’s up to at: http://curiouslycorrect.com
*
*

               

  May Phila SQL Server Users Group (PSSUG) Meeting

 
         Location: Teletorium at Mandeville Hall
St. Joseph's University
5600 City Ave
Philadelphia, PA 19131

                                                                     

 

 


Wednesday, May 11th, 5:30 - 8:30pm     
*   
*  
Brought to you by:
Masters of BI program at SJU (http://www.sju.edu/academics/hsb/grad/msbi/)  
and Philadelphia SQL Server Users Group (www.pssug.org).   
*
*
*
*
Our Sponsor for January is: Anexinet Solutions (www.anexinet.com)
Anexinet is an award-winning systems integrator and technology management company located in Blue Bell, PA.  Anexinet is an innovator in aligning IT with business goals, specializing in Application Solutions, Business Intelligence & Data Solutions, and Infrastructure Solutions, providing services throughout Northeast and Mid-Atlantic regions.  Check out www.anexinet.com for you solution needs.
*
*
Keynote Sessions  
 
1st Session Speaker:    Vince Napoli - Tips and Tricks, SSIS 64 bit considerations
*
Abstract:    Short Seesion on Tips and Tricks in using SSIS in a 64 bit environment.   As 64 bit becomes more prevalent from servers to laptops, we will look at what product restrictions are in effect on SSIS for a 64 bit environment.   We will learn and see how to get our friend, Excel, to work from a SSIS package with BIDS, DTEXEC, and SQL Server Agent.  
Bio:  Vince is a Business Intelligence Architect with Anexinet in Blue Bell, and until recently, a BI Architect and Enterprise Architect at IMS.   He has worked with Data warehousing and business intelligence since 1996, with a focus and specialty on SQL Sever since 1999, and an BI Architect since 2001.   Vince is a frequent presenter at PSSUG, and has been a SQL Saturday and Code camp presenter in the philadelphia area.    
*
*
*          
Spotlight session:    Ira Yermish, Ph.D.   - “In the Beginning, there were just Transactions …”
*
*
Abstract:    In this presentation, Dr. Ira Yermish will provide a personal retrospective of the growth of the data warehouse highlighting a number of his experiences in developing applications that were precursors of the modern data warehouse. He will review some of the issues of organizational development that prevented early acceptance of decision support systems based on aggregated data and that still create barriers to the adoption of modern, data warehouse based tools. Through the review of a number of case studies in which he was an active participant, Dr. Yermish will help data professionals better understand the organizational and strategic concepts that often prevent the most productive use of the data and information buried in the bowels of mass storage. Finally, he will give a short description of the MS in Business Intelligence program and how it might provide some of the missing links described in his talk.
 
Bio:  Dr. Ira Yermish is an Associate Professor of Decision and System Sciences in the Haub School of Business.  He has been at Saint Joseph's University since 1984.  His teaching and research areas include systems analysis and design, data base management, data communications, information resource management, and business intelligence and has been active in executive education. Dr. Yermish was awarded a certificate for Excellence in Teaching in 1988.  In addition to his current academic activities, he is an active management and information systems consultant. Dr. Yermish earned degrees from Case Western Reserve University (BS Management Science 1968), Stanford University (MS Operations Research 1969) the University of Pennsylvania (PhD Computer Science 1975).  His early professional experience included positions with Univac, Control Data, RCA Corporation, the Institute for Scientific Information, and was founder of MagnaSystems, Inc., a software development company specializing in the needs of growing enterprises. Dr. Yermish is an accomplished singer and photographer, avid cyclist, runner, and triathlete, having completed marathons and Ironman events all over the world.  
*                                                                                      
June Phila SQL Server Users Group (PSSUG) Meeting
Location: Microsoft Malvern Office
45 Liberty Blvd
Malvern, PA

Wednesday, June 8th, 5:30 - 8:30pm

 

*
*
Our Sponsor for June is: Validity (http://validityinc.net//)

 

Validity LLC, is a leading provider of comprehensive IT technology services to Corporate customers and Federal government agencies. As a privately owned company founded in 2003 and headquartered in King of Prussia, PA, Validity LLC, became a Certified Women Owned Business as of March 17th 2010. We leverage our in-depth expertise and experience to provide superior solutions.

Built on a foundation of integrity coupled with technical excellence and value we take pride in our results driven approach and realize that ultimately our success is measured by our clients’ success.

Our solutions are supported by our suite of professional practices, and encompass a full range of disciplines, and by bringing together strategic and creative teams of technology and industry professionals, designed to deliver the technologies that will move your business forward and establish Validity,LLC as a proven valuable strategic partner.

 

Meeting Sessions:
Vendor session: Donpaul Stephens, Founder & Chief Strategy Officer for Validity
Presenting: Unblocking The I/O Bottleneck ABC’s of Flash Storage + Violin Technology Overview
*

Donpaul Stephens is the Chief Strategy Officer of Violin Memory, Inc., which he founded in 2005 after identifying that the increasing demand for high-performance storage and scalable memory systems was not adequately addressed by any existing or foreseeable solutions.

Donpaul has Masters and Bachelors of Engineering degrees from Carnegie Mellon University and also received an Executive MBA from New York University. In his 15 year career, he has held engineering positions at Fore Systems, Ascend Communications and Bell Labs and was a General Manager at Vitesse Semiconductor. In 2000, he founded Xebeo which was acquired by UT Starcom.

Please see the attached link with Violin’s benchmark’s that will be discussed during the presentation: http://www.violin-memory.com/news/press-releases/hp-and-violin-memory-post-world-record-dual-socket-tpc-e-benchmark-result/

 
 
*
*
2nd Session: Sebastian Miene - "XML Query Plans"
**
Bio: Sebastian Meine, PhD is a principal trainer and consultant with sqlity.net llc (http://sqlity.net). He specializes in T-SQL performance and SQL-TDD and shares his passion and knowledge regularly with audiences world-wide.
*
*
*
Keynote Speaker: Mark Kromer - "New features in Denali and Azure "
*

 

Bio: Mark Kromer is Microsoft technology specialist for SQL Server for the Mid-Atlantic District. Mark was also lead technical product manager for BI solutions for Microsoft in Redmond and a principal product manager at Oracle. Prior to that, Mark was a DBA and applications developer for AT&T, Dun & Bradstreet and Agilent Technologies. Mark is a frequent contributor to SQL Server Magazine's BI Blog, SearchSQLServer.com, TDWI and a frequent speaker on databases and business intelligence.
*

 

 

                  July Phila SQL Server Users Group (PSSUG) Meeting  
                                                Location:  Microsoft Malvern Office
45 Liberty Blvd
Malvern, PA

Thursday, July 14th, 5:30 - 8:30pm     

 

 

We have several PSSUG members presenting topics from their book that was recently published - Microsoft SharePoint 2010 Business Intelligence Unleashed (http://www.amazon.com/Microsoft-SharePoint-Business-Intelligence-Unleashed/dp/0672335514 ).  
*
*
*

Our Sponsor for June is: RDA  (http://www.rdacorp.com)

RDA provides business solutions through custom software and application development for all types of industries. Our services include requirements definition and analysis, product and tool selection, architecture and systems design, implementation, testing, and staff training. Our project expertise includes business intelligence, enterprise search, workflow/collaboration, enterprise application integration, mobile development, cloud computing, and more. RDA is a Microsoft Partner with Gold certification in the competencies of Business Intelligence, Digital Marketing, Portals and Collaboration, and Software Development and Silver in Content Management, Data Platform, Search, and Web Development. Headquartered in Baltimore, RDA also has offices in Atlanta, Charlotte, Philadelphia, Seattle, and Washington, D.C. The company was founded in 1988.

*

*

 
Meeting Sessions: 
First Session: Steve Mann to talk about the SharePoint 2010 Business Intelligence Center
*
Second Session: RDA Consultant Samir Patel to talk to Integrating 2008 R2 Reporting Services in SharePoint 2010 and Working with Report Builder 3.0
*
Third Session: Chuck talking to Building a PerformancePoint Services Dashboard using the Dashboard Designer for SharePoint 2010
* 
Promotional items for attendees (we have a raffle at the conclusion of each meeting) - We are providing 3 copies of the Microsoft SharePoint 2010 Business Intelligence Unleashed to raffle. Chuck will have the books with him.
 
 
Presenter Bios:
Steve Mann was born and raised in Philadelphia, Pennsylvania, where he still re-sides today. He is an Enterprise Applications Engineer for Morgan Lewis and has more than 17 years of professional experience. Steve was previously a Principal Architect for RDA Corporation where he worked for over 13 years. For the past 8 years, he has primarily focused on collaboration and business intelligence solutions using Microsoft technologies. Steve managed the internal BI Practice Group at RDA for several years. He was also heavily involved within RDA's Collaboration/Search Practice Group. He has authored and co-authored several books related to the subject of SharePoint Server 2010. Steve's blog site can be found at:www.SteveTheManMann.com

Chuck Rivel is a Principal Architect with RDA Corporation and has been developing custom Microsoft applications for the past 14 years. He has architected numerous data warehousing projects in the financial, manufacturing, health and food industries involving all areas of the Microsoft business intelligence development life cycle using the Microsoft BI stack. In addition to the hands on experience of working with MS technologies, Chuck has coauthored the Microsoft SharePoint 2010 Business Intelligence Unleashed book. Currently, Chuck is the Business Intelligence Technical Lead for RDA.

 

 

August Phila SQL Server Users Group (PSSUG) Meeting

Location: Microsoft Malvern Office
45 Liberty Blvd
Malvern, PA

Wednesday, August 10th, 5:30 - 8:30pm

 

 

*
*
Our Sponsor for June is: BI (http://www.bivoyage.net)
B.I. Voyage is a trusted Microsoft partner and international systems integrator that provides information management, business intelligence, and advanced technology solutions. We bring advanced competencies in Microsoft appliances and cloud computing platforms. Our services include training, consulting, and architectural design from some of the world's most renowned technologists. Whether you are a Fortune 500 organization or a mid-market company, B.I. Voyage has the technical expertise to help you get more from your data and help drive your business forward!
*
*
Meeting Sessions:
First Session: BI Voyage (Vendor session) covering SQL Server Parallel Data Warehouse
*
Abstract:: They are going to demonstrate and talk to us about implementing SQL Server Parallel Data Warehouse (http://www.microsoft.com/sqlserver/en/us/editions/data-warehouse.aspx), as well as talk about the massive scale that PDW provides
*
*
Keynote Session: Joe D'Antoni - Deploying Data Tier Applications to the Cloud
*
Abstract: Interested in quickly rolling out new applications to your local environment or to SQL Azure? This session will cover the Data Tier Application functionality that is built into SQL Server 2008 R2 and Visual Studio 2010. The session will start out with an overview of the technology, how it works and how it functions in a typical development organization. We will then go under the hood in SQL Server and take a brief look at the internals that drive both the deployment and upgrade process. Lastly, we will walk through a demonstation of building a new application in Visual Studio and deploying it to SQL Server Azure, extracting a Data Tier application from SQL, and lastly the process of an application upgrade using the technology.

Session Goals
- Understand the purpose and limitations of data tier applications in SQL Server 2008 R2 and Visual Studio 2010.
- Understand the internals of DACPACs and how they are processed by SQL Server.
- Understand how to deploy a data tier application package from Visual Studio to SQL Server.
*
Bio: Joe D'Antoni is a DBA with over a decade of experience working in both Fortune 500 and smaller firms. He is currently working at Synthes, a medical device firm in West Chester, Pennsylvania. He holds a BS in Computer Information Systems from Louisiana Tech University, and a MBA from North Carolina State University. He is the Vice President of the Philadelphia SQL Server Users Group, and a member of the board of the SQL/Oracle and Health Care PASS VCs. Joe is a frequent speaker a local user groups, Code Camps, and SQL Saturdays
*

 

September Phila SQL Server Users Group (PSSUG) Mtg
Location: DeVry University
Rm 104
1140 Virginia Dr
Fort Washington, PA

Thursday, September 15th, 5:30 - 8:30pm

 

 

Please note: For October's meeting, we will be doing a speaker contest with a $50 gift card for the winner. Requirement is a session 15-20 minutes in length. To register, sign up using the Oct_Speaker_volunteer_15min_session ticket type on this meeting.
*

*
Our Sponsor forSept: PSSUG
*
Meeting Sessions:
*
First Session: Dominic Falso - Working with SSIS Packages through .NET C#
*
Abstract:: We will be looking at SSIS Packages through the API for .NET (using C# as our programming language). We'll start by figuring out how to call (run) an SSIS package (and best package configurations), follow with manipulating Connection property values, and finish with designing package objects.
*
Bio: Dominic is the Database Developer with The Reinvestment Fund in Center City Philadelphia. He has studied OO programming since 1995 and database software since 1999 (SQL Server since 2001). He currently works with SQL Server 2008 R2 and .NET C#, doing data analysis and manipulation, as well as writing code management software. In his spare time, he takes studies Chinese Acrobatics and Tightwire at the Philadelphia School of Circus Arts in Germantown.
*
*
*
Keynote Session: Vince Napoli - Advanced features in Analysis Services
*
Abstract: As component of the SQL Server BI Stack, Analysis Services has a number of features built into the product that enable complex calculations and behaviors that support business reporting that are head and shoulders above TSQL queries against the relational database by itself. Some of the features are Custom rollups, custom member formulas, and sub-cube calculations. We will look to build an Analysis Services cube from scratch and build out and demonstrate these features and how to leverage them to support your business and reporting. We will also look at how SSAS falls in the overall architecture.

*
Bio: Vince is a Business Intelligence Architect with Anexinet in Blue Bell, and until recently, a BI Architect and Enterprise Architect at IMS. He has worked with Data Warehousing and Business Intelligence since 1996, with a focus and specialty on SQL Sever since 1999, and an BI Architect since 2001. Vince is a frequent presenter at PSSUG, and has been a SQL Saturday and Code camp presenter in the philadelphia area.
*
 

 

October Phila SQL Server Users Group (PSSUG) Meeting
Location: Radnor Hotel
591 East Lancaster Avenue
St. Davids, PA 19087


Wednesday, October 12th, 5:30 - 8:30pm
*
*
PSSUG Appreciation night. It happens every so often, but we are being treated by to an amazing new location and treated to good food and drinks to boot. Join us at the Radnor Hotel courtesy of Anexinet Solutions. Come on out.
*
*
October is our Speaker Contest. Others call it the the 15 minutes of fame, we simply call it our speaker contest. Requirement: You only need to present for 15-20 minutes only. The audience will judge the winner and the winner will get a $50 gift card.
(Submit your name by using the Oct_Speaker_Volunteer_15min_session ticket type when registering) .
*
*
*
Our Sponsor for October is: Anexinet (www.anexinet.com)
Anexinet is an award-winning systems integrator and technology management company located in Blue Bell, PA. Anexinet is an innovator in aligning IT with business goals, specializing in Application Solutions, Business Intelligence & Data Solutions, and Infrastructure Solutions, providing services throughout Northeast and Mid-Atlantic regions. Check out www.anexinet.com for you solution needs.
*
*
We will have two 30 minute sessions by the sponsor and the rest of the meeting will be the speaker contest
*
*
Sessions
*
Session 1 (Anexinet): Mark Wojciechowicz - Applying Data Visualization in SSRS 2008
In this demonstration, we will explore the value of presenting data graphically and what are the best techniques to elicit the story behind the data. While reporting services offers quite a few tools to tease out the trends and performance in data, there are best practices to follow in order to make those trends pop. This demo will review a few of the common challenges that we face in presenting large sets of data and bringing the meaning of the data forward.
Bio: Starting with a background in supply chain management, Mark first began work in IT with systems implementation and development of line of business applications. Eventually, he began work in data warehousing on the SQL Server 2005 platform and, since, has become a passionate advocate for visualization in data analysis and ease of use in BI applications. Currently, Mark is a business intelligence architect at Anexinet.
*
*
Session 2 (Anexinet): Chris Exley - How to perform drillthrough on calculated members in SSAS
In this session we will learn how to perform drillthrough on calculated members in SSAS (which can’t be done out of the box) utilizing dynamic MDX and SSAS Actions to launch external comments to provide the data
Bio: Chris Exley is a Business Intelligence Architect with Anexinet. He has been working with the Microsoft stack of BI products for more than 10 years. His expertise is in SSRS and SSAS where he has built SSAS cubes and Reporting infrastructures for companies in the Healthcare/Insurance and Commercial Property areas.
*
*
*
Speaker Contest ( 5 submissions )
Submissions :
1) Alex Grinberg - Advanced T-SQL: OUTPUT CLAUSE
2) Chuck Kruele - Powershell for SQL Admin task
3) Bob Blackburn - SSIS: A faster SCD with the Hash function
4) Allen Jester - Nested CTEs
5) Faheem Mohammed - Merge Replication
*
October South Jersey SQL Server Meeting
 
Location: Haddon Heights Public Library
608 Station Ave
Haddon Heights, NJ 08035

Tuesday, October 25, 5:30 - 8:30pm
*
*
*

*

Meeting content

-------------------------------------------------------------------------------

Our Sponsor for October is: RDA (http://www.rdacorp.com)

RDA provides business solutions through custom software and application development for all types of industries. Our services include requirements definition and analysis, product and tool selection, architecture and systems design, implementation, testing, and staff training. Our project expertise includes business intelligence, enterprise search, workflow/collaboration, enterprise application integration, mobile development, cloud computing, and more. RDA is a Microsoft Partner with Gold certification in the competencies of Business Intelligence, Digital Marketing, Portals and Collaboration, and Software Development and Silver in Content Management, Data Platform, Search, and Web Development. Headquartered in Baltimore, RDA also has offices in Atlanta, Charlotte, Philadelphia, Seattle, and Washington, D.C. The company was founded in 1988.

*

*

 
Meeting Sessions:
 
First Session: RDA Consultant Samir Patel to talk to Integrating 2008 R2 Reporting Services in SharePoint 2010 and Working with Report Builder 3.0
*
Second Session: Chuck talking to Building a PerformancePoint Services Dashboard using the Dashboard Designer for SharePoint 2010
*
*
Promotional items for attendees (we have a raffle at the conclusion of each meeting) - We are providing 3 copies of the Microsoft SharePoint 2010 Business Intelligence Unleashed to raffle. Chuck will have the books with him.
*
*
Presenter Bios:
Chuck Rivel is a Principal Architect with RDA Corporation and has been developing custom Microsoft applications for the past 14 years. He has architected numerous data warehousing projects in the financial, manufacturing, health and food industries involving all areas of the Microsoft business intelligence development life cycle using the Microsoft BI stack. In addition to the hands on experience of working with MS technologies, Chuck has coauthored the Microsoft SharePoint 2010 Business Intelligence Unleashed book. Currently, Chuck is the Business Intelligence Technical Lead for RDA.
*
Samir Patel: Samir Patel is a Software Consultant with RDA Corporation and has been working with Microsoft technologies, including ASP.NET, SharePoint, SQL Server, and BI for the last 9 years. He has implemented internal and external websites to improve business processes and reporting needs. Currently, Samir is working on SharePoint and Microsoft BI to provide integrated reporting experience to customers, using Analysis Service and Reporting Services.
*
*

 

November Phila SQL Server Users Group (PSSUG) Meeting
Location: Microsoft Malvern Office
45 Liberty Blvd
Malvern, PA

Thursday, November 10th, 5:30 - 8:30pm

 

 

*
*
Our Sponsor for November is: CapTech (http://www.captechconsulting.com/)
*
*
*
Meeting Sessions:
First Session: DBA Open forum - panel or general discussion on DBA roles and daily responsibilities.
*
Abstract: Calling all DBAs. We can use any and all DBAs to be involved in an open discussion. Express your opinion without needing to put together any material.
*
*
Middle Session: Mark Kromer (Microsoft) - Recap on new announcements of at the PASS Summit.
*
Abstract: Short session to go over new things coming down the pike that you should be aware of.
*
 
*
Keynote Session: Jessica Moss (SQL Server MVP) - "Report Parts: How to Increase Development Productivity in SSRS"
*
Abstract: Using SQL Server 2008 R2 Reporting Services and Report Builder 3.0, report writers can store, re-use, and modify pieces of reports using "report parts". Report parts are stored on the report server and are provided to others for collaboration in a report part library to increase initial development productivity and decrease maintenance turn-around time. This presentation will describe how to set up a user-friendly and easily maintained report part library by discussing how to create report parts, how to store them on the report server, and how to import them into a new report.
*
Bio: Jessica M. Moss
Jessica M. Moss is an architect at CapTech Consulting, speaker, author, and Microsoft MVP of SQL Server business intelligence. Jessica has created numerous data warehousing solutions for companies in the retail, internet, health services, finance, and energy industries and has authored technical content for multiple magazines, websites, and the book "Microsoft SQL Server 2008 Integration Services Problem-Design-Solution". Jessica enjoys working with the central Virginia community and speaks regularly at user groups, code camps, and conferences. You can read more on her website, http://www.jessicammoss.com.
*
 
 

 

December Phila SQL Server Users Group (PSSUG) Meeting

Location: Microsoft Malvern Office
45 Liberty Blvd
Malvern, PA

Wednesday, December 7th, 5:30 - 8:30pm
*
*
**Note: Bharat Kenjale's session on SQL Server Storage Best Practices is being moved to January due to a scheduling conflict**
Meeting Sessions:
First Session: Jeff Leidy - "What is PowerPivot, Where does if fit in the BI technology stack and Why it is needed in an organization"
*
Bio: Jeff is a business intelligence consultant with Anexinet spcializing.
*
*
Middle Session: Vince Napoli - "Advanced SSIS coding techniques".
Abstract: We will be covering some advanced coding techniques for SSIS packages. Business uses for Precendence Constraints, Lookups, Conditional spits, and others to manage execution, and manipulate data in the data flow. Very good techniques to have in your toolbox.
*
Bio: Vince is a Business Intelligence Architect with Anexinet and has specialized with SQL Server since the 7.0 release, Data Warehousing since 1996, and in IT since 1987. He has presented at multiple SQL Saturday events, a Philly.NET code camp, and a common presenter for the Phila SQL Server User group. Vince is a graduate of Bloomsburg University from a long, long time ago.
*
*
*
Keynote Session: Joe D'Antoni - "High Availability / Disaster Recovery for 2012."
*
Abstract: SQL 2012 introduces a multitude of changes in the HA and DR stacks. We will review the options we currently have available in SQL 2008 R2, and discuss what changes both in clustering and the big new feature of SQL 2012 AlwaysOn Availability Groups. Joe will give a demo of the Availability Groups feature, and show how you can have a multi-site DR scenario without even talking to your SAN admin.
*
*
Bio: Joe D'Antoni is a DBA with over a decade of experience working in both Fortune 500 and smaller firms. He is currently working at Comcast. He holds a BS in Computer Information Systems from Louisiana Tech University, and a MBA from North Carolina State University. He is the Vice President of the Philadelphia SQL Server Users Group, and a member of the board of the SQL/Oracle and Health Care PASS VCs. Joe is a frequent speaker a local user groups, Code Camps, and SQL Saturdays

 

January Phila SQL Server Users Group (PSSUG) Meeting

Location: Microsoft Malvern Office

45 Liberty Blvd
Malvern, PA

Wednesday, January 11th, 5:30 - 8:30pm

 

*
*
Meeting Sessions:
 
Short Session - Mark Kromer (Microsoft) - Demo of the new SSRS 2012 reporting tool, Power View.
Otherwise known as Project Crescent, Silverlight SSRS reporting tool
*
 
Keynote Session: Bharat Kenjale - "SQL Server Storage Best Practices"
 
Abstract: Many database administrators consider storage as impenetrable block box where data come in and goes back out again but not as per DBA expectation. In this presentation we will discuss on what’s inside the block box: the types of storage, different components of the storage, how it attaches to the server and how it works when it’s shared between multiple servers in a SAN. We will go into basics and then discuss on configuring windows and SQL Server to get the best storage performance and review a practical case study to view how to identify storage bottlenecks and ways to remove those bottlenecks.

Bio: Bharat is Principal Database Architect with Comcast and has over a decade of experience with SQL Server. He has presented at SQL Saturday events and for the Philadelphia SQL Server user group. Bharat holds MS in Information Technology from Rochester Institute of Technology and a MBA from Pune University. He holds MCITP certification in SQL 2008 version.
*
*
Impromptu Session - Kalen Daleney (SQL Server MVP) - "New Features of 2012" 
 
Abstract: In a surprise visit, Kalen volunteered to do impromptu session.   She did an overview of the new release of SQL Server.          
 
Bio:  See Kalen's website for training, material, and activities (www.sqlserverinternals.com) 
*
*
*
Keynote Session: Kevin Goff (SQL Server MVP) - "What's new in SQL Server/SSIS 2012" (session postponed) 
*
Abstract: Have you ever gotten whiplash as you twist your head in fifty directions, trying to research all the new features in a product? In this session, I’ll go through all the new language and database management features in SQL Server 2012. I won’t focus excessively on any one feature – instead, I’ll go through as many new features in SQL Server 2012 as time permits. Everything from new database management features like the new Column Store index, new T-SQL Language Features, and also some new features in Integration Services (SSIS).
 
Bio: Kevin S. Goff (http://www.kevinsgoff.net) is a Microsoft SQL Server MVP, SQL Server/Business Intelligence Practice Manager for SetFocus LLC, author of 2 books, regular columnist for CoDe Magazine on .NET, SQL Server, and Business Intelligence topics, and a frequent speaker at community events in the Mid-Atlantic region.

 

 

January South Jersey SQL Server Meeting
 
Location: Haddon Heights Public Library
608 Station Ave
Haddon Heights, NJ 08035

Tuesday, January 24, 5:30 - 8:30pm
*
*
*

*

Meeting content

-----------------------------------------------------------------------

Our Sponsor is Microsoft.
*
*
Meeting Sessions:
 
First Session: Sebastian Meine, PHD - "Index Internals - How SQL Server stores and accesses data"
*
Bio: Sebastian is a principal trainer and consultant with sqlity.net llc (http://sqlity.net) and CTO for TSTS Inc, a company that provides an online personalized training and workout solution (http://www.tanyastroh.com). He specializes in T-SQL Test Driven Development (TDD) and performance and shares his passion and knowledge regularly with audiences world-wide through his writings and speaking engagements.
*
After receiving his PhD in Computer Science, Sebastian moved to the United States to begin his career as a software developer for a global Fortune 50 company. He quickly rose to the role of software architect, functioning as a SQL performance and TDD expert, assuming responsibility for the code quality and performance of dozens of large-scale database installations nationwide.
*
*
Keynote Session: AJ Mee (Microsoft) - "Review the key advances in SQL Server 2012"
Abstract: We are fast approaching the release of SQL Server 2012. Much like other recent installments of SQL Server, SQL 2012 provides a wealth of new capabilities in the arena of Business Intelligence. Come join A.J. Mee, a veteran Microsoft BI specialist, to review the key advances that SQL Server 2012 brings to the table, including:
· Power View
· BI Semantic Model (BISM)
· Data Quality Services
· Project Barcelona
· Master Data Management
· Columnstore Index
 
Bio: A.J. Mee is a Senior Technology Solutions Professional for Microsoft Corporation. He leads Microsoft's sales and pre-sales practice around Business Intelligence (BI), serving 300+ Enterprise customers in the Mid-Atlantic region of the US (PA/DE/NJ/DC/MD/VA). In his role, he is primarily responsible for aligning specific customer requirements around BI empowerment and democratization to Microsoft's industry-leading BI platform. He joined Microsoft in 2006 as part of its acquisition of ProClarity, a BI vendor whose technology has made its way into Microsoft's Corporate Performance Management (CPM) offering - PerformancePoint Services for SharePoint.

A.J. has been engaged in the Business Intelligence arena for over 15 years, serving in varied roles (director of software development, consulting, engineering, project management, database administration, and pre-sales). He is a popular speaker who frequently presents on a wide variety of BI-related topics (including OLAP, data warehousing, analytics, reporting, performance management, ETL) at Microsoft-hosted, vertically-focused, and technologically-focused conferences and events. A.J. holds a B.A. in Computer Science from LaSalle University (Philadelphia, PA).

 

 

February Phila SQL Server Users Group (PSSUG) Mtg
Location: DeVry University
Rm 121
1140 Virginia Dr
Fort Washington, PA

Wednesday, February 8th, 5:30 - 8:30pm

 



"Join us for the kick off for SQL Saturday #121 for June 9th"

 

Meeting Agenda:
5:45 - 6:15 - Intro session
6:15 - 6:30 - Break / Networking session
6:30 - 7:45 - Keynote Session
7:45 - 8:30 - Open PSSUG Board meeting - State of the Group / Kick off for SQL Saturday (to be continued off site)
8:30 - wrap up / raffle
*
*
*
Meeting Sessions:
First Session: Joe D'Antoni - "Windows Core Server--the Future of Windows"
*
Bio: Joe D'Antoni is a DBA with over a decade of experience working in both Fortune 500 and smaller firms. He is currently working at Comcast. He holds a BS in Computer Information Systems from Louisiana Tech University, and a MBA from North Carolina State University. He is the Vice President of the Philadelphia SQL Server Users Group, and a member of the board of the SQL/Oracle and Health Care PASS VCs. Joe is a frequent speaker a local user groups, Code Camps, and SQL Saturdays
*
*
*
Keynote Session: Sebastian Meine, PHD - "Index Internals - How SQL Server stores and accesses data"
*
Abstract: In this session we will examine one of SQL Servers' most fundamental yet most important functions - how does SQL Server store data on disk and how does it find it again when executing a query. Using a combination of demos, lecture and discussions we will begin with the structure of the data on disk by delving into the world of HoBTs and Extends, RIDs and Keys and especially Pages. From there we will tackle topics concerning the retrieval of data such as Index levels, Index Scans and Seeks and Lookups.
*
*
Bio: Sebastian is a principal trainer and consultant with sqlity.net llc (http://sqlity.net). He founded sqlity.net in 2010 to fully engage in his passion for SQL Server. Sebastian specializes in T-SQL Test Driven Development (TDD) and performance tuning and shares his knowledge regularly with audiences world-wide through his writings and speaking engagements. Sebastian is also the CTO of TSTS Inc, a company that provides online personalized training and workout solutions.
 
After receiving his PhD in Computer Science, Sebastian moved to the United States to begin his career as a software developer for a global Fortune 50 company. He quickly rose to the role of software architect, functioning as a SQL performance and TDD expert, assuming responsibility for the code quality and performance of dozens of large-scale database installations nationwide.
*
 
 

 

March Phila SQL Server Users Group (PSSUG) Meeting

Location: Microsoft Malvern Office
45 Liberty Blvd

Malvern, PA


Thursday, March 15th, 5:30 - 8:30pm

 

 

Remember: SQL Saturday will be on June 9th at Microsoft.

 
Meeting Sponsor is: Microsoft
 
 
 
Meeting Sessions:
 
 
First Session - Dominic Falso - "Intro to Statistical Programming in T-SQL"
 
 
Bio: Dominic is the Database Developer with The Reinvestment Fund in Center City Philadelphia. He has studied OO programming since 1995 and database software since 1999 (SQL Server since 2001). He currently works with SQL Server 2008 R2 and .NET C#, doing data analysis and manipulation, as well as writing code management software. In his spare time, he takes studies Chinese Acrobatics and Tightwire at the Philadelphia School of Circus Arts in Germantown.
 
*
*
Keynote Session: Kevin Goff (SQL Server MVP) - "What's new in SQL Server/SSIS 2012"
 
 
Abstract: Have you ever gotten whiplash as you twist your head in fifty directions, trying to research all the new features in a product? In this session, I’ll go through all the new language and database management features in SQL Server 2012. I won’t focus excessively on any one feature – instead, I’ll go through as many new features in SQL Server 2012 as time permits. Everything from new database management features like the new Column Store index, new T-SQL Language Features, and also some new features in Integration Services (SSIS).
 
 
Bio: Kevin S. Goff (http://www.kevinsgoff.net) is a Microsoft SQL Server MVP, SQL Server/Business Intelligence Practice Manager for SetFocus LLC, author of 2 books, regular columnist for CoDe Magazine on .NET, SQL Server, and Business Intelligence topics, and a frequent speaker at community events in the
 
April Phila SQL Server Users Group (PSSUG) Meeting
Location: Microsoft Malvern Office
45 Liberty Blvd
Malvern, PA

Wednesday, April 11th, 5:30 - 8:30pm
 

 

 

Reminder: SQL Saturday will be on June 9th at Microsoft (go to http://www.sqlsaturday.com/121/eventhome.aspx for info).

 
 
Meeting Sponsor is: Anexinet (www.anexinet.com)
 
 
 
Giveaway: We will be giving away a copy of the Best of PASS Summit 2011 to all who attend
 
 
 
Meeting Sessions:
 
 
Speaker Contest (15 minute segments each)
 
Speaker one : Kevin Howell - SQL & XML: Dataset Transactions
It will cover the progression from single record set transactions to “sp_xml_preparedocument” procedures to using the native SQL XML parser for complete dataset transactions
 
Speaker two: Steve Lindsay - Clustering a Replication Distributor Server
 
Speaker Three: Said Salomon - Topic TBD
 
Speaker Four: Chris Exley - Attribute Relationships in dimension design
 
Speaker Five: Joe D'Antoni - Changes in SQL 2012 licensing
 
*
*
 
Keynote Session: Alex Grinberg - "How to build XML".
 
 
 
Abstract: This session will cover process to create an XML as resultset from the table(s). Live demo samples will include and cover FOR XML clause, also RAW, ELEMENTS, AUTO, PATH, ROOT, and TYPE modes.
 
 
Bio: Alex has more than 15 years IT experience. His primary focus is with the latest Microsoft technologies including .NET (VB and C#), SSRS, SSIS. He provides tuning, optimization, analysis and development service creating new applications, converting legacy technologies (SQL Server, VB.NET and C# ) and one site training. He has worked for the CSC, VerticalNet, Insurance Data Processing, LSAC to name a few and is currently working with Aspect Consulting, Inc. Alex is PSSUG board member and guest author for SQLServerSentral.com.

 

1) SQL Server 2012 Special Ops Tour - March 21st in Center City Phila 
 
2) SQL Server 2012 Online Virtual Launch Event - March 7th 
 
http://www.sqlserverlaunch.com/ww/Home
3) SQL Saturday #121 - Philadelphia - on June 9th at Microsoft. 
 
http://www.sqlsaturday.com/121/eventhome.aspx

 

April South Jersey SQL Server Meeting
 
Location: Haddon Heights Public Library
608 Station Ave
Haddon Heights, NJ 08035

Tuesday, April 24, 5:30 - 8:30pm
*
*
*

*

Meeting content

---------------------------------------------------------------------

*
*
Meeting Sessions:
 

Talk 1:

Hilary Cotter:

Bio: SQL Server MVP Hilary Cotter is a 20 year IT veteran who has answered over 20,000 questions on the forums. Some of them correctly. He has been a SQL Server MVP for 11 years now.

Here is a description of the presenation.

Performance tuning is difficult task. In this presentation SQL Server MVP Hilary Cotter presents tools to help you to get to the root causes of performance problems. He presents common strategies for tuning queries, cleaning up code, handling blocking, deadlocking, and other common performance problems.

 

Talk 2:

Increasing High Availability and Decreasing Complexity with SQL Server 2012

Description:

In this session I will introduce the new SQL Server High Availability and Disaster Recovery solution (AlwaysOn) in SQL Server 2012. I will demo the setup of an AlwaysOn Availability Group and show how an application can reconnect following a failover. Additionally, I will show how to configure read-only secondaries and demonstrate the use of prioritizing the secondaries for access.

Speaker BIO: William Emmert

Bill is the Technical Director and an SQL Technology Architect in the Philadelphia Microsoft Technology Center (MTC). He has been working at Microsoft for the last 14 years helping customers of all sizes to develop and implement solutions around Microsoft SQL Server and Business Intelligence. Bill has worked in the computer industry for 25 years with experiences in mainframe development, LAN architecture and administration, client server application development, project management, consulting and IT management. He started his career at Microsoft in Consulting Services focusing on design, development, testing, deployment and troubleshooting SQL Server OLTP and OLAP solutions. In 2007, Bill joined the SQL Server development product group as a member of the SQL Server Customer Advisory Team (SQLCAT), and in 2010 worked as a SQL Architect in the New York MTC before taking on his current role in the Philadelphia MTC.

 

Sponsor: Antonio Sorbello

Robert Half Technology (Mt Laurel office) - we specialize in staffing highly skilled IT professionals on a contract, contract to hire, and full-time basis.

 

May Phila SQL Server Users Group (PSSUG) Meeting

Location:
excelleRx
1601 Cherry St., Suite 1700
Philadelphia (Center City), PA 19102
(Regional Rail and parking lots available - see end of announcement)
(this is a secure building - you will need to register for this meeting)
Wednesday, May 9th, 5:30 - 8:30pm
 
 
 
 
Reminder: SQL Saturday will be on June 9th at Microsoft (go to http://www.sqlsaturday.com/121/eventhome.aspx for info and to register).
 
 
 
Meeting Sponsor is: Antonio Sorbello - Digital Intelligence Systems Corporation (DISYS) (www.DISYS.com) - we specialize in staffing highly skilled IT professionals on a contract, contract to hire, and full-time basis.
 
 
Giveaway: We will be giving away a copy of the Best of PASS Summit 2011 to all who attend
 
 
 
 
 
Meeting Sessions:
 
 
1st Session: Sharon Dooley- Index Design (aka Should my Primary Key always be my clustered index?)
 
 
Abstract: This presentation will provide information about the various types of queries and show you which type of indexes are best for each query type. In addition, it will explore why covering indexes are highly beneficial in a SQL Server environment. The presentation assumes that the attendees understand the difference between clustered and non-clustered indexes.
 
 
Bio: Sharon has worked with SQL Server since its first release. Her major areas of specialization are database design and performance tuning, though she also does a lot of administration. She has a consulting practice and teaches and writes courses for Learning Tree International, where she is SQL Server Curriculum Manager. Ms. Dooley is the author of SQL Server 7.0 Essential Reference (New Riders), the lead author of Professional SQL Server 6.5 Administration (Wrox Press). Sharon is an active member of PASS (The Professional Organization for SQL Server) and has presented at numerous conferences. She was named a Microsoft MVP in 2001 and was an MVP for SQL Server until 2004. In her spare time, she enjoys being bossed around by her three cats.
 
 
 
 
 
2nd Session: Hilary Cotter - "SQL Server Replication Technologies"
 
 
Abstract: Replication is a native SQL Server component which is used for copying, distribution and aggregating data between databases and servers. In this presentation SQL Server MVP discusses the different replication types and technologies and their sweet points. He also shows common use cases, gotcha's, and performance tuning and troubleshooting techniques.
 
 
BIO: Hilary Cotter: SQL Server MVP Hilary Cotter is a 20 year IT veteran who has answered over 20,000 questions on the forums. Some of them correctly. He has been a SQL Server MVP for 11 years now.
 
Hilary is also an author, or contributor, on a number of books on SQL Server. Go to amazon.com and enter in Hilary Cotter: http://www.amazon.com/s/ref=nb_sb_noss?url=search-alias%3Daps&field-keywords=hilary+cotter+sql+server+books
 
 
 
 
 
Transporation Information:
 
 
Region Rail - Septa Suburban Station (approximately 2 blocks away).
 
 
Parking:
Parkway Parking Garage (Broad & Race Streets)
150 N. Broad Street
Philadelphia, PA 19102
(215) 569-8400

Gateway Parking Garage (16th & Spring Streets)
1550 Vine Street
Philadelphia, PA 19102
(215) 246-0300 ‎

 

July Phila SQL Server Users Group (PSSUG) Meeting
Location: Microsoft Malvern Office
45 Liberty Blvd
Malvern, PA
 
Wednesday, July 11th, 5:30 - 8:30pm
 

 

 

Meeting Agenda:
 
 
 
 
Session 1 - Vince Napoli - "Creating database change scripts for Deployment"
 
Abstract: Ever figure out how to turnover your database code / fix to your support personel and ensure it will run properly when you have your code deploy to QA or Production. In this session, we see a method being implemented on how to create change scripts that will allow you to deploy code with confidence and also allow you to store in Team Foundation Services or Visual Source Safe.
 
 
 
Organization Announcement: We have a major organizational shift taking place with the group with the launch of the Phila Business Intelligence Users Group. Jeff Leidy, vice-president of PBIUG, will do a introduction and overview.
 
 
 
Break - Open Discussion - Bring your problems (technical) from work - we'll look to discuss what challenges you would like to have folks talk about and come up with suggestions / ideas / solutions.
 
 
 
Session 2 - Joe D'Antoni - "Introduction to Extended Events in SQL Server 2012"
 
 
 
Session 3 - Mark Kromer (Microsoft) - "What's new for SQL 2012 - Columnar Indexes"
 
 
Abstract: As part of his continuing segments on providing information on the new features for SQL 2012, Mark will be focusing in the feature of Columnar Indexes
 

 

July South Jersey SQL Server Meeting
Location: Haddon Heights Public Library
608 Station Ave
Haddon Heights, NJ 08035

Monday, July 23rd, 5:30 - 8:30pm

 

 

 

 

Meeting content


-------------------------------------------------------------------------------
Vitural presentation: Minimally Invasive – Tools to Doctor Up Your Code

This code filled session examines several additions to recent versions of SQL Server. These tools allow you to perform minimally invasive surgery on your code and gain performance! Learn how the APPLY operator works; iterate through incoming data just once with the MERGE statement; “slice and dice” your data with the Windowing (ranking) functions; re-write your multi-statement table-valued functions to inline functions to help the optimizer and speed up your queries; learn how to create a grouped delimited list – without loops!

Bio: Wayne Sheffield is a Sr. SQL Server DBA, currently working with Ntirety (The Database Experts). Wayne started working with databases in the late 1980's, using DBase, Foxbase and FoxPro. With over twenty years in the IT industry, he has worked with SQL Server database systems (starting from version 6.5) since the late 1990's. He is the author of several articles at www.sqlservercentral.com, and he is a co-author of SQL Server 2012 T-SQL Recipes (Apress).

 


Virtualization for SQL DBAs-

Want to know about VMWare and what it means for your databases? This session will go through the hardware and terminology around this technology. Learn how to optimize your SQL Servers for VMs and what to tell your storage engineers.

BIO: Joey D'Antoni is a DBA with over a decade of experience working in both Fortune 500 and smaller firms. He is currently working at Comcast. He holds a BS in Computer Information Systems from Louisiana Tech University , and a MBA from North Carolina State University . He is the Vice President of the Philadelphia SQL Server Users Group, and a member of the board of the SQL/Oracle and Health Care PASS VCs. Joe is a frequent speaker a local user groups, Code Camps, and SQL Saturdays.

 
August Phila SQL Server Users Group (PSSUG) Meeting
Location: Microsoft Malvern Office
45 Liberty Blvd
Malvern, PA

Wednesday, August 8th, 5:30 - 8:30pm
 

**Note: We're working with an open and interactive format for the keynote session **

 

 
 
Meeting Agenda:
 
 
 
Session 1 - Vince Napoli - "Bulk load operations"
 
 
Abstract - We'll take a look at all the Bulk Loading operations available to SQL Server and how best to use them. Database recovery models will be explained and reviewed to how they impact the bulk operations.
 
 
 
Bio: Vince is a Business Intelligence Architect with Anexinet in Blue Bell, and until recently, a BI Architect and Enterprise Architect at IMS. He has worked with Data Warehousing and Business Intelligence since 1996, with a focus and specialty on SQL Sever since 1999, and an BI Architect since 2001. Vince is a frequent presenter at PSSUG, and has been a SQL Saturday and Code camp presenter in the philadelphia area.
 
 
 
 
 
 
 
 
Keynote - Alex Grinberg / Said Salomon - "Performance tuning, bring your questions"
 
 
Abstract - This is an open discussion format on Performance tuning. There will be part lecture and part open discussion with the audience on the topic of performance tuning.
 
 
Bio1: Alex has more than 15 years IT experience. His primary focus is with the latest Microsoft technologies including .NET (VB and C#), SSRS, SSIS. He provides tuning, optimization, analysis and development service creating new applications, converting legacy technologies (SQL Server, VB.NET and C# ) and one site training. He has worked for the CSC, VerticalNet, Insurance Data Processing, LSAC to name a few and is currently working with Aspect Consulting, Inc. Alex is PSSUG board member and guest author for SQLServerSentral.com.
 
 
 
Bio2: Said Salomon has over 25 year experience as an Information Technology Professional. I have a vast array of abilities in the field in the areas of: Network, Desktop Support, DBA, Staff Project Management, Application Software Development, Business Analysis and Quality Assurance. Said carries Microsoft certifications as a MCTS, MCPS, and MCNPS, and multiple certifications from the Insurance Institute of America.
 
 
 

 

September Phila SQL Server Users Group (PSSUG) Meeting
Location: Microsoft Malvern Office
45 Liberty Blvd
Malvern, PA

Wednesday, September 5th, 5:30 - 8:30pm

 

 ***Please note: Due to a scheduling conflict, the original first session on System Center 2012 will be cancelled and replaced by another session ***

 

(this session is replaced for 9/5 meeting) 1st Session: Todd Furst (Microsoft) - “System Center 2012 for the SQL Server DBA”
 
 
 
 
1st Session: Joe D'Antoni - Understanding New Storage Technology
 
Abstract: Joe will explain the components of a modern San and how they effect database servers. We will talk about things such as dynamic storage tiering and the impacts of virtualization.
 
Bio: Joey D'Antoni is a DBA with over a decade of experience working in both Fortune 500 and smaller firms. He is currently working at Comcast. He holds a BS in Computer Information Systems from Louisiana Tech University , and a MBA from North Carolina State University . He is the Vice President of the Philadelphia SQL Server Users Group, and a member of the board of the SQL/Oracle and Health Care PASS VCs. Joe is a frequent speaker a local user groups, Code Camps, and SQL Saturdays.
*
 
 
 
 
Keynote Session: Sebastian Meine - "Columnstore Index Internals"
 
 
Abstract: In this session we are going to take a deep dive into the columnstore index feature introduced in SQL Server 2012. We will compare columnstore with b-tree indexes and see why a columnstore index is not really an index at all.

After attending you will be able to identify queries that will benefit from columnar storage. You will be able to explain how the data in a columnstore index is stored on disk and which access mechanisms are available to SQL Server. You will be able to see whether a query is running in row mode or is utilizing the new batch mode and explain the difference between the two.

In this talk we will also cover the gaps that were left in the current implementation, scheduled to be filled in a future version of SQL Server.

http://sqlity.net/en/1060/presentation-materials-columnstore-index-internals/

 

Bio: Sebastian is the SQL Stylist at sqlity.net llc (http://sqlity.net). He founded sqlity.net in 2010 to fully engage in his passion for SQL Server. Sebastian provides training and consulting services. He specializes in T-SQL Test Driven Development (TDD) and performance tuning and shares his knowledge regularly with audiences world-wide through his writings and speaking engagements. Sebastian is also the CTO of TSTS Inc, a company that provides online personalized training and workout solutions.

After receiving his PhD in Computer Science, Sebastian moved to the United States to begin his career as a software developer for a global Fortune 50 company. He quickly rose to the role of software architect, functioning as a SQL performance and TDD expert, assuming responsibility for the code quality and performance of dozens of large-scale database installations nationwide.

October South Jersey SQL Server Meeting
 
Location: Haddon Heights Public Library
608 Station Ave
Haddon Heights, NJ 08035

Tuesday, October 23rd, 5:30 - 8:30pm
 
*
*

Meeting content

--------------------------------------------------------

First Talk: Performance Tuning Made Easy by Muthu Ramanathan

Second Talk: Columnstore Index Internals by Sebastian Meine

 

 

 

Performance Tuning Made Easy (Muthu Ramanathan)

Abstract: SQL Server is a developer platform. The experience you get from this platform depends on how you leverage the platform. In this interactive session, we will talk about some live performance scenarios including CPU starvation, High Memory consuming Queries, SQL Server Cache Stores, I/O Intensive Queries by walking through some live examples. This will be all examples, few slide interactive session that talks about SQL Server performance tuning, using some of the native tools that comes out of the box. We will finish by getting into SQL Server 2012 Architecture enhancements and if time permits, to Extended Events introduction and how better troubleshooting gets in SQL 2012 and .NET 4.5.

Bio: Muthu Ramanathan, currently working as a Dedicated SQL Engineer @ Microsoft, he has been with Microsoft for little under 5years, dealing with Microsoft’s Premier customers and acting as a trusted advisor. He has been working with SQL Server since version 4.2 for over 15 years, when SQL shared very similar characteristics as Sybase.

Right from his college days, he had a passion for Databases. His college project of showcase is a prototype RDBMS that was built using “file locking” mechanism. Though it had some concurrency restrictions, the product is still in production in a small manufacturing industry.

 

Column store Index Internals (Sebastian Meine)

Abstract: In this session we are going to take a deep dive into the columnstore index feature introduced in SQL Server 2012. We will compare columnstore with b-tree indexes and see why a columnstore index is not really an index at all.

After attending you will be able to identify queries that will benefit from columnar storage. You will be able to explain how the data in a columnstore index is stored on disk and which access mechanisms are available to SQL Server. You will be able to see whether a query is running in row mode or is utilizing the new batch mode and explain the difference between the two.

In this talk we will also cover the gaps that were left in the current implementation, scheduled to be filled in a future version of SQL Server.

Bio: Sebastian Meine, PhD - Sebastian is the SQL Stylist at sqlity.net llc (http://sqlity.net). He founded sqlity.net in 2010 to fully engage in his passion for SQL Server. Sebastian provides training and consulting services. He specializes in T-SQL Test Driven Development (TDD) and performance tuning and shares his knowledge regularly with audiences world-wide through his writings and speaking engagements. Sebastian is also the CTO of TSTS Inc, a company that provides online personalized training and workout solutions.\

After receiving his PhD in Computer Science, Sebastian moved to the United States to begin his career as a software developer for a global Fortune 50 company. He quickly rose to the role of software architect, functioning as a SQL performance and TDD expert, assuming responsibility for the code quality and performance of dozens of large-scale database installations nationwide.

 

November Phila SQL Server Users Group (PSSUG) Meeting
Location: Microsoft Malvern Office
45 Liberty Blvd
Malvern, PA

Wednesday, November 7th, 5:30 - 8:30pm

 

 

 
 
Meeting Agenda:
 
First Session - Mark Kromer - "Big Data with SQL Server 2012"
 
 
Abstract: TBD
 
 
BIO: TBD
 
 
 
 
Spotlight Session - Joshua Lynn - "The Data Whisperer: Detecting & Extracting Meaning From Changing Data"
 
 
Abstract: Data changes, accept it!

A DBA's Prayer: "May the deities of databases grant us the serenity to accept the things we cannot change and the courage to change the things we can and the wisdom to know the difference"

This presentation is about putting some wisdom behind how we deal with changing data. How is changing data detected? Did the data really change or does it just look like it may have changed? How do we know the old data we're comparing to didn't change itself? What does the change mean and why the !@#$% doesn't the application layer deal with this so I can get back to "real" database work?

Dealing with changing data is a big part of managing data. There are as many techniques as there are reasons for detecting change. The rules for dealing with changing data are not as well defined as the normal forms for persisting data. This presentation looks to analyze some use cases behind detecting and managing changing data and provide some consistent solutions using a logical framework, which is adaptable for purpose and technology.

So the next time you're handed a project where the requirements say only load or extract the changes, you'll have a new perspective to complete an analysis and formulate as solution that you know covers the permutations of change, the pitfalls of weak data, and has the ability to adapt.
 
 
 
BIO: Joshua Lynn started programming databases when he was 14 years old. Professionally, Joshua has been in the IT industry since 1991 specializing in database design, development and performance enhancement. Though his career he has lead IT and development teams in projects ranging from COLO fit-outs to full n-tier application development on the various incarnations of the Microsoft Platform. His experience with SQL server goes back to version 6.5 where he thought triggers were real neat. Currently he is working on SQL server 2K8 R2 projects and still believes CTEs have enhanced the quality of his professional life. Although the Tablix feature of SSRS is pretty neat too. Surprisingly Joshua's educational background is in Mechanical Engineering and has no formal training in what he does for a living but does maintain an unusual passion for SQL and high performance database query algorithms. In his spare time over the last 14 years he mentors high school students in building and programming robots for the FIRST Robotics Challenge an international completion with over 1500 teams and 35K students. Additionally Mr. Lynn is an advocate for Deadlock victims’ rights.
 

 

December Phila SQL Server Users Group (PSSUG) Meeting
Location: Microsoft Malvern Office
45 Liberty Blvd
Malvern, PA

Wednesday, December 12th, 5:30 - 8:30pm
 
 

 

Meeting Agenda:
 
1st Session - Kevin Howell - "Visual Studio 2012: A Complete IDE (Debugging & Source Control)"
 
Bio: Kevin Howell is a .NET Developer and SQL Server DBA for USLI (United States Liability Insurance Group) in Wayne, PA where he concentrates on driving SQL performance, security and integrity initiatives, along with leading development efforts on various .NET projects.Kevin started programming in Fortran and C++, then moved to Visual Basic and began developing full n-tier applications for the medical and insurance sectors.Kevin began working with SQL Server in 1999 (v6.5) and began active practice as a DBA in 2003.Since that time, he has focused his attention on best practices for both developers and DBA’s to strike a balance between each discipline and find the best solutions for scalable, enterprise applications.
 
 
 
Keynote - Roger Doherty (Microsoft) - "SQL Server on a Windows Azure Virtual Machine"
 
 
 
Abstract: Did you know you can deploy SQL Server on Windows Azure Virtual Machines and use it to power your cloud based applications or extend your on-premise network to the cloud? In this session Roger Doherty will discuss this exciting new capability and how you can leverage compute, storage and networking infrastructure in Windows Azure to deliver database and BI solutions without having to deploy your own server hardware.
 
 
Bio: Roger joined Microsoft in 1991 from Sybase, Inc. as a SQL Server trainer for Microsoft University. Since then he has filled a variety of roles including pre-sales Systems Engineer for Microsoft Federal in Washington DC, Software Design Engineer for Windows Server, Technical Evangelist and Program Manager. In his current role Roger focuses on driving adoption of SQL Server and Windows Azure with customers and partners worldwide. A graduate of Drexel University, Roger is a native Philadelphian and enjoys mountain biking with his family and searching for an edge in games of chance.
January Phila SQL Server Users Group (PSSUG) Meeting
Location: Microsoft Malvern Office
45 Liberty Blvd

Malvern, PA


Wednesday, January 9th, 5:30 - 8:30pm
 

 

 Meeting Agenda:

1st Session - The SQL Clinc
 
During this session we are going to work on a real world problem together. Everyone can attend and bring a problem or question. We will pick one or two during the session to resolve. During this process you can learn how to troubleshoot a problem like this. What techniques are appropriate, what DMVs might help and so on. At the end of the session we will have an answer for the selected question or at least a direction of things to try next.
 
If you have a problem that you would like to be solved, bring it to the session with as much detail as possible. If your company allows, we can connect to your test system (or even prod) live and troubleshoot right there. For this session to be effective, we need enough information about the problem.Bring as much information as you can. Take this list as a starting point:
 
- if you have a slow query, bring the XML execution plan of all statements in question. The actual plan is preferred.
- if you need help writing a query, bring a script to create the tables involved and maybe some example data together with expected results
- if you need help with indexing, bring
- the query itself.
- a problem description and requirements (does not need to be written down, but would be helpful)
 
We also need a one sentence description of the problem that we can use in the selection process at the beginning of the session.
 

Bio: Sebastian Meine, PhD - Sebastian is the SQL Stylist at sqlity.net llc (http://sqlity.net). He founded sqlity.net in 2010 to fully engage in his passion for SQL Server. Sebastian provides training and consulting services. He specializes in T-SQL Test Driven Development (TDD) and performance tuning and shares his knowledge regularly with audiences world-wide through his writings and speaking engagements. Sebastian is also the CTO of TSTS Inc, a company that provides online personalized training and workout solutions.\

After receiving his PhD in Computer Science, Sebastian moved to the United States to begin his career as a software developer for a global Fortune 50 company. He quickly rose to the role of software architect, functioning as a SQL performance and TDD expert, assuming responsibility for the code quality and performance of dozens of large-scale database installations nationwide. 

 
 
 
Keynote - Muthu Ramathan (Microsoft) - Performance Tuning Made Easy

Abstract: SQL Server is a developer platform. The experience you get from this platform depends on how you leverage the platform. In this interactive session, we will talk about some live performance scenarios including CPU starvation, High Memory consuming Queries, SQL Server Cache Stores, I/O Intensive Queries by walking through some live examples. This will be all examples, few slide interactive session that talks about SQL Server performance tuning, using some of the native tools that comes out of the box. We will finish by getting into SQL Server 2012 Architecture enhancements and if time permits, to Extended Events introduction and how better troubleshooting gets in SQL 2012 and .NET 4.5.

Bio: Muthu Ramanathan, currently working as a Dedicated SQL Engineer @ Microsoft, he has been with Microsoft for little under 5years, dealing with Microsoft’s Premier customers and acting as a trusted advisor. He has been working with SQL Server since version 4.2 for over 15 years, when SQL shared very similar characteristics as Sybase.

Right from his college days, he had a passion for Databases. His college project of showcase is a prototype RDBMS that was built using “file locking” mechanism. Though it had some concurrency restrictions, the product is still in production in a small manufacturing industry.

 
 

 

 January South Jersey SQL Server Meeting

 
Location: Haddon Heights Public Library
608 Station Ave
Haddon Heights, NJ 08035

Tuesday, January 22rd, 5:30 - 8:30pm
 
*
*

Meeting content

-------------------------------------------------------------------------------

 

The next meeting of the SJ Division of PSSUG will be Tuesday Jan 22rd 5:30PM –8:30PM

Haddon Hts Library, Haddon Hts, NJ

 

Stacia Misner: DataInspirations.com Inspiring Intelligence from Information 702.561.7118

Tabular versus Multidimensional: May the Best Model Win

Are multidimensional models dead on arrival? Are tabular models the future of analysis? What are the similarities and differences between these two approaches to analytical modeling available in SQL Server 2012 Analysis Services? We’ll explore the pros and cons of each type of model and review how to select the appropriate model for your analytical requirements.

 

Bio: Stacia Misner is a consultant, trainer, and author specializing in Microsoft business intelligence (BI) solutions since 1999. Stacia has written 13 books about BI and is a contributing editor of SQL Server Pro magazine. She is also a Microsoft SQL Server MVP, SSAS Maestro, MCITP, and MCTS.

 

Sebastian Meine: PhD http://sqlity.net Quality for SQL 832-377-5489

Presentation Materials: 5 Key Points for Effective T-SQL Unit Testing

In this session we are going to look at the five things you need to know when starting to unit test your T-SQL code. After attending the session you will know how to pick a good unit testing framework, how to write your first test, how to spy on procedures, how to fake tables and how to deal with constraints. We will also briefly cover test case heuristics that help with these questions: "How do I pick the first test?" and "How many tests is enough?"

 

Bio: Sebastian is the SQL Stylist at sqlity.net llc. He founded sqlity.net in 2010 to fully engage in his passion for SQL Server. Sebastian provides training and consulting services. He specializes in T-SQL Test Driven Development (TDD) and performance tuning and shares his knowledge regularly with audiences world-wide through his writings and speaking engagements. Sebastian is also the CTO of TSTS Inc, a company that provides online personalized training and workout solutions.

 

February Phila SQL Server Users Group (PSSUG) Meeting
Location: Microsoft Malvern Office
45 Liberty Blvd
Malvern, PA

Wednesday, February 13th, 5:30 - 8:30pm

 

 

 

*** This meeting will be one of two meetings in a dual meeting of PSSUG and PBIUG at Micrososoft ***

 

 

 

Meeting Agenda:
 
Short Session - The SQL Clinc
 
 
As a part of an ongoing clinic for every meeting, bring your questions / problems to the meeting. If you have a problem that you would like to be solved, bring ias much detail as possible. For this session to be effective, we need enough information about the problem.Bring as much information as you can. Take this list as a starting point:
 
- if you have a slow query, bring the XML execution plan of all statements in question. The actual plan is preferred.
- if you need help writing a query, bring a script to create the tables involved and maybe some example data together with expected results
- if you need help with indexing, bring
- the query itself.
- a problem description and requirements (does not need to be written down, but would be helpful)
 
 
 
 
 
First Session - Joe D'Antoni - new features in Clustering for Windows 2012
 
Bio: Joe D'Antoni is a DBA with over a decade of experience working in both Fortune 500 and smaller firms. He is currently working at Comcast. He holds a BS in Computer Information Systems from Louisiana Tech University, and a MBA from North Carolina State University. He is the Vice President of the Philadelphia SQL Server Users Group, and a member of the board of the SQL/Oracle and Health Care PASS VCs. Joe is a frequent speaker a local user groups, Code Camps, and SQL Saturdays
 
 
-------------
 
 
Break / Networking with PBIUG
 
 
-------------

Keynote - Alex Grinberg - "SQL Server Internal source safe"

Abstract: In this presentation, we will demonstrate how to use DDL trigger to track the changes to your Database schema.

 

Bio: Alex has more than 15 years IT experience. His primary focus is with the latest Microsoft technologies including .NET (VB and C#), SSRS, SSIS. He provides tuning, optimization, analysis and development service creating new applications, converting legacy technologies (SQL Server, VB.NET and C# ) and one site training. He has worked for the CSC, VerticalNet, Insurance Data Processing, LSAC to name a few and is currently working with Aspect Consulting, Inc. Alex is PSSUG board member and guest author for SQLServerSentral.com.

 

 

 

March Phila SQL Server Users Group (PSSUG) Meeting
 
Location:
The Reinvestment Fund, Inc
1700 Market St., 19th Floor,
Philadelphia, PA 19102
 
(Regional Rail and parking lots available - see end of announcement)
(this is a secure building - you will need to register for this meeting)
Wednesday, March 13th, 5:30 - 8:30pm
 
Reminder: SQL Saturday will be on June 1st at Microsoft (go to http://www.sqlsaturday.com/200/eventhome.aspx for info and to register).
Meeting Sponsor is: TBD
 
Meeting Sessions:

1st Session: Sharon Dooley- SQL 2012 Contained Databases

Abstract: TBD
 
Bio: Sharon has worked with SQL Server since its first release. Her major areas of specialization are database design and performance tuning, though she also does a lot of administration. She has a consulting practice and teaches and writes courses for Learning Tree International, where she is SQL Server Curriculum Manager. Ms. Dooley is the author of SQL Server 7.0 Essential Reference (New Riders), the lead author of Professional SQL Server 6.5 Administration (Wrox Press). Sharon is an active member of PASS (The Professional Organization for SQL Server) and has presented at numerous conferences. She was named a Microsoft MVP in 2001 and was an MVP for SQL Server until 2004. In her spare time, she enjoys being bossed around by her three cats.
 
2nd Session: Dominic Falso - "Intro to Spatial Data Processing"
 
Abstract: TBD
 
BIO: Dominic is the Database Developer with The Reinvestment Fund in Center City Philadelphia. He has studied OO programming since 1995 and database software since 1999 (SQL Server since 2001). He currently works with SQL Server 2008 R2 and .NET C#, doing data analysis and manipulation, as well as writing code management software. In his spare time, he takes studies Chinese Acrobatics and Tightwire at the Philadelphia School of Circus Arts in Germantown.
 
 
Transporation Information:
 
Region Rail - Septa Suburban Station (approximately 2 blocks away). - www.septa.org
 
Parking:
Parkway Parking Garage (Broad & Race Streets)
150 N. Broad Street
Philadelphia, PA 19102
(215) 569-8400

Gateway Parking Garage (16th & Spring Streets)
1550 Vine Street
Philadelphia, PA 19102
(215) 246-0300 ‎
 

 

April Phila SQL Server Users Group (PSSUG) Meeting

Location: Microsoft Malvern Office
45 Liberty Blvd
Malvern, PA
Wednesday, April 10th, 5:30 - 8:30pm

 

 

 

 

Meeting Agenda:
 
Short Session - The SQL Clinc
 
As a part of an ongoing clinic for every meeting, bring your questions / problems to the meeting. If you have a problem that you would like to be solved, bring ias much detail as possible. For this session to be effective, we need enough information about the problem.Bring as much information as you can. Take this list as a starting point:
- if you have a slow query, bring the XML execution plan of all statements in question. The actual plan is preferred.
- if you need help writing a query, bring a script to create the tables involved and maybe some example data together with expected results
- if you need help with indexing, bring
- the query itself.
- a problem description and requirements (does not need to be written down, but would be helpful)
 
 
 
 
First Session - Kevin Howell
 
Topic: SQL Server Monitoring: DBA Lifesaver
 
Abstract: SQL Server Monitoring: DBA Lifesaver - Have you ever had your database server come to a unexplainable stop, or been asked to identify database issues long after they have gone away? Would you like to be able to identify substantial server or database issues well before they become critical? We'll dive into the art of SQL Server monitoring and explore the advantanges of using tools - such as SQL Sentry - to perform these essential tasks. SQL Sentry Performance Advisor, Event Manager & Plan Explorer will be demonstrated to provide insights about database performance and identify issues impacting your server.
Bio: Kevin Howell is a .NET Developer and SQL Server DBA for USLI (United States Liability Insurance Group) in Wayne, PA where he concentrates on driving SQL performance, security and integrity initiatives, along with leading development efforts on various .NET projects.Kevin started programming in Fortran and C++, then moved to Visual Basic and began developing full n-tier applications for the medical and insurance sectors.Kevin began working with SQL Server in 1999 (v6.5) and began active practice as a DBA in 2003.Since that time, he has focused his attention on best practices for both developers and DBA’s to strike a balance between each discipline and find the best solutions for scalable, enterprise applications.
 
 
 
Keynote Session - Mark Scott (Microsoft)-
 
Topic: The Power of Business Analytics3
Abstract: Microsoft SQL Server provides a Business Intelligence stack that leads the industry, according to Gartner. With the new options in SQL Server Analysis Services, Multidimensional , Data Mining, Tabular and PowerPivot, it becomes more important to know which model of analysis services to use, and how to maintain those databases. This session will provide field proven guidance on how to select the appropriate model for SSAS for your individual needs. It will cover the security and operational considerations for each model. Attendees should, by the end of the session, have a framework for choosing the correct SSAS mode and have a basic understanding of the key elements in installing and maintaining those OLAP cubes.
 
Bio: Mark D. Scott is a senior consultant for Microsoft Consulting Services. He develops multi-tier, data-centric web applications. He implements a wide variety of Microsoft-based technologies, with special emphasis on SQL Server and Analysis Services. He is a Microsoft Certified System Engineer + Internet, Solution Developer, Database Administrator and Trainer. He holds A+, Network + and CTT+ certifications from COMPTIA. Mark has also written a number of books and articles. He has co-authored the MSDE Bible, eCommerce for Dummies, Professional Data Warehousing Using Microsoft SQL Server 2000 and Analysis Services, Special Edition Using Commerce Server 2002 and other books. He regularly writes articles for technical publications and speaks at national conferences. He has also written courses and conducted national tours for Microsoft and a variety of other organizations.

 

April South Jersey SQL Server Meeting

 Location: Haddon Heights Public Library
 608 Station Ave
 Haddon Heights, NJ 08035

  Tuesday, April 23rd, 5:30 - 8:30pm     
 
 
 


The next meeting of the SJ Division of PSSUG will be on Tuesday Apr 23rd 5:30PM – 8:30 PM at the Haddon Hts Library, 608 Station Ave,  Haddon Hts, NJ 08035
 
Sponsored by SIOS Technology (http://us.sios.com)
 
Dave Bermingham of SIOS, Microsoft Clustering MVP, will make as short presentation during dinner that examines SANLess SQL Server performance and availability options for both on premise and in the Amazon EC2 Cloud.  You'll learn how to accelerate SQL Server and achieve maximum uptime and data protection for mission critical workloads like SQL, SharePoint, Lync, Dynamics - without costly and complex shared storage.
 
 
 
PRESENTER: Hilary Cotter
 
PRESENTATION:  How to stress test your SQL Server or how high can we go?
 
Frequently in your career as a dba you will be asked to prove that your SQL Server can support a certain increase in workload, or asked to determine how many users your SQL Server can support.
 
 In this talk SQL Server MVP Hilary Cotter shows you how to come up with a realistic number that you can have confidence in. Not only will you arrive at a number, but you will know what your limitations are, and can frequently come up with ways to address your current bottlenecks and increase throughput without throwing hardware at your performance problems.

 BIO:  SQL Server MVP Hilary Cotter is a 20 year IT veteran who has answered over 20,000 questions on the forums. Some of them correctly. He specializes in high availability technologies, performance tuning, and full text search. He has been a SQL Server MVP for 12 years now.

 
 
PRESENTER: Bill Emmert - Microsoft
 
PRESENTATION:  Microsoft provides a variety of tools, Microsoft Excel and Excel Services, Microsoft PowerPivot, Microsoft SQL Server Reporting Services (including Power View), and Microsoft SharePoint PerformancePoint Services so customers can address a broad range of reporting and analytics needs. During this presentation, I will provide a brief look at these tools and cover when to use what for self-service reporting, data mashups, professional reporting, dashboards, and scorecards.
 
 BIO:  Bill Emmert is the Technical Director and SQL\BI Architect in the Philadelphia Microsoft Technology Center (MTC). He started his career at Microsoft in 1998 in Consulting Services focusing on design, development, testing, deployment and troubleshooting SQL Server OLTP and OLAP solutions. In 2007, Bill worked on the SQL Server product group for 1 year as a member of the SQL Server Customer Advisory Team (SQLCAT) returning back to consulting in 2008. In 2010 he worked in the New York MTC as a SQL Architect before taking on his current roles in the Philadelphia MTC
 

 

May Phila SQL Server Users Group (PSSUG) Meeting
 

Location: Microsoft Malvern Office
45 Liberty Blvd
Malvern, PA
Wednesday, May 8th, 5:30 - 8:30pm





Meeting Agenda:


Short Session - The SQL Clinc


- As a part of an ongoing clinic for every meeting, bring your questions / problems to the meeting. If you have a problem that you would like to be solved, bring ias much detail as possible. For this session to be effective, we need enough information about the problem.Bring as much information as you can. Take this list as a starting point:

- if you have a slow query, bring the XML execution plan of all statements in question. The actual plan is preferred.

- if you need help writing a query, bring a script to create the tables involved and maybe some example data together with expected results

- if you need help with indexing, bring

- the query itself.

- a problem description and requirements (does not need to be written down, but would be helpful)


First Session - Joe D'Antoni

Topic: Using Compression to Improve Database Performance

Back in the old days, compression and databases was a really bad idea. Now, with powerful CPUs we can use to both improve performance and save disk space. We will cover the basics of how all compression and deduplication works, and then we will learn how SQL Server page and row compression work, and the special compression that is used in SQL 2012 Columnstore Indexes. We will demo performance and space savings in using compression.

Bio: Joe D'Antoni is a frequent speaker at SQL Saturday events. He is a SQL Server Architect at Comcast in West Chester, Pennsylvania with 10+ years of experience working on a wide variety of database platforms. His specialties include DR, HA and Virtualization

Keynote Session - Hilary Cotter

Topic: Stress testing SQL Server

How high can we go? Frequently in your career as a DBA you will be asked how much load can your SQL Server support. In this session, SQL Server MVP Hilary Cotter, shows you how to Microsoft tools to stress test your application and determine what your bottlenecks are and how high you can ramp up your workload.


Session Level: Advanced


Bio: SQL Server MVP Hilary Cotter is a 20 year IT veteran who has answered over 20,000 questions on the forums. Some of them correctly. He has worked on some of the largest and challenging SQL Server topologies in the world. He has been a SQL Server MVP for 12 years now
 

July Phila SQL Server Users Group (PSSUG) Meeting
 Location: Microsoft Malvern Office

Room - Envisioning Center (1st Floor)
45 Liberty Blvd
Malvern, PA
Wednesday, July 10th, 5:30 - 8:30pm

 
 

Meeting Agenda:


Short Session - The SQL Clinc


- As a part of an ongoing clinic for every meeting, bring your questions / problems to the meeting. If you have a problem that you would like to be solved, bring ias much detail as possible. For this session to be effective, we need enough information about the problem.Bring as much information as you can. Take this list as a starting point:

- if you have a slow query, bring the XML execution plan of all statements in question. The actual plan is preferred.

- if you need help writing a query, bring a script to create the tables involved and maybe some example data together with expected results

- if you need help with indexing, bring

- the query itself.

- a problem description and requirements (does not need to be written down, but would be helpful)


First Session - Vince Napoli
 
Topic:Output Clause vs Triggers

One do you use one over the other? Let's put the Output clause and triggers up against each other head to head to identify good practices on how and to use each and then one over the other. In the session, I will show you how to use each feature, techniques on where to use, and then compare the strength and weakness of against each other.

 

Bio: Vince is a Business Intelligence Architect and Senior SQL Server DBA with Anexinet in Blue Bell. He has worked with Data warehousing and Business Intelligence since 1996, with a focus and specialty on SQL Sever since 1999, and an Business Intelligence Architect since 2001. Vince is a frequent presenter at PSSUG, and has been a SQL Saturday and Code camp presenter in the philadelphia area
 
 
 
Keynote Session - Alex Grinberg / Said Salomon
 
Topic: Efficent table design
 
We will go over efficient table's design issues. FILLFACTOR, how improper usage of this property could hurt storage or performance plus other considerations.
 
Bio: Alex has more than 15 years IT experience. His primary focus is with the latest Microsoft technologies including .NET (VB and C#), SSRS, SSIS. He provides tuning, optimization, analysis and development service creating new applications, converting legacy technologies (SQL Server, VB.NET and C# ) and one site training. He has worked for the CSC, VerticalNet, Insurance Data Processing, LSAC to name a few and is currently working with Aspect Consulting, Inc. Alex is PSSUG board member and guest author for SQLServerSentral.com.
 
Bio: Said Salomon has over 25 year experience as an Information Technology Professional. I have a vast array of abilities in the field in the areas of: Network, Desktop Support, DBA, Staff Project Management, Application Software Development, Business Analysis and Quality Assurance. Said carries Microsoft certifications as a MCTS, MCPS, and MCNPS, and multiple certifications from the Insurance Institute of America.
*

 

 

 

August PSSUG Center City Meeting
Location:
 
American College of Physicians
Rm - Board Room
190 North Independence Mall W,
(corner of 6th and Race Streets, at the foot of Benjamin Franklin bridge)
Philadelphia, PA
(Regional Rail and parking lots available - see end of announcement)

Tuesday, August 6th, 5:30 - 8:30pm

  

 

 

(Important this is a secure building - you will need to register for this meeting by noon on August 6th for admision to the meeting location for their security dept - contact Dominic Falso directly atdfalso@gmail.com if you missed the deadline and wishing to attend)

 

 
 
Meeting Sessions:
 

1st Session:  Sebastian Meine - "Five Secret MERGE Patterns"

 
Abstract:  The MERGE statement was introduced into the SQL Standard with SQL2003 and into SQL Server with version 2008. SQL Server goes far beyond the standard and implements the MERGE statement as a very powerful combination of the three statements INSERT, UPDATE and DELETE.  
In this talk I am going to show five use cases that you might not have thought of before. We will also cover some issues that you must be aware of to avoid problems when using the MERGE statement.
 

Bio: Sebastian is the SQL Stylist at sqlity.net llc (http://sqlity.net). After receiving his PhD in Computer Science at the University of Linz, Austria he spent several years at a global Fortune 50 company as software architect responsible for code quality and performance of dozens of large-scale database installations nationwide.

In 2010, to fully engage in his passion for SQL Server, he founded sqlity.net. Since that time he has been helping his clients to boost their SQL Server health, enhance their T-SQL coding skills and tighten their SQL Server security.

Sebastian is a sought-after trainer, speaker and author who shares his knowledge regularly within the world-wide SQL community through his writings and public speaking engagements. Additionally he is coauthor of tSQLt, the Database Unit Testing Framework for SQL Server. tSQLt is open source and available at http://tSQLt.org.

Sebastian is also the CTO of TSTS Inc., a company that provides online personalized training and workout solutions.

 

 
 
2nd SessionSharon Dooley- What’s New and Cool in SQL Server 2014

 

Abstract: While I really think I am too old to deal with yet another release of SQL Server, I can’t resist the temptation to dig into it. What’s particularly intriguing are some new features that will enhance OLTP performance! It’s so great that Microsoft has finally put some things in the engine that will benefit those of us who labor in the mundane Order Entry, etc. trenches. This presentation will look at some of the new features. It will concentrate on new database engine features. There may be demos. That depends on 1) my getting 2014 onto a VM and b) whether anything cool works!

 

Bio: Sharon has worked with SQL Server since its first release. Her major areas of specialization are database design and performance tuning, though she also does a lot of administration. She has a consulting practice and teaches and writes courses for Learning Tree International, where she is SQL Server Curriculum Manager. Ms. Dooley is the author of SQL Server 7.0 Essential Reference (New Riders), the lead author of Professional SQL Server 6.5 Administration (Wrox Press). Sharon is an active member of PASS (The Professional Organization for SQL Server) and has presented at numerous conferences. She was named a Microsoft MVP in 2001 and was an MVP for SQL Server until 2004. In her spare time, she enjoys being bossed around by her three cats.

 
Transporation Information:
 
Region Rail - Septa Market East Station (approximately 5 blocks away).
 
 
Parking: Do not park at the Consititution center - lot closes at 6:00.
 
In front of the building and down 6th street one block: Independence Visitor Center Parking Garage Enter from 6th Street between Arch Street and Market Street. For hours and rates, visit the IVC websitehttp://philapark.org/garages/Independence-mall
 
Behind the building and up Arch street one block: 8th and Arch Streets : http://www.parkwaycorp.com/index.php?id=106

 

September Phila SQL Server Users Group (PSSUG) Meeting

                          Location:  Microsoft Malvern Office
Room MPR II
45 Liberty Blvd
Malvern, PA
Wednesday, September 11th, 5:30 - 8:30pm    

 

 

*** New way to get to Malvern via PA Turnpike exit 320 (ezpass only) at Rt 29:   Opened this past December:  http://www.paturnpike.com/constructionprojects/r29ramp/  .    An alternative to using US202.  

http://www.mainlinemedianews.com/articles/2012/12/12/main_line_suburban_life/news/doc50c7b9ccd18c8801586698.txt ***  

 

 

Meeting Agenda:
 
Short Session - The SQL Clinc
As a part of an ongoing clinic for every meeting, bring your questions / problems to the meeting.  If you have a problem that you would like to be solved, bring ias much detail as possible.  For this session to be effective, we need enough information about the problem.Bring as much information as you can. Take this list as a starting point:
 
- if you have a slow query, bring the XML execution plan of all statements in question. The actual plan is preferred.
- if you need help writing a query, bring a script to create the tables involved and maybe some example data together with expected results
- if you need help with indexing, bring
- the query itself.
- a problem description and requirements (does not need to be written down, but would be helpful)
 
 
First Session - Sebastian Meine-
Topic: TBD
 
Abstract:   TBD
 
Bio: Sebastian is the SQL Stylist at sqlity.net llc (http://sqlity.net). After receiving his PhD in Computer Science at the University of Linz, Austria he spent several years at a global Fortune 50 company as software architect responsible for code quality and performance of dozens of large-scale database installations nationwide.

In 2010, to fully engage in his passion for SQL Server, he founded sqlity.net. Since that time he has been helping his clients to boost their SQL Server health, enhance their T-SQL coding skills and tighten their SQL Server security. 

Sebastian is a sought-after trainer, speaker and author who shares his knowledge regularly within the world-wide SQL community through his writings and public speaking engagements. Additionally he is coauthor of tSQLt, the Database Unit Testing Framework for SQL Server. tSQLt is open source and available at http://tSQLt.org.

Sebastian is also the CTO of TSTS Inc., a company that provides online personalized training and workout solutions.

 
 
Keynote Session - Mark Scott (Microsoft) 
 
Topic: Building a Business Intelligence Enclave
 
 
Abstract:   Business Intelligence solutions have a way of growing in unexpected and unpredictable ways. Microsoft’s comprehensive suite of Business Intelligence tools allows for the wide range of capabilities required. The trick is to build a flexible server infrastructure that can deploy services as required and balance the allocation of resources across those services to meet the changing needs of the business quickly. This session will examine a field-tested infrastructure that allows databases, analytical servers, ETL, reporting and data quality services to be deployed quickly on demand. Using Microsoft’s Hyper-V technology and server monitoring tools, the enclave allows the administration team to allocate CPU, memory and disk resources to provide the maximum return on investment in the server infrastructure and do the best job at meeting the service level agreements for the hosted solutions.
 
Bio:   Mark D. Scott is a senior consultant for Microsoft Consulting Services. He develops multi-tier, data-centric web applications. He implements a wide variety of Microsoft-based technologies, with special emphasis on SQL Server and Analysis Services. He is a Microsoft Certified System Engineer + Internet, Solution Developer, Database Administrator and Trainer. He holds A+, Network + and CTT+ certifications from COMPTIA. Mark has also written a number of books and articles. He has co-authored the MSDE Bible, eCommerce for Dummies, Professional Data Warehousing Using Microsoft SQL Server 2000 and Analysis Services, Special Edition Using Commerce Server 2002 and other books. He regularly writes articles for technical publications and speaks at national conferences. He has also written courses and conducted national tours for Microsoft and a variety of other organizations.
 
 

October Phila SQL Server Users Group (PSSUG) Meeting

                          Location:  Microsoft Malvern Office
Room MPR II
45 Liberty Blvd
Malvern, PA
Wednesday, October 9th, 5:30 - 8:30pm    

 

 

*** New way to get to Malvern via PA Turnpike exit 320 (ezpass only) at Rt 29:   Opened this past December:  http://www.paturnpike.com/constructionprojects/r29ramp/  .    An alternative to using US202.  

http://www.mainlinemedianews.com/articles/2012/12/12/main_line_suburban_life/news/doc50c7b9ccd18c8801586698.txt ***  

 

 

Meeting Agenda:
 
Short Session - The SQL Clinc
As a part of an ongoing clinic for every meeting, bring your questions / problems to the meeting.  If you have a problem that you would like to be solved, bring ias much detail as possible.  For this session to be effective, we need enough information about the problem.Bring as much information as you can. Take this list as a starting point:
 
- if you have a slow query, bring the XML execution plan of all statements in question. The actual plan is preferred.
- if you need help writing a query, bring a script to create the tables involved and maybe some example data together with expected results
- if you need help with indexing, bring
- the query itself.
- a problem description and requirements (does not need to be written down, but would be helpful)
 
 
 
First Session - Joe D'Antoni -
Topic: Into the Blue: Extending AlwaysOn Availability Groups
 
Abstract:   For many organizations, having a second data center or co-location center doesn’t make sense, financially or logistically. Typically, this would limit options for building out a disaster recovery (DR) solution. However, now with Windows Azure virtual machines and SQL Server AlwaysOn Availability Groups, you can connect your on-premise solution to a real-time secondary replica, providing read scalability and a solid DR solution.
This session will demonstrate how to extend an Availability Group into Windows Azure, discussing the pros and cons as well as the cost of the solution. You will walk away with a solid understanding of AlwaysOn functionality within Windows Azure VMs, the costs and benefits of building a DR solution within Windows Azure, and how Azure-based backup and recovery can work.
 
Bio:  Joseph D'Antoni is an Architect with over a decade of experience working in both Fortune 500 and smaller firms. He is currently solutions architect for SQL Server and Big Data for Anexinet in Blue Bell, PA.  He holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University.   Joey is the vice president of the Philadelphia SQL Server Users Group and a member of the board of PASS's SQL/Oracle and Healthcare Virtual Chapters. He is a frequent speaker at local user groups, Code Camps, and SQLSaturday events

 

 
Short Session - Tom Marshall (first time speaker)
 
Topic: Transactional Replication
 
Bio:
 
 
 
Keynote Session - Kevin Goff
 
Topic: Tsql for developers....attendees chose examples
 
 Abstract:  Aattendees chose examples Power tips for SSRS...attendees choose examples SSAS OLAP vs SSAS tabular Practical considerations for the Kimball Model...implementations in SQL server
 
Bio:  Kevin S.  Goff is a Microsoft SQL Server MVP, Columnist for Component Developer (CoDe) Magazine. He is also SQL Server/Business Intelligence Practice Manager and Instructor, SetFocus LLC (Certified Gold Partner for Microsoft Learning Solutions) He is a well known Industry developer/speaker/writer since 1987.

 

November Center City SQL Meeting
 
Location:  
 
DMi Partners
 One South Broad St
11th Floor
Philadelphia, PA 19107
 
(Regional Rail and parking lots available - see end of announcement)

Tuesday, November 5th, 5:30 - 8:30pm     

   

 

(Important - this is a secure building - you will need to register for this meeting by noon on November 5th for admision to the meeting location for their security dept - contact Dominic Falso directly at dfalso@gmail.com if you missed the deadline and wishing to attend)

 

 
 
Meeting Sessions:
 
 
Short Session - The SQL Clinc
 
As a part of an ongoing clinic for every meeting, bring your questions / problems to the meeting.  If you have a problem that you would like to be solved, bring ias much detail as possible.  For this session to be effective, we need enough information about the problem.Bring as much information as you can. Take this list as a starting point:
 
- if you have a slow query, bring the XML execution plan of all statements in question. The actual plan is preferred.
- if you need help writing a query, bring a script to create the tables involved and maybe some example data together with expected results
- if you need help with indexing, bring
- the query itself.
- a problem description and requirements (does not need to be written down, but would be helpful)
 
 

1st Session:  Sebastian Meine - "Using the Cross Apply"

  

Bio: Sebastian is the SQL Stylist at sqlity.net llc (http://sqlity.net). After receiving his PhD in Computer Science at the University of Linz, Austria he spent several years at a global Fortune 50 company as software architect responsible for code quality and performance of dozens of large-scale database installations nationwide.

In 2010, to fully engage in his passion for SQL Server, he founded sqlity.net. Since that time he has been helping his clients to boost their SQL Server health, enhance their T-SQL coding skills and tighten their SQL Server security. 

Sebastian is a sought-after trainer, speaker and author who shares his knowledge regularly within the world-wide SQL community through his writings and public speaking engagements. Additionally he is coauthor of tSQLt, the Database Unit Testing Framework for SQL Server. tSQLt is open source and available at http://tSQLt.org.

Sebastian is also the CTO of TSTS Inc., a company that provides online personalized training and workout solutions.

 

 
 
2nd Session:  Hilary Cotter -  Performance Tuning

 

Bio: SQL Server MVP Hilary Cotter is a 20 year IT veteran who has answered over 20,000 questions on the forums. Some of them correctly. He has worked on some of the largest and challenging SQL Server topologies in the world. He has been a SQL Server MVP for 12 years now

 
 
 
 
Transporation Information: 
 
Region Rail - Septa Market East and Suburban Stations
  
Parking:   
 
Central Parking Corporation
1601 Market St #1050
Philadelphia, PA 19103

J & L Parking Corporation
1744 Market St
Philadelphia, PA 19103
 

November Phila SQL Server Users Group (PSSUG) Meeting

                          Location:  Microsoft Malvern Office
Room MPR II
45 Liberty Blvd
Malvern, PA
Wednesday, November 13th, 5:30 - 8:30pm    

 

 

*** New way to get to Malvern via PA Turnpike exit 320 (ezpass only) at Rt 29:   Opened this past December:  http://www.paturnpike.com/constructionprojects/r29ramp/  .    An alternative to using US202.  

http://www.mainlinemedianews.com/articles/2012/12/12/main_line_suburban_life/news/doc50c7b9ccd18c8801586698.txt ***  

 

 

Meeting Agenda:
 
*** Speakers wanted for Short sessions *** 
 
Short Session - The SQL Clinc
As a part of an ongoing clinic for every meeting, bring your questions / problems to the meeting.  If you have a problem that you would like to be solved, bring ias much detail as possible.  For this session to be effective, we need enough information about the problem.Bring as much information as you can. Take this list as a starting point:
 
- if you have a slow query, bring the XML execution plan of all statements in question. The actual plan is preferred.
- if you need help writing a query, bring a script to create the tables involved and maybe some example data together with expected results
- if you need help with indexing, bring
- the query itself.
- a problem description and requirements (does not need to be written down, but would be helpful
 
 
 
 
Short Session - Vendor short session
 
 
 
 
Speaker Contest: 
 
This is a night of short segments by multiple individuals.   It is geared towards to new individuals to provide folks the opportunity to present.    Sessions are only 15-20 minutes long to give as many individuals a chance to present and not be overwhelmed by the material required to be put together for a full session.    
 
 
Speaker 1 - Chuck Kruelle  - SSAS - Data mining using Tables and|or views.  I will demo Brian McKnights Demo from Pass2013
Speaker 2 - Bob Blackburn - Performance Tuning SSIS
Speaker 3 - Said Salomon - DBA Tips and Tricks (top 5 secrets)
Speaker 4 - Joe D'Antoni - What Not To Do When You Install SQL Server
Speaker 5 - Mark Fink - How I download FTP Files
 
 
 

 

Back to Top