Events

Session 1: SQL Server 2016 – First Look by Amit R S Bansal (SQLMaestros), Sarabpreet Singh Anand (SSG), Ahmad Osama (SSG)
Abstract:
The next major release of Microsoft’s flagship database and analytics platform provides breakthrough performance for mission critical applications and deeper insights on your data across on-premises and cloud. Top capabilities for the release include: Always Encrypted – a new capability that protects data at rest and in motion, Stretch Database – new technology that lets you dynamically stretch your warm and cold transactional data to Microsoft Azure, enhancements to our industry-leading in-memory technologies for real-time analytics on top of breakthrough transactional performance and new in-database analytics with R integration. Hear & watch Microsoft Certified Master & SQL MVP Amit Bansal talk & demo a few of them.

Session 2: Clean, Verify and Enrich your Data in SSIS by Amit R S Bansal (SQLMaestros)
Abstract:
Join Microsoft Certified Master & MVP Amit Bansal in this demo-oriented session and see how your contact data can be cleansed, standardized, validated and better synchronized with business processes to get a single view of master data. You will witness out of the box easy integration capabilities. Learn the concept, the technique and implementation strategies.

Session 1: SQL Server 2016 – First Look by Amit R S Bansal (SQLMaestros), Narendra Ragho Angane (Microsoft), Mahendraprasad Dubey (Microsoft)
Abstract:
The next major release of Microsoft’s flagship database and analytics platform provides breakthrough performance for mission critical applications and deeper insights on your data across on-premises and cloud. Top capabilities for the release include: Always Encrypted – a new capability that protects data at rest and in motion, Stretch Database – new technology that lets you dynamically stretch your warm and cold transactional data to Microsoft Azure, enhancements to our industry-leading in-memory technologies for real-time analytics on top of breakthrough transactional performance and new in-database analytics with R integration. Hear & watch Microsoft Certified Master & SQL MVP Amit Bansal talk & demo a few of them.

Session 1: SQL Server 2016 – First Look by Amit R S Bansal (SQLMaestros), Narendra Ragho Angane (Microsoft), Mahendraprasad Dubey (Microsoft)
Abstract:
The next major release of Microsoft’s flagship database and analytics platform provides breakthrough performance for mission critical applications and deeper insights on your data across on-premises and cloud. Top capabilities for the release include: Always Encrypted – a new capability that protects data at rest and in motion, Stretch Database – new technology that lets you dynamically stretch your warm and cold transactional data to Microsoft Azure, enhancements to our industry-leading in-memory technologies for real-time analytics on top of breakthrough transactional performance and new in-database analytics with R integration. Hear & watch Microsoft Certified Master & SQL MVP Amit Bansal talk & demo a few of them.

Session 2: Clean, Verify and Enrich your Data in SSIS by Amit R S Bansal (SQLMaestros)
Abstract:
Join Microsoft Certified Master & MVP Amit Bansal in this demo-oriented session and see how your contact data can be cleansed, standardized, validated and better synchronized with business processes to get a single view of master data. You will witness out of the box easy integration capabilities. Learn the concept, the technique and implementation strategies.

Session 1: SQL Server 2016 – First Look by Amit R S Bansal (SQLMaestros)
Abstract:
The next major release of Microsoft’s flagship database and analytics platform provides breakthrough performance for mission critical applications and deeper insights on your data across on-premises and cloud. Top capabilities for the release include: Always Encrypted – a new capability that protects data at rest and in motion, Stretch Database – new technology that lets you dynamically stretch your warm and cold transactional data to Microsoft Azure, enhancements to our industry-leading in-memory technologies for real-time analytics on top of breakthrough transactional performance and new in-database analytics with R integration. Hear & watch Microsoft Certified Master & SQL MVP Amit Bansal talk & demo a few of them.

Session 1: Unlocking Data Insights from Any Data with SQL Server by Jen Stirrup
Abstract:
With business intelligence tools built right into Excel, and supercharged by a powerful back-end data platform in SQL Server, Microsoft makes it easier for everyone to discover new insights and uncover new connections and relationships across data sets. Create stunning, interactive views from any data using Excel, make real-time decisions using interactive charts and reports that can be changed on the fly directly in PowerPoint. Share and collaborate with other people by using SharePoint while retaining the rich data-linked visualizations that were built in Excel. Finally, Power BI transforms your company’s data into rich visuals for you to collect and organize so you can focus on what matters to you.

Session 1: Get involved in IoT by Sudhir Rawat (Microsoft)
Abstract:
There is lot of buzz around IoT. It involves not only understanding of services but also the hardware. There are lot of devices and sensors available to achieve the solution. This session will help you to connects the dots and help you to build solution around it. How devices connect each other and send information to event hub. How then information is presented to end user.

Session 2: Clean, Verify and Enrich your Data in SSIS by Amit R S Bansal (SQLMaestros)
Abstract:
Join Microsoft Certified Master & MVP Amit Bansal in this demo-oriented session and see how your contact data can be cleansed, standardized, validated and better synchronized with business processes to get a single view of master data. You will witness out of the box easy integration capabilities. Learn the concept, the technique and implementation strategies.

Session 3: Introducing Azure Machine Learning by Deepthi Anantharam (Microsoft)
Abstract:
Microsoft Azure Machine Learning (MAML) is a service on Azure which a developer can use to build a predictive analytics model using machine learning over data. ML Studio provides functionality to support the end-to-end workflow for constructing a predictive model, from ready access to common data sources, data exploration, feature selection and creation, building training and testing sets, machine learning over data, and final model evaluation and experimentation. In this presentation, we present an overview of the basic data science workflow, with details on select machine learning algorithms, then take you on a guided tour of ML Studio.

Session 1: High Availability Options in SQL Server by Edwin Sarmiento
Abstract:
SQL Server boasts of variety of features to improve database availability and significantly reduce downtime. In this webcast, join SQL Server MVP and Microsoft Certified Master Edwin Sarmiento as he covers Availability Groups and Failover Clustering to achieve high availability for your SQL Server databases. He will also cover how you can implement a hybrid solution for stretching your SQL Server Availability Groups or Failover Clustered Instances to Microsoft Azure.

Session 1: SQL Server 2014 Hidden Gems by Amit R S Bansal (SQLMaestros)
Abstract:
In-Memory tables and Availability Groups are all well-known features in SQL Server. But how about tempdb hidden performance, Delayed Durability and Cardinality Estimator? And have you seen how clustered columnstore indexes can improve performance? Come to this session and witness some lesser-known, yet awesome features of SQL Server.

Session 2: Clean, Verify and Enrich your Data in SSIS by Amit R S Bansal (SQLMaestros)
Abstract:
Join Microsoft Certified Master & MVP Amit Bansal in this demo-oriented session and see how your contact data can be cleansed, standardized, validated and better synchronized with business processes to get a single view of master data. You will witness out of the box easy integration capabilities. Learn the concept, the technique and implementation strategies –

