Sorry, We have to cancel May 13th meeting. Our Speaker has a family emergency.
We will let you know if we reschedule it to another day.
The next meeting of the Central NJ SQL Server Users Group will be on Wednesday May. 13, 2015 at 6:00.
Topic: SQL Performance Tuning. Inside the Scheduler and SQLOS
Speaker: James Phillips, Sr. BI Consultant Pragmatic Works
Summary: Ever wanted to know how the scheduler and SQLOS work? Wonder how you can tune performance without changing code? How does disk/ memory, processor and network play a role and how can I find out when I have a problem?
About James: James Phillips works at Pragmatic Works as a Sr. BI Consultant and has over 15 years of experience with SQL technologies with the last 10 years focused on Business Intelligence. He has worked in a wide array of industries including finance and insurance. Regularly speaks about SSIS and Power BI topics. Also an avid softball player and father to two beautiful daughters.
Sponsor: Solartech (www.solartech.us) - Microsoft Gold Training Partner
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.
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.
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
, and contact him at
. Kevin has worked in the software industry since 1987 and lives just outside
New York City.
Soho Dragon – Leading Mcirosoft Sharepoint partner -
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.
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.