About The Voice of the DBA

The Voice of the DBA is a moniker that Steve Jones has adopted for his writing and work with SQL Server. It came about after functioning as the editor of SQLServerCentral for many years as a title for his podcast efforts in 2008.

Steve has been working with SQL Server since 1991, when he became the accidental DBA for a SQL Server v4.2 system running on OS/2 1.3. It was an unstable combination that lead to Steve working almost 400 hours one month as the system needed constant babysitting and there were upgrades through SQL Server 4.2a and 4.2b, OS/2 2.0 and then v2.1. Eventually the system migrated to Windows NT 3.1 Advanced Server, and Steve could get some sleep.

Since that time Steve has worked with all versions of SQL Server at various jobs and been greatly pleased with the enhancements and growth of the product. He feels it is an outstanding database platform that is suited to a wide variety of needs and situations.

In 2001, Steve founded SQLServerCentral.com with Brian Knight, Andy Warren, and three other partners that were bought out the next year. In 2002, Steve left his job with Peoplesoft to manage SQLServerCentral full time as editor, publisher, and writer. Andy, Brian, and Steve continued to manage and grow SQLServerCentral until 2007 when it was sold to Red Gate Software along with Database Weekly (then Database Daily). At that time Steve went to work for Red Gate and has continued his work with SQLServerCentral and Red Gate since that time.

Steve regularly speaks at SQL Saturday and other technical events on career and technical topics, and enjoys meeting and interacting with the SQL Server community. If you are interested in inviting him come speak at your event, please feel free to contact him through email, Twitter, or Facebook. You can also get the text of his keynote talks.

Steve was first awarded the Microsoft MVP award in 2008 and has been renewed 3 times for his many contributions to the community. Steve holds an MCSE from NT 4.0, an MSITPro in SQL Server, and numerous other MCP certifications in SQL Server. He also has an undergraduate degree from the University of Virginia in Economics.

Photos (for use at other sites)

p15137ta101084_23 p15137ta101084_14 SQL Saturday 478 - ABQ - Feb 2016 - Headshots-0543

7 Responses to About The Voice of the DBA

  1. Mark Rogers says:

    Hi Steve, sorry to post this here, I couldn’t see an email contact.

    My name is Mark.

    I noticed that you tweeted one of my favorite articles from Seth Godin’s Blog, “To overcome an irrational fear…”

    I was hearing from my readers that they wanted something more in depth about the topic so I went ahead and created this post:


    It discusses some background neuroscience and a practical system for coping with anxieties.

    If you have time I’d love for you to check it out, and if you like it, it would be awesome if you could share it or maybe leave a comment.

    Mark Rogers Ph.D

  2. ben.brugman@hotmail.com says:

    As above, I do not see where to leave a reply on the ‘correct page’
    And I do realise this is a very late reaction on the article:

    Posted on June 7, 2011
    Combinations and Permutations

    But I still want to put in my 2 cents.
    The solution should be more Datadriven. Why if there is a number of items and we want to see combinations of items, each item is either present or it is not present. So a item can be represented as a bit. This immediatly leads to a simple result. The number of items is equivalent to a number of bits.
    The max number of combinations is (2^n).

    See code below to show all combinations of a number of items.
    Define the number of items. (Tested up to 20).
    Define the number of items which should be in the resulting combinations.
    The code is kept generic, but can easily be made more specific.

    The code can fairly easy be extended to show the actual items for a specific case.
    (For example possible color combinatons).

    The code:

    — Generic decimal to binary function.
    — This function is removed at the end of this script.
    CREATE FUNCTION DecimalToBinary_REMOVE_afterwards (@Input bigint)
    RETURNS varchar(255) AS
    DECLARE @Output varchar(255) = ”
    WHILE @Input > 0 BEGIN
    SET @Output = @Output + CAST((@Input % 2) AS varchar)
    SET @Input = @Input / 2
    — 20160202
    — Ben Brugman
    — Aka: Stef ten Bras

    — Show all combinations of a number of items.
    — A choice can be made which number of items should be present in the result combinations.

    — Can be easely expanded to show the actual items.
    — Items can be code or named. (For example a number of colors).
    DECLARE @number_of_items int = 20 — supply the number of items.

    DECLARE @items table(item_count int)
    INSERT INTO @items values(0),(1),(19),(20) — How many items should be in the combination.
    — Here only combinations with 0, 1, 19, 20 items are presented.
    — Result: 42 Combinations. 42, the Answer to the Ultimate Question of Life, the Universe and Everything.

    — Another ‘testset’
    — set @number_of_items = 13
    — delete @items;INSERT INTO @items values(0),(1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12),(13) — How many items should be in the combination.
    — 13 items this results in 8192 Combinations.

    — Another ‘testset’
    — set @number_of_items = 6
    — delete @items;INSERT INTO @items values(0),(1),(2),(3),(4),(5),(6),(7),(8) — Any number of items is ok.
    — 6 items this results in 64 Combinations.

    — Another ‘testset’
    — set @number_of_items = 10 — For example 10 colors
    — delete @items;INSERT INTO @items values (2),(3),(4),(5) — Pick 2 to 5 colors.
    — 10 colors pick a 2 to 5 gives 627 combinations.

    DECLARE @max_row bigint = power(2, @number_of_items)
    SELECT @number_of_items Number_of_items, @max_row Maximum_number_of_rows
    L1 AS(SELECT 0 as x FROM L0 A, L0 B, L0 C, L0 D), — 4 ^4 = 256
    L2 AS(SELECT 0 as x FROM L1 A, L1 B, L1 C, L1 D), — (4 ^ 4) ^4 = 4 Giga
    L9 AS(SELECT *, row_number() OVER(PARTITION BY x ORDER BY x )-1 as nr FROM L2), — voeg rijnummers toe
    LX AS(SELECT top (@max_row) ‘00000000000000000000000000000000’+convert(varchar(80),dbo.DecimalToBinary_remove_afterwards(nr)) Combinations, nr FROM L9 ORDER BY nr),
    LXI AS(SELECT SUBSTRING(combinations, datalength(combinations)-@number_of_items+1,@number_of_items+1) combinations, nr FROM LX),
    LXII AS(SELECT * FROM LXI WHERE (DATALENGTH(combinations)-DATALENGTH(replace(Combinations,’1′,”))
    in (SELECT * FROM @items))) –How many items must be present in the endresult.

    — comments :
    — L0..L9 Is to generate a large number of rows each with a row_number (minus 1).
    — LX Limits the result set to the maximum number of combinations.
    — Makes the combinations visible. Each item has a position. 1 present, 0 absent.
    — LXI Limits the resultlength of the string.
    — LXII Only specific combinations are show. (Specific number of items)

    DROP FUNCTION DecimalToBinary_REMOVE_afterwards


  3. Pingback: 100 Posts! – SQL Jana

  4. Rajan says:

    Hi Steve, I am new to this Filetable concept and I have a requirement like archive file stream data from once place to another place. How to move files a file directory to another directory programmatically (Through SQL sript)

  5. Rajan says:

    Hi Steve, Good morning.
    I have posted my query in forum https://www.sqlservercentral.com/Forums/.
    Could you please look my query and help me?
    Thanks in advance.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s