SQL SG UG Meetup - May 2017

Dear All,

Singapore SQL PASS Chapter meet up for May is scheduled on May 24th ( Wednesday) at 7 PM as usual. Speaker and topic details provided below

Agenda:

May 24th - 6:45 PM to 7 PM - Registration and Snacks

7 PM to 8:15 PM - Topic 1 - Presentation by Khilitchandra Prajapati

8:15 PM to 8:30 - Break

8:30 PM to 9:15 - Topic 2 - Presentation by Dharmendra Keshari

Location: Microsoft Office, One Marina Boulevard, Conf Room SINOMB 22CF-15 (24) AV

Topic 1: Deep dive into Configuring SSIS Packages

Abstract: Configuring SSIS Packages can be a tricky problem to encounter more often than not. This session on SSIS Packages will run thro various methods in configuring SSIS packages, their pros and cons and the scenarios at which they can be applied. The Session will also cover the end to end deployment cycle of a SSIS Package and discuss package and project deployment models. The session would explain the various best practices to be followed while configuring and deploying SSIS Packages.

Speaker Profile:

Khilitchandra V. Prajapati, an Enterprise Architect (Data Warehouse & Business Intelligence) at Marina Bay Sands, Singapore. He has implemented various BI solutions in last couple of years for industries like Oil & Gas, Banking, Telecom, Insurance, Casino & Gaming, Hospitality and IT. His prime focus is on Microsoft BI Stack (SQL Server, SSAS, SSIS, SSRS) with MOSS, C#.Net. He is a MSBI enthusiast and shares his knowledge, experience & expertise via his blog (www.bigator.com)

Topic 2: TSQL Fun & Explore few real life development problem

Synopsis: In this session we will discuss real life development problem, how aggregation, grouping, and distinct functionality can influence execution plans, why multi-statement table valued function can give very degraded performance, how TOP function helps not to put extra memory pressure... there are many more things to learn.

Speaker Profile:

Dharmendra Keshari, Microsoft Data Platform MVP, has strong and in-depth experience in Database Management and its internals. Currently, working as Senior Database Administrator in one of the best organization in Singapore. He is an avid, regular mentor on social media, helping several enthusiast in solving problems related to Database management. He has completed certification for “Microsoft SQL Server® 2008, Implementation” and “Maintenance & Administering Microsoft SQL Server 2012 Database”. You can follow his blog at http://www.dharmendrakeshari.com

Meetup link: https://www.meetup.com/mssgug/events/240039288/

SQL SG UG Meetup - April 2017

Dear All,

Its meetup time again at Singapore SQL PASS Chapter. Please refer below for the details.

Agenda:

April 27th - 6:45 PM to 7 PM - Registration and Snacks

7 PM to 8 PM - Topic 1 - Presentation by Sarbjit Singh Gill

8:00 PM to 8:15 - Break

8:15 PM to 9:15 - Topic 2 - Presentation by Sakthis Kumar

Location: Microsoft Office, One Marina Boulevard, Level 22 BR-01

Topic 1: How Data Helps business execute the how of Digital Transformation.

Synopsis:

The first revolution helped humans mechanize production with steam power, followed by the second revolution which was enabled by electricity and brought on the era of mass production. The third revolution used electronics and information technology. The speed of current breakthroughs and the exponential pace of disruptive innovation now bring about a fourth industrial revolution—characterized by unprecedented processing power, storage, access to knowledge and the blurring of lines between physical, digital, and biological space. The good news is that intelligent technologies like machine learning, big data analytics and the flexibility Azure and SQL Data Platform can help with cloud computing..

Speaker Profile: Sarbjit Singh Gill

I bring 24 years of IT experience spanning consulting, architecture and training for Microsoft technologies such as Lync, Exchange, SQL Server, SharePoint, Windows Server, Active Directory, System Center range of products. I am also experienced in carrying out a Microsoft IO (Infrastructure Optimization) and Implementation of the MS MOF (Microsoft Operations Framework).Since 2005, I have been a Microsoft Most Valuable Professional (MVP) with Technical Expertise in Lync, SCOM and SharePoint.I have participated as a speaker and proctor in numerous conference and forums and co-authored a book on MS Exchange monitoring using SCOM. As a MVP, I am founder of Singapore Lync User Group and an active member of other MS Technologies User Group communities. I hold a FIA International "C" racing license and I race actively in Japan and Malaysia in touring cars endurance and club races.I am an active Scuba Diver with interest in underwater videography.

