Central New Jersey SSUG

Meeting Archive

 

SQL DBA day at Microsoft Ofiice , NYC.  May 19, 2015

Register here

https://www.eventbrite.com/e/emc-nyc-sql-solution-day-tickets-16498455324

 

The next meeting of the Central NJ SQL Server Users Group will be on Wednesday June 10, 2015 at 6:00.  We are welcoming back Kevin Goff.  Last time he spoke, it was very difficult to attend because of usual traffic caused by an accident.

We also apologize for canceling last month at the last minute.

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 Microsoft Sharepoint partner -

http://www.sohodragon.com/


 

 

LOCATION & TIME

Microsoft office

101 Wood Avenue South,

Suite 900

Iselin (Metropark), NJ

 

·         6:00PM: Networking - Pizza and Drinks

·         6:30PM-8:30PM: Presentation and Q&A   

 

Attendees need to sign-in when entering the building with their ID’s. 

 

Please LinkedIn to us at SQLIselinNJ and join the Central NJ SQL Server User Group on LinkedIn or our website at http://cnjssug.sqlpass.org/

 

Thanks,

Linda, Divyesh, and Jaimie

 

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.

 

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.

We are pleased to announce Hilary Cotter will speak in our Central NJ SQL User Group meeting on March 12th 2014. The sponsor is Scalability

Topic: SQL Server Performance Tuning

Presenter: Hilary Cotter

Presentation File: SQL Server Performance Tuning (03122014).zip

Bio:

 Hilary Cotter has been a SQL Server MVP for 13 years now. He specializes in replication, and other HA solutions, Full-Text Search, Service Broker, and performance tuning. He has worked for many Fortune 500 clients on cutting edge solutions.

In "SQL Server Performance Tuning", Hilary Cotter, describes how to diagnose, troubleshoot and solve common SQL Server Performance tuning. This session will arm you with tools to do benchmarking, diagnosing, and resolving problems that you will face on most environments. You will leave this talk with an approach to performance tuning which will help you to make your SQL Servers handle greater loads on the same hardware.

 

The next meeting will be held on Feb 12th 2014

Topic: SQL Server 2014 OLTP In Memory Database

Speaker: Simon Facer

Presentation File: SQL 2014 In-Memory OLTP (02122014).zip

I'm Simon Facer, a SQL Server PFE with Microsoft for the last 3 years. I’ve been working with SQL Server, on and off, since the mid 1990’s, from SQL Server 4.21. I focus on all aspects of the core relational SQL Server engine, along with Parallel Data Warehouse (where I get to get to work with some pretty impressive hardware as well as the software). My passion at work is to help my clients understand SQL Server and its nuances, nooks and crannies, and to help them implement the right SQL Server technologies to solve their business problems in the best way possible.

 The sponsor is SolarTech.  

 

The December meeting will be held on Dec 11th 2013

Topic: SQL Azure and Windows Azure, Microsoft’s cloud Solution

 

Jim Priestley will be speaking about SQL Azure and Windows Azure, Microsoft’s cloud Solution.  Jim is an Azure Technical Solutions Professional at Microsoft who has helped many customers find success with Azure.  He has over 20 years of experience of various IT architecture and management roles.

Tableau will sponsor our food and drinks

 

The November meeting will be held on Nov 13th 2013

 

Melissa Demcsak  is the speaker.

 

 

Topic: Microsoft Power BI: Your first Roadmap
Abstract: With the introduction of Excel 2010, 2013 and Office 365, Microsoft has introduced many enhancements in the area of data mashing (combining data from diverse sources) and visualization. This presentation will provide you with an overview of Microsoft’s Self-Service Roadmap and will highlight the features below.  Please join us for a Demo filled presentation.
·        Power Pivot
·        Power Query
·        Power Map
·        Use of Publicly Available Data Sources
·        Overview of Office 365 Roadmap
Presenter: Melissa Demsak (aka @SQLDiva)
Bio: Melissa Demcsak is a Manager of SQL Architecture at Realogy.  She has a diverse background in helping organizations discover the value of their data by working with the business and technologist to achieve this goal. Melissa is also very active in the Microsoft SQL Server Community and the PASS Association (www.sqlpass.org).

 

 

 

 

