I want to seize the opportunity to join the September Free Community Tools Awareness Month . As an accidental DBA…
Read MoreSQL Server
Close 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 MoreObfuscating data through Data Scramble in Bulk
PROBLEM And we arrive to the last chapter of this session about how to mask and obfuscate data. This time…
Read More