Altering an Indexed Text Column

In this post, I am going to demonstrate how increasing the size of a text column with an index on it can lead to serious troubles without warning. I tested it two instances of SQL Server: SQL Server 2016 and 2017, but the same behavior should be expected with older versions; only the maximal allowed […]

Speaking at CI SQLPort Meeting in Lisbon

As always, I had a great time in Lisbon. I enjoyed this beatiful city and also visited Cascais and spent some time in the Atlantic ocean. But, Lisbon and Portugal are not only natural beauties, but also warm, openminded and cordial people. I meet again my friend Niko Neugebauer (blog | twitter) , an icreadible […]

#Tarabica 18 Conference– Slide Decks and Sample Code

As always, I had a great time in Belgrade, at the large IT conference in Serbia #Tarabica18. I was very happy to see so many people in the room for my session SQL Server 2017 za developere and want to thank all the attendees. It was really pleasure to deliver the session in that audience. […]

SQL Community Meeting 24. Mai

Am Donnerstag, 24. Mai 2018 findet unser nächstes SQL Community Meeting ab 17:30 bei Microsoft Österreich in Wien mit zwei spannenden Vorträgen statt: Apache Spark on Azure: Introduction to Azure DataBricks Azure DataBricks is one of the newest services in Microsoft Azure. It provides a fast, easy to use and collaborative platform to run Apache Spark […]

SQL Server 2017 Developer’s Guide

Together with Dejan Sarka (blog | twitter) and William Durkin (blog | twitter) I have finished writing the SQL Server 2017 Developer’s Guide book. The book is available at the Packt Publishing portal https://www.packtpub.com/big-data-and-business-intelligence/sql-server-2017-developer%E2%80%99s-guide and Amazon https://www.amazon.com/SQL-Server-2016-Developers-Guide-ebook/dp/B01MS5L01Q. Here is a very brief book description: Microsoft SQL Server 2017 is the next big step in the […]

SQL Server 2016 Developer’s Guide

Together with Dejan Sarka (blog | twitter) and William Durkin (blog | twitter) I have finished writing on the SQL Server 2016 Developer’s Guide book. The book is available at the Packt Publishing portal https://www.packtpub.com/big-data-and-business-intelligence/sql-server-2016-developer-guide and Amazon https://www.amazon.com/SQL-Server-2016-Developers-Guide-ebook/dp/B01MS5L01Q. Here is a very brief description of all chapters of the book. Chapter 1: Introduction to SQL […]

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.