Session 1: Big Data on Microsoft Azure by Joseph D’Antoni
Abstract:
The traditional enterprise data warehouse has been around a long time, and it isn’t going away anytime soon. However, with modern options based on Hadoop like HDInsight and PolyBase, and new analytic and data mining techniques, the warehouse is no longer the center of our business analytics universe. Enterprises now have the flexibility to integrate and analyze external and internal data in ways previously not possible. In this session, we will cover these new platforms through and our approach for integrating them into your warehouse environment. We will demonstrate how to do initial data loading and analysis using HDInsight and Power Query, and then visualizing that data using Power View.

Session 1: Let’s explore AlwaysOn Availability Group by Narendra Ragho Angane (Microsoft) & Mahendraprasad Dubey (Microsoft)
Abstract:
In this session, we’ll discuss following

• HADR Existing features before AlwayON
• AlwaysON introduction
• Benefits offered by availability groups
• Setup prerequisites, database consideration, limitations etc…
• What’s new in AlwaysON SQL 2014?
• Demo

Session 2: In-Memory OLTP & SQL Tuning by Amit R S Bansal (SQLMaestros)
Abstract:
Join Microsoft Certified Master & MVP Amit Bansal in this demo-oriented session and see how your high throughput workload can benefit from Memory Optimized Tables. You will witness blazing fast performance. Learn the concept, the technique and implementation strategies of In-MemoryOLTP.

Session 3: Panel Discussion: Ask the Experts by Narendra Ragho Angane (Microsoft) & Mahendraprasad Dubey (Microsoft)
Abstract:
oin the expert panel from Microsoft. SQL Stalwarts will be there to answer your questions. Whether you are a DBA, Developer, BI Specialist, Architect or just a SQL enthusiast – feel free to ask any question and get your doubts cleared!

Here is the photo collection!

Event pictures | Orginal Emailer | Browse SQLServerGeeks Photo Albums

Session 1: SQL Server Hidden Gems by Amit R S Bansal
Abstract:
In-Memory tables and Availability Groups are all well-known features in SQL Server. But how about tempdb hidden performance, Delayed Durability and Cardinality Estimator? And have you seen how clustered columnstore indexes can improve performance? Come to this session and witness some lesser-known, yet awesome features of SQL Server.

Session 1: Prepare yourself for running SQLServers on AzureVM by Sarabpreet Singh Anand
Abstract:

• Are you planning to move your SQLServers on Azure?
• Want to get clarity in terms of Support?
• Are you worried about the Performance?
• Want to avoid common mistakes?
• etc.

If you are worried about these\related questions attend this session where Sarabpreet Singh will help you find answer to most of your queries.

Session 2: SQL Server Query Tuning Simplified by Amit R S Bansal
Abstract:
SQL Server Query Tuning is no rocket science! It’s a simple methodology that one needs to follow. And if you follow a methodological approach, you will be able to solve almost 90% of performance issues. Join Microsoft Certified Master & MVP Amit Bansal in this demo-oriented session and learn a query tuning methodology that can be put into production right-away!

Session 3: Performance tuning from the field – Optimising stored procedures by Ahmad Osama
Abstract:
They say that performance tuning is an art. So let’s see what this art is all about. In this demo only session, we’ll together write an optimized stored procedure for a real life and the most common problem.

Here is the photo collection!

Event pictures | Orginal Emailer | Browse SQLServerGeeks Photo Albums

Session 1: SQL Server Query Tuning Simplified by Amit R S Bansal
Abstract:
SQL Server Query Tuning is no rocket science! It’s a simple methodology that one needs to follow. And if you follow a methodological approach, you will be able to solve almost 90% of performance issues. Join Microsoft Certified Master & MVP Amit Bansal in this demo-oriented session and learn a query tuning methodology that can be put into production right-away!

Session 2: Panel Discussion: Ask the Experts by Devashish Salgaonkar (Microsoft), Anmol Bhasin (Microsoft), Sanjiv Gore (Microsoft)
Abstract:
Join the expert panel from Microsoft. SQL Stalwarts will be there to answer your questions. Whether you are a DBA, Developer, BI Specialist, Architect or just a SQL enthusiast – feel free to ask any question and get your doubts cleared!

Here is the photo collection!

Event pictures | Orginal Emailer | Browse SQLServerGeeks Photo Albums

Session 1: SQL Server Query Tuning Simplified by Amit R S Bansal
Abstract:
SQL Server Query Tuning is no rocket science! It’s a simple methodology that one needs to follow. And if you follow a methodological approach, you will be able to solve almost 90% of performance issues. Join Microsoft Certified Master & MVP Amit Bansal in this demo-oriented session and learn a query tuning methodology that can be put into production right-away!

Session 2: Panel Discussion: Ask the Experts by Sudhir Rawat (Microsoft), Vijay Rodrigues (Microsoft), Deepthi Anantharam (Microsoft), Kumar Bijayanta (Microsoft) & Sunil Kumar Charkapani (Microsoft)
Abstract:
Join the expert panel from Microsoft. SQL Stalwarts will be there to answer your questions. Whether you are a DBA, Developer, BI Specialist, Architect or just a SQL enthusiast – feel free to ask any question and get your doubts cleared!

Here is the photo collection!

Event pictures | Orginal Emailer | Blog | Browse SQLServerGeeks Photo Albums

Session 1: Developer Vs DBA by Sarabpreet Singh Anand (SQLServerGeeks President) & Ahmad Osama (SQLServerGeeks Chief Technical Editor)
Abstract:
Bugs, Crashes, Meltdowns, we run into issues almost every day. The first thing we do is to find who’s fault it is. Is it the developer who wrote the bad code or is it the DBA who didn’t plan the maintenance. It’s high time we get over this blame game and resolve issues as a team. In this grueling, demo heavy 2.5 hours session, Sarabpreet and Ahmad will play as developer and DBA to resolve real life bugs and performance issues collectively.

Here is the photo collection!

Event pictures | Orginal Emailer | Blog | Browse SQLServerGeeks Photo Albums

Session 1: Master The Art of Public Speaking – Part 1 by Amit R S Bansal
Abstract:
Yes We Can! Remember this? Good oratory skills can land you the top job, be it the President of the United States or the Prime Minister of India – public speaking skills is indeed that important today! Even if you don’t need to make regular presentations in front of a group, there are plenty of situations where good public speaking skills can help you advance your career and create opportunities. In fact, top jobs need those skills. And don’t you want to climb the ladder for that top job? Come to this session if you want to get a kick-start in public speaking. Amit Bansal, who has learnt the art of public speaking the hard way, will teach you these skills, step-by-step. Amit has delivered a number of sessions at international conferences like TechEd, PASS Summit, SQL Bits, GIDS, Economic Times – Power of Ideas, Images Retail Confernce, etc – and he will bring all his experiences in a series of sessions, starting from April 18, Part 1 of “Master The Art of Public Speaking”. These sessions are unmissable.

Session 2: From Nobody to Somebody by Amit R S Bansal
Abstract:
Your colleagues know you. Your friends know you? Your family knows you. They all know what you know? Isn’t that a common thing with most people around you? Don’t you want that people who don’t know you, should know you and what you know? Confused? Well, this session is all about becoming Somebody from Nobody. What does it take to be popular? Why should you think about becoming famous? And how can you achieve fame and recognition within your community? It’s time you come out of your comfort zone and show the world what you know. This session will instill that thought in you, only if you are interested. This session is un-miss-able!

Session 1: Introduction to SSIS and Deployments by Jayaraj Vemula
Abstract:

• Brief Introduction to SSIS
• Differences between SSIS Package Deployment Model Vs Project Deployment Model (>= SQL 2012)
• Advantages of Project Deployment Model
• Couple of Demo Deployments

Session 2: From Nobody to Somebody by Amit R S Bansal (SQLMaestros)
Abstract:
Your colleagues know you. Your friends know you? Your family knows you. They all know what you know? Isn’t that a common thing with most people around you? Don’t you want that people who don’t know you, should know you and what you know? Confused? Well, this session is all about becoming Somebody from Nobody. What does it take to be popular? Why should you think about becoming famous? And how can you achieve fame and recognition within your community? It’s time you come out of your comfort zone and show the world what you know. This session will instill that thought in you, only if you are interested. This session is un-miss-able!

Session 1: Deep Dive into Delayed Durability by Manohar Punna (SQLServerGeeks Vice President)
Abstract:
I am going to introduce you to the one of the three top features of SQL Server 2014. In my previous sessions you have been introduced to In-Memory OLTP and Buffer Pol Extensions. In this session I will be covering Delayed Durability which readily boosts your transaction throughput. I will also be covering a case study of Delayed Durability in comparison with SSDs.

Session 2: This Session will introduce you to powershell and how to use it with SQL Server by Jayaraj Vemula
Abstract:

• Introduction to Powershell
• Why use PS and how is it different from CMD?
• First Powershell Command
• Frequently used Powershell Commands or helpers
• Introduction to SMO
• Different ways to Connect to SQL Server from Powershell
• Few Low hanging DBA activities that could be automated

Here is the photo collection!

Event pictures | Orginal Emailer | Blog | Browse SQLServerGeeks Photo Albums

Session 1: What is Updatable Columnstore Index? by Sarabpreet Singh Anand (SQLServerGeeks President) & Ahmad Osama (SQLServerGeeks Chief Technical Editor)
Abstract:
Let’s learn Columnstore Index and see how Updatable Columnstore index work. It’s a new feature in SQL Server 2014.

Session 2: Extended Events by Rajiv Jog
Abstract:
What are Extended Events(XE)? Why to use Extended Events & how it works. Finally we will see a demo to find CPU expensive queries with the help of XE.

Here is the photo collection!

Event pictures | Orginal Emailer | Blog | Browse SQLServerGeeks Photo Albums

Session 1: SQL Server Operating System – What the heck is that? by Amit R S Bansal (SQLMaestros)
Abstract:
SQL Server Operating System is a mini OS inside SQL Server. In this demo-heavy session, you will see SQL OS in action, especially SQL scheduling. This session will be Level 400.

Session 2: Explore Delayed Durability in SQL Server 2014 by by Sarabpreet Singh Anand (SQLServerGeeks President) & Ahmad Osama (SQLServerGeeks Chief Technical Editor)
Abstract:
Come and join SQL Server MVP Sarabpreet as he helps us understand what is Delayed Durability and its usage in SQL Server 2014. Its a new feature introduced in SQL 2014. Do invite your friends\Colleagues to learn together & Share your experience.

Here is the photo collection!

Event pictures | Orginal Emailer | Blog | Browse SQLServerGeeks Photo Albums
Attendee Feedback & Comments (Part 1) | Attendee Feedback & Comments (Part 2)

Session 1: Introduction to Azure SQL Databases by Kumar Bijayanta (Microsoft)
Abstract:
Being relatively new, Azure SQL databases, people often wonder what it really is? What is it capable of? What are the various editions and why do they really matter? If they did decide on moving to a cloud version of SQL Server, what are the options to migrate? What are the advantages and disadvantages? This session answers these questions and guides people through a knowledge of Azure SQL databases and methods to migrate.

Session 2: Something about SQL OS that you don’t know by Amit R S Bansal (SQLMaestros)
Abstract:
In this quick, demo-only session, the speaker will show something very interesting about SQL OS.

Session 3: Embrace Cloud – Why & how by Deepthi Anantharam (Microsoft)
Abstract:
Would you focus on your core business rather than worry about peripherals such as licenses, infrastructure, maintenance, upgrades ? Architect your solutions for the cloud. From a host of PaaS services to lifting and shifting your application as is – Microsoft Azure has it all. Let us focus on storage and analytical options in the tour of Azure for the data scientist in you.

Here is the photo collection!

Event pictures | Orginal Emailer | Blog | Browse SQLServerGeeks Photo Albums
Attendee Feedback & Comments (Part 1) | Attendee Feedback & Comments (Part 2)

Session 1: Data Archive and Purge by Saurabh Kothari
Abstract:
As a DBA we always face challenge of managing and maintaining data growth considering data retention defined. While designing database if we cover all aspects of archive and purge than we can very well prevent all database performance and infrastructure related fears.

In presentation I will be doing some live demo of how a user can define and add such value or parameter which will help DBA in maintaining considering data retention provided by business and how all the process is getting automated.

Session 2: Stay alive on Social Network by Manohar Punna (SQLServerGeeks Vice President)
Abstract:
In this professional development session I will talk about the importance of staying active on Social Network. I will share few tips on how to get the most out of it and benefit professionally over the social media.

Session 3: Explore the Power of Extended Events by Manohar Punna (SQLServerGeeks Vice President)
Abstract:
Extended Events has been introduced in SQL Server 2008 and with deprecation of Profiler, now it is more critical to start using Extended Events. In this session I will briefly introduce this feature and demonstrate few scenarios of your choice from a list of Demos.

Here is the photo collection!

Event pictures | Orginal Emailer | Blog | Browse SQLServerGeeks Photo Albums
Attendee Feedback & Comments (Part 1) | Attendee Feedback & Comments (Part 2)

Session 1: Realtime Analysis with Microsoft Technologies by Sudhir Rawat (Microsoft)
Abstract:
Mostly past data get analyzed and in other words there is always the case for latency. The current industry demands the evolution of Big Data and Hadoop solutions from batch oriented jobs to real-time stream based analytics. There are some scenario where data needs to analyse on real time basis. In this session we will cover the technologies from Microsoft to achieve the same.

