↓
 

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 5 << 1 2 3 4 5 6 >>

Post navigation

← Older posts
Newer posts →

ASP.Net Windows Authentication from outside the Domain

The Intransigent Data Blog Posted on 29/08/2014 by Andrew Ing15/10/2014

The Problems IIS server is on domain A. Problem 1. User accounts are on domain A. Users access the site from a network outside the domain, with no domain trusts established. Problem 2. User accounts are on domain B. domain … Continue reading →

Posted in ASP.Net, IIS

Report Parameter Defaults (SSRS)

The Intransigent Data Blog Posted on 12/08/2014 by Andrew Ing04/07/2016

Snippets of code to create date-range parameter defaults for SSRS reports. PrecedingWeek The seven days up to and including yesterday. /* Yesterday = Yesterday’s date. SevenDaysAgo = Seven days before today: i.e. a week up to and including yesterday. 12/08/2014 … Continue reading →

Posted in SSRS, T-SQL

Time Dimension

The Intransigent Data Blog Posted on 27/07/2014 by Andrew Ing27/07/2014

Time Dimension creation script DDL for a time dimension table. Create table DimTime ( time_key smallint NOT NULL, time_type varchar(20) NOT NULL, full_time time(0) NULL, hour_of_day tinyint NULL, minute_of_hour tinyint NULL, hourly_segments varchar(13) NULL, minute_15_segment_key tinyint NULL, minute_15_segments varchar(13) NULL, … Continue reading →

Posted in T-SQL

Monitoring SSRS Reports and Subscriptions

The Intransigent Data Blog Posted on 15/07/2014 by Andrew Ing29/12/2015

Interpreting data in ReportServer database Observations from SSRS 2008 R2 Subscriptions table dbo.Subscriptions. InactiveFlags There’s no way to disable a subscription from SSRS UI though articles suggest setting InactiveFlags to 1 will achieve this. 0 : schedule is active. 8 … Continue reading →

Posted in SSRS | Tagged SSRS

Performance Monitoring using typeperf.exe

The Intransigent Data Blog Posted on 03/07/2014 by Andrew Ing03/07/2014

Introduction Avoid all use of the Performance Monitor interface by using typeperf.exe (the oddest of names). Brent Ozar’s Tutorial on SQL Performance Monitoring – using performance monitor manually to gather SQL-relevant counters. Shaun J Stuart Baselining SQL Server Part 1 and … Continue reading →

Posted in Uncategorized

SSRS & MDX : Include Member Key in Report

The Intransigent Data Blog Posted on 30/06/2014 by Andrew Ing30/06/2014

Requirement:  to use the a member Key in a report rather than the display name or Value properties. Problem the SSRS query builder doesn’t allow selection of properties to return.  Reference to Fields!MemberName.Key returns Null in reports. One Solution:  Locate following … Continue reading →

Posted in MDX, SSRS

Minimal Permissions

The Intransigent Data Blog Posted on 25/06/2014 by Andrew Ing25/06/2014

What are minimal permissions required for certain operations? Run Profiler ALTER TRACE SSDT Import a database schema into project VIEW DEFINITION VIEW SERVER STATE If working with multiple databases use  VIEW ANY DEFINITION run on master. SSDT Make schema updates … Continue reading →

Posted in Permissions

Columns to Rows without using UNION or UNPIVOT

The Intransigent Data Blog Posted on 06/05/2014 by Andrew Ing21/05/2014

Problem Table contains two or three columns that should be output as a single column over two or three rows.  Such as [Telephone1], [Telephone2], … columns in a table. Use Table Values constructor in CROSS APPLY clause Use the table … Continue reading →

Posted in T-SQL | Tagged T-SQL

SSIS Export to a Named Worksheet in Excel

The Intransigent Data Blog Posted on 02/05/2014 by Andrew Ing02/05/2014

Exporting data to Excel, but to named spreadsheet(s).  These notes are taken from an exercise using SSIS 2008R2. Create the Data Flow and export data (in required format) to an Excel Destination (creating an Excel Connection Manager in the process).  … Continue reading →

Posted in SSIS | Tagged SSIS

T-SQL Code Generation

The Intransigent Data Blog Posted on 28/04/2014 by Andrew Ing02/05/2014

  Getting Table and Column details When you want to generate T-SQL code (views, procedures, triggers) automatically you need a list of tables and their columns.  It’s useful to have these in temporary tables or table variables because it is … 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
↑