Do you know C.R.A.P. when you see it?
If you popped by this blog, chances are that you work with BI or data analysis or just find...
Enhancing the pattern by keeping text in check
Text is an indispensable helper when we make data visualizations, but we need to be careful not to...
Leveraging comparison in a stacked bar chart
Redesigning existing charts has become a popular way to learn more about data visualization.
SQL Server trace flags
Normally I’m not a big fan of using trace flags, my advice is only to use these when it is...
Backup On-Premises SQL Server Databases to Azure Storage
SQL Server has supported backing up directly to Azure Blob Storage since SQL Server 2012 SP1 CU2....
Updateable views
By default view are updateable. It means you can write a TSQL update statement against a view just...
Change Data Capture (CDC) in SQL Server Integration Services (SSIS)
SQL Server introduced dedicated SSIS components for working with Change Data Capture (CDC), making...
