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

Sometimes It IS The Network

Over the years when a performance problem comes up there is always some speculation that it’s a network issue and not the database (can’t be us!). I always ask a few quick questions to see if I can see a reason to pursue the network angle:

  • Is the problem affecting…

Read more

0 comments, 1,162 reads

Posted in SQLAndy on 31 July 2013

Miscellaneous Reading for July 2013

  • Must read blog: Sacha Chua. Lots of info on going solo, being productive, sketch noting.
  • Related, if you’re trying to manage life and focus and progress, take a look at QuantifiedSelf.com
  • Don’t tell people they can borrow your tow truck
  • The Generals is a look at the evolution of…

Read more

0 comments, 1,119 reads

Posted in SQLAndy on 30 July 2013

A Long Summer Vacation

Based on a bit of luck/happenstance I’ve been able to stretch my summer vacation to two months. I had planned to take a few weeks off to reflect on life and think about where I should be focusing (and I have done a lot of that), but the chance to… Read more

0 comments, 1,272 reads

Posted in SQLAndy on 29 July 2013

Notes from SQLSaturday #231

First time event in Cocoa Beach went really well!

  • Speaker dinner well attended Friday night at Florida’s Seafood
  • Quite a few out of town speakers, and it seemed like more speakers brought their families. Having the event at a hotel on the beach certainly made it
  • What are the odds…

Read more

0 comments, 752 reads

Posted in SQLAndy on 29 July 2013

Encourage Someone You Respect To Run For The PASS Board of Directors

PASS is accepting candidate applications for the 2013 election through August 7th, 2013.  Later this year we – the PASS membership – will be voting to fill three seats on the Board. To have a good election we need a great selection of candidates. I hope for a slate of… Read more

0 comments, 627 reads

Posted in SQLAndy on 29 July 2013

Headed to Cocoa for SQLSaturday #231

I’m leaving mid-morning today to drive to Cocoa with my family for a beach weekend and SQLSaturday #231. I’ll be presenting PCI for the SQL DBA and I’m really looking forward to it. I did a virtual presentation of it earlier this month and it ran long, so I’ve made… Read more

0 comments, 699 reads

Posted in SQLAndy on 26 July 2013

The SQLAndy Rules for Storing Credit Card Numbers

I’ll try to write more about these over the next couple months, but I wanted to write down a quick reference for those that have to deal with storing credit card numbers. These rules cover the basics – the full topic of protecting card data is easily a book or… Read more

0 comments, 1,115 reads

Posted in SQLAndy on 26 July 2013

Blog Images and PNG Compression

I’m not terribly good at putting at least one image in every post. The images I do use are either screen captures from Snagit or photos from my phone.  I rarely do much in the way of editing them, a luxury of running a low key blog. As far as… Read more

0 comments, 930 reads

Posted in SQLAndy on 25 July 2013

Moving The Bottleneck

Most of you probably get that there will always be a bottleneck in a system. You implement a fix in one place, now something else becomes the constraint. The hard lesson to learn is that there is point of diminishing returns on optimizing (anything). Doesn’t mean you should stop, just… Read more

0 comments, 572 reads

Posted in SQLAndy on 24 July 2013

I Learned Something From You

I learned something from you – that was something someone said to me at the end of a recent consulting engagement. I wasn’t teaching, just doing, so that it made it all the more interesting to hear. Part compliment, part acknowledgement, maybe even part surprise, regardless, it was a very… Read more

0 comments, 747 reads

Posted in SQLAndy on 23 July 2013

Upscale Bowling

I don’t bowl often, maybe once a year at best. It’s a fun way to spend a couple hours – I imagine many of you have done the same. Regardless of location they all seem about the same. Mostly quiet, not fancy, maybe even utilitarian in most ways. Food. Not… Read more

0 comments, 698 reads

Posted in SQLAndy on 22 July 2013

Security Cameras in the Neighborhood

I live in a pleasant, calm, middle class neighborhood. Not much crime here, at most the rare break-in or vandalism, not a place where you worry about going out for a walk in the evening. Recently the HOA sent out a letter discussing the install of security cameras to increase… Read more

0 comments, 721 reads

Posted in SQLAndy on 19 July 2013

More on Finding Bad Links On Your Blog

Yesterday I mentioned using the Google Webmaster Tools to identify some bad URL’s here on the blog. I decided to do a little more checking to see what else might be wrong. First tool I found was http://www.brokenlinkcheck.com/, free for up to 3000 pages. I set it to run… Read more

0 comments, 623 reads

Posted in SQLAndy on 19 July 2013

Fixing Bad Links Found Using Google Webmaster Tools

I’ve been doing various clean up tasks this week related to the blog, with part of that being a review of the Google Webmaster Tools results. One of the things I noticed is that I had some crawl errors (URL’s that generated a page not found error). Here is the… Read more

0 comments, 818 reads

Posted in SQLAndy on 18 July 2013

PASS Security Virtual Chapter & Security Topics at PASS Summit

I just saw a post from Brian Kelley about the new PASS Security Virtual Chapter launching and the first presentation (by Brian on encryption) is tomorrow. That seems like a great step after the observations Brian made back in May about there only being one security topic at the Summit… Read more

0 comments, 593 reads

Posted in SQLAndy on 17 July 2013

Speakers Announced for SQLSaturday #232 in Orlando

It’s done, finally! The sessions for SQLSaturday #232 have been selected and the schedule is available for viewing. We have 8 tracks this year, 6 slots per track, for a whopping 48 sessions this year. It’s an amazing list of speakers – go take a look, you’ll see!

If… Read more

0 comments, 692 reads

Posted in SQLAndy on 17 July 2013

PCI Compliance Presentation on July 17, 2013

Next week I’ll be doing a new presentation about PCI compliance – aka dealing with credit cards – online (follow this link for free registration). My goal is to put PCI in perspective for DBA’s, starting with a quick overview of what PCI is, then discussing how audits work,… Read more

0 comments, 521 reads

Posted in SQLAndy on 9 July 2013

Notes from the 2013 American Association of Woodturners Symposium

This was my first time attending the AAW Symposium, hosted by the American Association of Woodturners. Here are some quick notes:

  • I registered on site for just one day attendance, $175. Very nice printed and spiral bound program guide, full color. Profiles and contact info for the presenters included,…

Read more

0 comments, 769 reads

Posted in SQLAndy on 2 July 2013