Session 2: Benchmarking Disk Performance by Amit R S Bansal (SQLMaestros)
Abstract:
A well-performing IO Subsystem is super critical to SQL Server’s performance. And benchmarking disk performance is super critical for a DBA. In this demo-heavy session, you will learn all the important terminologies and concepts related to disk drives and how to benchmark disks using SQLIO.

Here is the photo collection!

Event pictures | Orginal Emailer | Blog | Browse SQLServerGeeks Photo Albums
Attendee Feedback & Comments (Part 1) | Attendee Feedback & Comments (Part 2)

Session 1: Introduction to Azure SQL Database by Ahmad Osama (SQLServerGeeks Chief Technical Editor)
Abstract:
In this session we’ll explore the Azure SQL database. We’ll see how to setup and use Azure SQL Database and will explore the query platform.

Session 2: A to Z of Managed Backups to Windows Azure | SQL Server 2014 by Sarabpreet Singh Anand (SQLServerGeeks President)
Abstract:
Microsoft introduces an innovative way to handle all your backup strategy related queries, this is a new feature introduced in SQL 2014 to automate SQL Server Backups. Attend this session to learn more about its capabilities.

Here is the photo collection!

Event pictures | Event Resources | Orginal Emailer | Blog | Browse SQLServerGeeks Photo Albums
Attendee Feedback & Comments (Part 1) | Attendee Feedback & Comments (Part 2)

Session 1: Want to extend your Memory? See how SQL Server can do it by Manohar Punna (SQLServerGeeks Vice President)
Abstract:
Have you ever wanted to extend your memory so that you can have many threads running in your brain? In this session I am going to explain traditional relationship between our brain and SQL Server processing. I will introduce you to the new feature which is not explored much, Buffer Pool Extensions. How this can be corelated to our imagination.

Session 2: Troubleshooting perf problems using Xperf by Aditya Badramraju
Abstract:
Xperf is one awesome tool which is less used and which has the capability of debugging things more internally. In this session we will try to see the introduction of xperf, the ways to use it, solving complex problems such as High CPU, IO Latencies on SQL Server using Xperf.

Here is the photo collection!

Event pictures | Event Resources | Orginal Emailer | Blog | Browse SQLServerGeeks Photo Albums
Attendee Feedback & Comments (Part 1) | Attendee Feedback & Comments (Part 2)

Session 1: Building best webapps via Responsive UI using HTML5 and CSS3 by Hima Vejella (Microsoft)
Abstract:
• Case Study
• How can we implement Responsive UI Design — Hands On
• Best Practices Tips and Tricks
• Resources & Tools

Session 2: SQL OS by Manohar Punna (Regional Mentor – Hyderabad, SQLServerGeeks.com)
Abstract:
In this session I will be talking about his highness Shri SQL OS 2012 ji…, The actual mind of SQL Server.

Here is the photo collection!

Event pictures | Event Resources | Orginal Emailer | Blog | Browse SQLServerGeeks Photo Albums

Session 1: MAP-REDUCE Framework by Sudhir Rawat
Abstract:
In this session, we will discuss about how map-reduce framework works to extract out the data from distributed file system. After making slide-deck, PC, whiteboard demos, this time I will try my audience to do demo for me. It’s going to be tricky to demonstrate step by step but I am sure you will enjoy while learning it.

Session 2: Async Programming with SQL Broker by Praveen Srivatsa (CEO, AsthraSoft)
Abstract:
SQL Broker is a queue based infrastructure inside of SQL server that allows asynchronous processing of messaging. In this session, we take a look at how we can leverage the Service broker infrastructure of SQL Server to create a messaging based application.

Session 3: Quick hot things while using SSMS to save precious DBA time by Ashish Kuriyal
Abstract:
Come and learn some SSMS tips from Ashish that will make you more productive.

Here is the photo collection!

Event pictures | Event Resources | Orginal Emailer | Browse SQLServerGeeks Photo Albums
Attendee Feedback & Comments (Part 1) | Attendee Feedback & Comments (Part 2)

Session 1: Optimisation from the field: Parallelism by Ahmad Osama (Regional Mentor – Delhi NCR, SQLServerGeeks.com)
Abstract:
Know-how on parallelism and CXPACKET wait type.

Session 2: SQL Server Separation of Duties – Security Redefined by Sarabpreet Singh Anand (Vice President SQLServerGeeks.com, MVP)
Abstract:
Are you always worried about the data security? You don’t want your DBA to see what’s there in your Database? You want to avoid granting elevated privileges? If yes, come and join this session where Sarabpreet Singh will explain the tricks of trade and ways to avoid all these issues in your mission critical environment.

Here is the photo collection!

Event pictures | Event Resources | Orginal Emailer | Blog | Browse SQLServerGeeks Photo Albums

Session 1: Quick Start to SQL Server Replication by Karthick PK (Microsoft)
Abstract:
Join Karthick PK, SQL Server Expert from Microsoft where he will talk about Replication types, configuring them & troubleshooting techniques; in his style.

Session 2: Unlocking the Locking mystery in SQL Server by Amit Bansal (President & Founder, SQLServerGeeks.com, MVP SQL Server)
Abstract:
What is the purpose of UPDATE locks? When are PAGE locks taken? What is partition-level locking and when does it happen? There are just too many mysteries that Amit will de-mystify and demo during this session. Not to miss!

Here is the photo collection!

Event pictures | Event Resources | Orginal Emailer | Blog | Browse SQLServerGeeks Photo Albums
Attendee Feedback & Comments (Part 1) | Attendee Feedback & Comments (Part 2)

Session 1: SQL Server memory internals by Sanjiv Gore (Microsoft)
Abstract:
This session will provide overall understanding of SQL Server memory architecture and the concepts. Some tips, tricks, myth busting and demo.

Session 2: Lets attack Parallelly by Manohar Punna (Regional Mentor – Hyderabad, SQLServerGeeks.com)
Abstract:
From the introduction of Parallelism since SQL 7.0 there have been many misconceptions in understanding this powerful concept of SQL Server. This session will explain the detailed functionality of MaxDOP and Cost Threshold for Parallelism, two very important configuration parameters for SQL and most importantly DEMOs.

Here is the photo collection!

Event pictures | Event Resources | Orginal Emailer | Blog | Browse SQLServerGeeks Photo Albums
Attendee Feedback & Comments (Part 1) | Attendee Feedback & Comments (Part 2)

Session 1: Optimisation from the field by Ahmad Osama (Regional Mentor – Delhi NCR, SQLServerGeeks.com) (Microsoft)
Abstract:
Optimise a real world stored procedure.

Session 2: Cracking Execution Plans – SQL 2012 by Sarabpreet Singh Anand (Vice President SQLServerGeeks.com, MVP)
Abstract:
This session is for all IT Pros\Dev who are responsible for Writing Queries, Business Logic, optimizing Code or simply want to understand what’s happening under the Hood while a query executes & how it is being executed. Learn with the help of Demos how to get the Execution Plans & how to analyse the Pain areas.

