Dealing with the Microsoft Data Platform
Some notes from the field as consultant in Data Insights
Reverse string in Excel using array formula and without VBA
Being in the middle of something, suddenly the need to reverse a string in Excel arose. Using the...
Author: Johann Hackl Date: 02/22/2018
SQL Server: Compare row count local and remote for Oracle Linked-Server-Connection
As part of an Oracle2SQL-Project, it was required to compare the row count of the destination tables...
Author: Johann Hackl Date: 10/06/2017
SQL Server Database Objects and Dependencies Report
SQL Server exposes very much information using Dynamic Management Views and System Catalog Views. I...
Author: Johann Hackl Date: 09/09/2017
SQL Server Reporting Services: Inventory-Report with Parameters, Dependencies and Permissions
During a SSRS project with a lot of reports, there was the idea to have a detailed non-static...
Author: Johann Hackl Date: 08/25/2017
SQL Server Migration Assistant (SSMA): Export Data Type Mappings
Using the SQL Server Migration Assistant (SSMA), Database Migrations to various Microsoft Database...
Author: Johann Hackl Date: 08/04/2017
Dealing with the Report Server Report Rendering Object Model
After creating a working stub of a Custom Rendering Extension, it was time to add the actual...
Author: Johann Hackl Date: 07/16/2017
Creating and Debugging a SSRS Custom Rendering Extension
SQL Server Reporting Services (SSRS) is shipped with many predefined rendering extensions to save a...
Author: Johann Hackl Date: 07/14/2017