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: January 2014

The SQLSaturday Wiki–Revisited

I saw a discussion on Twitter yesterday where Kendal Van Dyke referenced the SQLSaturday wiki as a resource, I thought I’d post a reminder here about it and some thoughts on it as well. The build out of the wiki happened back in July 2010 – here’s my blog post Read more

0 comments, 345 reads

Posted in SQLAndy on 10 January 2014

Schedule Time To Review Your Passwords & Using a Password Manager

I use a password manager and it currently has more than 150 accounts in it, ranging from my checking account and other personal stuff to logins to MSDN, various client VPN’s, and more. Almost all of the passwords are unique. Ideally they would be unique, but sometimes I sacrifice ease… Read more

0 comments, 1,740 reads

Posted in SQLAndy on 10 January 2014

How To Campaign For the PASS Board

Let’s say you’ve decided to run, good! What do you do next? I’m not going to give you a blueprint (I need to see if you have some game after all), but I have some suggestions that I think will help you run a better campaign and make it a… Read more

0 comments, 381 reads

Posted in SQLAndy on 10 January 2014

Two-Factor Authentication

Something you have and something you know – that’s the heart of two-factor, sometimes called multi-factor, authentication. RSA was for years the most common. You use either the key fob hardware device or the software app to get a ‘code’ that you enter in addition to your ID and your… Read more

0 comments, 4,641 reads

Posted in SQLAndy on 9 January 2014

Changes to PASS Voting Eligibility

There was a blurb in the Connector today about an eligibility change for voting. The “change” is a requirement to update your profile (or for those of with more than one, all of your profiles).  Here are the fields that are now required on the profile:



I don’t… Read more

0 comments, 357 reads

Posted in SQLAndy on 8 January 2014

Reporting Services Parameter Assumptions

Ran into a new-to-me quirk this week while putting together a couple of reports. I have a summary report (essentially a group by) that is linked to a detail report (that shows the details!) based on a couple of passed parameters. Works fine. I wanted to add a couple of… Read more

0 comments, 485 reads

Posted in SQLAndy on 8 January 2014

Reminder: Orlando Code Camp on March 22, 2014

Ninth annual!

Yes, Orlando Code Camp #9 this year, being held at Seminole State College on March 22, 2014. I’ve submitted a couple sessions and plan to attend whether I’m on the schedule or not. Call for speakers is open until January 15, so you’ve got just a few days… Read more

0 comments, 343 reads

Posted in SQLAndy on 7 January 2014

Picking The Next Cell Phone

Cell phones are incredibly useful tools. Even a bad one is better than not having one, but a bad phone can get in the way a lot. Every couple years I spend a few hours evaluating the market and picking a new phone, hoping that I get it right.

I’m… Read more

0 comments, 424 reads

Posted in SQLAndy on 7 January 2014

Looking Back At the Droid Razr Maxx

It’s been 18 or 19 months since I upgraded from the Droid X to the Maxx. The X was a decent phone overall, not as refined by any means as the iPhone, but interesting. The Maxx was definitely an improvement in both hardware and software. The Maxx has also gotten… Read more

0 comments, 342 reads

Posted in SQLAndy on 6 January 2014

South Alabama Day of .Net

Just received an email from my friend Ryan Duclos announcing the South Alabama Day of .Net in  Mobile, Alabama, on March 29, 2014. I won’t be able to make the drive up this year, but wanted to share the event in case you’re in the area or looking for a… Read more

0 comments, 334 reads

Posted in SQLAndy on 6 January 2014

Throwing Spaghetti At The Wall Isn’t The Worst Plan

I get a lot of email about job opportunities, almost none of which interest me enough to call back about them. Which doesn’t mean that the next one won’t.  I review the location and description in about 10 seconds, close to 100% of them then get deleted – not even… Read more

0 comments, 274 reads

Posted in SQLAndy on 3 January 2014

Some Thoughts on the Target Breach

Possibly as many as forty million credit cards used at Target were compromised. A staggering breach and a cautionary tale – anyone can get beat, even a mega corp with close to unlimited resources.

My guess (no inside scoop) is that the Target IT team has had their world turned… Read more

0 comments, 884 reads

Posted in SQLAndy on 2 January 2014

Welcome To 2014

A quiet and rainy day here in Orlando today. Not my favorite weather, but good for thinking, mostly about what I what to accomplish in Q1. I also started on one of the smaller tasks on that list, getting the blog moved over to Windows Azure from Godaddy hosting –… Read more

0 comments, 292 reads

Posted in SQLAndy on 2 January 2014

Newer posts