(Tibor Nagy) I just started working at a payments company and now everyone is talking about the prevention of data breaches and an upcoming PCI DSS audit. What is PCI DSS and what are the requirements from a SQL Server perspective?
Other News
JQuery ID Selector Example
JQuery Id selector selects elements with the given id attribute. It represents the tag with the given ID in the document object model.
Redirect and Post JSON Object in ASP.NET MVC
(Samer Abu Rabie) I want to be short as much as I can by stating the problem, possible solutions and cleanest solution that I am sharing with you here, so I will be descriptive and straight forward to the point as much as I can.
An interesting case in ORDER BY LIMIT optimization
(Sergey Petrunia) Recently, I was asked about an interesting case in ORDER BY … LIMIT optimization. Consider a table
Integrating IBM Integration Bus with WebSphere Service Registry and Repository: Part 7: Configuring the WebSphere Service Registry and Repository cache in IBM Integration Bus
(Martin Smithson, Erik Nord, Stephen Rea and Jerry Stevens) Combining IBM Integration Bus (IIB) with WebSphere Service Registry and Repository (WSRR) lets you dynamically retrieve service metadata from WSRR and use it to modify message flow behavior at runtime. This article series shows you how to
db2look from a DB2 10.5 to a 9.7 database: how to successfully apply the SQL
(Norberto) Recently I needed to restore a backup taken on DB2 10.5 into a server where I was not able to install that same version (due to OS pre-reqs not met). As I already had DB2 v9.7 there – and I was not in a position where I could have the OS upgraded – I had to use db2move instead.
What does a Commit mean in DB2?
(Ember Crooks) Database management systems have the concept of a commit. This concept has to do with grouping sets of actions together such that they all succeed or fail as a group. This represents the A in the famous ACID properties of a transaction system.
12c Online Table Redefinition Examples
(Bobby Durrett) I’ve been learning about online table redefinition in Oracle 12c. Here is a zip of some test scripts I built for my own understanding: zip
Exporting Multiple BLOBs with Oracle SQL Developer
(Jeff Smith) BLOBs are cool. Optimized such that you can store files basically in the database, with the power of SQL AND no performance hit. That sounds like a pretty good deal.
ORA-32771 and ORA-32772
(Andrew Reid) Bigfile tablespaces were introduced, and this example was run, in Oracle 10. They have only one datafile. Usually, this will be very large, although this is not the case in the example below: