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
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
19 views

Software to build networks visualization using relational tables

I've an table in SQL Server with the following schema: - Partner_ID - Child_ID - Relationship_Name Example of my data: Partner_ID Child_ID Relationship_Name A A1 ...
1
vote
1answer
69 views

Which Software to take, when creating a database diagram

We are using a MS SQL Server database and we want to create a database diagram for an existing database. There were several options on how to do this: In Microsoft Visio 2010, Visual Studio 2013 or ...
1
vote
0answers
21 views

Mssql vs mysql for software development [closed]

Me and my team are developing a database software.We came a long way working with ms sql server.The project we are working on is also based on MsSql.Now , after we're done with the software , we'll ...
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 ...
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 ...
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. ...
2
votes
3answers
68 views

Which software can I use to browse a MSSQL database?

I want something similar to phpMyAdmin for an MSSQL server. It MUST have / be: M1: a graphical interface where I can see all table names M2: gratis M3: work with ubuntu 16.04 Nice to have would be ...
1
vote
1answer
131 views

Recommendations for creating wallboard-type displays using MSSQL data sources

I'm looking for some recommendations in terms of data visualisation tools. At my current place of work we have 'Wallboards' - these are basically web pages which are displayed on the big screens, ...
1
vote
0answers
43 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 ...
0
votes
2answers
58 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. ...
5
votes
1answer
149 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 ...
0
votes
1answer
394 views

Which database to use for making a small inventory management system?

I, want to make a small business inventory management system application in java ,for windows 7,8,10 . I have used sql server express ( but it has a limit of 10 gb) and a little of mysql but i know ...
0
votes
2answers
85 views

SQL Editor for Microsoft SQL server

I'm looking for an SQL editor which can be used to edit queries in MS SQL Server. Currently I'm using Oracle SQL developer which I like very much, but that can connect to Oracle databases only. ...
1
vote
2answers
169 views

Which tool to use for SQL Server Database migrations and why as of 2017?

I want to know a tool to use for SQL Server Database migrations and why as of 2017, since I worry about this topic, so I can automate this process as much as possible. What do you think about Entity ...
2
votes
1answer
67 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
2answers
50 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
1answer
109 views

Reporting tools when using SQL server management

Here's my context : We are found of SSRS (SQL server reporting services) with visual studio 2008 But the more we use it, the more we see limitations, and bug, and non-implemented feature, and ...
1
vote
0answers
42 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-...
2
votes
0answers
94 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 ...
0
votes
1answer
40 views

SQL Server manager alternative

I am currently using SQL Server Management Studio, which is way too heavy. I used to work with a different manager to connect to an Oracle database, but I don't recall the name. It was lightweight and ...
5
votes
2answers
5k views

Complex SQL Query visualizer

Is there a tool (gratis), that helps developer to understand or helps to visualize the complex queries (involving JOINS, GROUP BY). I know about the snowflakesjoins service which provides visualizer ...
0
votes
2answers
39 views

Web reporting from SQL Server

I have a query that mines all the Initial, Debit, Credit, and Final balance of our accounts for a specific month and year, I was given the opportunity to pick up any software/technology to report this ...
3
votes
2answers
88 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
2answers
162 views

Tool to generate SQL database update scripts

I'm looking for a tool or an open-source project that can generate database update scripts in the following way: Accept a database connection string as a config parameter Connect to the specified DB ...
0
votes
1answer
288 views

Fastest JDBC driver for SQL Server

What is the fastest JDBC driver for Microsoft SQL Server? Especially for SELECT operations with simple WHERE clauses, but also for INSERT and UPDATE operations. It must also be reliable, free to use, ...
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 ...
1
vote
1answer
98 views

Experience with database repair tools for mdf files?

I've got a HDD which is encrypted with petya-green. I used "Disk Internals NTFS Recovery" for recovering the databasefiles which are needed. Than I tried to simpl attach the databasefiles to a new ...
2
votes
0answers
149 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
1answer
62 views

SQL Data verification framework?

I receive a variety of flat files that need to be transformed and aggregated in several stages of a custom ETL process before loading it into a SQL Server database. After each stage, I'd like to ...
2
votes
3answers
3k views

Reporting tool/framework/library for .Net

I want to print pdf reports with lots of charts and text on demand. I have some sub reports, which can be generated stand-alone and can also be merged to generate a single master report. Right now, ...
3
votes
2answers
363 views

Database schema visualization for MS SQL Server

Are there any tools for schema visualization of an existing MS SQL Server database? In particular, I'd like something that reads the tables, fields, and constraints automatically, and that allows for ...
3
votes
1answer
116 views

Free SQL test data generator

I'm searching for a tool to generate SQL test data. What I'm looking for exactly should Be gratis Generate test data from Regex Be compatible with Microsoft SQL Server (compatibility with MySQL and ...
0
votes
1answer
201 views

MS SQL client providing read-only mode

I have a MS SQL database with some very, very sensitive data. If anything gets broken, half of the planet will fall into chaos. Almost :-). I have a database user with some restricted permissions, ...
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: ...
1
vote
2answers
26 views

What software do I use to process year by year calculations for large datasets?

I'm trying to move my .NET program to a database engine but I'm having trouble finding what specific platforms/languages I'm supposed to use. Right now everything is done on the client-side ...
0
votes
2answers
105 views

MS SQL Express Monitor Software

We are looking for a tool or web application that can monitor our MS SQL Express server instances which are running on a Windows Server 2012 R2. It should be possible to get notified when a service ...
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
69 views

Fitness for purpose of Access and Excel for Data analytics [closed]

I am working on a year long Data Analysis project for a moderate sized client, the aims of which are to analyse transactional data identify for the client its customer profiles, develop a monthly ...
1
vote
1answer
63 views

What software to use to make Python-based website using MSSQL

I need to build a simple web page using Python with the data fetched from MSSQL (Unfortunately, I cannot use MySQL and other easy awesome DBs). I tried with installing Django but encountered with ...
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
1answer
100 views

Automatic synchronization tool for MS SQL Server

I am looking for a specific tool which should automatically syncronizes the data between two databases present on two different servers. Whatever gets updates or inserted on the database on 1st server ...
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")? ...
4
votes
1answer
73 views

Database technology recomendation for simulator

Alright so I am developing a simulation application and I need to know what database is advisable (Or the pro's con's of some options). tl;dr: C# application Only the application will be using it ...
2
votes
2answers
62 views

Best tool for browsing schema or database properties or tabls structure of remotely installed Microsoft SQL Server by PHP

I'm seeking a tool to browse Microsoft SQL database server in PHP like phpMyAdmin. Is there any open source known project that works with Remote Microsoft SQL Server? I found some php open source ...
5
votes
1answer
1k views

SQL server and client for Ubuntu (Debian) [closed]

I have been using MS IIS server and MS Sql client Management Studio at workplace on Windows system. My home system is a Ubuntu system and I like setup a database server and a client to interact with ...
0
votes
1answer
70 views

Flow Diagramming Software with SQL Server Connectivity

I am looking for software that can connect to an MSSQL Database and download a diagram. We are running SQL Server 2014. You used to be able to do this in Visio Professional, however they have ...
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 ...