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-...
- 1,955
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 ...
- 11.6k
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 ...
- 2,707
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 ...
- 13.1k
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 ...
- 2,761
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 ...
- 8,963
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 ...
- 1,532
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, ...
- 1,476
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 ...
- 2,707
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, ...
- 151
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 ...
- 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 ...
- 81
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 ...
- 250
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 ...
- 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 ...
- 166
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 ...
- 2,707
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.
- 1,086
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 ...
- 7,781
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.
...
- 346
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 ...
- 1,086
Only top scored, non community-wiki answers of a minimum length are eligible