My take on the inner workings of SQL Server and views
Select * in a view
My take on the inner workings of SQL Server and views
Category: Geen categorie
Deploying a database to Azure
How to avoid high costs for your Azure SQL DB @Azure @SQLServer
SSMS funny feature
You can edit the SSMS default query's!
2019 | 2020
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
Reitse's blog 