Tagged with SQL Server

DATEFIRST

I came across something odd today at work. I was trying to run some retrospective updates using a stored procedure which ran data into a fact table, but couldn’t get it to properly pick up the date I was passing in. The stored proc takes the relevant date, works out the week from the Time … Continue reading

MCP BI Developer 2008

I finally got round to taking my certification exam today for my MCP. I did the BI Developer 2008, exam 70-448, it wasn’t easy but as I live and breathe most of what’s in it  a few days studying was enough for me. For anyone wanting to take it I would recommend getting the book … Continue reading