Questions tagged [sql-server]
Use this tag specifically when seeking recommendations relating to Microsoft SQL Server. For general database questions use the [database] tag.
94
questions
0
votes
1
answer
37
views
Are ESB still worth as communication layer? Which ones?
I need to develop a comunication layer between my application and customer's.
There are different data exchanges and I'm looking for some solutions. I don't know much about Enterprise Service Bus ...
- 101
0
votes
0
answers
11
views
Access to sql server synchronisation
I have a legacy VB system that creates a new access database for every job in our system, for example 1.Mdb, 2.mdb, 3.mdb I want to automatically write the details from these databases to a ms sql ...
0
votes
0
answers
321
views
Need documentation for MSSQL catalog views (sys.object etc)
The catalog views are horrible to work with, probably in part from lack of documentation. Is there any good quality comnprehensive docs/books for all or some of these https://learn.microsoft.com/en-us/...
- 101
1
vote
1
answer
232
views
Software to do Data Mining in SQL Server 2022
I'm tasked with creating a few data mining models for the Adventure Works demo database. I'm supposed to have been using SSDT and Visual Studio with SQL Server, however the latest version of SSDT (...
0
votes
0
answers
46
views
What is a good database tool for offline access?
I'm trying to find the right database service to use. I need multiple computers (1-5) to be able to access/write/read to the database simultaneously, locally (without internet access, via connecting ...
0
votes
0
answers
9
views
Software/Tools available for transforming SQL data and physical file names and locations
We're developing the next iteration of some software which basically collects data, stores it in SQL as a combination of columns or as JSON within columns, and stores physical files associated with ...
- 101
0
votes
1
answer
80
views
looking for alternative rdbms for oracle which is build by russian
can anyone suggest any alternative to DB2, Sybase, and Oracle? I knew that Teradata is a good alternative to these. But most oracle guys ridicule to this they still think Oracle is superior and more ...
- 7
1
vote
1
answer
26
views
Tool to get the most proper SQL for a predefined result
unlike to normal situation, which I write SQL Statement for pre-assumed result, I am in a situation that I need the SQL for predefined result. for example, suppose that you have the following table ...
1
vote
1
answer
20
views
Tool to generate SQL query with multiple record sets from xml source containing database relationships
I have xml files that describe data I want to retrieve out of an MS SQL database.
e.g.
<Customer Type="Entity" ID="12345">
<Territory Type="Entity" Table="...
- 11
0
votes
2
answers
118
views
open source tool for SQL Queries
I program in SQL, however I am not someone who comes from IT.
In my new job, we have to choose an open source tool for doing only queries (using SQL language), it means we are going to connect to some ...
- 1
-1
votes
1
answer
26
views
Can we use SQL Server 2019 Big Data Cluster as Data Warehouse?
I am trying to compare the solutions to create Data Warehouse which is around 20 TB using Microsoft products on both On-Premises and Azure. I have checked the SQL Server 2019 Big Data Clusters but got ...
2
votes
1
answer
119
views
Looking for something that will take an SSRS (.RDL) file and produce a PDF file
I'm looking for a product or method that allows me to take an SSRS report (.RDL file) and a parameter and produce a PDF file as output without manual steps.
This would be triggered when a user opens a ...
2
votes
1
answer
25
views
Tool to save collection of pages in SSMS
I do a lot of work for various clients using SQL Server Management Studio (currently using version 18.5.1). Often, when working on a particular task, I'll have a bunch of pages open, with various ...
- 121
1
vote
4
answers
1k
views
Replacement for MS Access Front End
I manage the IT Operations for a UK based Recruitment Agency. We have about 40 employees. Our main business system/CRM runs on a MS Access front-end connecting to on-prem MS SQL Server. The front-...
- 11
3
votes
1
answer
121
views
Mobile Friendly Data Entry App
I am trying to create a data entry "app" to collect daily readings across our site. Here are the three biggest constraints:
Software - ideally, we would use some software within the Microsoft
365 ...
- 131
-1
votes
1
answer
43
views
Should I learn MySQL and SQL server together for learning SQL? [closed]
I am starting to learn SQL so I was wondering which RDBMS should I use, i.e. MySQL or SQL Server, so I can also mention that tool in my resume to give good impression to get a job here in India.
So ...
- 58
1
vote
0
answers
14
views
Looking for a Web-Frontend for a single SQL-Server table
we are using a FreePBX VOIP-System. We want to make a Phone-Protocol where each Call is shown and Users can add Information and assign the Call to an co-worker.
The list will have some fields, which ...
- 11
1
vote
1
answer
60
views
Best Tool for Analyzing Multi-Tab Excel Files with 100-500k Records
I have started a new job and I need to analyze client's databases. Many times when we first meet with them we just get a huge Excel file with a dozen or so tabs and a partial to full dump of various ...
- 111
0
votes
1
answer
22
views
Is there a tool to view entity relations from a sql script?
I have a sql file with a long list of create tables and alter tables. Is there a tool available to look at the entity relationships that result from running the sql script. It would be great to not ...
- 1
-1
votes
1
answer
33
views
SSRS - SQL Server Reporting Services Possibility?
Currently, we have SQL Server 2012 R2. Looking to produce some reports and have them automatically run and have converted to PDF with the possibility of automating an email to send to subscribers of ...
- 1
1
vote
0
answers
11
views
Are there any open source API's to push and pull data tables from SQL to Google Cloud(Big Query) and Vice Versa?
Part of my jobs is to push and pull data tables from SQL to the Google cloud (Big Query) and vice versa. I was wondering if there are any robust API's that can be used in my web apps, SSIS Packages, ...
0
votes
1
answer
65
views
Report distribution tool
we are looking for a SW/tool which would help us to automate the reports distribution.
We use MS SQL Server 2016 and SSRS (Sql server Reporting Services), we have a knowledge of SQL coding.
Our ...
- 1
-2
votes
1
answer
30
views
What software should i use to create a ERP SYSTEM?
i would like you help me with this question. if you have to make a software ERP , with modules like Human Resource, Inventory, Sales & Marketing, Purches, Finance & Accounting, Customer ...
0
votes
1
answer
27
views
Dynamic web application based on MS Access
I am given MS Access file, based on which I need to create a web application with some statistics. The end user is downloading this MS Access file from some third party application, say once a week. ...
- 3
1
vote
1
answer
23
views
How can I install a small/lite version of SQL server on my client's machine for my software trial version?
I'm a software engineer and I'm currently working on a new project. My clients always complain about my trial versions as it takes too much time and resources. I usually install SQL server full ...
1
vote
0
answers
26
views
Tool to convert stored procedures from SQL Server to MySQL
I am already tried like a below tools for conversion
Mysql workbench
Dataloader (trial version)
DRPU database converter (trial version)
But, still i can't able to convert Stored procedures from sql ...
- 11
0
votes
2
answers
47
views
Best option/opinion on how to load website data - Html/PHP into a SQL Server Database?
I have been thinking and trying to expand my knowledge of different tools. One thing I have never had personal experience with is getting website data that users enter, and have that loaded into a SQL ...
- 1
1
vote
3
answers
124
views
Need a database for a single-user app to sync data across computers without storing on the internet
Need suggestions for a database. I'm tasked to write a C# desktop application for a small business. The business owner does not want his data to be stored on the internet. He has two desktop computers....
- 11
2
votes
0
answers
14
views
NoSQL or RDBMS for user defined columns
We will soon be rewriting an application that will allow the end user to define objects and fields on those objects.
I come from an MSSQL background and am familiar with options to handle this use ...
- 121
1
vote
0
answers
30
views
Software/tool to design database diagrams for MSSQL
I am looking for a free software/tool to design database diagrams for MSSQL. There are some online tools which I think great but not free
https://sqldbm.com
https://app.quickdatabasediagrams.com/
...
- 111
0
votes
1
answer
26
views
Are there any main differences between MySQL (MariaDB), PostgreSQL, Oracle, Microsoft Databases for usage in enterprise? [closed]
Lets take this: Company using Microsoft Server Database since 2008. Its company what heavily depends on working with data from databases. (Construction company ) Current database is outdated and not ...
- 141
1
vote
1
answer
42
views
Tool for monitoring table churn in MS SQL Server
I am looking for Desktop or Web based MS SQL Server monitoring tools, that runs on Windows Server 2008 ~ 2012, my budget is around $3000, who have this capability:
Able to monitor how many data rows ...
- 11
1
vote
0
answers
39
views
R access to SQL Server
I'm having to update my access to SQL Server from R on windows. The only option I see right now is odbc. Unfortunately, the ODBC standard and this driver (using nanodbc) in particular has some ...
- 121
1
vote
0
answers
84
views
Tool for transferring data from linux machine to MSSQL on remote (Windows) machine
Is there some kind of opensource / free tools for transferring data from a linux machine to a remote (Windows Server 2012) MSSQL Database Server that can be called / controlled via a bash script? ...
4
votes
0
answers
86
views
Excel to SQL mapping tool
I am looking for a tool/library to import data from different clients into our SQL database. Each client will have their own EXCEL file. So the number of columns, name of the columns in EXCEL would be ...
- 141
2
votes
1
answer
234
views
PHP MSSQL Table editor in browser
I have a website running PHP, and a Microsoft SQL Database at the back end.
I want an end user to be able to edit a table within the SQL database.
I want them to be able to do this using a page on the ...
- 21
1
vote
0
answers
11
views
Some freeware tool or script to fetch the MS SQL Server Edition
I need to check "Microsoft SQL Server Edition" e.g. Standard, Express or Enterprise etc installed on multiple systems, but to get the edition details I manually execute @@version query on each SQL ...
- 11
1
vote
1
answer
25
views
Software to build networks visualization using relational tables
I've an table in SQL Server with the following schema:
- Partner_ID
- Child_ID
- Relationship_Name
Example of my data:
Partner_ID Child_ID Relationship_Name
A A1 ...
- 13
1
vote
1
answer
115
views
Which Software to take, when creating a database diagram
We are using a MS SQL Server database and we want to create a database diagram for an existing database.
There were several options on how to do this: In Microsoft Visio 2010, Visual Studio 2013 or ...
- 113
1
vote
1
answer
72
views
Which Software Solution should I Use to employ predictive analytics (as a newbie)?
I'm a Business Intelligence analyst working almost entirely with SQL Server Management Studio (SSMS) and Tableau to produce BI reports. I'd like to start to incorporate some predictive analytics, and ...
- 11
1
vote
0
answers
34
views
Recommendation for a SQL server development and management tool
I am currently using Toad for SQL server 6.8 and I am very disappointed in the quality of the software. It took them more than year to deliver version 6.8 and finally, when they did, it is pretty much ...
- 121
0
votes
0
answers
33
views
Scheduling Jobs - Software Development
I require a free tool (capable to be mantain or grow up with my own developments) to maintain, monitor and schedule cron jobs that run on Windows, Linux, and executes MSSQL SSIS and MSSQL commands.
...
- 101
2
votes
3
answers
74
views
Which software can I use to browse a MSSQL database?
I want something similar to phpMyAdmin for an MSSQL server.
It MUST have / be:
M1: a graphical interface where I can see all table names
M2: gratis
M3: work with ubuntu 16.04
Nice to have would be
...
- 2,513
1
vote
1
answer
207
views
Recommendations for creating wallboard-type displays using MSSQL data sources
I'm looking for some recommendations in terms of data visualisation tools.
At my current place of work we have 'Wallboards' - these are basically web pages which are displayed on the big screens, ...
- 11
1
vote
0
answers
54
views
Generate ETL for many (173) delimited database files
I get a zip of 173 database files, in a delimited format, each day. We call this extract DbUnload. The company that sends me this file, won't adjust the file spec or give me notification of any ...
- 11
0
votes
2
answers
123
views
Tool to write a scheduled job that sends an email every 5 minutes using .Net core & SQL Server
My requirement is to write a batch program/job that sends an email every 5 minutes. It will query an sql server database.
My team is a microsoft shop so we are exposed to .Net core and SQL server.
...
- 101
6
votes
1
answer
327
views
SQL Server database version control
I'm looking for open source SQL Server database version control addon/tools to link with Git.
I tried gitSQL and red-gate sql source control (not an open source). With gitSQL I see a problem that ...
- 161
0
votes
2
answers
1k
views
Which database to use for making a small inventory management system?
I, want to make a small business inventory management system application in java ,for windows 7,8,10 . I have used sql server express ( but it has a limit of 10 gb) and a little of mysql but i know ...
- 111
0
votes
2
answers
112
views
SQL Editor for Microsoft SQL server
I'm looking for an SQL editor which can be used to edit queries in MS SQL Server.
Currently I'm using Oracle SQL developer which I like very much, but that can connect to Oracle databases only.
...
- 143
1
vote
3
answers
1k
views
Which tool to use for SQL Server Database migrations and why as of 2017?
I want to know a tool to use for SQL Server Database migrations and why as of 2017, since I worry about this topic, so I can automate this process as much as possible.
What do you think about Entity ...
- 111