A bit late (as usual) but time to look back on 2019 en look forward to 2020 2019 This year has been weird. All year long i had some lingering doubts about the way my career was becoming stagnant. I was still learning a lot, but i was having a hard time putting it to … Continue reading 2019 | 2020
Error on Linked Server SQL state 42000 error 7314
Blog: why can't i see data from my linked server connection?
TSQL Tuesday #121: Gifts received for this year
#tsql2sday blog post: gifts from this year,
Unexpected view behaviour
A short demo about a view returning an error when it contains a native sql function.
Losing SQL Agent history
A short blog to show and preserve SQL Agent history.
Bulk insert and the Foreign Key mystery
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
T-SQL Tuesday #119 -Changing your mind
My T-SQL Tuesday blog where i change my mind about many many many things
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
Reitse's blog 