Articles about SQL Server

The total number of common vulnerabilities and exposures (CVEs) is expected to increase by 25 percent in 2024 to 34,888 vulnerabilities, or roughly 2,900 per month.

This comes from a new report by 'active insurance' provider Coalition which uses honeypots to monitor for spikes to identify the biggest CVEs before they make news headlines -- thus providing companies with the opportunity to take action before an incident can occur.

Continue reading →

Datacenters disappear. Not often, but it happens. Hurricane Sandy in 2012 swallowed whole datacenters in Lower Manhattan. Hurricanes Irma and Maria wiped out virtually all the datacenters in Puerto Rico in 2017. Cloud datacenters are not immune, either. The Azure Central Region outage of 2018 occurred after a lightning strike queued up a sequence of automated responses that failed in a spectacularly Rube Goldberg-like manner and proceeded to take multiple Azure availability zones offline for the better part of a day.

Sometimes it’s possible to anticipate the arrival of a disaster; other times, the disaster arrives without warning. Either way, the production infrastructure your organization depends on is going to be offline for some time. That does not, however, mean that your operations must go offline. It means that you need to have a disaster recovery (DR) plan in place that can provide an alternative means of keeping your operations running when your primary infrastructure is out of commission.

Continue reading →

Architecturally speaking, what’s the difference between configuring SQL Server for high availability (HA) and configuring it for disaster recovery (DR)? The terms HA and DR are so often paired that one might imagine them to be the same -- when in fact they are distinct approaches to mitigating different risks.

Let’s start by distinguishing the risks. Let’s say your mission critical SQL Server infrastructure resides in a datacenter in Orlando, Florida. It doesn’t matter whether it’s your own data center, a co-location facility, or a cloud data center. A category 5 hurricane causes a catastrophic failure of the data center and your critical SQL Server infrastructure goes offline.

Continue reading →

If you use SQL Server, you know there is a significant price difference between the Standard and Enterprise editions. If you have had the Enterprise version for a while, you probably bought it for features not available at the time in the Standard version. But over the past few years, things have changed.

Today’s SQL Server Standard edition can make more sense to your organization with its lower license fee without sacrificing performance, features and availability. Its added functionality and resources, such as the increased number of supported cores, increased maximum memory per instance, database snapshots, table/index partitioning, compression, in-memory OLTP, and Transparent Data Encryption (TDE), make it an attractive alternative to the Enterprise edition.

Continue reading →

If you’re thinking about moving your SQL Server instances to the cloud, there are a lot of good reasons to choose AWS EC2. AWS offers a wide range of purpose-built systems, so you can easily find one that will support your organization’s particular needs. It has a global reach, with 69 availability zones in 22 geographically distinct regions around the world.

Building out a SQL Server infrastructure designed for high availability (HA) or disaster recovery (DR), though, can be costly. Are there ways to take advantage of AWS EC2 to reduce those costs? The short answer is yes. The longer answer is how much money you can save using AWS EC2 depends on the choices you make when configuring for HA and DR.

Continue reading →

System and database administrators are now being forced to do something about legacy SQL Server 2008 and 2008 R2 database applications. The reason is the end of Extended Support in July 2019. Extended Support will also end for its common companion Windows Server 2008 and 2008 R2 in January 2020. Upgrading to the latest versions is always an option, of course, but Microsoft is providing an attractive alternative when upgrades are not viable or cannot be cost-justified: Migrate the database to the Azure cloud and get three more years of Extended Security Update support at no additional charge over the standard virtual machine pricing.

This article highlights important considerations for migrating mission-critical legacy SQL Server 2008/R2 databases to the Azure cloud to help administrators make more informed decisions. Among the key considerations is knowing which options are and are not available.

Continue reading →

One of the challenges IT and database administrators confront when implementing disaster recovery provisions is choosing from among the myriad options available. Existing high availability configurations designed to minimize downtime for critical applications may not be adequate for recovering fully from a widespread disaster. And existing disaster recovery provisions may not be as comprehensive or cost-effective as they could be. This article provides practical guidance to help administrators optimize disaster recovery plans for SQL Server, beginning with the disaster recovery plan.

A good disaster recovery plan builds on the organization’s Business Continuity Plan. BCPs generally cover the entire organization, and in most organizations, IT is one of the most if not the most critical department. There are two aspects of the BCP that are fundamental to DR planning: the business impact analysis and the threat assessment. The former determines which applications are mission-critical and the latter identifies those disasters the organization is most likely to experience.

Continue reading →

Many organizations rely on databases to support their decision making processes, but the process of importing, analyzing and then acting on the data can inhibit fast action.

In-memory SQL database specialist, VoltDB is releasing version 7.0 of its to offer increased scalability for managing transactions and generating analytics while ensuring high availability and strict data consistency.

Continue reading →

Microsoft is a big proponent of open source, something highlighted by its becoming a Linux Foundation Platinum Member earlier today. The company has been contributing to multiple projects, and back in March, it even announced it was bringing SQL Server to Linux-based operating systems.

Today, the Windows-maker follows through on its promise and delivers SQL Server Preview packaged for two of the most popular business-used Linux-based operating systems -- Ubuntu and Red Hat Enterprise Linux (RHEL). While it is not ready for prime-time, both administrators and developers that prefer those aforementioned operating systems can start testing now.

Continue reading →