THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL   (RSS)
  • How would you do dynamic pivot SQL in Amazon Redshift? (This elegant script might be used in many other databases as well)

      Several days ago I have spent a few hours of my life figuring out how to do dynamic pivot in Amazon Redshift. To tell you the truth, I have expected much more from this DBMS SQL language. Redshift is based on Postgre SQL 8.0.2 ( which was released in 2005 !!!! ) Anything you would want for this, not too difficult task,  does not ...
    Posted to Maria Zakourdaev (Weblog) by Maria Zakourdaev on November 7, 2017
  • Automate ETL Testing: Cross-Server Data Comparison with PowerShell

    In collaboration with a current client over the past year or so, I've been working on the issue of Test Driven Development for ETL work, especially in the area of automated testing for data. He graciously agreed to allow me to rewrite some of the code we originally developed in Ruby as a set of PowerShell demo scripts and share it through ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on November 22, 2015
  • Fetch once, write many times

    As I’ve said before these days I’m spending time working on Hadoop rather than SQL Server and one of my colleagues today alerted me to a rather cool feature Of Hive (in a nutshell Hive is the technology that makes enables us to write SQL statements against Hadoop). Check this out: Pretty cool, no? From a single tablescan I can summarise and ...
    Posted to Jamie Thomson (Weblog) by jamiet on May 12, 2015
  • Debunking Kimball Effective Dates

    Those who are familiar with Ralph Kimball’s theories on data warehousing modelling may be familiar with his assertion that a type 2 dimension member record should have a StartDate and an EndDate that defines the effective period of that record. He outlines this approach in his paper Slowly Changing Dimensions, Types 2 & 3 from the October 2008 ...
    Posted to Jamie Thomson (Weblog) by jamiet on November 28, 2009
  • SSIS: living in a parallel world? Not yet...

    Today I come into a nice bug (misfeature?) of SSIS 2008 and I'd like to share it with you. Let's start from the beginning: One of the keys to make something speedy is to parallelize it. In TableDifference I read from two inputs, compare them and produce several outputs for new, deleted, updated rows and so on. It is the classical ...
    Posted to Alberto Ferrari (Weblog) by AlbertoFerrari on September 14, 2008
  • Visio and SQL Extended Properties: a tool to marry them

    Visio database models have column descriptions, SQL Server has extended properties where to store them but, even if they share the same producer, it seems that Visio is unable to store column descriptions in extended properties so that other tools can gather the same information easily and produce a decent documentation of a database. After some ...
    Posted to Alberto Ferrari (Weblog) by AlbertoFerrari on November 7, 2007
  • SQL: Merge two "history tracking" tables

    If you have two columns in a table that ''remember'' their old values in two different historical tables, as it is the case in AdventureWorks with EmployeePayHistory and EmployeeDepartmentHistory, you may need (or just wonder how) to merge these two tables into only one historical table that will keep track of both columns. This has ...
    Posted to Alberto Ferrari (Weblog) by AlbertoFerrari on October 15, 2007
  • Mantaining order in SSIS flow, problems with Merge

    In a previous post I spoke about the advantages of having sorted flows in SSIS to greatly speed up data insertion using fastload. The need to have a sorted flow brings some severe problems to the SSIS programmer that he need to be aware of and that IMHO Microsoft should address with a future implementation of SQL Server. Let’s have a look at the ...
    Posted to Alberto Ferrari (Weblog) by AlbertoFerrari on April 10, 2007
Privacy Statement