Nr: 116
SQLSaturday #116 - Bangalore 2012
SessionID: 28966
Demsytifying SQL Server Memory Dumps
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: Practical Track
Speaker: Amit Banerjee
Title: Demsytifying SQL Server Memory Dumps
Abstract:
SessionID: 29089
Want Databases Always Available?AlwaysOn Unplugged
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: Main Track
Speaker: Balmukund Lakhani
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.
SessionID: 31173
BI in Denali
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: Practical Track
Speaker: Karan Gulati
Title: BI in Denali
Abstract:
New Features in Denali from BI Perspective
-BISM (Tabular Model)
-DAX
-Crescent
-PowerPivot
SessionID: 31175
Keynote
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: Practical Track
Speaker: Karan Gulati
Title: Keynote
Abstract:
Keynote
SessionID: 31206
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: Main Track
Speaker: Lohith GN
Abstract:
SessionID: 32232
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: Main Track
Speaker: Pinal Dave
Abstract:
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
SessionID: 32328
A Whirlwind Tour of Contained Databases and TSQL e
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: Practical Track
Speaker: Pranab Mazumdar
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.
SessionID: 32507
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: Main Track
Speaker: Rick Morelan
Abstract:
SessionID: 32508
Avoid Errors on Errors
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: Main Track
Speaker: Rick Morelan
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.
SessionID: 33352
SQL Server Clinic
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: Practical Track
Speaker: Tejas Shah
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.
SessionID: 33841
Security with SQL Server - Discovering Pitfalls
Event Date: 07-01-2012 - Session time: 00:00:00 - Track: Main Track
Speaker: Vinod Kumar M
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.