March 2017 update for SDU Tools–More free tools for SQL Server developers and DBAs

Hi Folks,

As promised, tonight we’re releasing the monthly update to SDU Tools, our free toolset for SQL Server developers and DBAs. A download link will be sent to all registered subscribers.

image

First, the new tools:

AnalyzeTableColumns - allows for quick profiling of a table. Shows the column metadata, and shows a sample of distinct values from each column. We suspect this will be the favorite this month. You can see it here: YouTube Video

QuoteString - puts quotes around a string and doubles-up any embedded quotes. You can see it here: YouTube Video

LeftPad and RightPad - pads a string to the left (or right) with a specified filler character. Useful for formatting strings or right-aligning numeric values. You can see them here: YouTube Video

SeparateByCase - takes a pascal-cased or camel-cased string and separates out the words by inserting a space. You can see it here: YouTube Video

StartOfFinancialYear and EndOfFinancialYear - calculates the start (or end) of the financial year for any given date, and allows you to specify the month when the financial year starts. You can see them here: YouTube Video _XPKZs

PrintMessage - annoyed at waiting for PRINT messages to come back in your stored procedures? Wait no more. You can see it here: YouTube Video

And the new options:

We’ve added two other scripts to the download zip.

  • A script that can be used to completely remove the tools
  • A script that contains the sample code that we’ve used in the videos for this month

And the fixes:

We’ve also corrected a couple of issues that we had with collations (don’t you just love collations). And while we’re going to be super-careful about backward compatibility, we did rename one option. FindSubsetIndexes is now ListSubsetIndexes so it matches the other commands in that group. (The developer responsible has been dealt with Smile)

We hope you continue to use SDU Tools.

You can find out more about our free SDU Tools here:

http://sdutools.sqldownunder.com

2017-03-25