(Michael Paquier) When using COPY, there is an option called FORCE_NOT_NULL allowing to enforce a string to be not null even if it is not quoted. Here is an example of how it works:
Author: SSWUG Research
Row and Column Access Control (Column Masking)
(mkrafick) This article is based off the ¡°DB2 v10.1 ¨C Row and Column Access Control (Column Masking)¡± presentation for the DB2 Night Show (Episode #128) ¨C DB2¡äs Got Talent competition held on Friday, March 7th at 11am EST.
Auditing Mainframe Database Data Access and Modification
(Craig S. Mullins) Tracking who did what to which piece of data, and when they did it, is important because there are many threats to data security. External agents trying to compromise security and access company data are rightly viewed as a threat to security. But industry studies have shown that
Data Dictionary Cache Hit Ratio
(Andrew Reid) Every Oracle database has a data dictionary, which is owned by the SYS user and stored in the SYSTEM tablespace. This consists of read-only tables, which record information about the database e.g. table definitions, details of integrity constraints, usernames and the roles and privileg
Regular Expressions, Part 3: Business Intelligence Uses
(Ondrej Balas) In Part 1 and Part 2 in this series about regular expressions, I went over some of the key features of regular expressions and how to use them in your code.
Don’t forget the emctl reload agent command
(John Hallas) Just a quick entry to show the use of a command that I had forgotten existed but it seemed to work nicely
What’s Wrong with this Create Table Statement?
(Jeff Smith) I recently got this request for help via a YouTube video comment. I’m sharing it here, because I see this type of question A LOT. And it scares me.
Create and Use an ASP.NET Web Service: Part 2
(Ged Mead) In the first post of this series, I created an ASP.NET Web Service and a client that uses that service to fetch some data and display it. That demo simply returned a string. So although it was a useful way of getting you started with how to set up and use a web service, it’s a long way
SQL Server Best Practices
(Ian Stirk) Enhance your SQL Server performance by following the SQL Server Storage Best Practices advice in this month’s SQL Server Pro.
Detailed Migration Steps for SQL Server Upgrades, Part I
(Michael K. Campbell) There’s a saying that all warning labels in airplane cockpits are written in blood (meaning that warnings stem from an unfortunate accident or mistake someone else made in the past—which shouldn’t be repeated). To that end, I’ve decided to post an overview of actual steps you’l