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
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
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 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
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?
Microsoft Microsoft doesn't provide macro guidance for naming convention, however, sometimes it is useful to have a place to start. Also, there are times when flexibility with naming conventions are necessary. So, here is a quick set of SQL Server naming conventions, which may be helpful if you find yourself working with a customer who doesn't … Continue reading SQL Server – Basic SQL Server Object Naming Convention Guidance
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