Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
The Voice of the DBA
 

Cloud Concerns

 

This editorial was originally published on Dec 13, 2012. It is being republished as Steve is at the PASS Summit. Is the world of cloud stability and performance better today?

When I get feedback about cloud computing from DBAs, the main concern seems to be data security or the perception of problems with security from a cloud provider. That's natural as sending your data to the cloud doesn't necessarily remove the responsibility for security from the purview of the DBA, yet you don't have complete control over the way the data is managed. Various providers are working on their security and passing certifications, though this doesn't necessarily make many DBAs feel comfortable with databases in the cloud.

However, security may not be your number one concern. Outages and business continuity should be your primary concern. As noted in this article, cloud service outages have been more common than lost data. It's much more likely that the service will go down, and if it does, what do you do? Contacting a cloud services company and receiving fast answers aren't likely when a cloud outage usually affects a large number of customers.

However, business continuity is important. If your database or application server goes down, what would you do? In most cases, you would sit in your office waiting for the cloud provider to come back online. That's not much different from in-house failures where you may wait on the network or OS administrators to recover a host server. In a few of the disasters I've experienced, I only had slightly more control than I'd guess a cloud provider gives me.

In either case, having good backups and a strategy to bring your system online in the event of an extended outage is important. I suspect that will mean hybrid public/private cloud applications that can function from an alternative location will need to be an architectural requirement for many businesses.

Steve Jones - SSC Editor

Join the debate, and respond to today's editorial on the forums

 
 Featured Contents
SQLServerCentral Article

Enforcing Unique Customer Emails When Duplicates Already Exist

Imran2629 from SQLServerCentral

How do you keep some duplicate records by not others? An interesting business rule enforced by cleanup and a filtered index.

External Article

How to secure temporary objects, metadata visibility, and audit assurance in SQL Server

Additional Articles from SimpleTalk

This article, part of Fabiano Amorim’s complete guide to SQL Server security, explains and demonstrates where these three features commonly go wrong. Learn the the exact signs and queries to check for exposure – and the practical fixes that turn a theoretical risk into a closed gap.

Blog Post

From the SQL Server Central Blogs - Cleaning Up Azure MS Defender Billing

Steve Jones - SSC Editor from The Voice of the DBA

I have a few Azure subscriptions, which are fairly small and not used that often. Mainly I do some SQL Server or Azure SQL experimentation. Sometimes I might create...

Blog Post

From the SQL Server Central Blogs - Installing and Configuring containerd as a Kubernetes Container Runtime

aen from Anthony Nocentino Blog

This post shows you how to install containerd as the container runtime for Kubernetes and configure it to use the systemd cgroup driver. The commands below were tested on...

The Phoenix Project

The Phoenix Project: A Graphic Novel about IT, DevOps, and Helping Your Business Win

Site Owners from SQLServerCentral

Adapted from the acclaimed bestselling book, The Phoenix Project Graphic Novel Volume 1 introduces readers to a stalwart cast of characters as they are challenged by the four types of work that impact complex workflows.

 

 Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

Switching Schemas I

I run this query:
SELECT 
 s.name AS schemaname
 , o.name AS objectname
 FROM sys.objects o
 INNER JOIN sys.schemas s ON s.schema_id = o.schema_id
 WHERE o.name = 'Beer'
I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beer
What happens?

Think you know the answer? Click here, and find out if you are right.

 

 

 Yesterday's Question of the Day (by Steve Jones - SSC Editor)

Too Many Choices

I have a table, dbo.MasterBrands, with this data:

BrandID OfficialName
1       Samsung
2       Apple
3       Microsoft
4       Adidas
5       Coca-Cola

I run this query. What is returned for Coca-Cola?

SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel')
FROM dbo.MasterBrands;

Answer: NULL

Explanation: For an out of range index, the value returned is null. Ref: CHOOSE() - https://learn.microsoft.com/en-us/sql/t-sql/functions/logical-functions-choose-transact-sql?view=sql-server-ver17

Discuss this question and answer on the forums

 

 

 

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.


SQL Server 2019 - Development
MERGE in a nested TRY/CATCH won't roll back - I have a section of code similar to the following abstract: DECLARE @loop [int] = 0, @savepoint [varchar](4) BEGIN TRY BEGIN TRANSACTION _OUTER_ WHILE (@loop < 10) BEGIN SELECT @loop = @loop + 1, @savepoint = '_' + CAST(@loop AS [varchar](2)) BEGIN TRY BEGIN TRANSACTION SAVE TRANSACTION @savepoint MERGE ... -- This transaction works MERGE […]
SQL Azure - Administration
Managed Instance vs Azure Database - is this a good option? - We're currently in Azure, however as we had a very tight migration timeline when we moved, we've been using SQL Server on Azure VMs for the last several years.  There's a push in the organization to go "cloud native," and on the database side, well, I see some potential headaches. My question can be boiled […]
General
Access + ODBC Driver 18 + SQL Server 2025: ~150–250 ms per request - Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025 through ODBC Driver 18? In several existing Access applications, a simple DAO test behaves as follows: No forms open: approximately 0–4 ms per request after the initial execution. Certain bound forms open: approximately 150–250 ms per request. Closing the affected objects […]
Editorials
Planning for Change - Comments posted to this topic are about the item Planning for Change
Great Things - Comments posted to this topic are about the item Great Things
PostgreSQL 19 Is Late - Comments posted to this topic are about the item PostgreSQL 19 Is Late
A Heavy Heart - Comments posted to this topic are about the item A Heavy Heart
Article Discussions by Author
The ##MS_DatabaseConnector## User - Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Importing Excel files into SQL Server, Azure Edition - Comments posted to this topic are about the item Importing Excel files into SQL Server, Azure Edition
SQL Server Vector Support II - Comments posted to this topic are about the item SQL Server Vector Support II
Troubleshooting Slow Queries That Already Have an Index - Comments posted to this topic are about the item Troubleshooting Slow Queries That Already Have an Index
Hyperscale Replicas V - Comments posted to this topic are about the item Hyperscale Replicas V
Calculating Weighted Average in Power BI - Comments posted to this topic are about the item Calculating Weighted Average in Power BI
SQL Server 2025 Server-level Roles - Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
SQL Server 2022 - Administration
Perfermance result aftet purge operatio - Hello everyone, I am planning to implement a data purging solution that is expected to reduce the size of one of our main databases by nearly 50%. One of my colleagues believes that the performance benefits will be limited. His argument is that most queries access data through Index Seeks, so reducing the amount of […]
 

 

RSS FeedTwitter

This email has been sent to {email}. To be removed from this list, please click here. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -