Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Regular Columnist: Steve Jones

SQLServerCentral.com profile

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. For those of you interested (or really bored), you can check out my resume.

<< Newer    Items 41 to 60 of 2221    Older >>
 

Opening Up Data

Tim O'Reilly, head of O'Reilly publishing, has been an advocate of better date movement in the world. Steve Jones has a few comments on an interview he gave earlier this year.  Read more...
By Steve Jones 2015/05/12 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 87 reads

Native Audits

This week Steve Jones asks if you're using the SQL Audit feature built into SQL Server.  Read more...
By Steve Jones 2015/05/22 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 107 reads

Boring or Scripting

There is no shortage of mundane tasks at work. Steve Jones notes that you might not want to depend on those to fill your day in the future.  Read more...
By Steve Jones 2015/05/18 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 240 reads

The Service Pack Fiasco

The recent SQL Server 2014 Service Pack fiasco wasn't the first, but hopefully it won't be the last.  Read more...
By Steve Jones 2015/05/11 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 193 reads

How Virtualized?

This week's poll asks about virtualization in your environment. Let us know if you are moving your SQL Server to virtual machines.  Read more...
By Steve Jones 2015/05/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 134 reads

vNext 2016

Steve Jones looks at the next version of SQL Server, SQL Server 2016. Until this week, it was known as vNext.  Read more...
By Steve Jones 2015/05/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 195 reads

Can Auditing Fail?

It doesn't seem to be a feature that an auditing system can fail, but the application being audited continues to run.  Read more...
By Steve Jones 2015/05/05 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 81 reads

Idempotent

There are all sorts of coding practices that produce better code. Steve Jones talks about one today.  Read more...
By Steve Jones 2015/05/06 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 144 reads

BUILDing the Future

Steve Jones talks about the BUILD conference and the future.  Read more...
By Steve Jones 2015/05/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 51 reads

Testing Simple Calculations and UDFs with tSQLt

This article will give you a basic look at how you can test your user defined functions with the tSQLt framework.  Read more...
By Steve Jones 2015/05/18 | Source: SQLServerCentral.com | Category: tsqlt
Rating: |  Discuss |   Briefcase | 4,334 reads

Complete Definitions

When we write scripts, we often assume many settings will be at some default value. When we generate scripts, that's not the case. Perhaps we should be sure that we always include the settings we expect.  Read more...
By Steve Jones 2015/05/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 112 reads

Finding Problem Code

This week Steve Jones has a poll on performance tuning code. Since many people aren't experts, the answers this week might help them learn where to focus their efforts.  Read more...
By Steve Jones 2015/05/01 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 186 reads

Checking Table Metadata with tSQLt

In this article on tSQLt, learn how you can use the AssertResultSetsHaveSameMetaData method from the framework to enforce your API.  Read more...
By Steve Jones 2015/06/11 | Source: SQLServerCentral.com | Category: tsqlt
Rating: (not yet rated) |  Discuss |   Briefcase | 4,291 reads

Is It Time to Upgrade?

Today Steve Jones looks at the reasons for upgrading, or not, from SQL Server 2005.  Read more...
By Steve Jones 2015/04/30 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 131 reads

Dig Out the Root Cause

Finding the basis for a problem is always the best solution.  Read more...
By Steve Jones 2015/04/28 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 142 reads

Code Reviews

This week Steve Jones asks about a concept that he used early in his career: code reviews. It's a good practice, but it seems as though it's fallen out of favor with many developers.  Read more...
By Steve Jones 2015/04/24 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 175 reads

Security Through Chaos

A company Steve Jones knows uses a diverse network infrastructure to help provide security.  Read more...
By Steve Jones 2015/04/22 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 107 reads

Embrace Stored Procedures

Developers working with SQL Server should learn to embrace stored procedures. They really, really do work well.  Read more...
By Steve Jones 2015/04/20 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 393 reads

QA for Data

Often DBAs and developers might make quick data changes to correct user problems or application shortfalls. Steve Jones notes that we can make mistakes, and perhaps we should ensure we QA, or at least log, our changes.  Read more...
By Steve Jones 2015/04/16 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 133 reads

The Opportunistic Hacker

Sometimes the crimes of opportunity might be the worst ones for our data.  Read more...
By Steve Jones 2015/04/14 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 195 reads
<< Newer    Items 41 to 60 of 2221    Older >>