Skip to content
  • Twitter
  • Linkedin
  • Pinterest

Devin Knight

  • Home
  • Training
  • Services
  • About Me

Tag: T-SQL

Modified Insert Unknown Row to Dimension Table

July 29, 2011 devinknight

A little over a year ago Patrick LeBlanc wrote a blog post about inserting an unknown row into a dimension.  This is a great script

Continue reading

Date Dimension Using Computed Columns

November 8, 2010 devinknight

Picked up this nice script from a client last week.  Use this script below to create a Date Dimension for a data warehouse that is

Continue reading

Issues With Calculating Current Age Using DateDiff (Rounding?)

October 9, 2010 devinknight

Recently I inherited a set of SSIS packages that did a pretty simple calculation for age.  It used the following expression, which could just as

Continue reading

SQL Server 2008 Change Data Capture

October 5, 2009 devinknight

SQL Server 2008 has a new Change Data Capture feature that allows you to track Inserts, Updates, and Deletes on a table. A lot of

Continue reading

Search

Devin Knight

SQL Server MVP

Follow me on Twitter

My Tweets

Categories

  • Azure (5)
  • Books (2)
  • Data Mining (1)
  • Excel (7)
  • MDX (7)
  • PerformancePoint (5)
  • Power Automate (1)
  • Power BI (12)
  • Power BI – Problem, Design, Solution (3)
  • Power BI Custom Visuals (118)
  • Power BI Interview Questions (3)
  • Power BI Monthly Digest (29)
  • Power BI Q&A (7)
  • Power Map (3)
  • Power Platform Quick Tips (4)
  • Power Query (13)
  • Power View (10)
  • PowerApps (1)
  • PowerPivot (18)
  • Scripts (1)
  • Social (2)
  • Speaking (42)
  • SSAS (24)
  • SSIS (33)
  • SSRS (26)
  • T-SQL (5)
  • This Week in Data (16)
  • Training (2)
  • Uncategorized (1)
  • Visio (1)
  • Visual Studio (2)
  • Windows (1)

RSS Feed

RSS Feed RSS - Posts

Create a website or blog at WordPress.com