Here is the photo collection!

Event pictures | Event Resources | Orginal Emailer | Blog | Browse SQLServerGeeks Photo Albums
Attendee Feedback & Comments (Part 1) | Attendee Feedback & Comments (Part 2)

Session 1: BIG DATA | The Next Step by Sudhir Rawat (Microsoft)
Abstract:
At last session, Mr. Ranjan talked about data growth in various domain. He showed data growth in various businesses. To continue from there, in this talk we’ll explore the platform to handle such a huge data. We’ll explore how/what/why different services working behind the scene. We’ll also demo Microsoft platform to handle it.

Session 2: Peace of Mind with Extended Events by Amit Bansal (President & Founder, SQLServerGeeks.com, MVP SQL Server)
Abstract:
Troubleshooting SQL Server performance has never been so easy. In this demo-heavy session Amit will show you various performance issues and how to troubleshoot them with Extended Events. You will learn techniques that weren’t possible with profiler or otherwise. It’s indeed peace of mind.

Session 3: The Power of BI with Excel 2013 by Nishant Thacker (Microsoft)
Abstract:
In this session we explore various tools within the Excel environment for BI professionals. Ranging from Self-service BI to Team BI and Enterprise BI consuming data from a variety of sources including Big Data. Join us on this journey to see why Excel is now the tool of choice for Power Users. We’ll dive PowerPivot, Power View, Power Map and Power Query to determine how you can use these in your BI environments to enrich the information delivery and analytics.

Here is the photo collection!

Event pictures | Event Resources | Orginal Emailer | Browse SQLServerGeeks Photo Albums
Attendee Feedback & Comments

Session 1: In-Memory OLTP by Manohar Punna (Regional Mentor – Hyderabad, SQLServerGeeks.com)
Abstract:
The long awaited, memory optimized tables are finally out. This is the first session of many to follow series of SQL 2014 new features. Excited!!!

Session 2: Things that you don’t know about SQL Server 2012 by Amit Bansal (President & Founder, SQLServerGeeks.com, MVP SQL Server)
Abstract:
When it comes to SQL 2012, everyone talks about AG groups or Columnstore Index or other popular features. Yes, they are awesome. But there are other cool features with SQL 2012 that are lesser known and this session is going to evangelize them. This session will have something for a Developer, a BI professional and a DBA. Come and explore some lesser known gems in SQL 2012.

Here is the photo collection!

Event pictures | Event Resources | Orginal Emailer | Browse SQLServerGeeks Photo Albums
Attendee Feedback & Comments

Session 1:Troubleshooting from the field part 2 by Ahmad Osama (Regional Mentor – Delhi NCR, SQLServerGeeks.com)
Abstract:
Using sqldiag and SQLnexus to troubleshoot SQL server.

Session 2: How to configure AlwaysON by Sarabpreet Singh Anand (Vice President SQLServerGeeks.com, MVP)
Abstract:
Attend this session to understand ABC of deadlocks why they occur how to detect and troubleshoot.

Here is the photo collection!

Event pictures | Event Resources | Orginal Emailer | title=”Browse SQLServerGeeks Photo Albums” href=”https://www.facebook.com/SQLServerGeeks/photos_albums” target=”_blank”>Browse SQLServerGeeks Photo Albums
Attendee Feedback & Comments

Session 1: Introduction to Big Data by Ranjan Bhattacharjee & Sudhir Rawat, Microsoft

Session 2: New Analytical Functions in SQL Server 2012 by Sandip Pani (Regional Mentor – Bangalore, SQLServerGeeks.com)
Abstract:
In this session I’ll be exploring all of the below new analytical functions of SQL server 2012.
(CUME_DIST ,LEAD ,LAG ,FIRST_VALUE,LAST_VALUE ,PERCENTILE_CONT,PERCENTILE_DISC,PERCENT_RANK)

I’ll be explaining how this functions works , How we were achieving the same functionality in earlier versions and now how simple it is to achieve the same.

Session 3: Tabular Modeling for DBAs by Karan Gulati, Microsoft

Here is the photo collection!

Event pictures | Event Resources | Orginal Emailer | Browse SQLServerGeeks Photo Albumsa>
title=”comments” href=”https://www.facebook.com/photo.php?fbid=537326406333633″ target=”_blank”>Attendee Feedback & Comments

Session 1: Troubleshooting from the field by Ahmad Osama (Regional Mentor – Delhi NCR, SQLServerGeeks.com)
Abstract:
Come and troubleshoot some of the common yet difficult sql server issues.

Session 2: How to configure AlwaysON by Sarabpreet Singh Anand (Vice President SQLServerGeeks.com, MVP)
Abstract:
AlwaysON is a new feature introduced in SQLServer 2012 which provides the capability of both HA as well as DR. In this session Sarab will show you step by step how to configure and use AlwaysON.

Here is the photo collection!

Event pictures | Event Resources | Orginal Emailer | Browse SQLServerGeeks Photo Albums
Attendee Feedback & Comments

Session 1: SQLServerGeeks.com webcast (Always On – Introducing the Next Generation High Availability Solution in SQL Server 2012 by Amit Bansal)
Abstract:
In this demo-heavy session, Amit will show case the new high availability solution in SQL Server 2012, called AlwaysOn. The session provides an overview of AlwaysOn and introduces the key new features and capabilities that will help businesses achieve the high availability SLA for mission critical applications. Amit will run his demos on 4 clustered Hyper-V VMs – you cannot afford to miss this !

Event Resources | Orginal Emailer
Attendee Feedback & Comments

Session 1: SQL Server memory architecture and debugging memory errors by Karthick PK (Microsoft)
Abstract:
Session will cover the architecture of SQL Server memory management, troubleshooting the SQL Server memory errors, identifying memory leaks and how to configure SQL Server memory efficiently.

Session 2: Panel Discussion (open ended) on SQL Server & Microsoft Data Platform (Karthick PK (Microsoft), Sudhir Rawat (Microsoft), Nishant Thacker (Microsoft), MVP Amit Bansal)

Here is the photo collection!

Event pictures | Event Resources | Orginal Emailer | Browse SQLServerGeeks Photo Albums
Attendee Feedback & Comments (part 1) | Attendee Feedback & Comments (part 2)

Session 1: Creating SQL Server Performance Baseline by Sarabpreet Singh Anand, (Vice President SQLServerGeeks.com, MVP)
Abstract:
Are you facing performance problems in your environment? You find it difficult to create performance baseline or tracking different counters via Profiler? You have the data but don’t really know how to use that data to create a baseline and analyse the delta in values? If your answer is yes then come and attend this Free Community session by SQLServerGeeks.com where Sarabpreet Singh Anand will explain different ways to capture the data and creating the baseline.

