SQLBangalore UG Meeting – Sep 6

Come join us on Saturday, September 6th for another SQL Bangalore User Group meeting to learn more about Azure Backups, SQL Server 2014 In-memory OLTP, Hybrid cloud scenarios and Power BI.

The session line up is available below.

14:00PM 14:45PM – Azure Backup by Ravikanth
14:45PM 15:30PM – Performance Improvement and In-memory – Balmukund Lakhani
15:45PM 16:30PM – Hybrid Cloud Scenario with SQL Server – Vinod Kumar
16:30PM 17:15PM – Power BI Overview – by yours truly

I will show you how you can use Power BI and Excel can be used to analyze your Facebook data and much more. Register for the event here. As usual, I will post the content used during that day on this blog. Stay tuned in case you are not able to attend in person. And don’t forget to spread the word! Hope to see in person on the 6th!

Venue:
Microsoft Corporation, Signature Building,
Embassy Golf Links Business Park,
Intermediate Ring Road,
Domlur, Bangalore – 560071

The slide deck that I used for this session is available below.

August SQLBangalore UG Meet: It was a cloudy day

imageI am always amazed by the turnout on Saturdays for the SQLBanglaore UG Meetings. This time around it was an all Azure day where we had four sessions talking about different features that Azure offers.

The first session as about Machine Learning by Govind. He showed us how Machine Learning can make the machines smarter. It doesn’t mean that the machines are taking over but they can become your assistants with a bit of training. He went on to demo what Azure Machine Learning (in Preview) has to offer in this space.

This was followed by Angshuman’s session on Azure Redis Cache (in Preview). It gives you access to a secure, dedicated Redis cache, managed by Microsoft. A cache created using Azure Redis Cache is accessible from any application within Microsoft Azure.

The next session by Pranab was on the Smart Backup Feature in SQL Server 2014 which allows you to backup your SQL Server databases directly to Windows Azure Storage accounts. This enables you to pull down those backups for restore from anywhere in the world!

I had the last session and I was the one who was standing between attendees and their lunch! Not an enviable position to be in on a Saturday afternoon! This time around I had attempted to do things a bit differently. I started with the demo and moved onto my presentation. I used a video from PowToon to create a story line for provisioning a SQL Server virtual machine in a short span of time! That is available below. Lately, I have been using animation videos for a few of my presentations. And the view below is the one that I used for this session.

The presentation that I had used for my session is available below:

If you want the PowerShell script which performed the magic after creating the Azure SQL VM, you can from the files section of the SQLBangalore Facebook Group. Look forward to further posts on this blog detailing additional possibilities for that script.

Once again, a big THANK YOU to all the attendees as without them, these sessions will never be a success!

If you want to get notified about future posts, then you can follow me on one of these channels: Facebook | Twitter or simply subscribe to this blog (Available in the side-bar on the left).

SQLBangaloreUG: It is going to be a cloudy day

sponsor-bangaloreUGWHEN: Saturday, August 2, 2014 from 10:00 AM to 1:30 PM (IST)

WHERE: Embassy Golf Links Business Park, Bangalore, India

We are prepping up for another SQL Bangalore User Group meeting on August 2nd, 2014. I will be presenting on SQL Server provisioning on Azure Virtual Machines. We will see how the latest hooks provided in Azure makes provision and post installation configuration easier.

And what’s more, this SQL Bangalore User Group session is devoted to AZURE! So, if you are interested in learning about Azure, then do come and attend the session. There is a great lineup of speakers who will be presenting on various interesting topics:

  • Be Smart with …Smart Backup – Pranab Mazumdar (Twitter) – Escalation Engg, Microsoft
  • Zero to hero with Azure ML (Machine Learning) – Govind Kanshi (Twitter) – Technical Director, MTC
  • Introduction to Azure Redis Cache – Angshuman Nayak – Escalation Engg, Microsoft

So join us for another day of learning. See you in-person on the 2nd!

As usual, I will post the content used during that day on this blog post. Stay tuned in case you are not able to attend in person.

Signup for the event here and don’t forget to spread the word!

A full house–We could not have asked for more

The turnout at today’s event had an overwhelming response today. A big thank you to everyone who attended today’s event. An overwhelming response… So thank you everyone who attended and made this UG meeting a grand success! This was our very own version of introducing SQL Server 2014 to the SQLBangaloreUG community!

We had a brilliant line-up of topics… Just to re-cap the day.. Here is a short summary..

The day started off with a keynote session from Anupam Tiwari who is Business Program Manager and closely works with the team that supports developer technologies at Microsoft. He talked about where IT as we know it today is headed tomorrow.

Sourabh Agarwal [Blog | Twitter] covered the performance enhancements in SQL Server 2014 and explained why this version is bigger, faster and stronger! Smile

Then I had the opportunity of explaining the new enhancements in backup and restore in SQL Server 2014. I talked about backing up to a URL i.e. a storage account in Azure, managed backups to Azure and encrypted backups. The slide deck from today’s presentation is available below.

This was followed by Pinal Dave’s [Blog | Twitter] session on “Performing an effective Presentation” One key takeaway from this session is that the art of story-telling can weave out a presentation which can keep the audience hooked! He demonstrated this during his session and kept the audience awake after lunch! Smile

