ilovedata.ca
Martina Ponca's Blog
http://ilovedata.ca/page/2
Martina Ponca's Blog. Notes on database design, business intelligence, ETL, and enterprise reporting using Microsoft SQL Server. Transformation: Dates and Strings. April 30, 2010, 11:15 pm. Create Date declare @year int, @month int, @day int select @year = 2009, @month= 3, @day = 3; select dateadd(mm,(@year-1900)* 12 @month - 1,0) (@day -1) [Date]. Transformation: Create Dynamic Date Table (First Day of Month, Last Day of Month). April 30, 2010, 11:03 pm. Transformation: Rollup Rows or List to String.
thomaspullen.wordpress.com
April 2010 – Tom Pullen
https://thomaspullen.wordpress.com/2010/04
April 22, 2010. June 18, 2010. IT (and general) Recruitment Advice for Candidates. I decided to blog about this so I could point people at this rather having to repeat myself. First of all, let’s start with the CV. My golden rules are as follows:. 1 No more than 2 sides of A4. This is non-negotiable. Any more than that is just boring. No you are not that interesting. 2 Endless lists are dull. List your technical skills, tersely, and honestly. 4 It must be grammatically perfect. Including punctuation.
thomaspullen.wordpress.com
High Availability in the Real World at SQLBits 6 – Tom Pullen
https://thomaspullen.wordpress.com/2010/04/19/high-availability-in-the-real-world-at-sqlbits-6
April 19, 2010. October 5, 2010. High Availability in the Real World at SQLBits 6. On Friday 16th April 2010, I presented at SQLBits 6. It was held for the first time in London, and also (another great improvement) on a Friday as opposed to Saturdays as before. Unsurprisingly it was by far the best attended SQLBits Community Day (free for attendees and speakers unpaid, expenses covered by sponsors) so far, with 438 attendees. I also attended Tony Rogerson’s. High Availability In The Real World. Attemptin...
thomaspullen.wordpress.com
Tom Pullen – Page 2 – The finest DBA In the South of England™
https://thomaspullen.wordpress.com/page/2
The finest DBA In the South of England. June 22, 2010. June 22, 2010. SQL Bits 7 Session Submitted and a week of glorious unemployment! Has just been announced and it’s going to be in York at the end of September! The free community day is Saturday, with 2 paid days on Thursday and Friday, similar to SQL Bits 5. I have submitted a session on ‘Performance Tuning Quick Wins’! It was a compulsive thing . I hope I get chosen! I will let you know when voting opens! But maybe not always unpaid . April 22, 2010.
timmitchell.net
Resources - Tim Mitchell
https://www.timmitchell.net/resources
Business Intelligence and SSIS Consultant. July 22, 2016. Speaking at DevConnections 2016. July 14, 2016. Get Your Email Out of my ETL. July 11, 2016. June 27, 2016. Podcast Interview: Is the On-Premises Data Warehouse Dead? June 23, 2016. What if Your Employer Won’t Support Your Career? I am in the midst of incrementally publishing a guide to ETL best practices. This guide is platform-agnostic, intended to highlight recommended methodologies for ETL architectures on any platform. Next Level SSIS series.