(Rick Krueger) The folder structures for Database Projects can get very complicated. Even the most experienced of us can have trouble figuring out not only where Visual Studio wants us to put certain database objects, but how to name them properly (e.g. SQLUser.user.sql). If scripts aren’t named app
Author: SSWUG Research
Support for multiple triggers per table for the same value of action/timing.
(Dmitry Shulga) For a long time MySQL server supported only one trigger for every action (INSERT, UPDATE, DELETE) and timing (BEFORE or AFTER). In other words, there could be at most one trigger for every pair (action, timing). It means that a user couldn’t assign for example two BEFORE INSERT trigg
Getting started with real-time stream computing
(Jacques Roy) Use InfoSphere Streams to turn volumes of data into information that helps predict trends, gain competitive advantage, gauge customer sentiment, monitor energy consumption, and more. InfoSphere Streams acts on data in motion for real-time analytics. Get familiar with the product and fi
Can a simple DB2 command be exceptionally cool?
(Willie Favero) Yes it can. DB2 11 will be proving that to us once DB2 11 goes generally available and everyone gets a chance to play around with it.
HTML5 Real-Time Chat with Websockets, jQuery, and Spike-Engine
(Kel_) Everything in the web becomes increasingly real-time and HTML5 finally offers some facilities to build efficient, simple and robust real-time applications on the web. This article serves as a demonstration of such facilities in building a fun and simple client-server chat:
Setting Unscoped Variables Inside CFThread In ColdFusion
(Ben Nadel) A few years ago, I looked at the way scoped-variables were treated inside a ColdFusion component when set within the context of a CFThread tag. Since that posting (which was overly complex in retrospect), I’ve come to love CFScript; and with that love, I’ve also dropped most of my explic
IBM DB2 10.5 with BLU Acceleration vs. Oracle Exadata
(Chris Eaton) Now that I’ve written about BLU in so many different blog postings, I’m going to start to append a table of contents at the end of each posting. If you have missed some, check out the bottom of this blog for a list of other BLU topics.
XML Marks the Spot Part 3: Nested Objects
(Jeffery Hicks) In the previous lessons we explored converting PowerShell data into a “traditional” XML document. In other words, an XML document that you could use outside of PowerShell. In the last lesson I created a few XML documents using ConvertTo-XML including nested objects. I’ll use them for
Getting Started with Data Mining in SQL Server
(Paul Turley) As database professionals, we typically work in a field of exact science. For example, a common practice in business intelligence (BI) solutions is creating duplicate copies of data sets, then comparing the results from the different sources to make sure they’re the same.
A Journey from OLTP to OLAP- Part 2
(Franco Lopes) In my last article we saw the basics of the data warehousing in which we saw looked at how OLAP and OLTP technologies differ in their functionalities, what were the models being used to develop the data warehouse and what were the schemas under consideration for designing the data wa