SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in


I'm Andy Warren, currently a SQL Server trainer with End to End Training. Over the past few years I've been a developer, DBA, and IT Director. I was one of the original founders of SQLServerCentral.com and helped grow that community from zero to about 300k members before deciding to move on to other ventures.

Archives: February 2014

PASS, Evangelism, Goals, Dreams

The role of PASS in the community has evolved a lot over the past few years. Back in 2006/2007 PASS was mainly about the Summit and trying to grow new chapters, not a lot of emphasis on doing more for chapters and not much interest in a day based event… Read more

0 comments, 1,293 reads

Posted in SQLAndy on 28 February 2014

Spring in Florida

The first sign of spring in Florida is the leaves falling from the oak trees. Tons of leaves, leaves everywhere, definitely a pain to keep up with, yet it’s worth it for the next part – in the next week or so I expect – when the large oak in… Read more

0 comments, 1,040 reads

Posted in SQLAndy on 27 February 2014

Write The Perfect Question (Of The Day)

Have you ever voted against something only to be glad later you got out voted? Too many years ago the idea of a question of the day for SQLServerCentral came up for discussion. I was against the idea not because it was a bad idea, but because it is one… Read more

0 comments, 1,483 reads

Posted in SQLAndy on 25 February 2014

Notes From SQLSaturday #273

  • Speaker dinner at Spaghetti Warehouse was packed. Great crowd, not such great service. At 8:45 pm we still had not had a chance to order dinner. With a crowd of 40+ its challenging to get a good venue that can handle the service and provide an environment conducive to networking.…

Read more

0 comments, 670 reads

Posted in SQLAndy on 24 February 2014

Free Presentation Software

Here’s a list of free presentation software I ran across, maybe worth a few minutes to get out of the Powerpoint rut. Emaze looks very interesting, as does SlideDog. Prezi is a lot of fun to watch.

Read more

0 comments, 728 reads

Posted in SQLAndy on 24 February 2014

SQLSaturday #273 In Tampa This Weekend

I’m looking forward to the trip to Tampa for SQLSaturday #273 this weekend. I’m driving down this afternoon to beat traffic and have time for a break before going to the speaker party. I have one presentation on the schedule – PCI for the SQL DBA – and the rest… Read more

0 comments, 640 reads

Posted in SQLAndy on 21 February 2014

Notes From The February 2014 oPASS Meeting

Live notes from the meeting.

  • Attendance is low tonight, about 10 people (though it was well advertised, I got quite a few reminders – a good thing)
  • Yesterday was Karla Landrum’s birthday!
  • Met two new people (one was a sponsor, that sort of counts)
  • Good coverage of upcoming events,…

Read more

0 comments, 693 reads

Posted in SQLAndy on 21 February 2014

Sometimes Cheaper Makes Sense / Mastering the Basics Always Does

It’s good to remember that the ideas and challenges of mastering a craft – any craft – have been around a while. No, the world of IT doesn’t match exactly to building woodworking or cooking or anything else, but the path to mastery is really close to the same. It… Read more

0 comments, 644 reads

Posted in SQLAndy on 20 February 2014

PASS Goals Published

Hopefully you got the email today from PASS containing these:

Reading them I’m first struck that we often see goals set, but rarely see the end of year scorecard published the same prominence. Which are real goals and which are stretch goals? Are there… Read more

0 comments, 623 reads

Posted in SQLAndy on 19 February 2014

If You Plan to Publish A SQL Script–Some Suggestions

Nothing better than finding a script that does something you need done and often done better than what you’d put together to just get it done right then. If you solve a problem consider publishing the script. Even if it has been done a dozen times, maybe there is something… Read more

0 comments, 717 reads

Posted in SQLAndy on 19 February 2014

The Challenge of Customer Service

Friday night I took my wife out for Valentine’s Dinner. We had a reservation for 9 pm and I hoped that later in the evening we could enjoy a slow, quiet dinner. It was for a very nice restaurant, one where you’ll drop $150 or so on dinner for two.… Read more

0 comments, 640 reads

Posted in SQLAndy on 18 February 2014

Everything Is Awesome

If you don’t have kids you might not get the title of the post, it’s part of the theme song from The Lego Movie. We went to see it this past Saturday. Good fun! Lots of stuff to enjoy. The average hero pining for the girl who already has… Read more

0 comments, 617 reads

Posted in SQLAndy on 17 February 2014

Learning About Reporting & Visualization

Today I watched DATAVIZ YOU THOUGHT YOU COULD NOT DO WITH SSRS by Jason Thomas. The intro felt long, but once the content started it was fun to watch someone do some nice tricks with Reporting Services as far as visualizing data. The focus was using the capabilities provided with… Read more

0 comments, 743 reads

Posted in SQLAndy on 14 February 2014

Melitta Coffee Brewer

I’ve been trying out the Melitta Coffee Brewer for a few weeks. Not much to it, it’s just a plastic stand that holds a coffee filter. Add coffee, then add water to do a “pour over” and wait for it to drip into the cup. It comes in two sizes,… Read more

0 comments, 733 reads

Posted in SQLAndy on 13 February 2014

Interest In SQL Server Seems To Be Declining?

Amusing myself for a minute at Google Trends. Anyone missing 2005?


Read more

0 comments, 3,551 reads

Posted in SQLAndy on 12 February 2014

Review: Tell Me How I’m Doing

I found Tell Me How I’m Doing by Richard L. Williams at the local library. It’s a book about giving feedback, told as a story. To condense a lot, the technique they teach is to think of everyone having a ‘feedback bucket’ that has holes in the bottom. If a… Read more

0 comments, 599 reads

Posted in SQLAndy on 11 February 2014

Building an SSMS Add-In Using Redgate Ecosystem

On Friday I was finally able to spend a couple hours looking at the Redgate Ecosystem, which is essentially a framework for building an SSMS add-in. In about 3 hours I was able to download the framework, take the sample solution and change it to run a script to generate… Read more

0 comments, 998 reads

Posted in SQLAndy on 10 February 2014

Presenting at Code Camp Orlando

I’ll be at Code Camp Orlando on March 22, 2014 doing a presentation on storing credit cards in SQL Server (though a lot of what I’ll talk about applies to any database). Here is the SQL track:


9:00 AM – 9:50 AM

5 TSQL Commands I’ve been Missing -…

Read more

0 comments, 625 reads

Posted in SQLAndy on 5 February 2014

Presenting at SQLSaturday Tampa

The schedule just went up, I’ll be presenting PCI for the SQL DBA this year. Looking forward to visiting Tampa again, and taking my kids to the nearby science center. Should be a good trip!

Read more

0 comments, 495 reads

Posted in SQLAndy on 5 February 2014

Renaming The Reporting Services TempDB Database

Strange that I’ve never had/wanted to do this before, helping someone do it today and renaming it causes everything to break. The main ReportDB (regardless of what you named it) has hard references to the location to the ReportingTempDB (whatever it was called when you did the install). I found… Read more

0 comments, 1,334 reads

Posted in SQLAndy on 3 February 2014