(Martin Bach) If you ever wanted to know how Clusterware works with registered database resources, read on! It takes a little while to get your head around the concepts of the ORACLE_SID, the instance_name and the database name as well.
Other News
How to avoid hash collisions when using MySQL’s CRC32 function
(Arunjith Aravindan) Percona Toolkit’s pt-table-checksum performs an online replication consistency check by executing checksum queries on the master, which produces different results on replicas that are inconsistent with the master – and the tool pt-table-sync synchronizes data efficiently betwee
Using the IBM InfoSphere Guardium REST API
(Guy Galil, Yaacov Lacher, Oded Sofer and Kathy Zeidenstein) Organizations that use InfoSphere Guardium for data security and compliance can take advantage of a rich set of APIs to automate processes and maintain their systems very efficiently.
Load on Demand Data in Webgrid on Scroll Using ASP.Net MVC and jQuery AJAX
(Saineshwar Bageri) This article shows how to load on-demand data into a Webgrid on a scroll using ASP.Net and jQuery AJAX.
Using LISTAGG to Turn Rows of Data into a Comma Separated List
(Ember Crooks) This is a topic I have to look up from time to time, and I always go straight to Serge Rielau’s blog. He has a number of good articles on LISTAGG, the similar XML specific functions, and much more.
TechTip: JSON and XML Conversion in DB2 for i
(Michael Sansoterra) As I noted in my article on SOA and REST, JavaScript Object Notation (JSON) is an important data format in today’s world of RESTful service offerings. Whether your apps are publishing or consuming data, you may be asked to work with JSON.
Solution : Cannot add new node – Rule ‘SQL Server Database Services feature state’ failed.
(blakhani) While deploying SQL Server 2014 cluster in my lab I ran into this problem when I was trying to add second node (Node 2) to SQL cluster.
BLOBS in SQL
Today I want to return to the topic of FileStream and other BLOB (Binary Large Object) data types storage in SQL Server with the exception of XML. Let me start with a near dogmatic statement that BLOB data doesn’t belong in a relational database; especially when there is a lot of it. Let me provide a few reasons why. Using […]
SQL Server 2014 – Log Shipping Feature Overview
SQL Server 2014 – Log Shipping Feature Overview Author: Basit A. Farooq SQL Server log shipping allows you to automatically send transaction log backups from a primary database on a primary server instance to one or more secondary databases on separate secondary standby server instances. In Log Shipping, a database on secondary standby server instance is a mirror image of...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
WPF Data Display Controls – DataGrid – Resizing and Reordering
(Richard Carr) The one hundred and twelfth part of the Windows Presentation Foundation Fundamentals tutorial continues to look at the DataGrid control. This article explains how to disable resizing and reordering of data columns.