Session 2: Panel Discussion (open ended) on SQL Server & Microsoft Data Platform (MVP Amit Bansal, MVP Sarabpreet, MVP Dhananjay Kumar)

Session 3: Introduction – Microsoft Most Valuable Professional (MVP) Award Programby Tanmay Kapoor, (Microsoft)
Abstract:
There are millions of people who work on technology. But among those millions, there are very few who are helping others selflessly by sharing their knowledge in various forms like blogs, talks, webcasts etc. And all these are driven through their passion towards the technology. 20 Years back Microsoft initiated a way to recognize these amazing individuals for their outstanding contributions in technical communities and that’s the MVP Award.

Here is the photo collection!

Event pictures | Event Resources | title=”Orginal Emailer” href=”http://www.sqlservergeeks.com/Events/SQLServerDay_2013/SQLServerDayGurgaon_16Feb_2013/SQLServerDayGurgaon_16Feb_2013/O_SQLServerDay.htm” target=”_blank”>Orginal Emailer | Browse SQLServerGeeks Photo Albums
Attendee Feedback & Comments

Session 1: Index tuning – Things that you do not know about SQL indexes + 15 min cameo on ColumnStore indexes in SQL 2012 by Amit Bansal.
Abstract:
In this demo-heavy session, Amit Bansal will demonstrate advanced Index tuning techniques that will help SQL Developers, Engineers and Database Administrators to improve the performance of their queries, workloads & boost overall SQL Server performance. Amit will take you through real-world scenarios of bad indexing designs and how they can be rectified to improve performance. The session will conclude with a 15 minute came on the new coloumnstore index feature in SQL Server 2012.

Session 2: Panel Discussion (open ended) on SQL Server
Abstract:
Feel free to ask any SQL Server related question to our expert panel comprising of Lakshmana Kumar Kothapalli (S&P Capital IQ), Amit Bansal, Hima Himabindu Vejella (Microsoft), Abhishek Sur (MVP). Do not miss this opportunity to interact with our expert panel in an open ended discussion around SQL Server.

Here is the photo collection!

Event pictures | title=”Event Resources” href=”http://www.sqlservergeeks.com/resources/” target=”_blank”>Event Resources | Orginal Emailer | Browse SQLServerGeeks Photo Albums
Attendee Feedback & Comments

Session 1: SQLServerGeeks.com webcast (Tap is the only soution ver-2 by Sarabpreet Singh)
Abstract:
Scarcity is the fundamental economic problem of having humans who have unlimited wants and needs in a world of limited resources. Alternatively, scarcity implies that not all of society’s goals can be pursued at the same time.

Just like Water the Server Resources are also getting scarce and we should find a way to put a Tap on these resources to optimally utilize them as and when needed. In this session we’ll see a way to control & manage server resources to get desired performance and targets.

Event Resources | <a< span=””> title=”Orginal Emailer” href=”http://sqlservergeeks.com/webcasts/SSG_Webcast/8%20Nov%202012%20Thur-Tap%20is%20the%20only%20solution%20-%20Ver.%202-SarabPreetSingh/O_SQLServerGeeksWebcast.htm” target=”_blank”>Orginal Emailer

SQL Server Day in Bangalore, yet another SQL Server Day event, yet another success story! 160+ SQL enthusiasts proved what this event means for them. On Saturday, 15 September 2012, attendees started coming in at Microsoft IDC facility on Lavelle road from 1 pm onwards and within no time the entire hall was filled with 160+ SQL Geeks; all ready to learn what our speakers had to offer. We must say, Microsoft IDC in Bangalore was just awesome. The event started with Amit Bansal’s entertaining keynote followed by his session on Index Internals (performance tuning). The pick of the day was panel discussion after the refreshments break. Giri Sundaram, Sudhir Rawat, Niroop Reddy & Amit Bansal formed an expert panel answering many questions from the audience ranging from Database Administration to Business Intelligence to Performance tuning – it was all very busy day for the folks. The attendees had an excellent time networking with the speakers and amongst themselves. All in all, a great learning experience for the SQL community, another successful event from us.

Here is the photo collection!

Event pictures | Event Resources | Orginal Emailer | Browse SQLServerGeeks Photo Albums
Attendee Feedback & Comments

SQL Server Day in Gurgaon, yet another SQL Server Day event, yet another success story! 150+ SQL enthusiasts proved what this event means for them. On Saturday, 8 September 2012, attendees started coming in at Microsoft facility in Gurgaon from 1 pm onwards and within no time the entire hall was filled with 150+ SQL Geeks; all ready to learn what our speakers had to offer. The event started with Amit Bansal’ opening remarks followed by Sarabpreet Singh demoing SQL tips and tricks and the audience loved it. This was followed by Amit Bansal’s session on Index Internals. Last, Ahmad Osama de-mystified some SQL myths for developers. The attendees had an excellent time networking with the speakers and amongst themselves. All in all, a great learning experience for the SQL community, another successful event from us. And yes, we loved clicking the group photo at the end of the event, it was a challenge fitting all the attendees in the frame !

Here is the photo collection!

Event pictures | Event Resources | Orginal Emailer | Browse SQLServerGeeks Photo Albums
Attendee Feedback & Comments

Session 1: SQLServerGeeks.com webcast (Blazing Fast Performance with Columnstore Indexes part -1 by Amit Bansal)
Abstract:
This session will introduce you to a new data warehouse SQL query acceleration feature in Microsoft SQL Server 2012, called Columnstore Index. This new type of index architecture along with batch execution mode, improves data warehouse query performance by hundreds to thousands of times in some cases, and can normally give a tenfold speedup for a broad range of DW queries. Join this session (Part 1) to get introduce to this block-buster feature of SQL Server 2012. This is a 2 part series and part 2 will focus on advanced concepts related to columnstore indexes.

Event Resources | Orginal Emailer

Session 1: SQLServerGeeks.com webcast (Transactional Replication Latency by Abhay Chaudhary)
Abstract:
Solving replication latency issues is one of the most challenging tasks faced by the DBAs.We often spend a lot of time in troubleshooting the issue unsuccessfully as we try to jump to the solution rather than finding the actual problem. In the first webcast, we learnt how internally transaction replication works which is essential for again, resolving latency issues. In this webcast, we will see how to clearly find out the root cause of replication latency in less time. In future webcasts we will see how to resolve these issues.

Event Resources | Orginal Emailer

SQL Server Day in Bangalore, yet another success story. 140+ SQL enthusiasts proved what this event means for them. On Saturday, 28 July 2012, attendees started coming in at Microsoft facility in Bangalore from 9 am onwards and within know the time the entire hall was filled with 140+ SQL Geeks; all ready to learn what our speakers had to offer.

Sudhir Rawat was at his best when it comes to Business Intelligence and Sarabpreet Singh, our VP, showcased his production experience with Resource Governor. Piyush Bajaj also shared his success story as an author with SQLServerGeeks. The attendees had an excellent time networking with the speakers and amongst themselves. All in all, a great learning experience for the SQL community, another successful event from us.

Here is the photo collection!

Event pictures | Event Resources | Orginal Emailer | Browse SQLServerGeeks Photo Albums

Session 1: SQLServerGeeks.com webcast (Query Execution Plans – A Primer by Ahmad Osama)
Abstract:
Execution plan tells how SQL Server executes a query. How joins, group by, order by and aggregates are processed. A better understanding of execution plan internals not only helps troubleshooting most of the query performance issues but also to write optimized queries. In this preliminary webcast you will learn about “query processing” and “understanding graphical execution plans” to help you get started with execution plans.

Event Resources | Orginal Emailer

Session 1: SQLServerGeeks.com webcast (Transactional Replication Latency by Abhay Chaudhary)
Abstract:
We are beginning with a level 200 Webcast on Transactional Replication .Features from SQL Server 2005 and 2008 will be covered .This session will provide you a complete understanding of how Transactional Replication works .This is important and going to help you in resolving various issues related to Transactional replication.Sessions related to Replication performance , Latency and heterogeneous Replication will follow next.

Event Resources | Orginal Emailer

Session 1: SQLServerGeeks.com webcast (Log Shipping by Sarabpreet Singh)
Abstract:
You think Log Shipping is an old and not-so-worth solution to implement? Join this session and you’ll change your opinion.In this intersting session Sarabpreet Singh will show you different ways to implement Log Shipping. He’ll also explain all hidden powers of Log Shipping along with demonstrating a few key troubleshooting tips & tricks which can help you in your environment.

Event Resources

This year, we kick started SQL Server Day events with great enthusiasm and aggressiveness planning events in Bangalore, Mumbai, Gurgaon & Kolkata. The fourth and last one in this series was in Gurgaon (Delhi NCR) on 5 May 2012 at Microsoft India’s headquarters. And we must begin by saying “DelhiLites rock” !!!

This, again, was truly like a gala event with more than 100+ SQL Geeks who turned up for the event, room packed to its full capacity. And we appreciate the enthusiasm of learners, SQL geeks came all the way from Noida, Gaziabad – traveling for more than 2 hours, one way! If you know Delhi NCR, you know how big it is!

This one again was one of the most interactive events we had in a long time, the inquisitiveness of the audience kept the speakers on their toes and our speakers left no stone unturned to answer every single query being thrown at them. Ahmad Osama presented on SQL Server Transactions and Amit Bansal presented on SQL Server 2012 Business Intelligence (tabular model). As usual, our speakers did a fantastic job and the facebook comments show it all.

Here is the photo collection!

Event pictures | Event Resources | Orginal Emailer | Browse SQLServerGeeks Photo Albums
Attendee Feedback & Comments

Session 1: SQLServerGeeks.com webcast (SQL Server 2012 by Amit Bansal)
Abstract:
SQL Server 2012 delivers many highly anticipated developers features; many of them were long overdue, be it the SEQUENCE objects or the pagination feature. In this session Amit walk’s you through the new developer related features and shows off some intriguing demos while comparing performance with older techniques. You will learn what matters to you as a developer; be at the session to witness them all.

Event Resources | Orginal Emailer

This year, we kick started SQL Server Day events with great enthusiasm and aggressiveness planning events in Bangalore, Mumbai, Gurgaon & Kolkata. The third one was in Mumbai on 14 April 2012 at Microsoft Windsor (Kalina) facility. And we must begin by saying “Mumbaikars Rock” !!!

TProbably, one of the most interactive events we had in a long time, the inquisitiveness of the audience kept the speakers on their toes and our speakers left no stone unturned to answer every single query being thrown at them. Raunak Jhawar presented on SQL Server Integration Services 2012, Parikshit Savjani presented on Indirect ChckPoints in SQL Server 2012 and Amit Bansal presented on SQL Server 2012 Wait Statistics. As usual, our speakers did a fantastic job and the facebook comments show it all.

Here is the photo collection!

Event pictures | Event Resources | Orginal Emailer | Browse SQLServerGeeks Photo Albums
Attendee Feedback & Comments

This year, we kick started SQL Server Day events with great enthusiasm and aggressiveness planning events in Bangalore, Mumbai, Gurgaon & Kolkata. The second one was in Kolkata and Kolkata experience is always so different. The Microsoft facility in Kolkata, where the event was held, can only accommodate 30 attendees, and as expected, the classroom was full. We are so used to 100+ crowd that suddenly the small setup was becoming a different experience.

To begin with, the attendees were knowledgeable on SQL and had good experience. This was something that our speakers really liked including me, as we were able to have matured discussions with the audience. Sessions were presented by Abhishek Sur (MVP) and Amit Bansal (www.amitbansal.net). Abhishek presented on developer enhancements in SQL Server 2012 and Amit presented on SQL Server wait stats. Having only 30 attendees in a classroom format, as opposed to 100+ in seminar halls, things worked in our favor as the speakers were able to one-to-one discussions on many occasions; kind of a closed group talk – in a way, it was more effective.

Here is the photo collection!

Event pictures | Event Resources | Orginal Emailer | Browse SQLServerGeeks Photo Albums
Attendee Feedback & Comments

Session 1: SQLServerGeeks.com webcast (Concurrency in SQL Server by Amit Bansal)
Abstract:
Concurrency can be defined as the ability of the multiple processes to access or change shared data at same time. Failure to consider concurrency when developing applications can result in poor performance. In this demo heavy webcast you will learn about concurrency problems and their resolution.

Event Resources | Orginal Emailer

This year, we kick started SQL Server Day events with great enthusiasm and aggressiveness planning events in Bangalore, Mumbai, Gurgaon & Kolkata.

The first one was in Bangalore on 17 March 2012 at Microsoft campus. As usual, it was a packed hall with more than 130 SQL Geeks attending the event. Thanks to the Bangalore audience which is always so energetic and they do come in numbers – and they make a point; if they register, they will come; mark of a true professional. So, a big thank you to the audience !

Sessions were presented by Parikshit Savjani (PFE, Microsoft), Nickil Somani (GPS team, Microsoft) & Amit Bansal. The session started with Nickil presenting on SQL Azure and he made the session very interactive. His sessions was followed by Parikshit who talked about Indirect Checkpoints in SQL Server 2012. Being a Premiere Field Engineer, he brought all his experience to the cause and the audience loved his session. Amit Bansal presented the last session on Wait Stats in SQL Server and he was at his usual best.

Here is the photo collection!

Event pictures | Event Resources | Orginal Emailer | Browse SQLServerGeeks Photo Albums

Session 1: SQLServerGeeks.com webcast (Index Tuning by Amit Bansal)
Abstract:
In this session you will learn how to improve performance of your queries by implementing the right clustered and non-clustered indexes. You can have only one clustered index per table but an esoteric combination of non-clustered indexes. This demo-heavy session will show you some of those combinations that can work wonders for your databases.

