DataPlatformGeeks – Recent & Past Events
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!
Browse Event pictures | Event Resources | Orginal Emailer | Browse SQLServerGeeks Photo Albums | Attendee Feedback & Comments
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!
Browse 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!
Browse Event pictures | Event Resources | Orginal Emailer | Browse SQLServerGeeks Photo Albums | Attendee Feedback & Comments
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!
Browse Event pictures | Event Resources | Orginal Emailer | Browse SQLServerGeeks Photo Albums
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!
Browse 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 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!
Browse 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!
Browse 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 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!
Browse Event pictures | Event Resources | Orginal Emailer | Browse SQLServerGeeks Photo Albums
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Data Platform Summit 2017 August 17 – 19, 2017 |
SQLServerGeeks Annual Summit 2016 August 11 – 13, 2016 |
SQLServerGeeks Annual Summit 2015 August 27 – 29, 2015 |