SSMS Client statistics

My take on the client statistics of SQL Server Management Studio

Select * in a view

My take on the inner workings of SQL Server and views

Deploying a database to Azure

How to avoid high costs for your Azure SQL DB @Azure @SQLServer

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 →

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? →