Information Management News


The Bandwidth Paradox - How Pokémon GO Pushes Connectivity Boundaries and Data Center Demands

One hundred-fifty million people use Snapchat every day. Moreover, the playing field for mobile apps is much broader than MapQuest or Pokémon GO, the free-to-play, location-based augmented reality game for iOS and Android devices, which became so wildly popular this summer that there were reports of it causing some players to walk blindly off a cliff and others into traffic. To adequately manage this unprecedented level of capacity, data centers need to up their compute, storage, and memory capabilities. Read More

Storage Strategies for Meeting SQL Server SLAs in VMware Environments

Almost all database workloads are now (or eventually will be) virtualized. High availability (HA) clusters using virtual servers provide the application protection needed to satisfy even the most demanding service-level agreements (SLAs). Configuring the shared storage needed for HA in VMware can present challenges to creating these clusters and therefore satisfying SLAs. Read More

Big Data Means Big Transformation

Organizational issues such as governance and skills—not technology requirements—are the greatest challenges that IT and corporate managers are facing in the emerging world of big data. To get a better handle on the complex new world big data is catalyzing, executives and professionals recognize they must reimagine and re-architect the concept of the "data center"—and what ultimately is coming out of may be a surprise to everyone. These are some key takeaways from a recent survey of 319 corporate and IT managers, conducted by Unisphere Research, a division of Information Today, Inc., in partnership with Cloudera and Intel. Read More

Moving From Maintenance to Innovation

There is a tug-of-war of sorts going on in organizations today. On one hand, there is pressure on IT staff to maintain systems' uptime and availability along with a growing focus on data security, while dealing with the multitude of maintenance-level tasks, such as applying upgrades, fixes, and patches. But on the other hand, there is a growing requirement for IT to support the business as it seeks to use data in new ways for strategic benefit. Read More



Todd Schraml

Database Elaborations

Todd Schraml

  • The ‘GROUP BY’ Jitterbug: All-Too-Common SQL Development Dance Step One symptom of an organization in the middle of a knowledge vacuum is evidenced by SQL that often includes what appears to be extravagant usage of the GROUP BY clause. Writing GROUP BYs here, there, and everywhere becomes a little SQL development dance step, a jitterbug to bypass the issue—moving but not really getting anywhere. Why do these kinds of circumstances exist? Well, maybe the only expert on the involved system has retired and no one else has picked up the torch, so no one is willing to touch the code.
Recent articles by Todd Schraml
Craig S. Mullins

DBA Corner

Craig S. Mullins

  • Designing for Batch Database Processing Typically, most applications consist of both batch and online workloads. This is true even today, when most of our attention has turned to online and web-based interaction. Sure, online activities are the most obvious, in-your-face component of countless applications, but batch processing still drives many actions behind the scenes. This can include applying updates, processing reports, integrating input from multiple sources and locations, data extraction, database utility processing, and more.
Recent articles by Craig S. Mullins
Kevin Kline

SQL Server Drill Down

Kevin Kline

  • SQL Server Adds Even More New Features in Data Science One of the great promises of AI is contextual processing that come naturally to humans, such as understanding visual input and natural language. You can now get in on the new previews from Microsoft to accomplish these goals. Microsoft Cognitive Services is a collection of APIs that enable developers to tap into high-quality vision, speech, language, knowledge, and search technologies—developed through decades of Microsoft research—to build intelligent apps.
Recent articles by Kevin Kline
Guy Harrison

Big Data Notes

Guy Harrison

  • DataStax Extends Cassandra Capabilities For many years now, Cassandra has been renowned for its ability to handle massive scaling and global availability. Based on Amazon's Dynamo, Cassandra implements a masterless architecture which allows database transactions to continue even when the database is subjected to massive network or data center disruption. Even in the circumstance in which two geographically separate data centers are completely isolated through a network outage, a Cassandra database may continue to operate in both geographies, reconciling conflicting transactions—albeit possibly imperfectly—when the outage is resolved.
Recent articles by Guy Harrison
  • Technology Trends in the DBMS Market—Hype vs. Reality As technology professionals, one of the most important aspects of our jobs is to advise our organizations on the use of new technologies. However, the challenge is identifying the right technologies. This revolves around three very specific risks.
Recent articles by Gerardo Dada

Trends and Applications