Skip to content
jeeja.biz
Mainly IT stuff
  • About
  • Blog
  • Contact
  • RSS

How to export all Views from a database

2022-01-242022-01-24

Friends don’t let friends use INFORMATION_SCHEMA, but… I know the whole diatribe about INFORMATION_SCHEMA and I would not join the…

Read More
SQL Server, T-SQL

DROP and CREATE All Constraints

2022-01-17

Notes This blog has become a notebook where I can write down queries that I will reuse later on. Have…

Read More
SQL Server, T-SQL

One size fits all Dynamic Data Masking

2021-12-21

One size doesn’t fit all I can now define myself as an expert in Dynamic Data Masking. I’ve used all…

Read More
Security, SQL Server, T-SQL

Obfuscating data through Data Scramble in Bulk

2021-12-10

PROBLEM And we arrive to the last chapter of this session about how to mask and obfuscate data. This time…

Read More
Security, SQL Server, T-SQL

Obfuscating data through Data Shuffle in Bulk

2021-12-07

PROBLEM When Dynamic Data Masking is not an option you can go for Data Shuffle. Data Shuffle is when you…

Read More
Security, SQL Server, T-SQL

How to export Dynamic Data Masking

2021-12-012021-12-01

PROBLEM One day or another you arrive to the point where you have to mask your database. You pass days…

Read More
Security, SQL Server, T-SQL

How to export Data Classification

2021-11-27

PROBLEM In my previous post I described how Data Discovery and Classification is a half done tool. Personally I loved…

Read More
Security, SQL Server, T-SQL

Data Discovery and Classification with Data Preview

2021-11-24

PROBLEM I’m currently working on a project that is a sort of spaghetti monster. On all sides. The databases are…

Read More
Security, SQL Server, T-SQL

How to blind Reverse Engineer SQL Server database to ERD

2021-11-102021-11-14

Problem I lately faced a problem: we are working on a complex ETL project that aims to migrate a database…

Read More
hacking, Power BI, Reverse Engineering, SQL Server

Assess an enterprise and consolidate assessment reports with DMA

2021-08-302021-08-31

This post has the same title as the official Microsoft guide Assess an enterprise and consolidate assessment reports with DMA. …

Read More
Azure, Migration, Power BI, SQL Server

Posts navigation

1 2 3 4

Newsletter subscription:

Tag Cloud

architecture automation Azure Azure OSS Databases Databases DB2 Docker hacking hardware IBM Linux MAP Toolkit MariaDB Migration Monitoring MySQL NAS performances PostgreSQL Power BI PowerShell Reverse Engineering Security SQL Server Synology T-SQL WordPress WSL WSL2
HTML tutorial
profile for Francesco Mantovani on Stack Exchange, a network of free, community-driven Q&A sites
© 2022 jeeja.biz
Powered by WordPress | Theme: Cordero by UXL Themes