TOP (10) Bad Things to Do In a Database – Voting Begins The TOP (10) list is coming along quite nicely. I’ve been very busy trying to read through all of the submissions for Bad Database Practices and consolidate them into items that are concise, and meaningful. Wow! Open something like that up to 800,000+ readers and you’ve got a […]
Other News
The Semantic Web, Linked Data and Drupal, Part 2: Combine linked datasets with Drupal 7 and SPARQL Views
(Stéphane Corlosquet and Lin Clark) Part 1 of this series explored some of the new concepts recently incorporated into the Drupal content management system, such as how sharing and reusing data is now easier because the technologies discourage proprietary APIs in favor of a machine-readable format –
XML to JSON in PHP: an odyssey
(Enrico Zimuel) Last friday, in occasion of the April Zend Framework Bug-Hunt, I started to look at this bug: ZF-3257. This is an issue related to the Zend_Json class that occurs during the conversion from XML to JSON for some specific XML documents, like this one:
Things worth to mention and remember (III) – Parallel Execution Control 3
(Randolf Geist) Continuing from the previous part of this series I’ll cover in this post some further basics about parallel execution control:
Oracle 11g Security – Securing Client Connections: Client & Server
(James Koopmann) Before venturing down the path of “Securing Client Connections” I thought it would be best to first understand the general concepts of client-server connections.
Migrating Oracle to SQL Server using SSMA – Error O2SS0205 Unable to convert PRAGMA AUTONOMUS_TRANSACTION
(Bill Ramos) This blog post covers some of the reasons why SQL Server Migration Assistant (SSMA) 4.2 for Oracle doesn’t convert the PL/SQL blocks containing PRAGMA AUTONOMOUS_TRANSACTION statement on the block level (i.e. standalone BEGIN … END).
Top 10 SQL Server Counters for Monitoring SQL Server Performance
(Gregory A. Larsen) Do you have a list of SQL Server Counters you review when monitoring your SQL Server environment? Counters allow you a method to measure current performance, as well as performance over time. Identifying the metrics you like to use to measure SQL Server performance and collecting
DB2 Temporal Table: Table Space Clustering Design for Your DB2 Data Warehouse
(Dave Beulke) Last week we talked about the partitioning choices, options and considerations. This week we’ll talk about the other important aspect of table space design, clustering. The clustering of the data can have a huge impact on the overall flow and locking within any table in a DB2 data ware
Viewbox Attribute in SVG
(Darla Ferrara) Viewbox is an attribute commonly used when creating SVG shapes. If you think of the document as a canvas, the view box is part of the canvas you want the viewer to see.
SQL SERVER – CTAS – Create Table As SELECT – What is CTAS?
(Pinal Dave) I have been working with the database for many years and I am aware of many common terminologies. Recently I was attending training myself and the instructor used the word ‘CTAS’ in the class.