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

The Rise of Data Centers

For the last few years, we've seen no shortage of cloud migration stories and felt pressure from management who wanted to migrate our systems to the cloud. It seems that almost everyone I speak to has a story of having to move a system out of their owned or leased data center into a public cloud from some vendor. A lot of this is the movement of VMs from one place to another, which has me scratching my head. If we're just running VMs, surely we can do this cheaper in our own data center.

Perhaps, though there are a lot of costs to setting up or running a data center, and it's not easy getting a system in place that allows a bit of self-service for our customers. Especially while ensuring that images used are properly patched and secured, while ensuring lots of easy connectivity to storage that can be reconfigured easily. It might not be worth the effort for a few dozen VMs, but if you have hundreds of systems, maybe it is.

Maybe it's happening. I keep seeing stories about repatriation from the cloud. I also caught the global data center trend report, which shows a lot of growth in the data center world. Vacancy rates are low and there is continued demand for building more data centers. Some of this is due to public cloud providers, some is from AI companies who need lots of power and GPUs, and some is from private companies looking to collocate their systems.

The world is becoming more and more dependent lots of servers in data centers. I expect that we will continue to see more data centers built, but I expect fewer and fewer private, corporate data centers. More than likely all of us will use someone else's data center, even if we choose to own the computing systems. Even Basecamp, which left the cloud, is using a collocation facility for machines, which means they are using a facility owned by another organization and shared with other clients. However, they own the servers they use, which are just located in someone else's data center.

If any of you have private data centers, my guess is most of those will slowly fade away over time. The cost of running them privately will exceed that of what vendors will charge. Data center vendors can spread the cost of buildings, power, networking, cooling, etc. across multiple clients, often hundreds or thousands. While you might not be in the cloud, and you may still own your own computers, you'll likely store and connect them in someone else's data center.

That means that most of us will need to be comfortable with limits on the hardware deployed and amount of upgrades available. In the cloud you're limited to what vendors provide. In our own collation spaces, it might be what our core IT group makes available. I still expect database servers to be among the largest machines available, but there will still be limits to what most of us can provision. After all, most IT groups still want some standard configurations shared by most of their servers. That might be an interesting trade-off for some of us as the cloud might be more or less preferable in certain situations.

Steve Jones - SSC Editor

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

 
 
 Featured Contents
SQLServerCentral Article

Why you should avoid Implicit Measures in your Power BI model

Koen Verbeeck from SQLServerCentral

Learn about the differences and challenges with implicit and explicit measures in Power BI.

External Article

Data Documents and Common Sense

Additional Articles from SimpleTalk

What can be so difficult in creating a sensible standard for Structured Data Documents? To understand why they tend to get improved into unusable complexity, I’ll need to explain a bit of background.

Blog Post

From the SQL Server Central Blogs - Monday Monitor Tips: CIS Compliant

Steve Jones - SSC Editor from The Voice of the DBA

A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many enterprises think about as their auditors use this as a benchmark. If you’ve never looked...

Blog Post

From the SQL Server Central Blogs - Side Projects

dbafromthecold@gmail.com from The DBA Who Came In From The Cold

Anyone (everyone?) who has ever tried to learn a programming language knows that to really learn, you need a project. I’m a DBA by trade and as such…haven’t really...

Pro T-SQL 2022: Toward Speed, Scalability, and Standardization for SQL Server Developers

Site Owners from SQLServerCentral

Learn how to write and design simple and efficient T-SQL code. This is a hands-on book that teaches you how to write better T-SQL with examples and straightforward explanations.

 

 Question of the Day

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

 

Data API Builder APIs

What formats of API endpoints can the Data API Builder present to clients when exposing the database?

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)

Quiesce

What does it mean to quiesce a system?

Answer: This refers to pausing or altering the systems to achieve a consistent state.

