Central New Jersey SQL User Group  

Welcome to the Central New Jersey SQL Server User Group. This is a FREE group that meets every Second Wednesday of every month. We meet at the Microsoft offices in Iselin, NJ.   

 You can save $150 off 2015 PASS Summit registration by using our unique Chapter discount code: LC15NSM6


 New slides have been added

Presentation files for the past User Group sessions can be found at:

 

 

 

The April 2015 Central NJ SQL Servers Users Group meeting will be on Wed. April 15, NOT April 8.  Due to the holiday week and school schedules we have delayed the meeting by one week.

The topic will be IO and SQL Server and the speaker and sponsor will be from EMC.

More details to come.

 

 

The next meeting of the Central NJ SQL Server Users Group will be on Wednesday Mar. 11, 2015 at 6:00.

 

TOPIC

Baker's Dozen: 13 Advanced SQL Server Analysis Services tips

Join SQL Server Microsoft MVP Kevin S. Goff as he goes well beyond the
basics of creating SSAS cubes.  Along the way, I'll talk about new engine features in SQL Server 2012/2014 that can potentially help certain SSAS OLAP databases.

SPEAKER

Kevin S. Goff has been a Microsoft MVP for 11 consecutive years ( 5 years in C#/.NET and 6 years in SQL Server).   He is a SQL Server Data Warehouse/Business Intelligence consultant, author, and technical mentor.   He has utilized the "Baker's Dozen, 13 Productivity Tips" format in articles for CoDe Magazine, PASS webcasts and self-produced webcasts, and community presentations.    Check out his blog/website at 

http://www.KevinSGoff.net

, and contact him at

kgoff@kevinsgoff.net

.  Kevin has worked in the software industry since 1987 and lives just outside
New York City.

 

SPONSOR

Soho Dragon – Leading Mcirosoft Sharepoint partner -

http://www.sohodragon.com/


 

 

 

The next meeting of the Central NJ SQL Server Users Group will be on Wednesday Feb. 11, 2015.

 Come join us for a presentation by the original creators of Master Data services.   Giveaways raffled off.

SQL Server’s Master Data Services (MDS) serves as a powerful engine for Master Data Management and serves as the core platform for Profisee’s Master Data Maestro solution.  Together, these solutions provide organizations with the tools for data quality, matching, hierarchy management, and deduplication across multiple data sources and systems. 

As a Microsoft Gold ISV partner focused on extending and adding capabilities to MDS, Profisee has empowered organizations globally to leverage their investments in SQL Server to implement enterprise-grade Master Data Management solutions. 

Profisee has an extensive and exciting legacy in the Data Management space and is made up of many of the original developers of the product that was acquired by Microsoft and made into MDS.  With this experience and expertise, Profisee is well positioned to speak to scenarios where MDS and Maestro can be used jointly to provide powerful MDM functionality while saving organizations time and money.

During this session, we will discuss how to formulate a Master Data Management strategy and build a solution to find the single version of the truth, aka the Golden Record.  We will review a sample customer domain, showing how to use various tools including for data quality, matching, and deduplication across multiple data sources.

Presenting:

Brian Benzel is Northeast Regional Director with Profisee. Profisee is the successor to the company Stratature that built the SQL Server Master Data Services (MDS) product which was sold to Microsoft in 2007. Profisee focuses on Master Data Management (MDM) and is a Microsoft Gold Partner providing solutions built on MDS and the Microsoft stack. 

Brian spent the last 20 years in various information technology positions, including 7 years at Microsoft in product sales and account management roles.

 

The next meeting of the Central NJ SQL Server Users Group will be on Wednesday Jan. 21, 2015.

The speaker is Jimmy Wong, Microsoft Program Manager-SSIS
Topic: What is new in SSIS
 
Sponsor is VersaShore.

 

 

 

 

The next Central NJ - SQL Server Users Group meeting will be on Wednesday, November 12th. 

 

The topic will be an open discussion with all in attendance with topics around Big Data, Business Intelligence, Current Trends, Performance Tuning and Careers.  Feel free to bring your own topics and ideas. We are trying something new this month.

 

Robert Half International will be sponsoring.

 

 

 

 

The next Central NJ - SQL Server Users Group meeting will be on Wednesday, October 8th. 

 The speaker is Sharon Bjeletich. Sharon is the Principal Architect for Scalability Experts, a leading data consultancy company. She has been working with SQL Server since 4.2 and has worked at The World Health Organization, Corbis, and the SQL Server Product group at Microsoft.

The topic is “SQL Server 2014 New Cardinality Estimator”

Abstract: SQL Server 2014 has added a new and enhanced cardinality estimator for the query processor engine. In this session we will go over how to use the new feature, the differences from the older estimator, and some troubleshooting tips.

 

Scalability Experts is the Sponsor.

 

 

The next meeting will be on September 10th 2014 

The speaker is Jean Joseph. Jean  has  5 years’ experience working as a SQL Server DBA and 4 years working as a developer and gained so much experience in performance turning, database and index design, manage storage, fixing production issues, creating complex SSIS packages, disaster recovery, and scripting. He is a member of our user group. We are very happy to see he starts presenting.

The topic is "HOW TO IDENTIFY DATABASE PERFORMANCE ISSUES"

In this session, He will be talking about performance turning, index design, statistics, query optimizer, parameter sniffing, data types, analyzing and understanding execution plans, wait stats, activity monitor, DMV(s). After this session you should be able to quickly identify the top performance issues of your databases.

CommVault is the Sponsor.

 

  

Location:

101 Wood Avenue South, Suite 900
Metro Park 101
Iselin, NJ 08830
 
Meeting Format
6:00PM : Networking
6:30PM-8:30PM : Presentation and Q&A

 

 

 

Group Leaders

 

Linda Zhang sqliselinnj@gmail.com

Jaimie  Fox

 Divyesh Sah

 

Volunteers

If you are interested in presenting at one of our future meetings,  please send us email sqliselinnj@gmail.com
 

Sponsors

We are currently looking for sponsors for our meetings.
Sorry, there are no upcoming meetings. Please check back for updates.