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

tSQLt in Azure SQL Database 27 Aug 2015
I was excited to hear about the v12 Azure databases supporting CLR assemblies. Mainly because I’ve been doing testing work with tSQLt and wanted to run tests in an Azure database. I upgraded a SQL Azure database to v12 and connected in SSMS. My first step was to open the tSQLt file. I had the ...

A Clock With Benefits 26 Aug 2015
One of the difficulties I think that developers face is that so few people understand what actually goes into producing software. The end result that a user sees can mask the effort and complexity of the underlying code. A person might see one application that required months of effort and not ...

The Log Chain 25 Aug 2015
I ran across a question recently from someone that received a similar message to the one showed in this image: In this case, the log chain is broken. I’ve received this message, usually from a script that is automatically restoring all the logs in a folder. I’ve also had clients call me with this ...

Surfing 25 Aug 2015
How many of you have gotten up before dawn, driven to the coast, gotten on a long piece of fiberglass and paddled into the ocean before turning around to ride back to shore? It’s a great way to start your day, and I’ve been lucky enough to do this many times in my life. I […]

Pick the Right Database in Azure 24 Aug 2015
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Another quick post, because this is something that’s annoyed me regularly. Hopefully writing this will help me make fewer mistakes. Let’s suppose you have an Azure SQL ...