steve_jones.jpg

Steve Jones

Steve Jones is currently the editor of SQLServerCentral, employed by Red Gate Software. Steve has been working with SQL Server for two decades at a variety of large and small companies. Steve has spent time as a hiring manager as well as a technical DBA, easily moving back and forth between these positions at different employers. He has managed Windows networks, functioned as a production DBA, development DBA, software developer, and DBA manager. His work has included start-up as well as Fortune 1000 companies in the power, financial, education, and software industries. He currently has his dream job managing the largest SQL Server community on the Internet from his ranch in Colorado and writes a daily editorial at SQLServerCentral.
http://www.sqlservercentral.com http://voiceofthedba.wordpress.com/feed/

Sooner or later some sort of disaster occur on your SQL Server instance. It might be the destruction of a server, the corruption of a page inside the database, or just the unexpected deletion of some data. When disaster does strike, will you be prepa
A look at binary data in SQL Server and full-text searching of the content of binary files.
Everyone wants a job they enjoy and look forward to working at each day. This session will present practical techniques for improving your brand and giving you the chance to interview for the job you want.
Building software is hard, and we often find that fixing bugs is expensive if they are not caught early. Continuous Integration (CI) has proven to be a valuable technique in improving software quality and this session demonstrates CI for databases.
tSQLt is a testing framework that is designed to help you write repeatable, isolated tests against your database code. In this session we will briefly examine the goals of testing, and introduce tSQLt with a variety of demonstrations.
Everyone wants a dream job that they enjoy going to each week. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself in today's competitive world.

Blog posts RSS

The April Blogger Challenge 27 Mar 2015
I’d encourage you to take Ed Leighton-Dick’s challenge to blog in April. Read his post, start writing, and put your post out there. Tweet about it, and be proud. However, if you’ve never blogged, I have a modification for you. Publish privately. The important thing is to just ...

Efficiency 26 Mar 2015
This editorial was originally published on Oct 22, 2010. It is being re-run as Steve is away on vacation. There was a debate recently about older IT workers and the fact that there is some age discrimination going on in this industry. While that’s probably true, it happens in other fields as ...

tSQLt with TRY..CATCH 25 Mar 2015
Someone asked me the question recently about how tSQLt works with TRY..CATCH blocks and the exceptions that we might test for. It works fine, just as it would with other code, but you need to understand that a CATCH still needs to re-throw an exception. Here’s a short example. I’ve got ...

The Basic TRY..CATCH 24 Mar 2015
Have you written a TRY..CATCH statement in T-SQL? I hadn’t done it for most of my career, since the construct hadn’t existed. As a result, my code over the years is littered with catching @@error in a variable and then acting on that result.  However I’m trying to do better, ...

Are There That Many GUIDs? 24 Mar 2015
This editorial was originally published on Oct 12, 2010. It is being re-run as Steve is away on vacation. Do a lot of people actually use GUIDs as Primary Keys? I haven’t used them much, and I would have thought that more people chose identity keys. It seems that most of the demos and ...