Twitter

Follow SQLQuill on Twitter

Subscribe

MN Pass

Weekly Challenges – 4/3/11

Challenges:

  • Coding on Project B

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.

 

031

Weekly Challenges – 3/27/11

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.

 

015

Weekly Challenges – 3/20/11

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.

 

029

Weekly Challenges – 3/13/11

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.

009

Weekly Challenges – 3/6/11

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:

  • Project B coding

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.)

  • PASSMNMarch 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.

 

020

Weekly Challenges – 2/27/11

Challenges:

Good Reading from the Week:

The Week Ahead:

  • Project B coding

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.

 

010

Weekly Challenges – 2/20/11

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.

Abbies 8th 037

Weekly Challenges – 2/13/11

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.

046

Weekly Challenges – 2/6/11

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

013

Weekly Challenges – 1/30/11

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

 

003