Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [sql]

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

3
votes
2answers
84 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
87 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
42 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 ...
10
votes
2answers
713 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
1k 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 ...