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

Office Space–Not The Movie

I’ve worked in a lot of different offices and office layouts over the years. Looking back I’ve been lucky (or not as you prefer) to not spend much time in a cube, almost always having my own workspace or sharing it with one other person. I’ve helped assemble furniture, move… Read more

0 comments, 979 reads

Posted in SQLAndy on 26 March 2013

We Need a Place for SQLFamily News

I’m writing this because I was thinking about a member of the local PASS chapter on the way home last night, a friend who lost his spouse to illness after a long and happy marriage. I had known about her illness, but only knew that she died because he chose… Read more

0 comments, 1,181 reads

Posted in SQLAndy on 22 March 2013

Speaking Tomorrow Night at MagicPASS

I’ll be driving south a few miles tomorrow night to talk to the great group at MagicPASS about the basics of statistics in SQL Server – what they are, how they can help (or hurt) performance, and how to maintain them. I’m looking forward to it, hope to see you… Read more

0 comments, 651 reads

Posted in SQLAndy on 19 March 2013

Learning By Doing

I was recently talking with a friend about doing some research into a NAS solution for home and that I was trying FreeNAS out in a VM. He asked…why? Why not just buy one? He had one, a model I knew about, and said it was solid storage if maybe… Read more

0 comments, 1,775 reads

Posted in SQLAndy on 19 March 2013

Building My Next Workstation–Part 6 (The End)

Let’s start with a quick review of the pieces and what I paid:

Item Cost
Antec P280 Case $90 (may be higher now)
ASUS P8Z77-V LK Motherboard $120
Corsair 500W Power Supply $50 (400w would have been plenty)
Intel I7 3770-K $320 (have seen as low at $299)
Samsung 840…

Read more

0 comments, 661 reads

Posted in SQLAndy on 12 March 2013

Building My Next Workstation–Part 5

With the motherboard and CPU installed I was ready to add the final and perhaps easiest parts to the build. I started with a DVD drive. In practice I almost never use DVD’s any more, preferring to mount ISO files as drives (which also means I can keep them all… Read more

0 comments, 644 reads

Posted in SQLAndy on 11 March 2013

Building My Next Workstation–Part 4

Reading about the motherboard choices took a while. Because I had already decided on a CPU, the Intel I7 I at least had an initial filter. If you’re shopping for one today you want a board that has the Z77 chipset with an LGA 1155 socket – easy to spot… Read more

0 comments, 769 reads

Posted in SQLAndy on 7 March 2013

The End of SQLRally in the US

I saw it in the Connector, but just had time to read the minutes to see what was behind the decision to end the SQLRally franchise in the US. The minutes had precious little to say:

The Board evaluated the revenue, resources, and sustainability of the SQLRally NA model and…

Read more

0 comments, 853 reads

Posted in SQLAndy on 6 March 2013

Picking a Conference Venue

I was reading about the American Association of Woodturners annual symposium that will be held in Tampa this year (and yes, I plan to attend) and ran across this document that describes their process for picking a site each year. It’s not an equation, but here is the opening section… Read more

0 comments, 635 reads

Posted in SQLAndy on 5 March 2013

Building My Next Workstation–Part 3

With a case ordered and a CPU in mind I decided to focus on the power supply next. Remember that the better cases come with fans but not with a power supply (and in general that’s good, you want to pick you own).

As I did the reading I found… Read more

0 comments, 645 reads

Posted in SQLAndy on 5 March 2013

Notes from SQLSaturday #192

This past weekend I was back in Tampa for the sixth annual SQLSaturday. It’s a trip I always look forward to – its only about a 2 hour drive, the event is in Ybor City with tons of dining options, and the event always attracts a great crowd.

There… Read more

0 comments, 649 reads

Posted in SQLAndy on 4 March 2013

Trust in Access

One of the minor features/quirks/annoyances of MS Access is that if you create a single macro or code module you get a prompt to ‘Enable Content’, designed to prevent malicious code from running without you knowing it. I tend to just leave it open for long periods and so it… Read more

0 comments, 681 reads

Posted in SQLAndy on 4 March 2013