A short blog to show and preserve SQL Agent history.
Losing SQL Agent history
A short blog to show and preserve SQL Agent history.
Tag: SQL SERVER
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
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.
Reitse's blog 