Questions tagged [sql-server]

Use this tag specifically when seeking recommendations relating to Microsoft SQL Server. For general database questions use the [database] tag.

66 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
8
votes
1answer
251 views

Software library or tool to pivot and export a lot of data to Excel

I'm trying to find a way to get normalized data that's in an MSSQL database out of there, pivoted, and into an Excel file. The main problem is that I have many of those databases, each with the same ...
8
votes
1answer
495 views

.NET/MSSQL forum software supporting 3+ million users

This is not a duplicate of Forum solution for ASP.NET MVC Application. I've been searching for a (preferable) MVC.NET Forum Solution with the following requirements and found 2 "worth looking at" ...
3
votes
0answers
39 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 ...
3
votes
2answers
100 views

Looking for CMS/Wiki for IIS/SQL Server platform

We are SaaS company and looking to update our web help portal. We can host ourselves, but prefer this to be more Microsoft-ish (SQL Server, IIS) Currently we use Confluence, here is what we like: ...
3
votes
0answers
75 views

PHP Ad Manager (free)

I'm working with a PHP website that uses a custom CMS based on a MSSQL database. I'm desperately looking for a solution to install an Ad Manager, and I don't have much time so I would like to know ...
2
votes
0answers
6 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 ...
2
votes
0answers
97 views

Azure SQL Server client for Mac OS X that does not require Java

Is there a Microsoft SQL Server client that runs on Mac OS that does not require Java? If there is more than one, which would you recommend? Besides one that runs the usual queries, I would also like ...
2
votes
0answers
150 views

Machine Learning Multiclass Classification for thousands of Classes

I have Entities with 1 to 10 attributes describing each of them and I need Machine Learning to suggest best matching Class for each Entity. Sounds straightforward, but there are about one hundred ...
1
vote
0answers
7 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 ...
1
vote
0answers
22 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 ...
1
vote
0answers
7 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, ...
1
vote
0answers
4 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 ...
1
vote
0answers
20 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/ ...
1
vote
0answers
18 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 ...
1
vote
0answers
31 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 ...
1
vote
0answers
25 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? ...
1
vote
0answers
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 ...
1
vote
0answers
29 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 ...
1
vote
0answers
45 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 ...
1
vote
2answers
51 views

Open source Tool for creating reports of DB structure for SQL Server 2008

Any recommendation for open source tool (or evaluation functional software) witch I could generate a report (Excel or Word) of all my tables and fields of a SQL server 2008 Database ?
1
vote
0answers
44 views

recommendation for erp/dms using sql-server-express?

I am searching for recommendations for a ERP/DMS/CMS type platform which runs on or alongside SQL-server express. The ERP/DMS will be an extension to invoicing/accounting software - which runs on SQL-...
1
vote
0answers
30 views

Tool to trace and create a script of all DB writes

We have a complex process that creates various entries into a large database. I would like to generate a single SQL script that performs all the writes that are done by a single run of this process. ...
1
vote
0answers
416 views

Tool for converting MSSQL data to MariaDB (MySQL)?

We're using MySQL workbench to convert an MSSQL database to MariaDB. However, the process takes ~5 hours, and we're looking for a faster solution. We're using MSSQL Server 2012 and mysql Ver 15.1 ...
1
vote
0answers
33 views

Which are the most used formatting, source-controlling and comparing tools for T-SQL?

I am always trying to keep a "tight clean ship", or whatever the original English saying is, even though it looks like a "monkey business" to manually format any word that I am typing. I am even using ...
1
vote
0answers
32 views

SQL Server backup with API, automated deployment, S3

I am looking for a good SQL Server backup/restore solution. There seems to be a lot of options out there, but I specifically need these capabilities: Automated deployment. It should be easy to ...
1
vote
0answers
25 views

Website for comparing SQL performance

Is there a website which allows you to paste a DDL for your DB and two SQL statements, which can then recommend one (optionally including context such as; "if >10,000 rows use Query#2; else Query#1")? ...
1
vote
0answers
20 views

Application to check ability to access SQL database, based on active directory login?

I have a SQL database which has permissions through active directory groups. My company system to manage AD groups is frankly awful and something which requires tons of my time. Because of this, I ...
1
vote
0answers
28 views

Storage Use Case “Logging + Images + Metadata”

I have the following use case for which I'm trying to find an optimal use of either filsystem, database (rdbms or a flavour of noSql solution). Any advice is welcome, as I want to see what is optimal. ...
0
votes
0answers
14 views

SQL SERVER performance OPEN SOURCE monitoring

I'm searching for good open-source solution to monitoring SQL SERVER performance, It will be nice if it has a web client. I have 32 SQL SERVER instances and 11 Windows Servers, I want to collect data ...
0
votes
0answers
8 views

I need a suggestion on an Inventory application

I have non physical inventory. I need an application with a user logins than can parse and distribute that inventory to ~50 users based on different criteria. A user dash board would be nice. The raw ...
0
votes
0answers
5 views

Is there a software (like OpsGenie) that will show whether or not stored procedures have run on Microsoft SQL Server?

I'm looking for a web app (or something similar) that is able to show super simple statuses of stored procedures (or groups of stored procedures) similar to the way OpsGenie works. All I want it to do ...
0
votes
0answers
11 views

Oracle APEX vs MSSQL

I would like to request another software solution similar to Oracle Apex but using MSSQL database. Could you help me? Unfortunately, the customer won't buy Oracle license.. Thank you!
0
votes
0answers
3 views

Importing data from MS Server into Google Data Studio

I need to import data from SQL Server into Google Data Studio. The SQL Server Management Studio is in an hosted environment which needs to be accessed through Remote Desktop. I have access to the ...
0
votes
0answers
7 views

Compatible SQL server configuration manager for SQL server 2018

I have SQL server 2018, but its not showing local server. And also i have not installed SQL server configuration manager.Please suggest me compatible SQL server configuration manager for SQL sever ...
0
votes
0answers
3 views

Replacement for diagramming function in SQL Server Management Studio

I am connecting to a Native Azure environment using Azure Data Studio, I haven't used SQL Server for 3-4 years, to my horror the diagramming functionality has been removed. I've joined a project ...
0
votes
0answers
13 views

Key difference between SQL Server 2016 and MySQL

My company is in the midst of an IT overhaul and considering a shift away from MS SQL Server (2016 Standard) to a MySQL database. I have used MS SQL Server for years, so I am apprehensive to make ...
0
votes
0answers
8 views

Alternative to SQL profiler that would have less impact on the production environment

I want to find an alternate to the SQL profiler to trace-up the SQLBatch / Stored procedures that are ran against the database of SQL server 2008. I have a problem where the client has an issue with ...
0
votes
0answers
7 views

SSMS gui for Query building

Does SQL Management Studio have a GUI similar to SAS Enterprise Guide by which the user can graphically interact with query stages/elements? I found SAS EG a wonderful query tool but I prefer using ...
0
votes
0answers
7 views

Sever host for simple PHP mysql dynamic website

I've been working on my first serious web project for about 6 months now - the time has now come to deploy it. I am a complete noob and this is new territory but equally this site is very important so ...
0
votes
0answers
6 views

Power BI Report Server & SSRS Report Server

We have reports created by using SSRS. Currently we are using Power BI Report Server to deploy those reports. Now we are thinking to switch it to SSRS Report Server. Our concern is that, we have ...
0
votes
1answer
6 views

Framework for T-SQL unit testing

I am looking for a framework to do unit testing of T-SQL stored procedures and functions.
0
votes
0answers
5 views

use SSIS Odata to export to MS SQL

I'm the new in SSIS When I try to use Odata Source Editor to link D365 customer service, I got the error message: error detail: Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress ...
0
votes
0answers
3 views

Any tool for converting the collation in MS SQL or Azure SQL database?

I am looking for a tool (paid or open-source ) that can do the following things. Connect to single databases or all databases under MS SQL Server or Azure SQL (PaaS) Shows the current database ...
0
votes
0answers
4 views

stress test web application

I have an application developed with MVC 5 and SQL Server 2012. And in December of this year a new use process begins. The issue is that it will be twice as many concurrent users and I would like to ...
0
votes
0answers
4 views

MSSQL 2017 Win2k16 64GB Memory Setting

MSSQL 2017 Win2k16 64GB Memory Setting What should be the memory setting value for both min and max if my server has 64GB ram and the vendor states? atleat 10% dedicated to OS. So if 10% * 64 ...
0
votes
0answers
7 views

Can I use Azure SQL Databese to learn, test and use smal programs, as a private person?

I would like to have an SQL server to test my small programs written in C# (usually 5-6 tables) uses MSSQL Databases. Azure and its SQL service seems to good for me but I'm not a company, only a ...
0
votes
0answers
4 views

Synch Data to and From Android device using SQLite db to MS-SQL db

I have an android app which makes use of a local sqlite db. We have developed our own code to synch data between the sqlite db and a cloud based sql standard/express db... the only problem is our ...
0
votes
0answers
5 views

MSSQL Server cluster to MSSQL always on

my on premise MSSQL using windows server cluster and shared storage. I want to create DR at the cloud. In my cloud, i can only use MSSQL always on. Is it possible to replicate my on-premise SQL to ...
0
votes
0answers
9 views

SSIS Excel (.xlsx) Connector to SQL Server 2012/2016 recommendations?

Any recommendations on 3rd party Excel Source/Destination Connectors for SSIS to SQL Server 2012/16? What are the kinks? I really can't find reviews on these things anywhere. We need something ...
0
votes
0answers
5 views

Which Azure PaaS SQL DB type for Data Warehouse (Single DB or Managed Instance)

I am considering a generic Data warehouse setup using Azure SQL DB. Which option would be best: Single Database OR Managed Instance The following differences I am already aware of that are key ...