Questions tagged [sql-server]

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

42 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
8
votes
3answers
278 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
510 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" ...
4
votes
0answers
73 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
151 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
1answer
46 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 ...
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
101 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
168 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 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 ...
1
vote
0answers
8 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 ...
1
vote
4answers
76 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-...
1
vote
0answers
8 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
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
21 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
19 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
37 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
55 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
1answer
54 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 ...
1
vote
0answers
32 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
48 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
54 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
49 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
417 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
29 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
24 views

Which OR mapper would you recommend for a new application (C# .net) with an existing database

We want to write a new application in C# that uses our existing database (SqlServer). There are many stored procedures and functions in the database. The database has several schemes. Which OR mapper ...
0
votes
0answers
14 views

Working on a group project, can our tech stack work? [React FE, Python BE, MS_SQL database]

We are concerned that our tech stack might have difficulties with integration testing since we are not very experienced with this process. We are looking for any validation or suggestions with "...
0
votes
0answers
9 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 ...
0
votes
0answers
9 views

Are there any free options available for connecting SSIS to MongoDb?

I need to move data from a SQL Server table to a MongoDb collection using SSIS. I've been looking around but can only seem to find options that require a hefty payment such as those offered by CData ...
0
votes
0answers
13 views

SQL Server CE Hotfix KB 2960153

There was a Microsoft Hotfix "On-demand hotfix update package for SQL Server Compact 4.0 Service Pack 1" made available around 2014 on the Microsoft website. Unfortunately, around 2018, ...
0
votes
1answer
33 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 ...
0
votes
2answers
55 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....
0
votes
0answers
30 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. ...
0
votes
2answers
68 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. ...
-1
votes
1answer
24 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 ...