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: September 2013

I Just Voted in the PASS 2013 Election

I feel like it’s been a good election cycle. Good set of candidates, good discussions, lots of good blog posts from the candidates and their supporters, and some attempts to better inform voters via the online town halls and twitter chats.

I decided on my final candidates last night– it… Read more

0 comments, 565 reads

Posted in SQLAndy on 26 September 2013

Monday Night Networking at the 2013 PASS Summit

For the fourth year Steve Jones and I are hosting an informal networking dinner on Monday night at the PASS Summit. We’ll be at Buffalo Wild Wings this year near the Convention Center from 6 to 9 pm. An added bonus this year is that beginning at 7:30 pm they… Read more

0 comments, 1,015 reads

Posted in SQLAndy on 25 September 2013

I’m Voting for Allen Kinsel

As you can see from the title of this post, I’ve decided on one of the three votes I’ll be casting in the PASS Election this year – I’ll be voting for Allen Kinsel. I wrote a letter of recommendation for him to be included in his application. Here… Read more

0 comments, 750 reads

Posted in SQLAndy on 25 September 2013

PASS Elections 2013

Yesterday the slate of candidates for the PASS Board of Directors was announced. Seven candidates for three open positions this year and that’s good. Good that we have a choice of who will lead and good that we have seven people willing to step up and give more of their… Read more

0 comments, 838 reads

Posted in SQLAndy on 24 September 2013

Finding The Active Sharepoint Databases

This was a task from last week. There was a server where we wanted to make some adjustments to security including changing the database owner to SA. To do that we needed to make sure that we included all the Sharepoint databases. If you’ve ever looked at a SQL instance… Read more

0 comments, 877 reads

Posted in SQLAndy on 23 September 2013

Notes from SQLSaturday #232 in Orlando

Our seventh annual SQLSaturday here in Orlando went well. To the casual observer it might appear to happen without effort, if only that were truly the case! Kudos to Shawn and Karla for a great job of leading the event and we couldn’t have done it without the help of… Read more

0 comments, 654 reads

Posted in SQLAndy on 16 September 2013

My 2013 PASS Suggestion Tsunami List

Back in August I posted about an approach that Aaron Nelson and I thought of to try to get more ideas and suggestions into general circulation with regards to PASS and the SQL community – in short, designate a ‘suggestion day’. We only lightly evangelized the idea so it will… Read more

0 comments, 789 reads

Posted in SQLAndy on 9 September 2013

Log Backup Failing–A Simple Mistake

Last week I was checking on some stuff and noticed that a couple databases were in simple mode – unusual, but not necessarily wrong, so I asked someone on the team that manages the environment about it. He said that because of the usage it wasn’t critical but they did… Read more

0 comments, 691 reads

Posted in SQLAndy on 5 September 2013

Skills I Used Last Week

Ever thought about what your average week looks like? What are the real core skills your environment uses every day or every week? I tried to write down all the variations I did last week, during an admittedly slow week:

  • Adhoc full backup of a database
  • Restore database with different…

Read more

0 comments, 2,395 reads

Posted in SQLAndy on 3 September 2013