SDU Tools for March 2018 - going out tonight

I’m really happy with the additions we made to our free SDU Tools for developers and DBAs that are going out tonight:

DatesBetween - table-valued function to return dates between two dates DateDimensionColumns - table-valued function to return typical date dimension columns for a date (useful for data warehouses)

JulianDayNumberToDate - converts a Julian day number to a date DateToJulianDayNumber - converts a date to a Julian day number

SystemConfigurationOptionDefaults - view that shows system configuration options and their default values (and many other values) NonDefaultSystemConfigurationOptions - view that shows system configuration options that are not at their default values

SQLServerVersionForCompatibilityLevel - function that converts a database (or server) compatibility level to a SQL Server version

SystemWords - view that shows reserved words, future reserved words, ODBC reserved words, and system data type names and their display color in SSMS ReservedWords - view that shows SQL Server reserved words (and their display color in SSMS) FutureReservedWords - view that shows SQL Server future reserved words (and their display color in SSMS) ODBCReservedWords - view that shows ODBC reserved words (and their display color in SSMS) SystemDataTypeNames - view that shows all system data type names (and their display color in SSMS)

CreateLinkedServerToAzureSQLDatabase - as the name says - makes it easy to create a linked server to an Azure SQL DB

ListPrimaryKeyColumns - comma-delimited list of primary key columns for all primary keys

You’ll find more on joining SDU Insiders and getting our free resources here:

http://sdutools.sqldownunder.com

2018-02-28