Information Management News

Sponsors

10 Ways to Save Money and Provide More Comprehensive Availability Protection in SQL Server Environments

Microsoft SQL Server has become a business-critical database for a growing number of enterprises that rely on it to run a wide range of essential business processes. As enterprises look to continuously improve the efficiency of their data centers, they face the challenges involved in improving their ability to provide high availability and disaster protection for SQL Server. Read More

Improvements Instead of Incidents: Optimize and Align IT Services

These days, managing a data center can be like working inside a pressure cooker. Virtualization, dynamic computing, cloud computing, big data, the Internet of Things—each major development turns up the heat, but budgets, staff, and skills often lag behind explosive growth in data center scale and complexity. Read More

Database Administrators Expand Their Horizons

Many DBAs are now tasked with managing multi-vendor environments, and handling a variety of data types. Increasingly, DBAs are turning to strategies such as database automation to be able to concentrate more on the big picture of moving their enterprises forward. Read More

Powering the Internet of Things with Real-Time Hadoop

The future will flourish with machines. We've been told this in pop culture for decades, from the helpful robots of the Jetsons, to the infamous Skynet of the Terminator movies, to the omniscient "computer" of Star Trek. Smart, connected devices will be ubiquitous and it's up to us, the humans, to decide what's next. But the Internet of Things (IoT) is about more than devices and data. Read More

Newsletters



Columnists

Todd Schraml

Database Elaborations

Todd Schraml

  • The Instrumentality of Database Design The objects and relationships identified within any database design need to match with the very subjective realities considered true within a given organization. An optimal data model must incorporate the semantics of the business and provide for a structural arrangement supporting the necessary corporate instrumentality. And that model should do so, even if in the details things within the model are contrary to what other organizations may consider to be the nature of their reality.
Recent articles by Todd Schraml
Craig S. Mullins

DBA Corner

Craig S. Mullins

  • How Effective Are Your DBAs? Every now and then, somebody will raise the age-old question "How can I measure the effectiveness and quality of my DBA staff?" This can be a difficult question to answer. And it almost always hides the actual question that is begging to be asked, which is "How many DBAs do we need?"
Recent articles by Craig S. Mullins
Kevin Kline

SQL Server Drill Down

Kevin Kline

  • Cool Features of SQL Server 2014: Improved Cardinality Estimates With all the cheerleading and the steady drumbeat of new features being released to Azure, it's easy to lose track of the many cool and valuable new features released in the on-premises version of SQL Server. One of the crown jewels of SQL Server, the cardinality estimator (CE), underwent a large redesign for SQL Server 2014 to improve performance. Cardinality estimates are an extremely important part of query processing. In a nutshell, cardinality estimates are what the relation engine predicts for the number of rows affected by a given operation, including intermediate row sets like those created by filters, aggregations, joins and spool.
Recent articles by Kevin Kline
Guy Harrison

Applications Insight

Guy Harrison

  • Bitcoin’s Blockchain Promises More Than Just Electronic Cash You would have to have been living under a rock for the past few years not to have heard of Bitcoin. Bitcoin is an electronic "crypto" currency which can be used like cash in many web transactions. At time of writing there are about 14 million bitcoins in circulation, trading at approximately $250 for a total value of about $3.5 billion.
Recent articles by Guy Harrison
  • To RDS or EC2—Where Will Your Database Be Happier? Four years ago, moving a database to the cloud required courage, optimism, and confidence (or ignorance). Cloud platforms were young, and fundamental security, performance, and management issues were far from solved. How much things have changed.
Recent articles by Gerardo Dada

Trends and Applications