Explanation: This refers to This refers to pausing or altering the systems to achieve a consistent state. Often in a database system where we need exclusive access we may choose to let current connections complete, but preventing new ones to quiet the system in preparation for maintenance. However, the VSS actions on a SQL Server database server will quiesce the system. Ref:

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 2017 - Administration
Events of System_health extended event serious or not - I have listed the event names present in my system_health extended event report. Based on these groupings, can I decide whether a group needs to be checked or not? Which ones are serious and must be checked, and which ones can be ignored? Specifically, I want to know how to determine if the following event […]
SQL Server 2017 - Development
Database Archive missing FK - Bonjour à tous, je vais bientôt démarrer un projet d'archivage de données pour alléger la base de production. Dans la configuration spécifique de la base d'archivage, il a été décidé qu'elle ne contiendrait pas de clés étrangères (FK), ce qui fragilise davantage la base. En effet, un TRUNCATE TABLE pourrait être effectué sur toutes les […]
Testing whether TRY_CONVERT is losing precision - Hello All, I am using TRY_CONVERT to parse character data into a decimal column. I want to generate alerts when the value is not null and TRY_CONVERT returns a null. That works. SELECT '5254.15',TRY_CONVERT(DECIMAL(5,2),'5254.15') But I am running into situations where TRY_CONVERT truncates precision. In the cases I want to be alerted. SELECT '6.125',TRY_CONVERT(DECIMAL(5,2),'6.125') Any […]
Timeout Error while executing a TSQL statement in Sql server Express Edition - I am getting the below error when I execute a SQL command in SQL Server 2017 Express Edition Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding The same query works fine in SQL Server Standard Edition. What might be the reason for this issue? […]
Timeout Error while executing a TSQL statement in Sql server Express Edition - I am getting the below error when I execute a SQL command in SQL Server 2017 Express Edition Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding The same query works fine in SQL Server Standard Edition. What might be the reason for this issue? […]
SQL 2012 - General
sqlbackups through veeam not updating msdb tables - We have veeam backups happening everyday on a server where all sql databases are also getting backed up but the same is not reflecting in the msdb.dbo.backupset table. Why is it so ?  Where do I start troubleshooting ?
SQL Server 2019 - Administration
Vendor claims unused table space impacts performance - Hello experts, I got a report from an application owner of degraded performance for an application. To paraphrase: The unused table space is quite large when compared to the actual data space used. Per the vendor, this would impact performance. Has anyone ever heard of unused table space causing performance issues? I haven't. In addition, […]
SQL Server 2019 - Development
dont want pkg to abort if someone is in excel source document - Hi, is there a way when using excel as a flat file source in ssis to forgive the fact that someone has it open?   in my mind analogous to a dirty read in sql?   maybe read what it had at last save?  i'd hate to have an error handler alerting the file owner for hours […]
need help with assigning a value to a variable - Hi I am trying to assign the value of the  variable using the output of a query but I am getting an error.  How do I fix it? Query: DECLARE @LATEST_DATE DATE; SET @LATEST_DATE = SELECT MAX(MY_DATE) FROM DBO.TABLE Error: Msg 156, Level 15, State 1, Line 8 Incorrect syntax near the keyword 'SELECT'. Thank […]
String Variable and sp_executesql - I am not understanding why this command completes "successfully" and it seems correct to me. However, the focus of the session does not switch to the database specified in the USE clause. Is there something I am missing? I am trying to make my script able to run on any database it finds, and change […]
adding dtc to my pkg - Hi below i show the control flow of my pkg.   I'd like to enlist any component that updates into dtc.  I havent used dtc in a long time. i tried reading what's posted at the links you see below but id really like to get to the finish line faster. my understanding is that all […]
Powershell
printing complete path - get-ChildItem C:\ -recurse -erroraction silentlycontinue | sort length -descending | select -first 10 FullName,length Result: C:\Program Files\Microsoft SQL Server\120\Setup Bootstra...                                  88821760 FullName is not getting printed.How can I fix this ? Thanks  
Working with Oracle
SQL Server 2005 service fails to start - Hello, I’ve been trying to install Ms SQL Server 2005 for over two weeks now, and I’ve finally gotten to the point where the prerequisites all seem to be in place. Unfortunately, every time I try to install SQL Server itself, I get the following message: “The SQL Server service failed to start. For more […]
SQL Server 2022 - Development
Automating Export of PowerQuery to SQL Server using DAX Studio...? - I wrote a PowerQuery that parses a table from a PDF, and I want to export it to SQL Server. I tried using the PowerQuery source in SSIS, and it wouldn't let me map the columns. (Maybe I did it wrong???) I got DAX Studio to export the result of the PowerQuery to SQL Server, […]
Sql script replace and rearrange numbers - Hi everyone. I have this table and this information. (left side of the image) I need to replace Black with White and rearrange the numbers of the priorities. After the replacement, the numbers should be rearranged. (right side of the image) CREATE TABLE [dbo].[Priorities]( [Airplane] [nvarchar](50) NULL, [Priority] [int] NULL, [Color] [nvarchar](50) NULL ) ON […]
 

 

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

 

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