Topic 2: Azure Security – Secure your Azure SQL Assets

Synopsis:

Learn about Azure Security and how to apply Azure Security features & capabilities to secure your Azure SQL Assets

Speaker Profile: Sakthis Kumar
Sakthis, Microsoft Azure MVP has 17+ years of IT experience spanning enterprise consulting, architecting hybrid solutions using Microsoft technologies like Exchange, SharePoint, Windows Server, Directory Services, Office 365 Platform, Azure.

Meetup link: https://www.meetup.com/mssgug/events/239250326/

DataCamp 2017 - Schedule of Sessions

Dear All,

As you may be aware, we, Singapore SQL Server User Group is organizing one day free event called "Data Camp" on March 11th. The event features several MVPs, MCMs and Microsoft Professionals too. Schedule of sessions is provided below

 

Do register for the event at https://www.meetup.com/mssgug/events/236952292/

See you on March 11th!!!

Regards,

Singapore SQL Server User Group Team

Pre Conference - "Indexes – The Complete Story" - March 10th - Andreas Wolter

Dear All,
 
We are again lucky for the second time to have Mr.Andreas Wolter, MVP, MCM, MCSM from Germany deliver one day pre conference seminar on March 10th 2017. Andreas will be speaking on the topic "Indexes – The Complete Story: from pages to in-memory storage".
 

 

Limited seats available. For our Singapore SQL Server Community, we have come up with a super early bird price of just 150$. So, don't miss the chance to gain in depth knowledge from the best in the business. Please register and purchase the ticket for the event at the link provided below.

 

https://www.eventbrite.com/e/pre-conference-indexes-the-complete-story-andreas-wolter-tickets-31376543085

 
Detailed abstract of the session and speaker profile provided below:

Abstract:

This training day will introduce you to essential indexing concepts of SQL Server: How data is stored in SQL Server, and how indexes change the game. We will look at disk-based objects and also briefly at memory optimized objects to gain a complete picture of how tables can store data and how access to the data can be optimized via indexes.

 

You will learn about important concepts of indexes that one should be aware of like “when are certain indexes not considered for a query plan”, “why indexes can even considerably slow down a system”, “why memory optimized indexes are not automatically faster than disk-based indexes” and many others.

 

This is probably the first workshop ever to treat traditional page-based indexes together with Column store and even memory-objects at the same time, as valid alternatives. Don’t miss this chance to obtain an overview of which possibilities exist today in terms of table- & index-design to speed up database-systems and to ask the questions that you have always wanted to ask.

 

Level: This one day seminar ranges between Level 200 and 400, to get everybody on the same page but also be able to point out some little-known internals.

 

Contents:

 

1.Storage basics for HEAPS and Indexes

2.Clustered Indexes & Non clustered Indexes in Detail

3.More Options at hand: Included Columns and Filtered Indexes

4.Column store Indexes introduction

5.In-Memory OLTP Indexes introduction

6.Statistics – what are they good for and how do they work?

7.Index maintenance: the good the bad the ugly

Speaker Profile :

Andreas Wolter is both a Microsoft Certified Master (MCM) on SQL Server 2008 and a Microsoft Certified Solutions Master Data Platform (MCSM) SQL Server 2012 – making him one of only 2 experts worldwide being master-certified on SQL Server 2008 and 2012. Besides that he has also been awarded with the MVP for SQL Server since 2014.

As the founder of Sarpedon Quality Lab a Germany-based company he has over 16 years of experience with SQL Server, helping customers worldwide with Development and Optimization of SQL Server Database- and large Datawarehouse-architectures focusing on performance and scalability and a special passion for security.

Since many years he can be met at various international conferences starting from the biggest SQL Server conference in the US but also in local user groups. Also he is delivering exclusive training for the SQL Server Master-Class seminar-series.

You can follow him at Twitter at @AndreasWolter and find his blog at www.insidesql.org/blogs/andreaswolter .

