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

Building a Data Center

Most of you reading this have likely seen a data center, and maybe sat in one while connecting to a database, but how many of you have had to try and do some of the work to set one up? It's not something most data professionals do, but since we often have some of the most expensive boxes in one, I thought it would be interesting to discuss what goes into getting one running.

There's a blog post that starts to cover what it takes to set up a data center. I found it interesting to read as I've been a part of the group choosing a space a few times, and a lot of the issues discussed in the blog were things I dealt with or experienced. Both with large and small companies, I've helped to spec out and decide what we need from a colocation facility or our own room in an office. In smaller companies, I've had some of the "what-the-duck" moments outlined in the post when I tried to rack and connect systems, only to find some issue with power, connections, etc.

When I read that post, I think about the months of getting everything set up, it's hard to see this as more cost-effective than the cloud in some ways. Certainly setting up racks and servers is easy. Getting them powered, having a cold and hot aisle, and deciding what gets connected to where these are relatively simple things. However, making decisions on networking, routing, and other complex tasks can take specialized expertise. For a single company, finding, hiring, and retaining someone who knows this stuff well is hard. Startups might get someone excited, but the really good people who can design this stuff are often working at a cloud company of some sort.

Maybe those people are tired of the FAANG/Microsoft world and want to come to your startup, but for how long? And how do you replace them? Lots of companies found maintaining a data center to be more expensive than it was worth.

I suppose a similar situation in the database world is setting up a complex system, perhaps something like a new Firebolt warehouse. If the person that did that leaves, can the rest of the company fill their shoes? Do you know how Firebolt works? Would it be better to use a more popular system, like Snowflake or Databricks, with lots of other people writing articles and blogs about how things work? I think it would be, if for no other reason than there are other models to follow and more people that can give you guidance.

A data center, whether a private one or a cell in a large cloud provider's footprint, is a complex beast. The days of using a closet with servers on a bookshelf are likely gone for most commercial enterprises. Even SQL Server Central moved on to hosted systems. We used to rent a rack in the early 2000s in a co-location facility, one I enjoyed visiting, as long as the visits were few and far between. Now I like connecting to EC2, which is much simpler and easier.

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.

Technical Article

Navigating the Database Landscape in 2025 Livestream on Feb 12

Press Release from SQLServerCentral

Join us on February 12th for the livestream: Navigating the Database Landscape in 2025: Simplifying Complexity. Discover the latest trends and insights from our 2025 report, learn new approaches for professional development, and gain valuable knowledge to stay ahead in your career.

Blog Post

From the SQL Server Central Blogs - Take over Ownership in Microsoft Fabric

Koen Verbeeck from Koen Verbeeck

When you create an item in Microsoft Fabric (a notebook, a lakehouse, a warehouse, a pipeline …), you are also the owner of the item. There has been an...

Blog Post

From the SQL Server Central Blogs - Get a PAT in Azure DevOps

Steve Jones - SSC Editor from The Voice of the DBA

I have a presentation recently on Continuous Integration Using Local Agents in Azure DevOps and one of the things I do in there is get a PAT for Azure...

The Definitive Guide to Azure Data Engineering: Modern ELT, DevOps, and Analytics on the Azure Cloud Platform

The Definitive Guide to Azure Data Engineering: Modern ELT, DevOps, and Analytics on the Azure Cloud Platform

Site Owners from SQLServerCentral

Build efficient and scalable batch and real-time data ingestion pipelines, DevOps continuous integration and deployment pipelines, and advanced analytics solutions on the Azure Data Platform. This book teaches you to design and implement robust data engineering solutions using Data Factory, Databricks, Synapse Analytics, Snowflake, Azure SQL database, Stream Analytics, Cosmos database, and Data Lake Storage Gen2.

 

  Question of the Day

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

 

CHOOSing an Alias

I have this code:
SELECT CHOOSE (MONTH (saledate), 'Winter', 'Winter', 'Spring', 'Spring', 'Spring', 'Summer', 'Summer', 'Summer', 'Autumn', 'Autumn', 'Autumn', 'Autumn') AS x FROM ProductSales;
What is a good name for the column alias?

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)

Taking File Backups

What options do I have in SQL Server 2022 for file and filegroup backups?

Answer: multiple files or filegroups can be specified.

