|
|
Challenges:
- Coding on Project B – checked a bunch of stuff in, working with developers, ironing details out.
- On call – pager was pretty quiet.
- More tweaking of Powershell script to deploy all DB changes locally
Good Reading from the Week:
The Week Ahead:
- Project B coding.
- Project A2 still needs some of my time.
- PassMN Meeting Tuesday.
Goals for the Year – 3 Ps – (These are my year long goals that I’ll report on each week to keep me focused, read about them here.)
- PASSMN – Meeting this week: C for the past week.
- Powershell – Worked through some issues A- for the past week
- Present – No progress – NA for the past week
Challenges:
- PASSMN January Meeting – details are ironed out
- Coding on Project B – altering procedures for schema changes – still going…
- Tweaked Powershell script to deploy all DB changes locally for easier troubleshooting
Good Reading from the Week:
The Week Ahead:
- Project B is still behind (Broken Record).
- Project A2 still needs some of my time (Broken Record).
- On Call for Production – really this week I am.
Goals for the Year – 3 Ps – (These are my year long goals that I’ll report on each week to keep me focused, read about them here.)
Challenges:
- PASSMN January Meeting – details are getting ironed out
- Learning the stuff needed for the PASSMN Website
- Deploy DB analysis – verify incremental deploys match full deploys for Project A2 (smaller project – from here on known as A2)
- Performance Analysis – a few procedures had to be analyzed for performance improvements from A2
- A couple of VT (Verification Testing) procedures needed to be altered
- Coding on Project B – altering procedures for schema changes
- Wrote Powershell script to deploy all DB changes locally
Good Reading from the Week:
The Week Ahead:
- Project B is still behind.
- Project A2 still needs some of my time
- On Call for Production
Challenges:
- Some running and parenting
Good Reading from the Week:
The Week Ahead:
- Get back into it – Project B is behind.
- A smaller project needs some of my time
- On Call for Production?
The Past Year – SQL Related
- Started this blog
- Got it going on 5/21/10
- 65 Posts since
- That’s 1 post every 3.5 days or twice a week.
- Started tweeting as SQLQuill
- Coached Dale Carnegie – Human Relations Class
- Got elected to MN Pass Board
- Rolled back an upgrade – I could do about 20 posts on this – it was a “good” loss – if there is such a thing.
- Joe Webb – if you read this and follow the link above, I still say Clemson deserved to win!
- Solidified my role as a development DBA – that’s a very good thing for me.
The Year Ahead:
- PASS MN Director of Technology
- 100 Posts – here’s how I plan on doing it…
- 50 Weekly Challenges – once a week with two weeks of vacation
- 26 Technical Posts – one every two weeks
- 12 MN Pass Posts – once a month
- 4 PASS Posts – One a day plus a review
- 4 MN SQL Saturday Posts – Info on it as it becomes available and a recap
- 4 Wild cards….
- Optimize this site
- Loading speed is an issue
- SEO Optimization – learn more about it.
- Present more – I’ve got some plan on this.
- Tweet more – I tend to listen more than I talk and I try to impress “Big Dan”, but I need to have a few more words to impress him.
- Oh yeah and have a baby in April and run three marathons.
Challenges:
- Project A
- Troubleshooting performance issues
- One sproc was missing a set of parenthesis, it went from 1.5 million reads to 17 when corrected
- One sproc needs some indexed views to perform bette
- Project B – back to being a development DBA again!
- Spent about 4 hours on this project
- Week #8 as a Dale Carnegie coach – the class is complete.
- Missed TSQL Tuesday – the first time in 7 months – just too busy!
- Met with MN SQL Pass Board Members to determine roles and responsibilities for 2011 – I’ll be the Director of Technology.
Good Reading from the Week:
The Week Ahead:
- Work on Project B
- Troubleshoot any issues with Project A
- Head to Sunny Breckenridge, CO to see my sister and her family and my in-laws.
Challenges:
- Project A – Deployed
- Fixed issues in already deployed environment
- Migration script performance issues solved
- Spent a lot of the week working on a discrepancy report
- Worked all weekend on Project A – again
- About 3 AM Saturday morning, the performance issues proved to be solved
- Discrepancies report came back with “No Discrepancies”
- I was so fired up, I couldn’t sleep.
- Week #7 as a Dale Carnegie coach
Good Reading from the Week:
The Week Ahead:
- Figure out were I’m at with Project B
- Troubleshoot any issues with Project A
- TSQL Tuesday
Challenges:
- Project A – Issues
- Troubleshooting issues in already deployed environment for Friday night release
- Migration script performance issues
- Worked all weekend on Project A
- Week #6 as a Dale Carnegie coach
Good Reading from the Week:
The Week Ahead:
- Project A troubleshooting and fixing performance
Challenges:
- Thanksgiving – the weather – I had to take Wednesday off, so we didn’t get stranded at home.
- Project B – lots more ALTER PROCEDURE commands to fit DB changes.
- Changed some changes for a smaller project
- Week #5 as a Dale Carnegie coach
Good Reading from the Week:
The Week Ahead:
- Coding for Project B – head down and fix stuff – working from home and hidden conference rooms most of the week.
- Project A goes 100% live on Friday
- Week #6 as a Dale Carnegie coach
Challenges:
- Project B ramping up – lots of ALTER PROCEDURE commands to fit DB changes.
- Moved some changes into testing area including DDL triggers and Rev’ed changes
- One smaller project needed some attention.
- On Call – backup failures kept me up late a couple of times.
- Week #4 as a Dale Carnegie coach
Good Reading from the Week:
The Week Ahead:
- Shortened week for Thanksgiving
- Coding for Project B
About a minute into Tuesday’s keynote, I wondered what the heck have I gotten myself into. A Tina Turner impersonator kicked off the PASS conference with Simply The Best. I’ll admit it, I am a Tina Turner fan.
To remember and sum up Keynote #1 – I used the previously mentioned pegging technique. I was thinking about:
- Tina Turner jockeying a race horse (the Tina Turner intro)
- A monkey throwing a Ron Mexico out of the stadium in his Atlanta Falcon’s jersey (Project Atlanta for SQL Servers)
- A Denali SUV on knocking over a tree (Next version of SQL – Denali)
- Billons of rows of data being sorted by Amir Netz with a crescent wrench blocking the revolving door (Crescent)
- A bunch of equal signs with wings flying out of a bee’s hive (parallel data warehouse)
There are loads of recaps for all the keynotes including a minute by minute recap from day 1 from Brent O. All the recaps from Mr Denny.
Here’s video of:
All in all – I learned a ton, met lots of people.
The two best sessions I went to were:
Good Reading from the Week:
The Week Ahead:
- Back to the grind…also enjoying what I missed out by being is Seattle.
|
|
