SQL Server – how to know when a stored procedure ran last

This week I needed to know if a stored procedure was running when expected during our batch.  So, here is a quick couple of SQL to answer the question: When a Stored Procedure was run last This version of the SQL gives the date for the last time the Stored Procure was run: select distinct   … Continue reading SQL Server – how to know when a stored procedure ran last

Oracle TO_CHAR to SQL Server CONVERT Equivalents to change Date to String

Transact SQL (T-SQL) When it comes to SQL I tend to lean on the SQL I have used the most over the years, which is Oracle.  Today was no exception, I found myself trying to use the TO_CHAR command in SQL Server to format a date, which of course does not work. So, after a … Continue reading Oracle TO_CHAR to SQL Server CONVERT Equivalents to change Date to String

SQL server table Describe (DESC) equivalent

Transact SQL (T-SQL) Microsoft SQL Server doesn’t seem have a describe command and usually, folks seem to want to build a stored procedure to get the describe behaviors.  However, this is not always practical based on your permissions. So, the simple SQL below will provide describe like information in a pinch.  You may want to … Continue reading SQL server table Describe (DESC) equivalent

Microsoft SQL Server – Useful links

Microsoft SQL Server 2017 Here are a few references for the Microsoft SQL Server 2017 database, which may be helpful. Table Of Useful Microsoft SQL Server Database References Reference Type Link SQL Server 2017 Download Page https://www.microsoft.com/en-us/sql-server/sql-server-downloads SQL SERVER version, edition, and update level https://support.microsoft.com/en-us/help/321185/how-to-determine-the-version--edition-and-update-level-of-sql-server-a SQL Server 2017 Release Notes https://docs.microsoft.com/en-us/sql/sql-server/sql-server-2017-release-notes SQL Server Transact SQL Commands … Continue reading Microsoft SQL Server – Useful links

Netezza / PureData – How to Number for day of week in SQL?

I had reason today to get the number of the day of the week, in PureData / Netezza, which I don’t seem to have discussed in previous posts.  So, here is a simple script to get the number for the day of week with a couple of flavors, which may prove useful. Basic Format select … Continue reading Netezza / PureData – How to Number for day of week in SQL?

Netezza – JDBC ISJDBC.CONFIG Configuration

JDBC ( Java Database Connectivity) This jdbc information is based on Netezza (7.2.0) JDBC for InfoSphere Information Server11.5.  so, here are a few pointers for building an IBM InfoSphere Information Server (IIS) isjdbc.config file. Where to place JAR files For Infosphere Information Server installs, as a standard practice, create a custom jdbc file in the … Continue reading Netezza – JDBC ISJDBC.CONFIG Configuration