Winston Churchill was a Data Analyst

"However beautiful the strategy, you should occasionally look at the results." -Winston Churchill

Script I used to populate DimDate from AdventureWorks with current data

WITH mycte AS
    (
    SELECT CAST('2012-01-01' AS DATETIME) DateValue
        UNION ALL
    SELECT DateValue + 1
        FROM mycte
        WHERE DateValue + 1 < '2013-12-31'
    )INSERT INTO dimdate
    SELECT CONVERT(VARCHAR, DateValue, 112) AS DateKey
            , CAST(DateValue AS date) AS FullDateAlternateKey
            , DATEPART(dw, datevalue) AS DayNumberOfWeek
            , [dbo].[FormatDateTime] (DateValue, '[dweek]') AS DayNameOfWeek
            , dbo.FormatDateTime(DateValue, '[d]') AS DayNumberOfMonth
            , DATEPART(dy, datevalue) AS DayNumberOfYear
            , DATEPART(ww, datevalue) AS WeekNumberOfYear
            , dbo.FormatDateTime(DateValue, '[MONTH]') AS MonthName
            , dbo.FormatDateTime(DateValue, '[M]') AS MonthNumberOfYear
            , DATEPART(q, datevalue) AS CalendarQuarter
            , DATEPART(yyyy, datevalue) AS CalendarYear
    FROM mycte
            OPTION (MAXRECURSION 0)

I'll include a new script that will populate the other tables with good dates some time later.

Quote on Business Failure

"I can't give you a surefire formula for success, but there is one for failure: Try to please everybody all the time." Herbert Bayard Swope

Thomas Edison Believes in Iterations, Too!

"I have not failed. I've just found 10,000 ways that won't work." -Thomas Edison

Hugh Prather speaking to Agilists

"It's simple: if I never try anything, I never learn anything."-Hugh Prather

Quote for Agilists

Salman Rushdie speaking to agilists: "A bit of this and a bit of that is how newness enters the world."

Quote

"If one FELT successful, there'd be so little incentive to BE successful." Alain de Botton

Louis L'amour Speaking to Future Agilists

"Are you where you want to be if it doesn't work?" - Louis L'amour speaking to future agilists.

Einstein Quotes on Education

"It is,in fact, nothing short of a miracle that modern methods of instruction have not entirely strangled the curiosity of inquiry" Einstein

Quote from Edmund Burke

"Hypocrisy can afford to be magnificent in its promises; for never intending to go beyond promises, it costs nothing."-Edmund Burke

Love this Quote from Bertrand Russell

"In all affairs, it's a healthy thing now and then to hang a question mark on the things you have long taken for granted"-Bertrand Russell

Quote

"Whoever best describes the problem is the one most likely to solve it." -Dan Roam (Back of the Napkin)

Another Quote on Education

"Self-education is, I firmly believe, the only kind of education there is." Isaac Asimov

New Tip on Executing SSIS Packages

Quote on Eduction

"Eduction is not the answer to the question. Education is the means to the answer to all questions." -Bill Allin

Business Intelligence Quote

"Praemonitus praemunitus (forewarned is forearmed)" -Even the Roman's depended on business intelligence.