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: June 2011

Protected: Google Correlate

This post is password protected. To view it please enter your password below:

Read more

0 comments, 1,452 reads

Posted in SQLAndy on 30 June 2011

Google Correlate

My friend Rob Hatton pointed me to Google Correlate, a new service that lets you explore data trends in a few different ways. The theory is that the history of searches should expose both some interesting trends and correlations, often faster than than the way ‘official’ approaches work.

On… Read more

0 comments, 1,764 reads

Posted in SQLAndy on 30 June 2011

Energy Efficient Offices

I work with a client that recently moved into a newly renovated space in a smaller office building. The renovation was nicely done, and as part of that they put in some effort to make it energy efficient. Compact fluorescent bulbs in the hallways, some new windows for natural light,… Read more

0 comments, 873 reads

Posted in SQLAndy on 29 June 2011

Attention Speakers–Sign Up for SQLSaturday #85 in Orlando!

Our call for speakers for #85 will be open about another 10 days, and then Bradley Ball can jump into the fun and chaos setting up the schedule. As always we’re going to try to give everyone one presentation and we’re friendly to first time speakers too!

Reasons to speak… Read more

0 comments, 609 reads

Posted in SQLAndy on 28 June 2011

PASS Update #58 (Elections)

Last year we had some problems with our annual election, enough problems that clearly we needed to do a deeper look at our ‘process’ to see what was working and what wasn’t. We ended up fielding an Election Review Committee (ERC) that had it’s first meeting at the Summit last… Read more

0 comments, 661 reads

Posted in SQLAndy on 27 June 2011

Growing Leaders

Here’s a two part story(Part 1, Part 2 from Information Week by Larry Tieman you should read. There’s a great quote that to find the influential leaders within an organization “Look for the person with a line at their door”, something that rings true to what I’ve seen.… Read more

0 comments, 880 reads

Posted in SQLAndy on 24 June 2011

Indexes Aren’t Always the Answer

There’s a tendency to think all problems can be solved with an index or two (or partitions, or other performance trick of your choice), but sometimes the answer is to not do the work to start with. Sounds Zen, but it’s often a matter of caching in the write place.… Read more

2 comments, 972 reads

Posted in SQLAndy on 20 June 2011

An Update on My Dell E6500

I bought my E6500 almost three years ago, giving away what was a perfectly good Latitude to trade up to the latest and greatest, including a 64G SSD. It’s been a good machine, runs Windows 7 without issue and even though I hibernate the machine daily, the SSD still goes… Read more

0 comments, 553 reads

Posted in SQLAndy on 17 June 2011

Used Book Stores and Vacation Reading

I took a vacation recently (well, a really long weekend) and as I like to do, visited a few book stores during that time. One was Haslams in St Petersburg, in business more than 60 years and 30,000 square feet of books. I browed for a while and picked up… Read more

0 comments, 665 reads

Posted in SQLAndy on 16 June 2011

PASS Update #57-Board Benefits, Travel, and Meetings

From time to time I get asked about how PASS Board members are compensated, so I thought it would make a good blog post, and I want to add to that some notes related to travel and meetings.

Board members are not paid a salary, stipend, or honorarium. We get…

Read more

0 comments, 680 reads

Posted in SQLAndy on 15 June 2011

Hash Tag Art

I haven’t tried this, but run across a reference to hashtagart that looks pretty interesting as a way to use Twitter to drive people to a URL. Here’s one example of the resulting mosaic:

Maybe someone in the SQL community will give it a try?

Read more

1 comments, 623 reads

Posted in SQLAndy on 14 June 2011

PASS Update #56-SQLRally 2012 Site Selection

Note: This is a good, bad, and ugly post. We took some chances, got some things right, got more than a few wrong. In the end we launched SQLRally, had a good event in 2011, and have one coming to Dallas in 2012.  

Way back in July 2010 as… Read more

1 comments, 973 reads

Posted in SQLAndy on 13 June 2011

Book Review: Make the Impossible Possible: One Man”s Crusade to Inspire Others to Dream Bigger and Achieve the Extraordinary

I finished reading Make the Impossible Possible: One Man”s Crusade to Inspire Others to Dream Bigger and Achieve the Extraordinary ($12 @ Amazon) by Bill Strickland a few weeks ago. I found it browsing at the library and the title definitely caught my attention, and I’m glad it did.

It’s… Read more

1 comments, 772 reads

Posted in SQLAndy on 10 June 2011

What Color Were You On Today?

The school my daughter attends gives each student a workbook type thing at the beginning of each year, and it travels back and forth between school and home with them each day. It contains homework assignments, trip notices, and whatever else might be going on for that day/week. It also… Read more

0 comments, 595 reads

Posted in SQLAndy on 9 June 2011

Another Idea for SQLSaturday

I spend a lot of time just looking at events, watching for new ideas. At our recent SQLRally we had a representative on site from our registration company. They prepared all the badges and raffle tickets in advance, and as you can see below they had them organized in some… Read more

0 comments, 633 reads

Posted in SQLAndy on 7 June 2011

Just Deserts

Here’s another photo from my phone, this one from SQLSaturday Tampa in the cafeteria area. An easy typo to make, after all, they serve sandwiches. The title of the post is just some additional whimsy for you, according to Wikipedia it’s commonly misspelled as ‘just desserts’.

Read more

0 comments, 597 reads

Posted in SQLAndy on 2 June 2011