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

All authors

SQLServerCentral Article

Another DBA Whoops

Two in a month? Steve Jones brings us another mistake made by a DBA in SQL Server. Everyone makes them and we may not like to admit to them, everyone that we print hopefully helps a few other SQL Server DBAs avoid that particular mistake. This one looks at the dangers of sorting by aliases.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2005-07-06

13,487 reads

All authors

Blogs

T-SQL Tuesday #174 – My Favorite Interview Question

By

This month is a great topic to me. I think growing and improving your...

T-SQL Tuesday #174: Job Interview Questions

By

Once upon a time, I used to think of difficult technical questions to ask...

Power BI: Refreshable Excel Files in PBI Service

By

Ever since Excel made its debut in the 1980’s, it has been used as...

Read the latest Blogs

Forums

Help on grouping to sets of rows in my sql data

By Mond

Hello I need help on writing this query. This is what i need. I...

SSIS Connecting to Azure SQL Managed Instance w/ MFA

By tjcavins

We've been testing out Azure SQL Managed Instance and created SSIS packages to run...

Summarizing Raw Sales Data with Group Summaries and Final Summary

By Paul Stasny

Greetings, I need to transform data returned in a query from several tables as...

Visit the forum

Question of the Day

The Query Traceflag

If I want to enable a trace flag for a specific query, how do I do it?

See possible answers