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
0answers
9 views

Migrating from TFS 2015 to DevOps Server 2019

We are attempting to migrate our current TFS 2015 (Source control and build server) to Azure DevOps Server 2019. We have followed the instructions given on the We have followed all instructions ...
1
vote
0answers
14 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 ...
3
votes
1answer
160 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 ...
3
votes
1answer
18 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 ...
0
votes
1answer
85 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: ...
3
votes
2answers
103 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 ...
1
vote
0answers
101 views

Teamcity - Conditional OctopusDeploy Create Release

We have a SQL Server Visual Studio Database Project in Source Control. We have 10 databases in the solution. We build all database projects together, since there are dependencies/cross joins etc. Then ...
2
votes
1answer
46 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 ...
12
votes
2answers
864 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. ...
3
votes
1answer
2k 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 ...