DROP IF EXISTS aka D.I.E.

In my first post in the series “SQL Server 2016 Features for Developers” I will write about probably the smallest one – conditional DROP statement or DROP IF EXISTS. With a conditional DROP statement, you can avoid getting an exception if the object you want to drop does not exist. If a table you want […]

Speaking at SQLSaturday Belgrade

I’m proud to announce that I will present at SQLSaturday Belgrade on November 28th, 2015. In SQL Server 2016 Microsoft has decided to implement system-versioned temporal tables according to the SQL-2011 standard and my session on this conference is dedicated to it. The session name is “Temporal Tables in SQL Server 2016”. This will be […]

Introduction to SQL Azure Databases at SQLdays

Originally posted on sqlederhose:
This week I did two talks at SQLdays, Erding, Germany. One of them was an “Introduction to SQL Azure Databases”. As it was an introductionary level 200 talk, I had lot of slides to explain the concepts and the use cases pro & contra cloud computing, but also prepared some quick…

SQL Server 2016 CTP2 First Impressions – Download

Thanks to everybody who joined for the first impressions about SQL Server 2016 version. By using the following link you can download the code and slides, but also watch the videos for both sessions: http://1drv.ms/1CXzpVF.    

SQL Server 2016 CTP2 First Impressions

As most of you probably know on 27th May Microsoft announced the first public Community Technology Preview (CTP2) for SQL Server 2016. The version can be downloaded here: https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016 This versions brings a number of new features and a lot of enhancements for existing ones. Since we in bwin keep up-to-date on the latest technology […]

SQL PASS Austria Meeting April: SQL Server Extended Events & Simple Rules for Clear and Attractive Visuals

Im kommenden SQL Server Community Meeting am Mittwoch, 15. April 2015 geht es um SQL Server Extended Events und Daten Visualisierung. Ich freue mich sehr, dass diesmal das Meeting in meiner Firma bwin stattfindet. Wir werden um 17:30 starten, die Adresse lautet: Marxergasse 1B, 1030 Wien.   Making the Leap from Profiler to Extended Events If you’re […]

Beyond Statistics Histogram Part 4 – Significant Performance Regression in SQL Server 2014

In the previous articles we’ve covered differences in estimations between the old and new CE related to queries that use predicates with literals which values are beyond the statistics histogram. We saw some issues with key ascending columns in SQL Server 2012 which can be solved with the trace flags 2389, 2390 and 4139. And […]

Hurry up: SQLSaturday und Pre-Con diesen Freitag bzw. Samstag

Diesen Samstag, 28.02.2015 ist es endlich soweit: die 2. SQLSaturday Konferenz findet in Wien statt. Der SQLSaturday ist eine ganztägige, technische Konferenz und Trainings-Veranstaltung mit internationalen Vortragenden und über 20 Vorträgen rund um SQL Server. Hier geht es zur KOSTENFREIEN Anmeldung: https://www.sqlsaturday.com/374/register.aspx Wann: Samstag, 28. Februar 2015, 9:00 – 18:00 Uhr Wo: JUFA Wien City,…

Speaking in Lisbon at SQLSaturday Portugal

I’ am really excited to back as a speaker to my favorite SQL Saturday event – Sql Saturday Portugal in Lisbon. The SqlSat 369 will be my fourth event in one of the most beautiful cities in the world. I am happy to see all my Portuguese friends feat. world wide freinds from Sqlfamily. My […]

SQL Server Konferenz 2015 – Slide Decks and Sample Code

I had a great time in Darmstadt, on  the largest SQL Server conference in the German speaking area “SQL Konferenz 2015“. I was very happy to see a lot of people in the room for my session SQL Server 2014 and Ascending Key Problem in Large Tables and want to thank all the attendees. It […]