Event Resources | Orginal Emailer

Session 1: SQLServerGeeks.com webcast Bulletproof Backup & Restore Strategy by SarabPreet Singh)
Abstract:
In this session you will learn how to plan\prepare a bullet proof recovery solution to ensure minimal possible data-loss. Recovery Models play a vital role while designing a backup recovery solution, Sarabpreet Singh will also explain the correlation between these two and how they affect RTO & RPO. This session will also include couple of Demos to gain better understand on the topic.

Event Resources | Orginal Emailer

Session 1: SQLServerGeeks.com webcast (SQL Server Locking Internals by Amit Bansal)
Abstract:
A solid understanding of Locks and Concurrency is critical whether you are a Database Administrator, Developer or Architect. In this session, Amit will demystify the locking and concurrency behavior of SQL Server. This is going to be a demo heavy session and you can apply your learnings in your day to day dealing with SQL Server.

Event Resources | Orginal Emailer

SQLServerGeeks.com delivered its 3rd SQL Server Day event in Bangalore, the Silicon Valley of India. Sudhir Rawat from Microsoft featured in our events for the 2nd time and delivered a rocking session on Denali Business Intelligence. This was followed by Sarabpreet Singh delivering a session in PowerShell for SQL Server. His Powershell expertise was much appreciated in SSG’s last event in Gurgaon and thus, he carried on with the form. Amit Bansal delivered the 3rd and final session on the day de-mystifying a few things about Locking Architecture in SQL Server. We had a fun-filled day with the 80+ audience really participating so well. Our consistent turn out shows the popularity of our events. We cherish organizing such events and will continue to do so in the future for SQL Server community.

Here is the photo collection!

Event pictures | Watch Video | Orginal Emailer | Browse SQLServerGeeks Photo Albums

SQLServerGeeks.com delivered a set of rocking sessions on SQL Server Day at Chennai on 6th August 2011 in association with Chennai SQL Server User Group. We had more than 30 people turning up for the event at Microsoft conference room in Chennai – all SQL geeks ! The event started with Vidhya Sagar (SQL Server MVP) delivering a session on TempDB performance and troubleshooting, followed by Amit Bansal delivering a session on Database Testing, followed by Madhivanan (SQL Server MVP) delivering a session on Date/Time in SQL, followed by a cameo by Ram on SQL Myths. The sessions were very well received by the audience. We cherish organizing such events and will continue to do so in the future.

Here is the photo collection!

Event pictures | Event Resources | Watch Video | Orginal Emailer

SQLServerGeeks.com delivered a set of rocking sessions on SQL Server Day at Gurgaon on 30th July 2011. We had more than 80 people turning up for the event – all SQL geeks ! Sarabpreet and Amit delivered sessions on PowerShell & Database Testing respectively. The sessions were very well received by the audience. The highlight of the day was the debate on “Whether Cloud Computing is a hype?” And we were overwhelmed to see the participation of the attendees in the debate. We cherish organizing such events and will continue to do so in the future.

Here is the photo collection!

Event pictures | Event Resources | Watch Video

SQLServerGeeks.com hosted its monthly dose of SQL Server knowledge & learning in Gurgaon on 5th Dec 2010. This was another opportunity to learn maximum from SQL Server Geeks. The event was hosted at the Microsoft premises in Gurgaon.

The event kicked off with Sarabpreet Singh’s session on Implementing Database Snapshots, which was targeted at DBA’s to make them understand how to implement snapshots in their current environment and the usefulness of it. Amit gave a lecture on Deploying & Securing OLAP databases targeting it towards the BI Developers & IT Pros to let them know more about the OLAP world. The session focussed on Deployment and Security techniques. After this session we came to the last session of the day addressed by Rajni Kant Ranjan from Wipro about Data Synchronization using Replication, which actually focuses on the Developer’s audience to show how to replicate the data from database into the applications with proper synchronization.

It was a a fun-filled day for all, besides the event we also had a great photography session. Heartfelt gratitude goes to Rishu Mehra, M. V. Priyank and & Col. Dhanaraj Saripalli for coordinating the entire event so smoothly.

Here is the photo collection!

Event pictures | Event Resources | Original Emailer

SQLServerGeeks.com hosted its monthly event on SQL Server knowledge & learning in Mumbai on the 28th Nov 2010. It was another great opportunity to learn the maximum from SQL Server Geeks. The event was hosted at the Microsoft premises in Mumbai.

Amit Bansal’s welcome notes were like icing on the cake. The event kicked off with Abhay Parekh’s session on Test Drive of SQL Azure which was targeted at Developers to make them understand what SQL Azure is and how it works along with the usefulness of it. Amit also hosted the MDX Madness: Writing your first MDX script – which was targeted towards the BI, Developers & IT Pros to let them know more about the MDX Query. The last session of the day was by Sachin Dedhia was on ETLing Flat Files, dynamically using SSIS, which was aimed at the BI audience.

The feedback for the event was excellent. The participants enjoyed the sessions greatly. Thanks to Chirag Panchal (Regional Co-Ordinator, SQLServerGeeks.com) and Girija Acharya (Regional Mentor, SQLServerGeeks.com) for flawlessly co-ordinating the event.

Here is the photo collection!

Event pictures | Event Resources | Original Emailer

The maiden Bangalore chapter of SQLServerGeeks, took place on November 20 at the Microsoft Embassy office, and had been a great experience for the speakers as well as visitors alike.

The event saw senior professionals like Vinod Kumar and Sudhir Rawat from Microsoft and Amit Bansal from SQLServerGeeks delivering rock solid sessions. A welcome talk by Vinod Kumar, an Evangelist & SQL champ from Microsoft DPE, was a food for thought as he posed a question and went on to clarify one of the misconceptions that the SQL world has. So was the talk by Sudhir Rawat who spoke on Business Intelligence and its improved integration in SQL server 2008 and 2008 r2. The last session was by Amit Bansal, the driving force behind SQL Server Geeks, which became the talk of the crowd as they dispersed later.

Thanks to all the attendees. An event like this would never have been possible without our supporters. Cheers to all the participants!

Here is the photo collection!

Event pictures | Event Resources | Original Emailer

SQLServerGeeks.com officially kicked off its series of community sessions on SQL Server, branded as SQL Server day. The Delhi NCR chapter was delivered on 24th April 2010 at the Microsoft center, Gurgaon.

Amit Bansal along with Sarabpreet Singh presented one session each on SQL Server Spatial data & Back/Restore respectively. The sessions were very well received and appreciated by the audience.

The event was attended by around 40 IT professionals and developers. Thanks to Microsoft, Rishu Mehra, Sarabpreet Singh, Amit Bansal, PeoplewareIndia, UGSS, GITCA & INETA for their kind support.

Here is the photo collection!

Event pictures | Original Emailer