What we're about
Upcoming events (3)
Are you responsible for database changes such as index management or configuration changes?
Have you experienced how a seemingly harmless change like changing an index went south completely after the release on production? Or do you even prefer not to make any changes at all due to the uncertainty of the outcome?
Then this session is for you! Get to know the power of DB-Workload-Tests: recording and replaying the complete activity of a database. Sounds complicated? It doesn't have to be that way. After the session you have the tools to perform workload testing as well. This gives you the chance to get to know possible problems related to changes directly through the workload test and to fix them before a release to production.
Good knowledge of schema adjustments (changing tables, indexes etc.) and querying using TSQL is required. Further knowledge in the field of performance tuning or database administration (especially backup / restore) is an advantage.
About Martin Guth
Martin Guth (37) has been a passionate BI developer for more than 11 years. He has also been fascinated by database administration for 5 years. He works at 3C Deutschland GmbH (part of Experian Ltd.) in Heilbronn. Highlights from his work as a BI developer are building a data warehouse from scratch and delivering analytic products.
As a database administrator, performance tuning is particularly important to him. Martin shares his experiences (deliberately irregular) on his blog at martinguth.de.
Most modern programming environments offers exception handling in some form, and SQL Server provides the popular TRY-CATCH concept. However, error handling in SQL Server is not as straightforward as one may wish, but it is marred with inconsistencies and surprises. This session starts off by displaying the some of the surprises you can encounter, both when you use TRY-CATCH and when you don't. The session presents a recipe for writing CATCH block where focus is on keeping things simple and you will learn why it is not a good idea to make your error handling ""fancy"", although it may seem to be a good idea in theory. The session also covers a few things to think of on client level.
About Erland Sommarskog
Erland Sommarskog is an independent consultant based in Stockholm. He has worked with SQL Server since 1991. He was first awarded SQL Server MVP in 2001, and he has been re-awarded every year since. His focus is on systems development with the SQL Server Database Engine and his passion is to help people to write better SQL Server applications.
SQL FRIDAY #50 - Markus Ehrenmüller-Jensen on 'From SQL to R – Leverage Your T-SQL Knowledge to Learn R'
You are already familiar with T-SQL and are eager to learn R but do not know, where to start? Start from what you already know: T-SQL. Both languages have many things in common on some levels, but are very different on others. This session will kick you off to the new language by using analogies from T-SQL. You will learn how to write your first R-scripts, make usage of packages and will leave this session with a basic understanding of typical use-cases of R and how to integrate that into your existing environment with SQL Server.
About Markus Ehrenmüller-Jensen
Markus Ehrenmüller-Jensen is the founder of Savory Data and works as a project leader, data engineer and BI architect since 1994. He is an educated software-engineer, graduated business educator and professor for databases and project engineering at HTL Leonding (technical college) and certified as MCSE Data Platform and MCSE Business Intelligence. Markus speaks regularly on international conferences (eg. SQL PASS Summit, SQLBits London, Power Platform Worldtour, SQL Saturdays, SQL Days, SQL PASS Austria, ...) and writes articles for well-known journals. In 2013 he co-founded SQL PASS Austria and in 2016 Power Platform Usergroup Austria and organizes SQL Saturdays in Vienna since 2014. For his technical leadership in the community he was awarded repeatedly as a Microsoft Data Platform MVP since 2017.