Questions tagged [sql-server]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
49 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
1answer
36 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 ...
0
votes
0answers
12 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
28 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
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 ...
2
votes
1answer
33 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 ...
0
votes
1answer
38 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....
1
vote
3answers
36 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-...
8
votes
3answers
272 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 ...
0
votes
2answers
65 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
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 ?
3
votes
2answers
120 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: ...
0
votes
0answers
5 views

Is there an extension for Azure Data Studio that places a guideline at 80 characters?

Question: I use the extension Editor Guidelines in Visual Studio. Are there any similar extensions for Azure Data Studio? Workaround If not, is there any way to mimic this using an existing ...
0
votes
0answers
8 views

Documenting stored procedures

I'm searching for a SQL script or a freeware to document stored procedures batch, from the point of entry to tables and depending stored procedures. It should analyse all stored procedures regarding ...
9
votes
7answers
10k views

Web-based OLAP CUBE browser?

I have cube on MS SQL Server and I want to install a web based visual client tool for exploring and analyzing OLAP databases. A cube is an array of data understood in terms of its 0 or more dimensions....
0
votes
0answers
9 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 ...
-1
votes
1answer
30 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 ...
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
9 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
7 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
6 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
9 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 ...
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 ...
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
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 ...
3
votes
3answers
21k views

What is the best frontend program for my database needs?

I am currently an Electrical engineer and I have been tasked to set up a database(outside my realm of expertise) that will be used by multiple users over a networked drive. There will only be a couple ...
0
votes
1answer
14 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
votes
1answer
21 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
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, ...
-2
votes
1answer
17 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
1answer
16 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. ...
1
vote
1answer
7 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
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 ...
5
votes
3answers
6k views

SQL Server client for Ubuntu

I need to connect to a MS SQL Server database from my Ubuntu machine. Any client suggested? I found libmono-entityframework-sqlserver6.0-cil, will that work? It doesn't sound like just a client: ...
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 ...
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/ ...
0
votes
1answer
20 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 ...
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 ...
5
votes
1answer
245 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 ...
2
votes
1answer
69 views

SQL Server replication tool

I'm looking for a Windows tool (preferably installable as a windows service) for periodic database synchronization. Once every X minutes it should connect to Source SQL Server database, check for any ...
1
vote
0answers
35 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
43 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
0answers
54 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 ...
2
votes
1answer
88 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 ...