(Julian Stuhler) In-memory databases are becoming increasingly popular and an ever-more important factor in performance-critical activities such as stream processing and deep data analytics.
Other News
Building a WebSphere Business Events Infrastructure, Part 1: Augmenting a Business Space in a WebSphere Business Events clustered infrastructure
(Paul Faulkner and Wilson Fievre) This series covers recommendations and techniques for implementing a highly available, highly scalable WebSphere Business Events infrastructure. Part 1 provides a step-by-step guide to augmenting a Business Space in a WebSphere Business Events clustered environment.
Automate Bringing Cluster Resources Online After Failover is Unsuccessful
(David Bird) Have you noticed that when a failover is initiated on a SQL Server cluster it does not always do so successfully? Often nothing is wrong, it’s just taking too long to confirm a resource or Windows id. The cause may vary but the solution is the same. You log onto the cluster server and b
Production Controls
SSWUG Free Expo Event: Real-World SharePoint Administration Friday, February 11, 2011, 9 a.m. – 1 p.m. PST Build your skills for deploying and supporting SharePoint by attending this virtual expo. Experts will teach you techniques for managing access control, implementation strategies and tips you can use immediately. With registration you also receive a free complimentary membership to SSWUG for one […]
TIMESTAMP versus DATE/TIME
(Craig Mullins) Consider a database design decision point where you need to store both date and time information on a single row in DB2. Is it better to use a single TIMESTAMP column or two columns, one DATE and the other TIME?
An External Table Definition
(chet justice) Yes, I know these examples are everywhere…but this is:
Reporting: How to sort grouped rows
(Ged Mead) In an earlier blog, I talked about how to sort columns of a table report. That report didn’t have any row groups, so it was a straightforward task. To be honest, if your report does have row groups and you want to include column sorting functionality, it’s not that much more difficult.
How InnoDB performs a checkpoint
(Baron Schwartz) InnoDB’s checkpoint algorithm is not well documented. It is too complex to explain in even a long blog post, because to understand checkpoints, you need to understand a lot of other things that InnoDB does.
Table Constraints in SQL 2005
(Sivaraman Dhamodaran) Constraints are rules that decide what kind of data can enter into the database tables. SQL server has six types of constraints and we will explore all these constraints here with suitable examples.
Namespaces – What They Do and How They Work
(Darla Ferrara) Namespaces are critical components in XML design; however, they tend to be a bit conceptual. Think of a namespace as a last name for elements.