Questions tagged [sql]

For questions about Structured Query Language (SQL), which is a language for querying databases.

Filter by
Sorted by
Tagged with
0 votes
0 answers
13 views

Delta and Key file, how to ingest changes from vendor

I am a relatively new dev ops engineer and I have a project that requires that I update multiple tables with changes delivered in a delta and key file combination. So basically I need to ingest ...
user avatar
0 votes
2 answers
25 views

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

My current company is looking to benefit from the cloud by hosting our different web apps and sql servers on Azure. We're not a tech company and I'm the sole developer here and I need some guidance on ...
user avatar
0 votes
1 answer
34 views

SQL Server database default template

I'm creating a microservices architecture. Each service needs its own database, so I've created an SQL Server resource in my Azure's Resource Group. But the databases are created code-first by the ...
user avatar
  • 103
4 votes
2 answers
201 views

Postgresql in DevOps skills

What are the basic skills and requirements a DevOps candidate should have when working with PostgreSQL? How to monitor it, deploy, etc.?
user avatar
3 votes
0 answers
49 views

Monitoring SSRS report server with AppDynamics

I've spent several days trying to figure out how to set up AppDynamics to monitor our SQL Server Reporting Servers, and am encountering the issue where multiple nodes for the same server and ...
user avatar
0 votes
1 answer
578 views

Azure DevOps Different Post Deployment script per environment

I have a visual studio database project being built and released through Azure DevOps. I need to execute a different post deployment for Dev vs. Prod. Is there a way to achieve this either through ...
user avatar
  • 101
1 vote
1 answer
55 views

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

I'm running a serverless SQL database in azure, taking a load from some data transformed by Databricks. Every time I try to write to the database the, IOPS percentage shows up as 100% which makes it ...
user avatar
  • 111
0 votes
1 answer
43 views

How to incorporate containers into a standardized dev environment? [closed]

I'm currently working at a small company where we've had a lot of issues being on the same page with entity framework migrations and local databases. I want to start incorporating containers in hopes ...
user avatar
  • 105
1 vote
1 answer
258 views

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

How we can manage database part in DevOps environment/CICD pipeline, Here taking about the SQL Script. For Example any deployment where Insert and Update SQL's, If we setup in CICD pipeline then I ...
user avatar
3 votes
1 answer
661 views

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

while trying to build dacpac using sqlpackage.exe, we are getting the following error Microsoft.SqlServer.Dac.DacServicesException: An error occurred during deployment plan generation. Deployment ...
user avatar
7 votes
2 answers
5k views

MSSQL and AD in a Docker Container

I am attempting to use Active Directory authentication with SQL Server on Linux running inside the official MSFT Docker container for MSSQL (https://hub.docker.com/_/microsoft-mssql-server) I am in ...
user avatar
  • 1,203
2 votes
1 answer
349 views

Conditionally stopping SQL replication during deployment

The project that i recently started working on uses a dacpac to deploy / update a database in MS SQL Server. The database is replicated, whenever the dacpac contains modifications to any table, we ...
user avatar
  • 121
8 votes
1 answer
6k views

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

I have a background in relational databases and new to Prometheus. I wonder why Prometheus is not a good choice for high cardinality data? Why do I need to use low cardinality data? It's exact ...
user avatar
  • 452
3 votes
1 answer
111 views

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

For example, if I have a SQL Server instance in RDS, and I have only a connection string to connect to the server, is there a sproc or some pre-configured tables I can access via SQL on the instance ...
user avatar
  • 131
0 votes
1 answer
619 views

How to filter ELB logs by today's date?

I've tried this query: SELECT request_timestamp FROM elb_logs WHERE date_trunc('day', request_timestamp) = date_trunc('day', current_timestamp) LIMIT 10 but it fails with: SYNTAX_ERROR: line 3:7: ...
user avatar
  • 7,151
3 votes
2 answers
253 views

Git - Everyone Pushing to Same Branch in Different Files

Database team is implementing code changes, using Visual Studio SSDT database projects with Git source control. Everyone is pushing to main Release branch with code review (only 5 developers on the ...
user avatar
2 votes
1 answer
49 views

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

I am working on some architecture where we need to have a Microsoft Sql Server database that is scalable, with one writable master and many read-only slaves. Ideally I should be able to hit a load ...
user avatar
12 votes
2 answers
2k views

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

I'm new to SQL Server, so this may be more of a SQL Server management question. I'm creating test and production databases for a service, and I imagine I'll be wiping the test database quite a lot. ...
user avatar
4 votes
1 answer
3k views

What are HiveQL limitations compared to SQL? [closed]

I'm aware that Apache Hive provides SQL-like interface to query stored data. So I would like to ask, what are the main limitation of Hive-based SQL-like compared to other relational SQL query ...
user avatar
  • 7,151