Hello Dear Reader! This is the first Tuesday of the month and you know what that means. It’s time to announce the T-SQL Tuesday Topic of the month! This is your opportunity to participate in the largest SQL Blog party on the intrawebs.
T-SQL Tuesday is an event started by Adam Machanic(@AdamMachanic|Blog) back in 2009. The basic idea one blogger hosts the party and others participate. We announce the topic the first Tuesday of the month, December 1st 2015 for today, and everyone will post their blogs on the second Tuesday of the month, December 8th 2015 for the actual posts. This month the host is none other than……….. drum roll………….. ME!
Since it is the holiday season, I wanted to keep this holiday themed. I couldn’t help but think of the approaching Christmas holiday. Every year I get my children to make a list of presents that they would like to get from Santa Clause. If we are out and about and they start to misbehave I remind them about their list and that only Nice children get presents.
“So Balls,” you say, “What in the ever loving wide wide world of sports does this have to do with SQL Server?!?”
As you work with SQL Server look around you. Is your environment Naughty or Nice? If it is Naughty what’s wrong with it? What would you do to fix it? Do you have a scrooge that is giving you the Christmas chills? Perhaps you have servers of past, present, and future haunting you. Maybe you are looking at SQL Server 2016 like some bright shining star in the east.
First and foremost the rules.
Rule 1: Don’t get yourself fired. If your boss is a scrooge don’t name names, don’t hint to hard. It’s okay to protect yourself. You want to write about events we can look back on and reflect over, not events HR would *love* to know about. Perhaps a reminder of SQL Server's past would be better than that of SQL present.
Rule 2: Some Time next Tuesday using GMT, here’s a link to a GMT time convertor, publish your blog post. For example in the US that would cover 8 pm Monday to 8 pm Tuesday.
Rule 3: Make sure that you include the Image at the top of the page helping to identify your post as a T-SQL Tuesday blog. Then come back here and post a link in the comments so I can find them. Before the end of the week I'll do a round up of all the blogs.
Extra Credit!
Tweet your blog with the hash tag #tsql2sday, use SQL Server 2016, & go read someone else’s blog on the subject!
As Always Dear Reader, Thanks for stopping by and I’ll see you next Tuesday!
I've grown up reading Tom Clancy and probably most of you have at least seen Red October, so this book caught my eye when browsing used books for a recent trip. It's a fairly human look at what's involved in sailing on a Trident missile submarine...
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.
In which Phil illustrates an old trick using STUFF to intert a number of substrings from a table into a string, and explains why the technique might speed up your code...
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...
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.