4th - 7th May 2016

Liverpool

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/
Steve Jones has submitted 5 sessions for SQLBits XV, although the agenda hasn't been chosen yet. See all submitted sessions.

Pending Sessions

Protecting our data from unauthorized access becomes more and more important all the time, however it has been difficult to ensure sensitive data is encrypted in SQL Server. The new Always Encrypted feature in SQL Server 2016 makes this much simpler.
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 that 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.
SQL Server 2016 gives developers a number of ways in which they can protect their data. In this introductory session, you will learn about the encryption options in SQL Server 2016 and how each can be used to protect data.
Compliance and auditing are becoming more important characteristics for many databases and applications. This session will examine how SQL Server Audit can be used to track all changes and access on your SQL Server database.

Previous Sessions

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 that 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.

Blog posts RSS

The Push to Upgrade from SQL Server 2005 12 Feb 2016
It was interesting to see the results of my straw poll last week on SQL Server 2005. Quite a few people still run that version, and some aren’t looking to upgrade anytime soon. However when support ends, you should be aware that there is potentially an impact to your organization. If you work ...

Limiting Database Permissions for DLM Dashboard 11 Feb 2016
I was talking with some of our support people recently about permissions on DLM Dashboard. A client was having issues, and we weren’t sure what was wrong. As a result, I decided to dig in a bit and see how limited I could be with permissions for the login/user that is used to track changes.…

Reasonable Timeframes 11 Feb 2016
Many of us hear about problems with various systems on a regular basis. We report them in Database Weekly far too often, and I’m sure a few of you have been informed (or found) bugs, nagging issues, even vulnerabilities in your systems. What’s a reasonable time to fix a system after an ...

CROSS APPLY v InLine Functions 10 Feb 2016
While working on the Advent of Code problems in SQL, I ran across something interesting. Day 4 involves hashing, which is done with the HASHBYTES function in SQL Server. This is a computation and given the problem, there is no good way to do this without brute force. The problem says hash a ...

The Digital Woes of Public Records 09 Feb 2016
Researcher Chris Vickery, discovered that 191 million voter records are available to the public. The information was in a database on the Internet, which seemed to be a collection of voter records and information compiled from public sources in various US states. While no Social Security numbers ...