THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Greg Low (The Bit Bucket: IDisposable)

Ramblings of Greg Low (SQL Server MVP, MCM and Microsoft RD) - SQL Down Under

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: https://youtu.be/V-jCAT-TCXM

QuoteString - puts quotes around a string and doubles-up any embedded quotes. You can see it here: https://youtu.be/uIj-hTIhIZo

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: https://youtu.be/P-r1zmX1MpY

SeparateByCase - takes a pascal-cased or camel-cased string and separates out the words by inserting a space. You can see it here: https://youtu.be/kyr8C2hY5HY

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: https://youtu.be/wc8ZS_XPKZs

PrintMessage - annoyed at waiting for PRINT messages to come back in your stored procedures? Wait no more. You can see it here: https://youtu.be/Coabe1oY8Vg

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. More information is here: http://www.sqldownunder.com/resources/sdutools

Published Saturday, March 25, 2017 6:46 PM by Greg Low

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

No Comments

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Tags

No tags have been created or used yet.

Archives

Privacy Statement