Rush and grab your tickets before they fill up!!! Email us or post here if you have any questions. Thanks.

Cheers,
Singapore SQL Server User Group Team

DataCamp 2017 - Singapore - March 11th

Dear all,

We, Singapore SQL Server User Group Team, are happy to announce "Data Camp 2017", a one day free event for SQL Server and Microsoft Data Platform technologies to be held on 11th March 2017. The event will have top quality technical content delivered by Data platform experts in this region. The event features 8 MVP award winners, 3 Microsoft Professionals and 6 overseas speakers!!! Details provided below

List of speakers and topic of sessions provided below

Topic	Speaker
Monitoring of Availability Groups with DMVs and XEvents	Andreas Wolter
SQL On Linux - Architecture	Dharmendra Keshari
Data Mining with ANN	Dinesh Asanka
Processing unstructured data	Dinesh Priyankara
SQL Server Hardware Sizing	Hamid Fard
Power BI Story - for everyone	Khilitchandra Prajapati
Silenced Secrets of Security	Krishna Deepak
SQL Server Partitioning: Things you should know	Mohit Nirawal
Cardinality Estimator: A Ride from SQL 7.0 to SQL Server 2016	Nagaraj Venkatesan
SQL Server 2016 BI Features and Enhancements	Naginder Singh
High Performance Database Design	Chiu Kiang Phua
Practical Tips and Tricks using SQL Server Tools	Vinod Kumar M
Capturing and managing data in Azure	Prakash Sawant
To Be Announced	Sarbjit Singh Gill
SQLLite – Mobile development using Xamarin	Senthamil Selvan

Click below to register for the event : https://www.meetup.com/mssgug/events/236952292/

Go ahead, register and don't miss the opportunity to learn from the Masters!!!

Regards,
Singapore SQL Server User Group Team

SG SQL UG Meetup - Feb 2017

Dear All,

Its meetup time again at Singapore SQL PASS Chapter. Please refer below for the details.

Agenda:

February 15th - 6:45 PM to 7 PM - Registration and Snacks

7 PM to 8 PM - Topic 1 - Presentation by Sarbjit Singh Gill

8:00 PM to 8:15 - Break

8:15 PM to 9:15 - Topic 2 - Presentation by Dharmendra Keshari

Location: Microsoft Office, One Marina Boulevard, Level 22 BR-01

Topic 1: Uncovering your true capability in the tech world

Synopsis:

Have you asked yourself the question why you do what you do ? Are you thinking about it or are you in an automatic mode, just doing without thinking?

Speaker Profile: Sarbjit Singh Gill
I bring 24 years of IT experience spanning consulting, architecture and training for Microsoft technologies such as Lync, Exchange, SQL Server, SharePoint, Windows Server, Active Directory, System Center range of products. I am also experienced in carrying out a Microsoft IO (Infrastructure Optimization) and Implementation of the MS MOF (Microsoft Operations Framework).Since 2005, I have been a Microsoft Most Valuable Professional (MVP) with Technical Expertise in Lync, SCOM and SharePoint.I have participated as a speaker and proctor in numerous conference and forums and co-authored a book on MS Exchange monitoring using SCOM. As a MVP, I am founder of Singapore Lync User Group and an active member of other MS Technologies User Group communities. I hold a FIA International "C" racing license and I race actively in Japan and Malaysia in touring cars endurance and club races.I am an active Scuba Diver with interest in underwater videography.

Topic 2: DeadLock Troubleshooting
Synopsis:

In this session, we will learn about locking & blocking in SQL Server. Based on that knowledge you will learn about the various kinds of deadlocks that can occur in SQL Server, how to troubleshooting them. It will help you to decide your index strategy and database settings.

Speaker Profile: Dharmendra Keshari

Dharmendra Keshari has strong and in-depth experience in Database Management and its internals. Currently, working as Senior Database Administrator in one of the best Semi-Government organization in Singapore. He is an avid, regular mentor on social media, helping several enthusiast in solving problems related to Database management. He has completed certification for “Microsoft SQL Server® 2008, Implementation” and “Maintenance & Administering Microsoft SQL Server 2012 Database”

Meetup link: https://www.meetup.com/mssgug/events/237562596/