(Shaun M. Thomas) PostgreSQL is a pretty good database, and I enjoy working with it. However, there is an implementation detail that not everyone knows about, which can drastically affect table performance. What is this mysterious feature? I am, of course, referring to foreign keys.
Other News
Dealing with a long string
(Kenneth Fisher) Every now and again you have to put a really long string (more than 8000 characters). Dynamic SQL is the most frequent example where I see this but I do see it elsewhere as well and it’s very easy to make a simple mistake.
A dynamic RequireSsl Attribute for ASP.NET MVC
(Rick Strahl) In most of my Web applications I’m finding that I need to handle SSL activation dynamically rather than statically. IOW, depending on the environment that I’m running in I need to specify whether I want to enforce SSL or not.
Reliability and Performance with IBM DB2 Analytics Accelerator V4.1
(Paolo Bruni, Jason Arnold, Leticia Cruz, Jeff Feinsmith, Willie Favero, Anna Griner, James Guo, Chris Harlander, Johannes Kern, Ravi Kumar, Ruiping Li, Andy Perkins, Jonathan Sloan, Steve Speller and Dino Tonelli) The IBM DB2 Analytics Accelerator for IBM z/OS (simply called Accelerator in this boo
Services Made Easy
(Peter Shaw) How many times have you needed to create a backend service to support your latest web project? For many people, the answer to this is, quite a few! So how do you go about doing that then?
SHUTDOWN TRANSACTIONAL
(Andrew Reid) If you run this command, Oracle waits until all users have committed or rolled back any outstanding transactions before closing the database. To test this out in Oracle 12.1, I tried to close a database from a session with an outstanding transaction.
Using the New OData Source in SQL Server Integration Services
(Koen Verbeeck) Microsoft recently released the OData source adaptor for Integration Services (SSIS). Using this source component, it becomes really straightforward to read data from OData sources, such as SharePoint lists. This tip will walk you through the installation and configuration of this br
Competing With Yourself
Is it possible for a product to be too good? I am wondering if that may be so. It used to be a goal to create a product that had a long lifetime. The value was in the quality and longevity. Today it seems vendors would wish their products were not so good. Here are a few examples: Windows XP […]
SSWUGtv Security: Your cloud provider isn’t encrypting your data! …and other misconceptions.
Video Programming for IT Professionals
Geek City: Lost Identity
(Kalen Delaney) Way long ago, when Sybase first added the IDENTITY property, it took people quite a while to get the hang of using it. Along with being able to automatically generate sequential numbers for each row, we had to tune a configuration option with the geekiest of names: “Identity Burning