SQL 2017 and SSIS

Error 27203 when importing a dtsx file or ispac file into the SQL Server SSIS database.

T-SQL Tuesday-118, What are your wishes for SQL Server?

This month the T-SQL Tuesday is hosted by Kevin Chant (b | t) and he asks us what our fantasy feature would be for SQL Server To answer that question, the starting point is the way i work with SQL Server. My company is mostly working with ETL software, meaning the databases are 99% datawarehouses. … Continue reading T-SQL Tuesday-118, What are your wishes for SQL Server? →

T-SQL Tuesday #116 – SQL on Linux

Sql Server on Linux? Why not! #tsqlTuesday #tsql2sday

SQL Server 2008 and R2 is history!

SQL Server 2008 and 2008 R2 no longer supported by Microsoft!

dbatools 1.0 released!

Celebrate dbatools 1.0 and my own insignificant history with this wonderfull project.

Datagrillen, the event you must not miss!

A short review of two excellent days at DataGrillen #datagrillen

T-SQL Tuesday #115 – Dear 20 Year Old Self

A new T-sql Tuesday post: Write a letter to your 20 year old self.

Missing SQL Agent job history?

A weird issue with missing log data from the SQL Server Agent.

T-SQL Tuesday #113 – What Do YOU Use Databases For?

#tsql2sday

MaxDop Fun

Erik Darling posted a great video with results i couldn't reproduce. Untill i stumbled on some clustered columnstore behaviour 😀