Tuesday, December 20, 2016

SG SQL UG Meetup - Dec 2016

Dear All,

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

Agenda:

December 21st - 6:45 PM to 7 PM - Registration and Snacks

7 PM to 8 PM - Topic 1 - Presentation by Nagaraj Venkatesan

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 21 Auditorium

Topic 1: R and SQL Server 2016

Synopsis:

"R", a popular statistical language among data scientists has been integrated with SQL Server 2016. Now, with SQL Server 2016, one gets to perform the data retrival and statistical compute in one box. The session will provide an overview on how R works with SQL Server 2016 and the benifits of using Microsoft R in data science process. The session will also provide a quick introduction for T SQL Deveoplers and DBAs on how "R" code can be deployed to SQL Server 2016.

Speaker Profile: Nagaraj Venkatesan

Nagaraj Venkatesan, a SQL Server enthusiast exploring SQL Server for the last 10 years. Working for NCS Pte Ltd as SQL Server DBA, Nagaraj maintains databases used by one of the busiest public facing applications in the city. He frequently blogs at strictlysql.blogspot.com and is a regular contributor sqlservercentral.com. Besides these, he also holds a Masters Degree in Computing from National University of Singapore

Topic 2: SQL Server on Linux

Synopsis:

The announcement of SQL Server on Linux brings a significant technological and operation shift to enterprise relational database management system. It is vital to understand the features and capabilities. The agenda of the session

- Introduction to SQL Server on Linux

- How SQL Server is running on Linux (How I think - Microsoft has done it)

- Demos

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 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”

Monday, November 21, 2016

SG SQL UG Meetup - Nov 2016

Dear All,

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

Agenda:


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

7 PM to 8 PM - Topic 1 - Presentation by Andreas Wolter

8:00 PM to 8:15 - Break

8:15 PM to 9:00 - Topic 2 - Presentation by Nagaraj Venkatesan

Location: Microsoft Office, One Marina Boulevard, Level 21 Auditorium

Topic 1: “SQL Server Attacked” – excerpts from “Hacking SQL Server from inside & outside”

Synopsis:

Join us in this November’s special: Andreas Wolter will give a “best of” of his various “Hacking SQL Server” sessions, covering attacks from inside as well as from outside. While a part will be demonstrated using SQL Injection, other small demos will demonstrate security traps and holes that can occur when mixing Development & Production and granting external personnel too many permissions.

Speaker Profile: Andreas Wolter


Andreas Wolter(Facebook | LinkedIn) has over 16 years of experience with SQL Server and earned the Master-Certification both on SQL Server 2008 (MCM) and SQL Server 2012 (MCSM)– as one of only 2 experts worldwide. Besides that he has also been awarded with the MVP for SQL Server since 2014.
He is the founder of Sarpedon Quality Lab, originally from Germany, specializing in Development and Optimization of SQL Server Database- and Datawarehouse-architectures with focus on performance, scalability and security.

Topic 2: SQL Server 2016 SP 1 - a Rocking Release!!!


Synopsis: SQL Server 2016 Service Pack 1 was announced on Nov 17th and unlike any other usual service pack release, it had several path breaking changes announced. The big one of them being a major list of Enterprise features being made available on Standard edition. This session will discuss the features that moved to standard and how the applications can benifit using the same. The session will also cover few other useful enhancments that were released in SP1

Speaker Profile: Nagaraj Venkatesan

Nagaraj Venkatesan, a SQL Server enthusiast exploring SQL Server for the last 10 years. Working for NCS Pte Ltd as SQL Server DBA, Nagaraj maintains databases used by one of the busiest public facing applications in the city. He frequently blogs at strictlysql.blogspot.com and is a regular contributor sqlservercentral.com. Besides these, he also holds a Masters Degree in Computing from National University of Singapore


Tuesday, October 25, 2016

SG SQL UG Meetup - Oct 2016

Details

Dear All,

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

Agenda:

November 2nd - 6:45 PM to 7 PM - Registration and Snacks

7 PM to 8 PM - Topic 1 - Presentation by Dharmendra Keshari

8:00 PM to 8:15 - Break

8:15 PM to 9:00 - Topic 2 - Presentation by Vikas Rai

Location: Microsoft Office, One Marina Boulevard, Conf Room SINOMB 22CF-12

Topic 1: The Secret of the SQL Server Database Boot Page


Synopsis:

We will be exploring some secretive information about SQL Server Brain page also known as boot page. What is pseudo-simple recovery model? How will you come to know your SQL server was upgraded from which version to which version? How does the SQL Server make sure, a full backup has happened before the log backup?

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 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”

Topic 2: Introduction to R and Data Science


Synopsis: The session will be focused towards providing the basic understanding of R Programming language. To provide fundamental knowledge on Analytics and how it assists in decision making. How to work on statistical concepts like linear & logistic regression, cluster analysis and the approach to use statistical techniques and R language.

Speaker Profile: Vikas Rai

Vikas Rai, a technocrat with over 14 years of rich experience in various aspects of Enterprise Architecture, Data Science, Security (Infra & Apps) and Quality Management, is currently working as APAC BI Senior Solution Architect at L'Oréal. Vikas is also Skilled trainer for Microsoft technologies and Project Management Courses.


