Questions tagged [sql-server]

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

64 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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
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 ...
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
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 ...
0
votes
0answers
110 views

Looking for a free, opensource, C#/.NET based URL-Shortener

I'm looking for a opensource URL-shortener which I can host myself which works with C#/.NET and a MSSQL database. There are quite a few free URL-shortener out there, but I'd like to shorten the URLs ...
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 ...
0
votes
0answers
28 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
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
16 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 ...
-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 ...