(Tony Rogerson) Part 2 (Basics of the method in SQL Server) explained how to get data into a Bloom Filter structure, it now needs persisting. This post explains a method on how a Bloom Filter can be stored in a SQL Server database – I assume you have read Part 1 and Part 2 and understand about the h
Author: SSWUG Research
Analyze Your Data Where It Lives: On System z
(Robert Catterall) I can say, with a high degree of confidence, that your organization has at least one analytics application. You have one or more data stores that support this analytics workload: perhaps a data warehouse, some data marts, maybe an operational data store (ODS).
Use Predicate Methods to Stop Writing For…Each Loops
(Peter Vogel) Predicate methods allow you to separate the criteria you’re using to test items in a collection from the code that processes the collection. You may never write a For…Each loop again.
Making Promises With jQuery Deferred
(Rob Gravelle) Remember when you wanted to associate an event handler to a mouseclick, you would assign it to the element’s onclick event, as in mywidget.onclick = myhandler;.
Emitting XML Comments from Everest
(The Mad Programmer) A great question came to me the other day. How does one pretty-up the XML output generated by Everest so that humans can read the XML? Of course there are the old tricks of indentation and formatting the output however that only gets us so far.
Five Big Data Features in DB2 Databases
(Srinivasan Sundara Rajan) Over the past two decades relational databases have been most successful in serving large-scale OLTP and OLAP applications across enterprises.
How to Create OData Service in ASP.NET
(Raj Kumar) In this article you will learn how to create an OData Service in ASP.Net.
Analyze text from social media sites with InfoSphere BigInsights
(Cynthia M. Saracco, Gary Robinson and Vijay Bommireddipalli) Analyzing social media data often requires processing text-based messages to categorize their content, eliminate false positives, assess the sentiments expressed, and perform related functions. Such efforts require extracting context from
Implementing Asynchronous Cascade Delete in MySQL
(Ike Walker) A while back one of my foreign keys started causing trouble. The problem was that some parent rows had tens of thousand of child rows, and the foreign key was defined with CASCADE DELETE enabled. When we deleted one of those parent rows on a master database, it took several seconds to e
Modify segment attributes on Logical Standby during Migration
(Uwe Hesse) Whenever you want to change certain storage attributes of your production tables, a Logical Standby can help. A common case is to do that during a migration. Not only will Data Guard help you to reduce downtime for the migration to the time it takes to do a switchover! With a Logical Sta