Skip to main content

Posts

Showing posts from April, 2019

SQL Server Reporting Services best practices

SSRS (SQL Server Reporting Services) Best Practices Data Sources 1.      Use shared data sources even if there is only dataset 2.      In case of providing fixed credentials, use read-only user accounts 3.      Do not create report using SSRS Report Builder Data Sets 1.       Try to keep report fields in single dataset. If the parameters are being populated from dataset then that dataset must be kept separate. 2.       Do not hard code anything either in the query or calculated dataset fields. Use parameters instead of hardcoding values 3.       Instead of filtering data in the dataset filters, filter the same in query 4.       Do not pull unnecessary fields 5.       Do not call queries that updates data in the data source objects e.g. Database Table 6.    ...

SSIS (SQL Server Integration Service) Naming Conventions

SSIS (SQL Server Integration Service) Naming Conventions Task name Prefix Type New For Loop Container FLC Container Foreach Loop Container FELC Container Sequence Container SEQC Container ActiveX Script AXS Task Analysis Services Execute DDL Task ASE Task Analysis Services Processing Task ASP Task Azure Blob Download Task ADT Task * Azure Blob Upload Task AUT Task * Azure HDInsight Create Cluster Task ACCT Task * Azure HDInsight Delete Cluster Task ACDT Task * Azure HDInsight Hive Task AHT Task * Azure HDInsight Pig Task APT Task * Back Up Database Task BACKUP Task * Bulk Insert Task BLK Task CDC Control Task CDC T...