Steve Jones

My background is I have been working with computers since I was about 12. My first "career" job in this industry was with network administration where I became the local DBA by default. I have also spent lots of time administering Netware and NT networks, developing software, managing smaller IT groups, making lots of coffee, ordering pizza for late nights, etc., etc.

I currently am the editor of SQL Server Central and an advocate/architect at Redgate Software. I am also the President of SQL Saturday, maintain the T-SQL Tuesday monthly party, and remember our colleagues at sqlmemorial.org.

You can find out more about me on my blog (www.voiceofthedba.com) or LinkedIn (www.linkedin.com/in/way0utwest)
  • Interests: yoga, reading, biking, snowboarding, volleyball

SQLServerCentral Editorial

Billy-yons and Billy-yons of Records

There was an article last week with a great title: The Mother of All Genealogy Databases, and so I had to take a look at it. It talks about some of the large databases on the Internet that are collection public records and linking them together to help people find out about their individual and family histories. The largest site so far, Ancestry.com, supposedly has 5 billion records.

You rated this post out of 5. Change rating

2007-09-24

218 reads

SQLServerCentral Editorial

Opening Day

Today is the opening day for the PASS conference here in Denver and it's kind of exciting. As many of you read this, I've hopefully gotten Simon Galbraith, owner of Red Gate software, and my boss, out here at the ranch shoveling manure. He's anxious to get on the ATV for a ride, so maybe I can work out a deal to reduce my workload 🙂

4 (1)

You rated this post out of 5. Change rating

2007-09-18

115 reads

SQLServerCentral Editorial

Unethical or Just Sneaky

One of the fundamental rules of a stable, controlled production system is that you apply updates singly, after they've been tested, and you document the change. This way you can ensure that if a problem occurs, you can do some backtracking to see what might have caused instability.

5 (4)

You rated this post out of 5. Change rating

2007-09-17

1,207 reads

SQLServerCentral Editorial

Recruiters

Do you like recruiters? Do you use them? It's almost impossible not to use them these days when looking for a job. So many of the listings on online job boards are from recruiters and many have deals to place people, so chances are you'll at least deal with on even if they don't get you a job.

You rated this post out of 5. Change rating

2007-09-13

172 reads

SQLServerCentral Editorial

What Could Go Wrong?

It's the law of unintended consequences: things happening that you don't expect from a seemingly unrelated area. This article talks about a data center having leaks from carpet cleaning above. The concrete floor had aged and the carpet cleaners dumped water on the carpet to soak it through and it leaked. I'm not sure how people have data centers below office floors, but I know I've had a number of them at different companies where I've worked.

You rated this post out of 5. Change rating

2007-09-12

133 reads

Blogs

Big Queries, Big Money

By

I had been meaning to post this, so as I finished a piece that...

A New Word: Fardle-dun

By

fardle-din – n. a long-overdue argument that shakes up a relationship, burning wildly through...

Lukáš Karlovský: I got the green light from management and built Fabric specialization from scratch

By

The post Lukáš Karlovský: I got the green light from management and built Fabric...

Read the latest Blogs

Forums

Peer review SQL Central articles

By Srinivasarao Daruna

Hi, I would like to contribute to SQLServerCentral in peer reviews. As there are...

Getting ANY of the data

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Getting ANY of the data

Why Would You Do That?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Why Would You Do That?

Visit the forum

Question of the Day

Getting ANY of the data

I have this data in two tables:

-- Beer table
BeerIDBeerNamebrewer
5Becks    Interbrew
6Fat Tire   New Belgium
7Mac n Jacks  Mac & Jack's Brewery
8Alaskan AmberAlaskan Brewing 
9Kirin        Kirin Brewing

-- Beercount table
BeerName      BottleCount
Becks         5
Fat Tire      1
Mac n Jacks   2
Alaskan Amber 4
NULL          7
Corona        2
Tsing Tao     4
Kirin         12
What is returned from this query?
SELECT *
FROM dbo.BeerCount AS bc
WHERE bc.BeerName=ANY
  (SELECT b2.BeerName FROM dbo.Beer AS b2);
 

See possible answers