|
|
Challenges:
Good Reading from the Week:
The Week Ahead:
- Project B coding.
- My wife
is was due 4/2 – tie up more loose ends at work until I get the call!!! I might work some, I might not make it to work tomorrow – kind of a weird place to be….
- PASSMN Meeting coming up on 4/19/11 – need to get announcement out and iron out the details of that.
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 – Not a lot: C for the past week
- Powershell – B+ for the past week:
- Searched for Dependent objects – working on a shareable script for that.
- Present – Not a lot: C- for the week.
Challenges:
- Coding on Project B
- Gave Demo on Red Gate’s SQL Compare
- On Call – two issues – Rollback of a partitioning job and log shipping out of sync.
- Customized Grant Fritchey’s (blog/twitter) powershell script from the Scripting a database using Powershell section of this article.
Good Reading from the Week:
The Week Ahead:
- Project B coding.
- My wife is due 4/2 – tie up more loose ends at work this week!
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 – Not a lot: C for the past week
- Powershell – B+ for the past week:
- Customized the Scripting database with Powershell script
- Organized all my snippets of code (for sharing)
- Present – Gave demo on Red Gate SQL Compare: B for the week.
Challenges:
- Coding on Project B
- Checked a bunch of small changes in
- Gave demonstration of our deploy process to team members
- Attended a few 24 Hours of PASS sessions – I missed a couple I really wanted to see – they will be available in about a month – I’ll have a link to them.
- PASSMN Meeting – SQL Azure interesting talk by Steve Hughes (blog)
Good Reading from the Week:
The Week Ahead:
- Project B coding.
- My wife is due 4/2 – tie up loose ends at work this week!
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 – March meeting this past week – attended via Live Meeting due to my son being sick: C for the past week
- Powershell – B- for the past week – dabbled with script to script databases the way I want it.
- Present – Gave demo on our deploy process to DBA team: B for the week.
Challenges:
- Coding on Project B
- Errors needed to be harsher, bumped them up to level 16
- Security issues
- Cranked out some table and sproc changes.
- TSQL 2s Day – here’s my entry.
Good Reading from the Week:
The Week Ahead:
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 – Didn’t do much, meeting is set up for this week: C for the past week
- Powershell – C for the past week – Used Powershell to:
- Worked on powershell script to script database schema based on Grant Fritchey’s script in the section called “Scripting a database using Powershell / SMO” from here.
- Present – Signed up to present to team next week on SQL Compare: C for the week.
Challenges:
- Coding on Project B
- A couple of issues with Error Codes not being harsh enough
- Sproc/Table changes
- 24 hour flu – hit me Tuesday night, was by dinner on Wednesday, but slept like 18 hours in between
- This blog is now syndicated on sqlserverpedia.com
Good Reading from the Week:
The Week Ahead:
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 – March Meeting announced: B for the past week
- Powershell – A- for the past week:
- Completed the book Powershell for Dummies – great for learning the basics.
- Started to write a script to check our deploys on a bunch of servers.
- Downloaded and watched live meeting of PASSMN December 2010 meeting – “PRACTICAL POWERSHELL & SQL” by Nick Weber
- Present – No activity: Inc. for the week.
Challenges:
- Coding on Project B
- Gave demonstration of Powershell to my DBA team on how to:
Good Reading from the Week:
The Week Ahead:
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 – not much: C for the past week
- Powershell – A- for the past week – gave demo, started reading two books on it…
- Present – Gave demo on Powershell to DBA team: B for the week.
Challenges:
- Updated this site:
- Feedburner Feed – new RSS feed here – Please update – I’ll post on just this when I’m ready 100%.
- Updated the Twitter, Subscribe and Search Widgets
- Added The SQLQuill Daily
- Added a link to Pass MN
- Pitchers and Catchers reported, so I updated the logo – temporarily.
- On Call – Log Shipping Issue that took some midnight hours
- Coding on Project B
- A bit of performance tuning – I had to pull out the “Image an index is a like…an index in a book and you are trying to look up something that is either a 0 or a 1, would the index of a book be helpful?”
- Attended Pass MN’s meeting – the slides from the presentations are found at the Pass MN site under the Resources tab.
Good Reading from the Week:
The Week Ahead:
- Project B coding
- New procs for new tables
- Syncing environments or verifying environments are level set
- Syndicate this blog to SQLServerPedia – it’s time to get more traffic.
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 – Added some content, attended Tim Plas’s presentation: B for the past week
- Powershell – A- for the past week – Used Powershell to:
- Get servers from web page script (more to come on that)
- Started working with PowerGUI.
- Present - N/A: Inc for the week.
Challenges:
- Coding on Project B
- Moved Code in TFS
- Gave demonstration of new database DDL triggers and deploy process
- Used Powershell to find files with columns, move files in crunch time – there was an issue I needed resolved ASAP.
Good Reading from the Week:
The Week Ahead:
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 – February coming up, tweeked web site: B+ for the past week
- Powershell – A for the past week – Used Powershell to:
- move files around for TFS changes
- find procedures with columns
- get links list above (more to come on that)
- Present – Gave demo on DDL triggers and deploy process to DBA team, Gave overview of schema changes for Project B to others: B+ for the week.
Challenges:
- Coding on Project B
- A couple of fires with other projects
- Used Powershell to manage files in TFS
Good Reading from the Week:
The Week Ahead:
- Project B coding.
- Project A issues?
- T-SQL 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 – February Meeting details ironed out: B+ for the past week
- Powershell – Wrote scripts move files around, worked on the Out-file: A for the past week
- Present – – No progress – NA for the past week
Challenges:
- Coding on Project B
- A couple of fires with other projects
Good Reading from the Week:
The Week Ahead:
- Project B coding.
- Project A issues?
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 – UG Meeting last week – went well: A- for the past week
- Powershell – Wrote script to replace text in a bunch of files: A- for the past week
- Present – Was inspired to speak at PassMN meeting, no action: D for the past week
|
|
