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
43 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 ...
7
votes
2answers
11k 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
43 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
157 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
3answers
202 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
384 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
24k 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
0answers
103 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
169 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
77 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, ...
4
votes
2answers
456 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 ...
4
votes
1answer
136 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
228 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
7k 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
27 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
108 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
1answer
64 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
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
1answer
102 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
79 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
64 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 ...
1
vote
1answer
72 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 ...
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. ...
2
votes
2answers
68 views

Tool for deploying web-project to the server

I don't need a recommendation, but need a tool name or, at least, a name of such tools (probably, language barrier). I am looking for a tool which will help me to deploy a project to the server. ...
15
votes
1answer
1k views

Replacement for MS Access, very rapid development

Background: I have an Access-software (~30 simultaneous users) with split front- & back-end, both UI & DB running on Access-files. Most important features for me are reports & printing, ...
2
votes
1answer
92 views

Geo Mapping tied to an SQL Database

First a little background on this project. Our company has developed a web page for our Inside Sales team that lets them enter a Zip Code and it returns the District Manager that is responsible in ...
3
votes
2answers
95 views

Access to SQL-database, SQL-rapporting

I am looking for software that allows non-sql users to access an SQL-database, and set up data exports fast and easy. Background: My company has a lot of data in our SQL-database. We do not have ...
8
votes
3answers
281 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 ...
2
votes
3answers
128 views

RDBMS for newbies in IT

I need to teach my two interns how to use RDBMSes in general and "standard" SQL during their free time, using the outdated windows notebooks we have laying around. They come from math courses and have ...
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" ...
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....

1
2