DBTA E-EDITION
November 2014

Subscribe to the online version of Database Trends and Applications magazine. DBTA will send occasional notices about new and/or updated DBTA.com content.


Trends and Applications

The increasing pressure of compliance regulations and security policies makes the deployment of high-level database protection a must-have for any organization. For those looking for ways to advance database security, here are 5 SQL Server best practices to maintain database security and streamline compliance.

Business intelligence, analytics, and just-in-time reporting have exploded in recent years. The documentation manuals for older database software are filled with tips on shutting down access to data warehouses for the weekend while data loads are performed, dropping and recreating indexes along the way for a performance boost during the load. However, today's high-velocity world does not allow for that; instead, the data supply chain must constantly be flowing from source to ODS to warehouse to the rich dashboards of eager executives and business analysts at all times.

The Juno release of OpenStack, which made its debut on October 16, represents a significant milestone. The success of a cloud platform fundamentally depends on the ability to easily deploy applications on that platform, and the Juno release builds on Icehouse in making OpenStack a much more compelling option for customers wishing to operate a private cloud within their own enterprise, or for service providers who wish to provide a public cloud service.


Columns - Applications Insight

We are now seeing a seismic shift and increase in the significance of social network data for marketing and brand analysis. The next wave of social network exploitation promises to allow companies to narrowly target consumers and leads to predict market trends, and to more actively influence consumer behavior.


Columns - Database Elaborations

Big data tool vendors try to downplay the notion that data warehouses and data marts still need to exist, even in a big data world. Relational DBMSs are painted as "old-fashioned," "yesterday," and "inadequate." They beckon potential customers to take a dip in the refreshing data lake. The fact that big data, in all of its glory, is only part of a larger business intelligence solution is getting lost in the dialog.


Columns - DBA Corner

Designing an appropriate set of indexes can be one of the more troubling aspects of developing efficient relational database applications. Perhaps, the most important thing you can do to assure optimal application performance when accessing data in a relational/SQL database is to create the correct indexes for your tables based on the queries your applications use. Of course, this is easier said than done. With the caveat that appropriate index creation can be complicated, let's look at the top 10 steps to building the right indexes on your tables.


Columns - SQL Server Drill Down

The holiday season is right around the corner, a time for cheer and goodwill towards men. That got me thinking about the whole "most wonderful time of the year" tune playing in the background and how that has some special implications for the SQL Server world. Here's a bit of context: I'm writing this article for you in the midst of the biggest gathering of SQL Server professions in any given year, the PASS Summit. One of the most visible activities when attendees get together for the very first time at the registration desk or the assembly hall for the first keynote address is the huge number of hugs, backslapping, fist bumps, high fives, and a variety of other happy and genuine reunions.


MV Community

Kourier Integrator Release 4.2, the latest version of its enterprise integration and data management suite, includes improvements to the enterprise application integration (EAI) and extract-transform-load (ETL) capabilities of the product, as well as new support for SQL Server 2014, the latest version of Microsoft's RDBMS.

Pick Cloud, Inc., a provider of hosting, cloud computing, system backups and disaster recovery, professional services, and monitoring for MultiValue applications, is making replays available of its recent webcasts, "Introduction to OpenQM - A Tour of Benefits and Features" and "Ten Things You Didn't Know About AccuTerm 7" available for on-demand replay.

Rocket Software's DBMS and Application Servers division is now being led by Gary Gregory, vice president and general manager. Looking ahead, the two key words for Rocket MultiValue are "modernization" and "acceleration," said Gregory. "That is what we want to do - and continuous quality improvement is something we must have to enable those two objectives."

Sponsors