SQLSaturday #116 - Bangalore 2012
Event Date: 01/07/2012 00:00:00
Event Location:
- Microsoft Signature Building
- Domlur, Bangalore
- Bangalore, Karnataka, India
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: Keynote
Abstract: Keynote
Speaker(s):
- Karan Gulati
Track and Room: Practical Track - N/A
Title: BI in Denali
Abstract: New Features in Denali from BI Perspective -BISM (Tabular Model) -DAX -Crescent -PowerPivot
Speaker(s):
- Karan Gulati
Track and Room: Practical Track - N/A
Title: A Whirlwind Tour of Contained Databases and TSQL e
Abstract: SQL Server 2012 will introduce the concept of a contained database . CDBs represent a fundamental shift in the architecture of SQL Server that will simplify the development and management of SQL Server applications. Without containment, SQL Server databases are highly intertwined with the instance on which they reside. This entanglement complicates application development, deployment, and management tasks.
Speaker(s):
- Pranab Mazumdar
Track and Room: Practical Track - N/A
Title: Want Databases Always Available?AlwaysOn Unplugged
Abstract: This session will describe how to build practical end-to-end HA and DR solutions for mission critical applications using SQL Server 2012 AlwaysOn technology. For example, how to combine Failover Cluster Instances with Availability Groups to provide a complete HA and DR solution, how to use Availability Groups Multiple Secondaries to replace existing database mirroring + log shipping solutions. Readable Secondaries, backup on secondaries are kool features which would be covered.
Speaker(s):
- Balmukund Lakhani
Track and Room: Main Track - N/A
Title: SQL Sever Dev Tools - Code Name Juneau
Abstract: SQL Server Developer Tools, or SSDT (code-named Juneau), represents Microsoft’s continued commitment to providing integrated tools for developers targeting Microsoft SQL Server. Those familiar with the previous versions of the Database Project in Visual Studio will find that Juneau is an evolution of those tools for SQL Server, plus many new capabilities and improvements.
Speaker(s):
- Lohith GN
Track and Room: Main Track - N/A
Title: Avoid Errors on Errors
Abstract: Did you know that when SQL encounters an error of Severity 11 (or higher), there a 4 different ways it can react? Learn how to predict the Error Action or control it. This is possible with or without structured error handling. See both ways to control the outcome. This is a very common workplace faux pas and a Microsoft Certification topic for Dev and Admins. We will use lessons from SQL Programming Joes 2 Pros Vol4.
Speaker(s):
- Rick Morelan
Track and Room: Main Track - N/A
Title: SQL Server Performance Tips and Tricks
Abstract: In this session we will go over various SQL Server Performance Tuning Tricks and Tips.
Learn about top tips and best SQL Server performance practices related to: o Unused Indexes o Clustered Indexes o Importance of Statistics o Index Maintenance Scripts o ColumnStore Index o A Surprise Secret Tip
Speaker(s):
- Pinal Dave
Track and Room: Main Track - N/A
Title: SQL Server Clinic
Abstract: In this track we are going to have resources from SQL Server support at Microsoft available at a booth for QA. If you have a question about how things work in SQL Server, how to make best use of them, or something is broken and you need help - walk over and talk to experts from Escalation servcies at SQL Server support at Microsoft.
Speaker(s):
- Tejas Shah
Track and Room: Practical Track - N/A
Title: Basic Performance Tips and Gotchas
Abstract: Forget Profiler for a second, I have seen one poorly placed index bring an enterprise database to its knees. We will cover the basic tips of performance which always work and the ones which always fail. What can you do – and what should you do –when it comes to the most common types of indexes so you always make the right move. We will use lessons from SQL Architecture Joes 2 Pros Vol3.
Speaker(s):
- Rick Morelan
Track and Room: Main Track - N/A
Title: Demsytifying SQL Server Memory Dumps
Abstract: This session will help you understand when memory dumps are generated in SQL Server, what information can be gathered without analyzing the dump and how much can be done by just using public symbols.
Speaker(s):
- Amit Banerjee
Track and Room: Practical Track - N/A
Title: Security with SQL Server - Discovering Pitfalls
Abstract: Compliance and auditing are some of the core tenants around which SQL Server based applications can be built. But understanding the intracacies of each of these fundamentals is critical to both developers and administrators alike. Come to this fun filled, demo centric and interesting session where we unearth some of these fine prints in understanding why we use SQL Server the way we use it and build the system is the most secure and locked down mode.
Speaker(s):
- Vinod Kumar M
Track and Room: Main Track - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Balmukund Lakhani
Contact: http://www.sqlserver-help.com
Balmukund is currently working as Technical Lead - SQL Support team with Microsoft India GTSC. Balmukund is passionate for technology, learning and sharing his knowledge. He is active blogger on www.sqlserver-help.com to share his knowledge with world. He also owns project SQLServerFAQ (http://blogs.msdn.com/SQLServerFAQ) where SQL support team writes technical content on various topics.
Pinal Dave
Twitter: - @pinaldave
LinkedIn: Pinal Dave
Contact: http://blog.sqlauthority.com
Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 12 SQL Server database books, 30 Pluralsight courses and has written over 5000 articles on the database technology on his blog at a https://blog.sqlauthority.com. Along with 16+ years of hands-on experience, he holds a Masters of Science degree and a number of database certifications.
Rick Morelan
Rick has worked more than 12 years at Microsoft and has attained over 30 Microsoft technical including certifications in applications, networking, databases and .NET development (MCDBA, MCTS, MCITP, MCAD, MOE, MCSE, MCSE+I). He has also provided training for NW University, Volt Technical Education, The DigiGirlz, and Microsoft. Rick is the Author of the 5 volume SQL Joes 2 Pros book series.
Rick Morelan
Rick has worked more than 12 years at Microsoft and has attained over 30 Microsoft technical including certifications in applications, networking, databases and .NET development (MCDBA, MCTS, MCITP, MCAD, MOE, MCSE, MCSE+I). He has also provided training for NW University, Volt Technical Education, The DigiGirlz, and Microsoft. Rick is the Author of the 5 volume SQL Joes 2 Pros book series.
Pranab Mazumdar
I am presently aligned to our Escalation Services team as a Support Escalation Engineer for SQL Server. I am with Microsoft for little more than 7 years now.
Tejas Shah
Twitter: - @mr_tejs
LinkedIn: Tejas Shah
Tejas is a Principal Program Manager with SQL Tiger team at Microsoft. Prior to that he worked as an Escalation Engineer with SQL support team for over 13 years and has an overall industrial experience of over 19 years.
Vinod Kumar M
Twitter: - http://twitter.com/vinodk_sql
Contact: http://blogs.ExtremeExperts.com
Vinod Kumar has worked with SQL Server extensively since joining the industry over more than 17 years back. Working on various versions from SQL Server 7.0, Oracle 7.3 and other database technologies - he now works with Microsoft Technology Center (MTC) as Technology Architect. With extensive database, BI and application background, he currently helps customers maximize on the investments on technologies to solve real world business and technology integration problems. Speaker in major conferences like TechEd India (12 yrs), TechNet, MSDN, Azure Conference etc.
Karan Gulati
Contact: http://blogs.msdn.com/karang
Employer - Microsoft India Designation - Support Escalation Engineer (SQL BI) Handling Critical Cases from Premier and Mission Critical Customers, only Escalation Rersouce in India for SQL Analysis Services. Apart from daily case work i am very active blogger, in free time i try to help Dev Community through Forums. In July 2011, I appared for SSAS Maestro (MCM) in Redmond - resut awaited.
Amit Banerjee
Twitter: - banerjeeamit
LinkedIn: Amit Banerjee
Contact: http://www.troubleshootingsql.com
I am a data professional with over a decade of experience in Relational Database Management Systems. I lead Program Management for the SQL Server engineering team focusing on the SQL Server database engine (Windows and Linux) and Azure SQL Edge.
My past experiences include Program Management for Business Continuity and Disaster Recovery (HADR), Data Movement and Performance for SQL Server, Azure Database for PostgreSQL and Azure Database for MySQL.
I am an active blogger, co-author of Pro SQL Server on Microsoft Azure and Professional SQL Server 2012: Internals and Troubleshooting and a regular speaker at various community events like Microsoft Ignite, SQL PASS, TechEd, Virtual Tech Days, SQLSaturday and User Group meetin
Lohith GN
Contact: http://kashyapas.com
Well - you can know more about me here - http://about.me/kashyapa
Karan Gulati
Contact: http://blogs.msdn.com/karang
Employer - Microsoft India Designation - Support Escalation Engineer (SQL BI) Handling Critical Cases from Premier and Mission Critical Customers, only Escalation Rersouce in India for SQL Analysis Services. Apart from daily case work i am very active blogger, in free time i try to help Dev Community through Forums. In July 2011, I appared for SSAS Maestro (MCM) in Redmond - resut awaited.
Sponsors
The following is a list of sponsors that helped fund the event: