< ? php //If there is analytic campaign data, attempt to get the campaign_guid from that cookie if ( 1 === preg_match( '/pk10mkto-([0-9]+)/', $_COOKIE[ '__utmz' ], $match ) ) { $campaign_guid = $match[ 1 ]; } ?>

Making SQL Server Even Better

photo-making-sql-server-even-better
February 25, 2015
Shares

If you look under enough rocks, you may find someone who has an issue with Windows SQL Server 2014. They’d be in a minority of very few, though. They probably don’t like ice cream, either.

As secure and productive as previous versions of this relational database management system (RDBMS) standard have been, SQL Server 2014 is that and much more. A tech review in InfoWorld (1) magazine rated it 9.5 on a 10-point scale. The National Institute of Standards and Technology named past and present SQL versions as the most secure RDBMS available. By all accounts, SQL Server 2014 is a standout product, not only for what’s new but for its backward compatibility with previous versions, as well.

This release builds upon SQL Server 2008 and 2012, retaining much of the same look and feel, which flattens the learning curve. It uses the same familiar management tools, T-SQL language and APIs, enabling backward compatibility to existing and legacy applications. Further, organizations can quickly and efficiently upgrade existing databases in place to take advantage of the many improvements found SQL Server 2014, including greatly improved speed, performance, scalability, availability, backup and disaster recovery (DR).

Here a just a couple of examples of what SQL Server 2014 provides:

  • AlwaysOn Availability (2) integrates disparate high availability (HA) and automated DR/backup features from previous versions into a unified solution. In this release, AlwaysOn presents an integrated and unified HA and DR solution that part of the database’s core functionality.
  • Hekaton in-memory data base (3) turbo-charges SQL Server 2014 performance, increasing processing speed to support large, more data-intensive applications and workloads, while also complementing existing in-memory data warehousing and business intelligence capabilities.
  • In-memory OLTP and data warehousing tools make it unnecessary to place the entire database in memory, instead letting you choose the DB tables you deem necessary to achieve a performance boost.

Find out what it takes to have an effective disaster recovery plan.
DR/Backup Security and Reliability

Corporations of all sizes in all industries require their databases to deliver high performance, extremely fast, efficient DR/backup, as well as extremely strong security and high availability. Beyond generally desirable, this is vital as businesses drive to become more “digital” and compete to attract, win and retain customers in an always-on world. The 20-40 percent performance improvements claimed by early adopters of SQL Server 2014 fit the bill perfectly, made even more germane given these industry trends:

  • Nearly eight out of ten corporations now require a minimum of 99.99 percent uptime (52 minutes of annual unplanned downtime per server or database) for mission-critical hardware, operating systems and key LOB databases and applications
  • Hourly downtime costs exceed $100K for 98 percent of firms; 22 percent estimate the cost to their companies on the order of $300-400K.
  • Top challenges impacting DB reliability are security (79 percent) and DR/backup (77 percent)
  • On quarter of businesses fail to provide hardware failover and redundancy, making efficient DR and backup more crucial than ever.

The combination of Microsoft SQL Server 2014 advancements and the security, reliability and disaster recovery services that Peak 10 offers are a great recipe for peace of mind.

(1) InfoWorld, Review: SQL Server 2014 pushes the pedal to the metal, March 20, 2014

(2) SQL Server Pro, Changes to SQL Server 2014 AlwaysOn Availability Groups, September 20, 2013

(3) MSDN, SQL Server 2014: Inside Hekaton Natively Compiled Stored Procedures, January 15, 2014

Fine tune your content search

About Peak 10

"Our values are the foundation for everything we do at Peak 10, and are ultimately what enable us to earn our customers' business and their trust."
David H. Jones,
Board Member, Peak 10 + ViaWest