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 Get A List Of When A Store Procedure Was Last Changed Or Created

In the continuing journey to track down impacted objects and to determine when the code in a database was last changed or added, here is another quick SQL, which can be used in Aginity Workbench for Netezza to retrieve a list of when Store Procedures were last updated or were created. SQL List of When A Stored Procedure was … Continue reading Netezza / PureData – How To Get A List Of When A Store Procedure Was Last Changed Or Created

Netezza / PureData – How To Get a SQL List of When View Was Last Changed or Created

Sometimes it is handy to be able to get a quick list of when a view was changed last.  It could be for any number of reason, but sometimes folks just lose track of when a view was last updated or even need to verify that it hadn't been changed recently.  So here is a quick … Continue reading Netezza / PureData – How To Get a SQL List of When View Was Last Changed or Created

Netezza / PureData – How To Quote a Single Quote in Netezza SQL

How To Quote a Single Quote in Netezza SQL? The short answer is to use four single quotes (''''), which will result in a single quote within the select statement results. How to Assemble the SQL to Quote a Single Quote in a SQL Select Statement Knowing how to construct a list to embed in … Continue reading Netezza / PureData – How To Quote a Single Quote in Netezza SQL

Netezza / PureData – How to build a multi table drop command from a select

How to Quick Drop Multiple Tables occasionally, there is a need to quickly drop a list of tables and you don't always want to write or generate each command individually in Aginity.  So, here is a quick example of how you can use a 'Select' SQL statement to generate a list of drop commands for you. Now, … Continue reading Netezza / PureData – How to build a multi table drop command from a select

How to know if your Oracle Client install is 32 Bit or 64 Bit

  How to know if your Oracle Client install is 32 Bit or 64 Bit Sometimes you just need to know if your Oracle Client install is 32 bit or 64 bit. But how do you figure that out? Here are two methods you can try. The first method Go to the %ORACLE_HOME%\inventory\ContentsXML folder and … Continue reading How to know if your Oracle Client install is 32 Bit or 64 Bit

OLTP vs Data Warehousing

OLTP Versus Data Warehousing I’ve tried to explain the difference between OLTP systems and a Data Warehouse to my managers many times, as I’ve worked at a hospital as a Data Warehouse Manager/data analyst for many years. Why was the list that came from the operational applications different than the one that came from the … Continue reading OLTP vs Data Warehousing