Skip to main content
Share Your Experience: Take the 2024 Developer Survey
13 votes
Accepted

Why is Prometheus not a good choice for data with high cardinality?

As far as I know, Prometheus doesn't mind high-cardinality data. What Prometheus doesn't like is high-cardinality labels. Let's start with Prometheus official documentation, it gives a good high-...
Alexandre's user avatar
  • 1,965
8 votes
Accepted

Separate SQL Server or just separate SQL Database for test and production?

Go with a separate logical server: It is going to cost the same because you are charged on the tier of the database not the database server. By providing separate servers you provide isolation ...
Richard Slater's user avatar
7 votes
Accepted

MSSQL and AD in a Docker Container

You absolutely can do this. However, you will need to make sure that the following is happening: Setup the Docker host on the MSSQL computer in such a way that it can reach the AD server. Using a ...
Wesley Rolnick's user avatar
6 votes

Postgresql in DevOps skills

In my opinion an Operations candidate (DevOps is a culture, not a role) should be capable to perform at least the following actions: deploy postgres backup postgres restore postgres run some psql ...
030's user avatar
  • 13.2k
6 votes

Separate SQL Server or just separate SQL Database for test and production?

Putting them both on the same server is certainly the easiest. However, I'd argue in a business situation you shouldn't be able to do it. A production database is one of the most important resources ...
Xiong Chiamiov's user avatar
5 votes

Git - Everyone Pushing to Same Branch in Different Files

This is not a "strategy". This is a sure way toward chaos. The idea behind "trunk branch", which means having one branch for integration, does not mean that everyone should be pushing their changes ...
Evgeny Zislis's user avatar
4 votes
Accepted

What are HiveQL limitations compared to SQL?

The Wikipedia page for HiveQL provides a brief summary of the differences: While based on SQL, HiveQL does not strictly follow the full SQL-92 standard. HiveQL offers extensions not in SQL, including ...
Aurora0001's user avatar
  • 1,522
2 votes

How to deploy SQL Script in DevOps culture and Rollback situation too?

There are a few different things you can do: In your CI process, run your new SQL update scripts against a Dockerized SQL Server. This will allow your CI server to reject the changes if there are ...
Wesley Rolnick's user avatar
2 votes

SqlPackage.exe: Error SQL0: Required contributor with id 'id' could not be loaded

I have figured the answer on my own and wanted to help someone like me. So, the problem is I was referencing sqlpackage.exe from C:\Program Files (x86)\Microsoft SQL Server\150\DAC\bin directory, ...
Shubh Rocks Goel's user avatar
2 votes

Postgresql in DevOps skills

To add to 030's answer, and as a devops engineer who has had to do this a few times, learning how to set up replication and failover in an automated fashion is very important. If you're learning, ...
Peter Turner's user avatar
  • 1,440
1 vote

What would be a better option, to migrate our server to an Azure VM or to migrate our database to an Azure SQL instance?

I will concur with tintin. migrating from your on-prem sql server to an Azure SQL Server instance would be the way to go. Microsoft has outlined a tutorial to go through this exact thing here, though ...
xtreampb's user avatar
  • 433
1 vote
Accepted

What would be a better option, to migrate our server to an Azure VM or to migrate our database to an Azure SQL instance?

From my inexperienced perspective, Azure SQL would be the go. That is at least what Microsoft emphasised during the Certification I passed with them. Database as a managed service would free your time ...
tintin's user avatar
  • 101
1 vote
Accepted

SQL Server database default template

ARM is the natural tool for templating an azure resource. I'd suggest structuring your solution so that: your DB is deployed using an arm or bicep template, using the Microsoft.Sql/servers/databases ...
Vince Bowdren's user avatar
1 vote

Azure DevOps Different Post Deployment script per environment

You can define multiple stages in a release pipeline. Each stage (i.e. Dev, Prod) can have its own set of tasks and/or other factors that differ. If you want the same set of tasks, you can duplicate a ...
Peter's user avatar
  • 221
1 vote

How many iops do I actually get in a General Purpose SQL Database in Azure?

Follow this article But in serverless mode you will have to look at limits for the vCores your DB is using at that second, so if vCores are 4 then you will have limit of 1280 and Throughput of '5-7 ms ...
Hassan Raza's user avatar
1 vote
Accepted

How to incorporate containers into a standardized dev environment?

Docker is an awesome tool for creating a database, seeding data into it, and disposing of it. For an example check out Microsoft's SQL Server with Docker. The following would pull and run a sql ...
Wesley Rolnick's user avatar
1 vote
Accepted

Conditionally stopping SQL replication during deployment

I eventually found the solution :) In an Azure Devops Release pipelines I've created a Command Line task that executes SqlPackage.exe /Action:DeployReport /p:DoNotAlterReplicatedObjects=false ... ...
SimonAx's user avatar
  • 131
1 vote

Is there a way to acquire metadata about an Amazon RDS database instance using only SQL?

I don't have a SQL Server on AWS to check, but you could see if it's in xp_msver, or figure it out from ProcessorCount, ProcessorType and PhysicalMemory in that sproc.
Gaius's user avatar
  • 1,076
1 vote
Accepted

How to filter ELB logs by today's date?

Either request_timestamp needs to be converted from the ISO 8601 formatted string into a timestamp with time zone, or current_timestamp needs to be converted into the string. One method is to convert ...
kenorb's user avatar
  • 7,871
1 vote

Git - Everyone Pushing to Same Branch in Different Files

I believe there are several anti-patterns in your workflow. 1. Having different developpers pushing to different files to avoid conflicts is to hard of a constraint to be sustainable in the long run. ...
avi.elkharrat's user avatar
1 vote

Is it possible to set up Microsoft Sql Server in a scalable way?

Not impossible, very easy in fact with read-only routing. Clients intending to be read-only specify it in their connect string, so this is per-session rather than per-statement. You can have up to 9 ...
Gaius's user avatar
  • 1,076

Only top scored, non community-wiki answers of a minimum length are eligible