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.
Everyone tests their code, but most people use ad hoc, non-repeatable testing with simple queries. This session will show you how to begin implementing testing into your development process, giving you a growing library that improves code quality.
Come to this session to see how you can create a more efficient database development platform by integrating your VCS with SQL Server. In real-time, you’ll see how versioning, branching, merging, and the other manual tasks you hate can fade away with

Blog posts RSS

Where’s the Unit Testing? 25 Jul 2016
I’ve been a proponent of Unit Testing, especially for databases. I’ve given presentations on the topic and advocate the use of techniques to verify your code works, especially over time when the complexity grows, new developers change code, and potentially introduce regressions. ...

Deploying Row Level Security with SQL Compare 25 Jul 2016
Row Level Security (RLS) is a great new feature in SQL Server 2016. It’s been in Azure SQL Databases for some time, but we now have it on premise. It’s easy to setup and use, and worth taking a look at if you have multi-tenant scenarios, or need more granular security in your organization. ...

What’s Database Drift? 22 Jul 2016
The first time I heard someone mention drift at Redgate, it made sense to me. After all, in the context of the schema of your database, I can see the code “drifting” away from what you expect. Someone noticed this was a problem when implementing continuous delivery and DLM Dashboard was born. I ...

Rename a Primary Key–#SQLNewBlogger 21 Jul 2016
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Having system named objects is one of those things that people may debate, but as you move to more automated and scripted processes can cause you issues. In the case of a ...

ReadyRoll and Octopus Deploy Webinar 21 Jul 2016
I’ll be hosting a webinar next week, Thursday, July 28, with Daniel Nolan (t) (founder of ReadyRoll and fellow Redgate employee) and Damian Brady (b | t) of Octopus Deploy. We’ll be talking deployment, with demos to show you how to work with ReadyRoll for your deployment and then how to build ...