T-SQL Tuesday #62 - Invitation to HealthySQL

, 2015-01-06

TSQL Tuesday 62

Greetings ALL and Happy New Year 2015!  I wish everyone an excellent year ahead, and

that 2015 will bring peace and new beginnings! 

I have the distinguished pleasure of kicking off the New Year, with this

month’s T-SQL Tuesday #62!   My fuzzy

logic vaguely remembered I had signed up in way advance for this awesome task,

when Adam Machanic (b|t) came swooping down the chimney with

a holiday reminder that yours truly, Robert Pearl (b|t) is on deck to host January’s T-SQL

Tuesday.   I already had a topic in mind,

when I confirmed that I am ready to roll, and excited to host the first T-SQL

Tuesday of 2015.

Last year’s blog party ended with a bang, T-SQL

Tuesday #61 (see the wrap-up by clicking the hyperlink), hosted by my

compadre Wayne Sheffield (b|t), was about the Season of Giving

and giving back to the community.  In the

spirit of the New Year, let’s make our first T-SQL Resolution to maintain a

Healthy SQL environment.  One of the most

common New Year’s resolution (and often broken before February 😉 is to stay healthy

and fit.  So, let’s resolve to maintain

our SQL Fitness, and keep our SQL Servers healthy and humming by ensuring they

are tuned, performing optimally, and up to date with all its latest

optimizations and service packs.

Healthy SQL

So, let’s get this blog party started, and kick off our

international Healthy SQL campaign. Let’s spread the word to anyone and

everyone managing a SQL Server Database infrastructure of the necessity to

perform regular health checks on each SQL Server and repeat often.  The purpose here is to get database

professionals, to ensure that all their SQL Servers are healthy, and can pass a

health check. It also means that you can prove this (to heaven forbid,

auditors), and back it up with documentation. 

If you want to excel in your career as a data professional

or DBA, then you need to be concerned about your companies’ SQLFitness.  Therefore, I am inviting all of you, to blog

about your T-SQL Resolution, and describe what it is that you will do this year

to make sure your SQL Servers are healthy and fit.  Now, it’s ok to ponder Healthy SQL in the

abstract, but we’re looking for some technical tips on things a DBA should do

to keep your SQL Servers performing well. 

It could be something as simple as implementing a new

monitoring software or script, updating all your SQL Servers to the latest

version or service pack, setting up maintenance and optimization jobs, HA/DR,

creating a performance baseline, capturing performance stats, (ie: DMV

automation scripts, or MDW), a checklist ,etc. 

Sky is the limit, as long as you can contribute something to the

SQLCommunity that can be used in the effort to ensure SQL Fitness

The year is new, the possibilities are endless, but for the

record here, the rules are the same.  You

are all cordially invited to this month’s T-SQL Tuesday number 62, a week from now,

Tuesday, January 13, 2015, as long as you are following these three (3) T-SQL

Tuesday tenets:

1.     

Your T-SQL Tuesday post needs to go live between

00:00 GMT Tuesday, January 13th, 2015 and 00:00 GMT Wednesday,

January 14th, 2015.  

2.     

Your blog post needs to contain the T-SQL

Tuesday logo image on this post, and it should link back to this post.

3.     

Use trackbacks or post a comment to this post

with a URL link to your post.

 

** An optional but preferred step, please tweet

about your post using the #TSQL2sday

hashtag.

 

Finally, if you would like to get on the

list and sign up to host a blog party of your own go ahead and ping Adam

Machanic with your favorite topic!

 

Remember to always maintain a Healthy SQL

Server environment, and look for more on the HealthySQL campaign!  See you all soon!

Follow me on twitter @Pearlknows

Rate

Share

Share

Rate

Related content

Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?

Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.

2009-02-23

1,567 reads

Networking - Part 4

You may want to read Part 1 , Part 2 , and Part 3 before continuing. This time around I'd like to talk about social networking. We'll start with social networking. Facebook, MySpace, and Twitter are all good examples of using technology to let...

2009-02-17

1,530 reads

Speaking at Community Events - More Thoughts

Last week I posted Speaking at Community Events - Time to Raise the Bar?, a first cut at talking about to what degree we should require experience for speakers at events like SQLSaturday as well as when it might be appropriate to add additional focus/limitations on the presentations that are accepted. I've got a few more thoughts on the topic this week, and I look forward to your comments.

2009-02-13

360 reads