↓
 

The Intransigent Data Blog

Getting data to toe the line

The Intransigent Data Blog
The Intransigent Data Blog
  • Home
  • About this Blog
  • Links
  • Toolset
Home - Page 3 << 1 2 3 4 5 6 >>

Post navigation

← Older posts
Newer posts →

SSRS Date Range Parameter

The Intransigent Data Blog Posted on 06/05/2016 by Andrew Ing23/04/2017

Summary A method for providing a selection of pre-set date ranges plus the ability to enter a custom range of dates. Until the SSRS improvements in 2016, this will require Nullable date parameter boxes to be used. (Why could not … Continue reading →

Posted in SSRS

Data-Tier Application (dac) and SqlPackage.exe

The Intransigent Data Blog Posted on 27/04/2016 by Andrew Ing03/05/2016

Can you install tools to export/deploy DacPac files without requiring a Visual Studio installation? Prerequisites.  Install following from Microsoft SQL Server 2014 Feature Pack https://www.microsoft.com/en-us/download/details.aspx?id=42295 ENU\x64\SqlDom.msi ENU\x64\SQLSysClrTypes.msi Install Data-Tier Application Framework.  (May 2015 version is here: https://www.microsoft.com/en-us/download/details.aspx?id=46898.  This took some finding: there was … Continue reading →

Posted in DBA

Master Data Services 2012 Notes

The Intransigent Data Blog Posted on 06/03/2016 by Andrew Ing06/04/2016

Notes from a first brush with MDS. Installation (2102) The ApplicationPool credential should be a member of MDS_Services (?) local user group. (not convinced that setup does this for you). The installation is not complete until you get the chance … Continue reading →

Posted in MDS

Parse SSRS Subscriptions Table

The Intransigent Data Blog Posted on 26/02/2016 by Andrew Ing26/02/2016

Information about Report subscriptions is held in ReportServer.dbo.Subscriptions table. ExtensionSettings XML Fragment with root node <ParameterValues>  Contains information about the format and destination of the report. Each <ParameterValue> element has child <Name> and <Value> nodes : named according to classical … Continue reading →

Posted in SSRS

Duration Dimension

The Intransigent Data Blog Posted on 21/02/2016 by adminUsr22/02/2016

For measuring short durations, such as telephone calls or handling times. Q1 Linear Grain? The question I haven’t answered is whether the dimension should be at the finest grain for all durations.  The grain I am using is seconds but … Continue reading →

Posted in Data Warehouse, T-SQL

SSRS Linked Reports

The Intransigent Data Blog Posted on 04/12/2015 by Andrew Ing09/02/2016

Is it worth the effort? Advantages Can encapsulate a set of defaults. Pre-configurations of a very general report, for example. Disadvantages Links between reports take users to the master source folder. (!) Dynamic parameter defaults don’t survive linking.  Instead the … Continue reading →

Posted in Uncategorized | Tagged SSRS

SSRS tips and techniques

The Intransigent Data Blog Posted on 03/12/2015 by Andrew Ing16/01/2022

Display All Values on a Graph’s Axis Set Interval in Axis Options section to 1. Auto is normally too sparse for my liking on date axes.  Setting an Interval expression disables auto-settings although the layout will still be adjusted automatically (staggered … Continue reading →

Posted in SSRS | Tagged SSRS

Sql Server Service Broker (SSSB)

The Intransigent Data Blog Posted on 02/12/2015 by Andrew Ing03/12/2015

SSSB Endpoint Authentication Certificate Don’t forget to give this a long lifetime (if security policy allows) by using EXPIRY_DATE, otherwise the certificate expires after a year. CREATE CERTIFICATE [BrokerCertificateDec15] WITH SUBJECT = N’certificate_subject’, EXPIRY_DATE = N’2025-12-31′; Expiry of the certificate … Continue reading →

Posted in Uncategorized

Configure SSRS Datasources to use Execution Account

The Intransigent Data Blog Posted on 29/10/2015 by Andrew Ing29/10/2015

The SSRS Execution Account is a default Windows credential used by SSRS when running a report to access resources (e.g. file shares for image files) or databases for report datasources that do not require credentials and where Integrated Security is specified. … Continue reading →

Posted in SSRS

Data Obfuscation

The Intransigent Data Blog Posted on 30/07/2015 by Andrew Ing30/07/2015

Some functions for obfuscating data to protect personally identifiable data.  Aims: fast enough to process a large table resulting data is “sufficiently” obfuscated resulting data retains enough characteristics that it makes some sense in context. transformations are repeatable so that … Continue reading →

Posted in T-SQL

Post navigation

← Older posts
Newer posts →

Recent Posts

  • Alternatives to the (slow) FORMAT function
  • Disable non-clustered indexes during data load
  • Script the creation of ODBC DSNs
  • DAX: partitioned conditional aggregations
  • Referential integrity checks
  • Understanding errors from Tabular Analysis Services
  • Error flows in Azure Data Factory
  • The effect of RAID cache backup battery failure

Pages

  • About this Blog
  • Links
  • Toolset

Categories

  • ASP.Net
  • Automation
  • Azure Data Factory
  • Data Warehouse
  • DAX
  • DBA
  • IIS
  • MDS
  • MDX
  • Permissions
  • SSAS
  • SSIS
  • SSRS
  • T-SQL
  • Uncategorized
  • VBA

Archives

  • January 2022 (1)
  • June 2021 (1)
  • May 2021 (1)
  • August 2020 (2)
  • June 2020 (1)
  • December 2019 (1)
  • March 2019 (1)
  • February 2019 (1)
  • December 2018 (1)
  • November 2018 (1)
  • August 2018 (1)
  • April 2018 (1)
  • October 2017 (1)
  • April 2017 (1)
  • January 2017 (2)
  • November 2016 (1)
  • September 2016 (1)
  • May 2016 (2)
  • April 2016 (1)
  • March 2016 (1)
  • February 2016 (2)
  • December 2015 (3)
  • October 2015 (1)
  • July 2015 (1)
  • May 2015 (1)
  • April 2015 (2)
  • February 2015 (1)
  • January 2015 (1)
  • December 2014 (1)
  • October 2014 (2)
  • September 2014 (2)
  • August 2014 (2)
  • July 2014 (3)
  • June 2014 (2)
  • May 2014 (2)
  • April 2014 (1)
  • March 2014 (1)
  • January 2014 (1)
  • December 2013 (5)

Tags

Blog Convention SQL-Pattern SSAS SSIS SSRS T-SQL Validation

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
©2022 - The Intransigent Data Blog - Weaver Xtreme Theme
↑