Tuesday, October 4, 2016

SG SQL UG Meetup - Sept 2016

Dear All,

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

Agenda:

September 29th - 6:45 PM to 7 PM - Registration and Snacks

7 PM to 8 PM - Topic 1 - Presentation by Mohit Nirawal

8:00 PM to 8:15 - Break

8:15 PM to 9:30 - Topic 2 - Presentation by Nagaraj Venkatesan

Location: Microsoft Office, One Marina Boulevard, Conf Room SINOMB 22CF-15

Topic 1: DMV:Sql Server DBA best friend

Synopsis: With SQL Server  Dynamic Management Views (DMVs) You can find server top wait types,memory pressure, most CPU intensive stored procedures,database missing indexes, and identify unused indexes. This session , presents and explains over twenty DMV queries that we can quickly run to detect and diagnose performance issues in our environment.

Speaker Profile: Mohit Niranwal

Mohit Niranwal,works as a DBA  at InternationalSoS based in Singapore.He holds MCSE Sql Server 2012 data platform certification, with over 10 years experience in IT.He has worked with all versions of SQL Server starting  from 7 in various dev/admin roles, with an emphasis in performance tuning.


Topic 2:  SQL Server Query Store - The Real "Deal"

Synopsis:

"Why my database performance has been suddenly slow?
 Have my query plans changed?
 Which plans have regressed and since when?
 Is there any way I can control the plan change without changing the source code?"
If you have encountered any of the above situations, then query store is your remedy. SQL Server Query store is one of the path breaking features released in SQL Server 2016. The presentation will showcase how query store is a boon in handling sudden performance degradations, plan changes and analyzing query performance patterns over a period of time. Presentation will also demonstrate the power of query store in forcing query plans and compare it against options available in earlier versions of SQL Server. Presentation will have interesting demos on tracking plan regressions and on scenarios the use force plans feature. At the end of the session, audience will have a clear understanding on how query store becomes their new important weapon in their arsenal, for performance


Speaker Profile: Nagaraj Venkatesan
Nagaraj Venkatesan, a SQL Server enthusiast exploring SQL Server for the last 10 years. Working for NCS Pte Ltd as SQL Server DBA, Nagaraj maintains databases used by one of the busiest public facing applications in the city. He frequently blogs at http://strictlysql.blogspot.com and is a regular contributor sqlservercentral.com. Besides these, he also holds a Masters Degree in Computing from National University of Singapore

Download Link for the Slides: here
 

Tuesday, September 13, 2016

SQL Saturday Singapore 2016 - A Grand Success


Dear All,
Can't believe it’s over!!!! It was an awesome awesome SQL Saturday Singapore...There were so many people to thank for the great success of this event.




* Let me start off with YOU - Singapore SQL Community. Without your interest, passion and the enthusiasm we wouldn't have thought of doing a SQL Saturday in first place. Thanks for giving us a good attendance in all our meetups and encouraging us to do this event.
* PASS - Thanks to PASS for giving us a platform to arrange for an event of this scale. Without PASS support, we wouldn't have had the access to so many world class speakers for sure and event wouldn't have been such a success
* Microsoft, our Gold sponsor for the event - Thanks for the tremendous support for the event. Be it providing a venue, arranging food and taking in all our last minute requests. Don't recall how many times I would have disturbed Koh Ming Hao with countless emails and phone calls at odd hours for the event. Thanks to Vivek Ravindran, Tamarai, Harminder SethiPrakash Sawant for their priceless support without which this event would not have been possible
* Volunteers - Thanks to the gentle men with the "Red Tee" during the event. We formed a team just few days ago and how well we worked...Thanks for the selfless service rendered in the last 2 days. Thanks to Rehan RockerManjuke FernandoVikash RaiMohit Niranwal, Abhishek Patel, Anand RajAlvin Lau and Sakthish Kumar for your help
* Speakers - Thanks to the overwhelming response for our event. We still wonder how lucky we are to have speakers from United States to Australia travelling 1000s of miles, speakers from the product team and industry experts. Joe young , Pinal DaveVinod Kumar MDenny CherryJoey D'Antoni, Glenn Morris, Harminder sethi, James Beresford, Andreas Wolter, Stefan Riedel, Kevin Boles, Krishna Deepak, Subramani- Can't thank you all enough for the wonderful technical sessions
Special Thanks to Andreas Wolter for making a successful pre conference event too.
Special Thanks to Kevin Boles for covering an additional session in the last minute
Special Thanks to Harminder Sethi for taking a 90 minute session when one of the previously announced speakers couldn't make it
* Sponsors - Thanks to all our Sponsors - Gill Technologies, Red Gate, Devart, Sarpedon Quality labs for the raffle gifts and all the support for the event.
* Last but not least - Our Team, Singapore SQL Saturday Team -Dharmendra KeshariKhilitchandra PrajapatiSarbjit Singh Gill. Yes, little weird to thank ourselves but still thanks for surviving the grueling last few weeks and for all the efforts :)
Once again, Thank you every one and we promise to be back stronger, bigger and better next year!!! #sqlsat549

More photos of the event can be found here.