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 2011

Big Numbers

What had me reflecting on numbers was an article in the Financial Times (Conduit of Contention if you can find it) that talked about the Depository Trust and Clearing Corporation, which settles all the equity trades on American exchanges. According to the article the DTC settled 1.48 quadrillion dollars… Read more

0 comments, 1,490 reads

Posted in SQLAndy on 29 July 2011

Do You Work for #1?

Someone recently asked me if I would work for a company if I didn’t believe in their products or services (to the point that I would consider them the best). It’s an interesting question because it reflects the trade offs many of us make when selecting jobs, and there is… Read more

1 comments, 645 reads

Posted in SQLAndy on 28 July 2011

Projects – Win Early

Project plans should try to plan for some unknowns. For large projects they include known risks, vacation time, maybe even the loss of a key person or a parallel business crisis. For smaller projects it’s just x percent of slack time that can be used as needed. You do what… Read more

2 comments, 665 reads

Posted in SQLAndy on 26 July 2011

My Schedule for The Remainder of 2011

Just a few notes about things I’m doing over the next few months:

  • July 30 – Attending SQLSaturday Birmingham. I went to their first one and had to skip last year, great to have time to go back to see one of my favorite SQL groups
  • Aug 13 – Making…

Read more

0 comments, 574 reads

Posted in SQLAndy on 25 July 2011

Trusts Are Transitive

If you’ve done networking in the MS world you know about the trust options between domains, and one of the nice features of Windows Server are transitive trusts. If A trusts B and B trusts C, then A trusts C. Technical stuff, but I want to talk about the… Read more

0 comments, 964 reads

Posted in SQLAndy on 21 July 2011

Knowing Someone Makes a Difference-Part 2

How long does it take you to get comfortable at a new job. How long to figure out who is who, find someone people to have lunch with, and feel like you’re fitting in? Consultants do better at this that employees simply because they go into new situations a lot… Read more

0 comments, 908 reads

Posted in SQLAndy on 20 July 2011

Knowing Someone Makes a Difference-Part 1

I’ve put a lot more emphasis on networking in the last few years and I’ve always considered it an investment, the kind of investment that you think will pay off but has no guarantee. It’s not a certificate of deposit type investment.

Does it pay off? How often does knowing… Read more

0 comments, 611 reads

Posted in SQLAndy on 19 July 2011

A Big Milestone-SQLSaturday #100

Just announced yesterday, SQLSaturday #100 will be held in Brazil on November 26, 2011. Just a little over four years since we started the planning for #1 in Orlando, it seems like both a long time and not very long at all. A lot of people have volunteered a lot… Read more

1 comments, 768 reads

Posted in SQLAndy on 19 July 2011

PASS Update #60

I’ve written a lot here, but for June & July (and part of August) I’m trying to just keep the ship moving (my part of it at least) while I recharge. I still manage to have a few things going on, so here is the 60th update on my efforts… Read more

0 comments, 647 reads

Posted in SQLAndy on 18 July 2011

Android Game: Slice-It

The eternal challenge with games, and free/cheap software in general, is knowing what’s out there, especially since you don’t always know what you’d find useful! For illogical reasons I’m a lot more willing to take a chance on stuff on my phone that I would on my laptop – maybe… Read more

1 comments, 648 reads

Posted in SQLAndy on 15 July 2011

Profiled on SQLPeople

I’m late posting it, but I was featured on SQLPeople for June 27th. It’s a project Andy Leonard has going on and it’s interesting indeed to see the similarities and differences from those of that work with SQL Server.

Read more

0 comments, 519 reads

Posted in SQLAndy on 14 July 2011

Denali on TechNet Radio

A quick plug for my friend Blain Barton from Microsoft, he’s got a series of three broadcasts that are video, but done in radio interview format. Worth a look.

Read more

0 comments, 724 reads

Posted in SQLAndy on 13 July 2011

Subtle Errors When Using Dates-Part 2

It’s so easy to make make mistakes with dates. Here is another one I saw recently, this one used when doing some checks on some billable data that had been captured:

select * from sometable where somedate between ‘6/1/2011’ and ‘7/1/2011’

Nine times out of ten when you see that… Read more

3 comments, 562 reads

Posted in SQLAndy on 12 July 2011

SQLSaturday Round Table at the PASS Summit (Early Reminder)

Once again this year we’ll be holding a meeting open to all SQLSaturday event leaders and key team members (and space permitting, we’ll also welcome SQLSaturday volunteers at any level). Karla from PASS HQ will be sending out invitations in the next couple weeks, but for now wanted to get… Read more

0 comments, 612 reads

Posted in SQLAndy on 11 July 2011

Subtle Errors When Using Dates-Part 1

I was reviewing some code recently that has been in production for a while and I saw something like this:

set @SomeDate = getdate()

delete from sometable where datecol > @SomeDate – 3

…..lots of work here, several seconds to a minute

Insert Into SomeTable….new rows where DateCol > @SomeDate…

Read more

0 comments, 580 reads

Posted in SQLAndy on 11 July 2011

Baseball and Scheduling Your Vacation, and a Puzzle?

I saw an article in the newspaper titled How to Visit 30 Ballparks in 35 Days This Summer.  I think it would be an I interesting idea to visit all of them and see some of America in the process, but doing it in 35 days seems less like… Read more

0 comments, 664 reads

Posted in SQLAndy on 8 July 2011

Protected: Count to 41

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

Read more

0 comments, 588 reads

Posted in SQLAndy on 8 July 2011

Count to 41

My children never cease to delight me in all kinds of ways, but never more when they come up with some unusual twist out of the blue. My youngest daughter loves to play hide and seek, and always has to be the first to count (seek). Lately when it’s my… Read more

1 comments, 511 reads

Posted in SQLAndy on 8 July 2011

Maciej Pilecki Speaking at Space Coast UG on July 14, 2011

Just got an email from the Space Coast User Group that Maciej Pilecki (@DrHouseOfSQL) will be doing a presentation to the group on July 14th. Great for a chapter to get a well known speaker.

Read more

0 comments, 610 reads

Posted in SQLAndy on 7 July 2011

PASS Update #59 (Run for the Board)

If it hasn’t happened already we should be close to beginning the election cycle for the 2012 election. Last year we had rough election and we’ve made some changes since then. In particular because we had a rough election last year we need a good pool of candidates this year.… Read more

0 comments, 596 reads

Posted in SQLAndy on 7 July 2011

Older posts