Then we had Balmukund Lakhani [Blog | Twitter] talking about InMemory Enhancements with SQL Server 2014. You can follow his SQL Server 2014 learning series to gain in-depth insights into the various enhancements that he talked about.

His session was followed by Vinod Kumar [Blog | Twitter] who talked about the Some more lesser known enhancements with SQL Server 2014 where he talked about managed lock priority, delayed durability and more.

And last but not the least was Kane Conway – (Support Escalation Engineer at Microsoft) who talked about Power Packed – Power BI with SQL Server. If you have not played around with PowerBI, then you should start now! Presenting data with compelling visualizations just got a new definition.

image image

It was a house full event and I had to put in two pictures to showcase the turnout today! It is not possible to have a successful event without the audience participation. We personally want to apologize to folks who came in late and had to return because the hall was overcrowded and the seats were full. Please do come in early for next UGs for sure.

A special thanks to Microsoft GTSC for giving us the space and the support till date. Also a special thanks to SQL Server Product Marketing team for sponsoring this Launch Event. Finally, a special thanks to team Pluralsight for supporting the UG till date and giving us numerous gifts as giveaway at the event.

The presentation that I used at the event today is available below:

Bangalore Community gets a peek at SQL Server 2014

SQL Server 2014 which was recently released will now receive special attention at the SQL Bangalore UG Meet scheduled to happen on Saturday, May 3rd, 2014. We are  conducting a full-day event for a SQL Server 2014 Community Launch at the SQL Bangalore UG. So don’t miss the opportunity to come and learn some of the new cool features introduced with SQL Server 2014.

I will be presenting on Backup Enhancements in SQL Server 2014 and will show you some exciting new features. This will get you thinking about your backup strategy when you upgrade to SQL Server 2014.

Just to tickle your learning taste buds, the agenda for the day is mentioned below:

Backup Enhancements with SQL Server 2014
Performance Enhancements with SQL Server 2014
Sourabh Agarwal [Blog | Twitter] – An active member on SQLBangalore community!

LUNCH BREAK

Performing an effective Presentation by Pinal Dave [Blog | Twitter] – He does not require an introduction!
InMemory Enhancements with SQL Server 2014 by Balmukund Lakhani [Blog | Twitter] – One of the most helpful people in the SQL community!
Some more lesser known enhancements with SQL Server 2014 by Vinod Kumar [Blog | Twitter] – Another individual who needs no introduction!
Power Packed – Power BI with SQL Server by Kane Conway – (Support Escalation Engineer at Microsoft) – A technical expert who will explain to about what PowerBI can do for you and your organization!

Register for the event (registration link) and feel free to pass along the message. The day will have an early start… 9.30AM!! Get your learning hats on and come visit us on Saturday!

Venue:
Microsoft Corporation, Signature Building,
Embassy Golf Links Business Park,
Intermediate Ring Road,
Domlur, Bangalore – 560071

Another day at the SQL Bangalore UG Meeting

Another Saturday and another Bangalore SQL UG meeting completed! The turnout on a Saturday morning was really good. This time around the event was a bit different as we had a session on Photography by Vijay [T: @msigeek | B: iClickD]. This week’s User Group meeting was dedicated to SQL Server Tips and Tricks with Balmukund Lakhani [T: @blakhani | B: sqlserver-help] and me presenting on Management Studio and Power Pivot and Power View in Excel 2013.

Balmukund’s session as always was a superb hit where he demonstrated more than a fair share of SSMS tips and tricks. I am sure every one at the event learnt atleast a new thing about SSMS. There are multiple hidden options under the Tools->Options view in SSMS.

Vijay delivered a great session on photography which was very well appreciated by the audience!!

My session was around the the usage of Power View and Power Pivot in Excel 2013. I demonstrated how easy it was to build visualizations with Excel 2013 for administrators. I also demoed the Excel sheet that I had created using the System Health Session data. All my blog posts on this topic are available below.

PowerView and System Health Session–CPU health

PowerView and System Health Session–Scheduler Health

PowerView and System Health Session–SQL Memory Health

PowerView and System Health Session– IO Health

PowerView and System Health Session– System

The Excel file can be downloaded from Sky Drive using the link: http://sdrv.ms/10O0udO The presentation that I used for my session is available at SlideShare and also embedded below.

SQL Bangalore UG Meeting–July 13

sponsor-bangaloreUGEven though the 13th is considered unlucky by a lot of individuals, this 13th happened to be a good one! The SQL Bangalore UG meeting had another successful event today!

It always surprises me with the number of SQL community folks that turn up to attend the sessions on a Saturday morning! Thank you to all the attendees! Without you this event would not have been possible.

There were some fun filled, technical and interactive sessions delivered by Olga Medvedeva [T] on Pagination Methods in SQL Server, Vinod Kumar [B|T] on SQL Server 2014 CTP1: In-memory OLTP and Sourabh Agarwal [B|T] on SQL Server Memory Basics.

I had the privilege of presenting on SQL Server Scheduling Basics at this user group meeting. The slide deck used for this session is available on Slide Share and the embedded copy of the PPT is available below.

As usual it was good fun to meet the SQL Server community members. In case you have any questions regarding my session, please send a tweet to @banerjeeamit or post your question on the TroubleshootingSQL Facebook page or on the SQLBangalore Facebook group.