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
0answers
2 views

What kind of database schema I can use for streaming?

I want to understand what's the better schema I can use for data streaming. For example, Star, Snowflake, etc. Thanks a lot.
-1
votes
0answers
5 views

How do I find a changed table list after executing an SQL query through Spring Boot API in a MySQL workbench? [on hold]

I am use Spring Boot for rest API for this API we connect MySQL as a database through MySQL Workbench.now my question is that how i find how many database table is changed after executing API call and ...
0
votes
0answers
4 views

How to connect Microsoft SQL Server to Google Data Studio

I am an amateur exploring business intelligence tools. Currently, our company uses a Microsoft SQL Server database for all of our software products. We also use Google G Suite to manage all of our ...
0
votes
0answers
4 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
12 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
7 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
2answers
59 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
0answers
15 views

Debug SSIS packages in VS 2019 and SQL Server 2016 is not working. Breakpoint doesn't stop in DataFlows

Working with Visual Studio 2019 v16.2.3. I am developing SSIS packages for SQL Server 2016. I already have the TargetServerVersion property set to SQL Server 2016. By adding a breakpoint in any data ...
8
votes
1answer
248 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 ...
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 ?
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
3 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
4 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 ...
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 ...
3
votes
2answers
89 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
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
1answer
45 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 ...
3
votes
3answers
17k 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
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
6 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
1answer
18 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
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
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 ...
0
votes
0answers
7 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 ...
-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 ...
0
votes
0answers
3 views

how to sync database from MS SQL to PostgreSQL

I have to do database sync from MS SQL to PostgreSQL. Intially i thought to do transact replication but MS SQL is not supporting Postgresql while creating Non SQL subscriber in subcriptions. Any ...
0
votes
0answers
6 views

SQL Server 2017 to Mongo DB

I have SQL Server 2017 DB for my application. The data stored is already in JSON format. Now management has decided to move to MongoDB. 1) Could you please recommend a good ETL or Migration Tool to ...
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, ...
0
votes
0answers
5 views

Change Data Capture tools that work based on change logs in RDBMS

I am looking for a CDC-Change Data Capture tool that can capture change based on change log from an RDBMS. I am trying to do a CDC between databases DB2 and mssql. I know few tools that does this such ...
0
votes
0answers
4 views

AWS service to display data from database or configuration file

I need to display some data from a database or from a configuration file using AWS, Please suggest which AWS service is better to display data which is fetched from an ini or json file or from a ...
0
votes
1answer
29 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
12 views

How to auto generate MSSQL database diagram, suitable for print on plotter

I am trying to find some software that can help me get our database scheme printed out in a big format. We have a DB with roughly 60-70 tables, and a lot of relationships between them. Overall i ...
0
votes
0answers
2 views

SQL Server Snapshot Alternative (Multiple per database)

I'm looking for a tool, either a built-in SQL Server feature or a third party tool, to do everything a database snapshot can do, plus having the ability to revert to more than one. Specifically, it ...
-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
5k 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: ...
0
votes
0answers
6 views

How to control/monitor BigQuery ETL process with Azure services

I'm looking for the best Service solution which would be able to trigger/monitor and control ETL process in BigQuery, then transfer files to Azure VM and do insert into MS SQL. Was trying to use ...
0
votes
0answers
12 views

Program for Windows users to add, update, delete, search SQL Server tables?

I'm creating a SQL Server database for our lost & found items. One table will have an inventory of lost items and another table will have inquiry information of those looking for items. Intuitive ...
0
votes
0answers
3 views

Comparing Tool for MS Reporting Services Objects

I have three MS Reporting Services Instances (Server), all in version of MS SQL-Server 2017. All instances have the same tree structure with hundreds of objects (datasources, datasets and reports) ...
0
votes
0answers
11 views

Transfering data from aurora to sql server

I am using auorora postgres database and sql server. Can you recommend a way how to transfer 100M rows table from aurora to ms server? I was trying to use spark for this issue and as I understood ...
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 ...