The October meeting will be held on Oct 9th 2013

 

 Divyesh Sah  from Microsoft will be  presenting on SSAS : Multidimensional and Tabular Model

 

 

The September meeting will be held on September 11th 2013

 

Pam Lahoud Sr. Premier Field Engineer from Microsoft will be  presenting on Execution Plans and Query Optimization 

 

We will skip August meeting. Please attend the SQL Saturday in New York City at August 17th. It is full day free training.

 

http://www.sqlsaturday.com/235/eventhome.aspx

 

 

The July meeting will be held on July 10th 2013

 

 Martin Schoombee  will speak on ETL- SQL Server Integration Services

 Martin is a Business Intelligence Architect at Insight, and have been specializing in Microsoft BI solutons for more than 9 years

 

 

 

 

The June meeting will be held on June 12th 2013

 

 Pam Lahoud Sr. Premier Field Engineer from Microsoft will be  presenting on  SQL Server I/O internals

 

The May meeting will be held on May 7th 2013 ( Please note This meeting is on Tuesday night)

 

Brian Knight, SQL Server MVP from Pragmatic will be presenting on Ninja Data Visualization Moves

 

PowerPivot and PowerView brings with it some amazing business intelligence and data visualization enhancements. Watch how you can improve data cleansing with Excel 2013 and some of the new features integrated into Excel and the other Office tools to visualize data better than ever before. See how the new PowerPivot and PowerView features in Excel 2013 take your data to the next level of visualization. We’ll also show how you can visualize map data with GeoFlow and tie disparate data together with Data Explorer.

 

 

 

The April meeting will be held on April 10th 2013

 

Marc Jellinek from Neudesic will be presenting on  Performance Optimizations in T-SQL

 

Marc Jellinek Bio:Marc Jellinek is a Principal Consultant with Neudesic, focused on the Business Intelligence space.  He has worked with every version of SQL Server since 6.0; with experience in leveraging the strengths of the relational database, Analysis Services, Integration Services and Reporting Services.  He gained his experience working for Ernst & Young, MLB Network and Microsoft.

 

 

Special session--'Ask The Expert' :  04/13/2013 Saturday Morning

 

SQL PFE Panel for the NJ SQL User Group and Central NJ SQL User group 'Ask The Expert' session

The Microsoft PFE Panel (Premier Field Engineers for SQL Server) will answer questions from attendees .
Format:•  
    Initially pre-screened questions•    
    Questions could be on any SQL related subject.•    
    Questions could also be on PFE process in general (e.g. ‘What’s it like to be a PFE?’)•   
    Any questions relating to specific issues requiring hands-on viewing of a client system can be declined.•   
    Open floor as time allows, but questions can be declined if they fall outside what we can answer in the
 
 Location: Iselin Microsoft Office 
Date:   04/13/2013, 9am – 12pm•       
 013 Saturaday

 

Registrate on this Eventbrite site

 http://njsqlpfesaturday2013.eventbrite.com/

 

  Our March group meeting is on March 13th 2013. 
 
 
Linda Zhang, Leader of Central NJ SQL user group, will be presenting on Database Management- Disaster Recovery 
 

 

The February meeting will be held on Feb 13th 2013

Karthik Yella from Microsoft will be presenting on SQL Server 2012 Manageability Enhancements

 

The next meeting will be held on Jan 9th 2013. 

Andrew Korfin (Premier Field Engineer at Microsoft ) will be presenting on SQL Server Extended Events

 

 

 

 

The next meeting will be held on December 12th 2012.

Krishna Golla from Microsoft will be presenting on SQL Server 2012 Column Stored Indexes and Performance Enhancements

 

 

 

The next meeting will be held on November 14th 2012.

Jaimie  Fox from Microsoft will be presenting on SQL Server 2012 Business Intelligence

Pizza and Drinks will be provided

 

The first meeting will be held on October 10th 2012.

Troy Ault  from Microsoft will be presenting on SQL Server 2012 Always On

Pizza and Drinks will be provided

 

EventArchive

Meeting Archive

Back to Top