Why should I care how many lines of code my database has? You are right, it shouldn’t matter. But when…
Read MoreSQL Server
September Free Community Tools Awareness Month
I want to seize the opportunity to join the September Free Community Tools Awareness Month . As an accidental DBA…
Read MoreClose Encounters :: Microsoft OLE DB Provider for DB2
You sometime have to deal with ODBC Data Source. You don’t want to, but you have to. I’m currently finalizing…
Read MoreBowel Movements :: How to migrate a DB2 database to SQL Server
Haemorrhoids, this is how I should have called this post. If you have been dealing with DB2, Oracle or Microsoft…
Read MoreT-SQL :: DELETE All Data in Schema
I never empathize enough how much the welfare of my family relies on StackOverflow. Every time I receive help I…
Read MoreHow I use sp_WhoIsActive
sp_whoisactive is a nice little tool that has lately been updated by Adam Machanic. If you work with SQL Server…
Read MoreAzure: should I use Single Tenant or Multi Tenant?
Introduction Holy moly! I’m been so busy skiing lately that I’ve completely forgot to write on my blog. I open…
Read MoreHow to export all Views from a database
Friends don’t let friends use INFORMATION_SCHEMA, but… I know the whole diatribe about INFORMATION_SCHEMA and I would not join the…
Read MoreDROP and CREATE All Constraints
Notes This blog has become a notebook where I can write down queries that I will reuse later on. Have…
Read MoreOne size fits all Dynamic Data Masking
One size doesn’t fit all I can now define myself as an expert in Dynamic Data Masking. I’ve used all…
Read More