| Thomas Grohser
BWIN |
About In the last 15 of my more than 20 years as an IT Professional I spent the majority of the time exploring the deeper inner workings of SQL Server and his features while working for entertainment , pharmaceutical and other industry leading companies. The main focus of my work is to architect, plan and provide a reliable, highly available, secure and scalable infrastructure for and with the features of SQL Server. This covers all angles from hardware, network, storage systems, Operating systems, SQL Server configuration and the Data Access Layer of applications; Currently I work at one of the largest SQL Server installations in the world processing hundreds of millions of transactions daily while moving peta bytes of data in a 24x7 environment; Now its time to share all the findings and the gathered know how with the SQL Server community therefore I started speaking regularly at international conferences in North America and Europe and at local events and work closely with SQLCAT to make sure everyone interested can access the information. |
| Website/Blog N/A |
Video N/A |
| Track: SQL | |
Session title |
Session description |
100% Uptime while doing 24h of Maintenance every day |
The problem of globally operating internet sites or any other real 24x7 operation is, that there is no time for maintenance. This session will show you a way to partition your user data in a way that you can maintain each partition at least once a day. If you place the partitions on different servers you can even maintain the servers on a daily basis without interrupting your users. You will hear how it works in theory, see a proof of concept demo and learn how to analyze your data to make the same partitioning for your application. |
Failure is not an Option - VLDB Infrastructure |
See how to combine several SQL Server features like backup, log shipping, database mirroring, Replication and more to build an zero data loss, high available infrastructure that scales up from normal every day workloads to 450.000+ TSQL statements per second. You will learn (step by step) how to archive zero data loss, high availability and performance. The session will show you also with code samples and a demo how to overcome some limitations of database mirroring to make 99,99% availability happen in a 24x7 environment and fulfill the SLA. |
SQL Server Storage Engine under the hood: How SQL Server performs I/O |
How is SQL Server really accessing the data and log files on the disk? What's done asynchronous and what's synchronous and what impact does that have on our queries and DML statements. Which impact have features like database mirroring and
replication, what's different when SQL Server is starting up. |