In this second of a series of entries on my favorite SQL-related enhancements provided via Db2 12 for z/OS (and "Db2," versus "DB2," is officially the new form of the product name), I will describe us...
While the SQL standard allows multiple NULLS in a unique column, and that is how Postgres behaves, some database systems (e.g. MS_SQL) allow only a single NULL in such cases. Users migrating from othe...
Here are the slides from my presentation at OUG Ireland 2017. All about running R using SQL. Embedded R Execution using SQL from Brendan Tierney...
Oracle Database 12c offers several enhancements to improve security in your PL/SQL program units. These features include: Code-based access control: fine-tune access to database objects inside prog...
Here are the presentations I gave at OUG Norway last week. These are also available on SlideShare Predictive analytics: Mining gold and creating valuable productfrom Brendan Tierney...
Azure SQL Database (SQL DB) has increased its max database size from 1TB to 4TB at no additional cost. Customers using P11 and P15 premium performance levels can use up to 4 TB of included storage at...
I see a lot of confusion when it comes to Azure Data Factory (ADF) and how it compares to SSIS. It is not simply “SSIS in the cloud”. See What is Azure Data Factory? for an overview of ADF, and I’ll...
Some trivia for your Friday. I recently got a question asking about what the attribute “monitorLoop” is in the blocked-process-report because it’s not really documented. You won’t find too much expl...
Oracle Database raises an exception when something goes wrong (examples: divide by zero, duplicate value on unique index, value too large to fit in variable, etc.). You can also raise exceptions when ...
Over the past 6 months I have been trying to push myself to use extended events (XEvents) over SQL trace, once you get past the learning curve it’s probably the way to go. If you are operating in the ...
I. Introduction In the IT industry we go through a tedious and long process of acquiring infrastructure (hardware software and licenses). Typically, projects are held back due to infrastructur...
The SQL Tuning Problem If you ask most DBA's what their #1 pain point is the likely response would be database performance issues. The quickest and least expensive way to solve database performance i...
