Today i ran into a weird thing. One of our clients found out that with using SAP Data Services (an ETL tooling by SAP) where you can use the bulk load setting, foreign keys on a table got disabled. Demo To test this out, i've created a small demo CREATE TABLE BASE_TABLE ( ID INT … Continue reading Bulk insert and the Foreign Key mystery
My T-SQL Tuesday blog where i change my mind about many many many things
Error 27203 when importing a dtsx file or ispac file into the SQL Server SSIS database.
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?
Sql Server on Linux? Why not! #tsqlTuesday #tsql2sday
SQL Server 2008 and 2008 R2 no longer supported by Microsoft!
Celebrate dbatools 1.0 and my own insignificant history with this wonderfull project.
A short review of two excellent days at DataGrillen #datagrillen
A new T-sql Tuesday post: Write a letter to your 20 year old self.
A weird issue with missing log data from the SQL Server Agent.
Reitse's blog 