Explanation: File and filegroup backups allow multiple files and filegroups to be specified in one backup command. Ref: Back Up Files and Filegroups - https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/back-up-files-and-filegroups-sql-server?view=sql-server-ver16

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 2016 - Administration
Over period of time application stop connecting to AG database - Hello. SQL version - 2016 , windows 2019 both are enterprise edition Over period of time application stop connecting to Alwayson availability group database. what could be reason why application stop working automatically? please suggest. Checked SQL Error logs not found any errors regarding connections. also windows event viewer not found cluster related errors. application […]
SQL Server 2016 - Development and T-SQL
Data Joining technique help - Hey All, I'm wondering if there is a different/better way to join the data from these two tables. Please see my sample data and example query below. Cart_id is unique #mytable_main and not in #mytable_Krb2. I need the Field_name and field_values from #mytable_krb2 joined to #mytable_main. Hopefully, what I'm trying to do makes sense to […]
Administration - SQL Server 2014
Getting below error - An error occurred during recovery, preventing the database 'XXXXX' (28:0) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support. (.Net SqlClient Data Provider) (Microsoft SQL Server, Error: 3414) Version : Microsoft SQL Server 2012 (SP4-GDR) (KB4583465) - 11.0.7507.2 […]
Development - SQL Server 2014
Why is "SELECT *" about 10 times faster than "SELECT (ALL Columns)" - Dear all, I have noticed that  a "SELECT * ..."  is about 10 time faster than "SELECT Column1, Column2, ... LastColumn  FROM Table WHERE ID = (number)" 70 ms <-> 650 ms The Queryplans are equal and so are the costs - in both cases it is a grouped index scan with a Cost of […]
SQL Server 2019 - Administration
Columnstore index record with huge delta_store_hobt_id - I am a starter on the concept of indexing. I have been looking into a table which has clustered column store index and has very poor performance. I was able to get the following script online to find how the row-groups are partitioned, number of rows per group and fragmentation level etc., SELECT i.object_id, object_name(i.object_id) […]
SQL Server 2019 - Development
SSIS Connection Manager Errors - issue resolved
Rollback Logic Isn't Working - Hi Everyone I am not sure how to do this correctly.  The below code "looks" right but it didn't rollback the code.  I put 'select 1/0' to guarantee a failure to test the rollback logic.  In production, I won't be using this.  Instead, it will be a bunch of exec SP statements.  How do I […]
One SP is not running in SSIS and I don't know why - Hi everyone I have an SSIS package that has close to 3o SP that are run.  One container has 22 SP.  Of these 22, 1 is giving me problems.  Here are the tests I have run so far: Test 1 - Run all 22 SP -> the problem SP never finishes hence SSIS package never […]
Change all occurances of one field in DB - Hi everyone I am doing some clean up of my DB.  There is one field that I want to change in all tables and SP.   For example, tableA has fieldA.  I want to change the name from fieldA to fieldB in all tables and SP.  I don't want to open each table and SP to […]
locks in sql database 2019 - please help. Do they know if the use of try and catch for error control can produce crashes in the database when used in procedures with a high volume of data in their output?
Bloqueos en base de datos SQL 2019 - Hola saben si el uso de begin try y catch puede producir bloqueos en la base datos al ejecutar procedimientos almacenados con alto volumen de datos. Tengo este problema y me indicaron que el uso de estas instrucciones podría ser el origen de mi problema.
Reporting Services
Having issues with backing up SSRS for SQL Server 2008 - We have an old server running SQL Server 2008 SSRS. We are in the planning stages of upgrading the Windows Server OS as well as the SQL Server version and need to backup the SSRS database and encryption keys so we can upgrade (same hardware, just in-place upgrades). When I run this rskeymgmt command I […]
Integration Services
Convert Project model back to package model - What started out as an attempt to use the SSIS Project-model combined with deployment using the SSISDB catalog has been superseded by the requirement to use devops+pipeline to deploy packages from dev to production. This means using direct deployment at file level and converting everything build from project to package. Are there any best practices […]
Building SSIS Custom Task - Hi Everyone, Greetings of the day! I am working on building SSIS Custom task which logs variable values to SSIS execution log. I should be able to select more than one variable in SSIS Custom task, package should log all of the selected variable values to the execution log. I need your help in writing […]
SQL Server 2022 - Administration
windows services monitor - With no budget for some paid tools to monitor sql server service and sql agent service ; how can we send an email alert when they go down etc..what are the options ? I do not want processes where I have to run some piece of code(t-sql/powershell--I can set this up but is there a […]
 

 

RSS FeedTwitter

This email has been sent to newsletter@newslettercollector.com. 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

 

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