SQL Server Database Objects and Dependencies Report

SQL Server exposes very much information using Dynamic Management Views and System Catalog Views. I like the idea of self-documenting systems. Manually maintained documentation tends to be outdated very fast and therefore is obsolete in many cases. What I’ve missed, is a report visualizing the Database Objects and Dependencies at a glance. Here we go!…

0

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 documentation for the following aspects: Report-Server-Structure Permissions Parameters Basic data like name, type etc. Value List, static or reference to dataset Default Value, static or reference to dataset References Shared DataSources Shared DataSets Subreports URL- and Report-Actions…

2

SQL Server Migration Assistant (SSMA): Export Data Type Mappings

Using the SQL Server Migration Assistant (SSMA), Database Migrations to various Microsoft Database targets (SQL Server Versions on premise and cloud) are possible. One aspect of the migration is the mapping between source data types and target data types. During an Oracle-2-SQL-Migration project, it was necessary to send the used Data Type Mapping to the…

0

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 functionality. In order to do so, the Report Server Object Model used for Report Rendering has to be understood. In this blog post, I want to share some insights gained during this process. It will hopefully help to…

0

Creating and Debugging a SSRS Custom Rendering Extension

SQL Server Reporting Services (SSRS) is shipped with many predefined rendering extensions to save a report in various different formats, e.g. CSV, Excel, PDF, Word, PowerPoint. Nevertheless, a customer requested creating his own rendering extension. The goal was to create a new extension based on the predefined PowerPoint-Extension with fallback to the original one. The…

0