SQL Server is a relational database management system from Microsoft.

learn more… | top users | synonyms (1)

2
votes
4answers
972 views

Write data to SQL Server directly from BizTalk or use external service?

An external source will be sending us XML data that BizTalk will pick up and transform into an internal schema. We need this data to be loaded into a SQL Server database as we're going to expose some ...
3
votes
1answer
191 views

.NET DataSource binding for legacy SQL Server DB with undefined relationships

I'm designing a utility that will load data into a legacy SQL Server Database. I've been trying to mock up a simple WinForms utility with C# using the DataSource connectors (Tried a straight ORM ...
1
vote
1answer
38 views

Database Object That Reads From Two Tables and Writes to One

I am updating a database design that must be compatible with old and new applications. My goal is to make a design change which minimizes impact on the existing code. The Design Change Currently our ...
1
vote
1answer
47 views

How to model the database tables for calculating on peak and off peak usage data

I am using MS Sql Server and my system contains power usage data in one table as timestamp and values for KW(two columns). This data is collected at 1 hour interval. At the end of the month I need to ...
-4
votes
1answer
71 views

Migrating MYSQL functions and stored procedures to SQL Server

The company i'm working for is selling HRIS management software. It was built using ASP and mysql. But one of our client's demand is for it to be based on MS SQL Server. our team is made up mostly of ...
2
votes
0answers
53 views

ODBC 3 Multiple Statements vs Multiple Connections

So right now I have a single thread to handle all the requests for the database. Let's say I have 400 requests per second for logins / logouts / other stuff, and 400 requests per second which are only ...
2
votes
0answers
91 views

Integrate MS Dynamics AX with Play Framework

In my company we use MS Dynamics AX 2009. This is the ERP of the company. We have around 100 users. The servers of MS Dynamics AX are in the headquarters company. We are developping a new website ...
1
vote
0answers
37 views

Better dynamic user permissions

I support an Internal ERP system and an external Reporting/Dashboard that our customers use that both use the same database. Internal normal application users can control what customers can access ...
1
vote
0answers
44 views

SQL - Locating closest value in a set

I have a table that contains the percentiles from a reference data set. CREATE TABLE [Core].[RiskFactor]( [SpecialtyCode] [char](2) NOT NULL, [RiskCategoryId] [int] NOT NULL, [Percentile] [tinyint] ...
1
vote
0answers
25 views

Offsetting high usage in a multi-tenant database environment?

I'm writing a research essay over distributed cloud-based systems, and one of the topics that I'm trying to touch on is potential solutions to high database utilization in a single-database ...
1
vote
0answers
39 views

Managing shared storage in a high availability environment

I have an application with a custom high availability (HA) feature that provides automatic failover from an active primary server that experiences a failure to a passive backup server. To date, this ...
1
vote
0answers
171 views

Software License for project using .NET and Sql Server Express

I considering making my application open source on github. I don't intend to sell it (neither in binary form nor source code form). It probably isn't even useful to a lot of people except maybe for ...
0
votes
0answers
45 views

Authenticate to a SQL Server with Active Directory credentials from a UWP app

I've been tasked to design an application and a database to store information our company's electricians have measured on-site. We need to save in our database who exactly did which measurement. ...
0
votes
0answers
499 views

How to handle field level Acces Security when using Entity Framework

Scenario: a large existing system (~300 tables, 500 stored procs, 200 views and a code base of several 100k lines) with most security level stuff in stored procedures needs to be refactored (for ...
-1
votes
0answers
22 views

SQL Server - Fetch data

Project Case: Send sms communication on Parent's mobile number on the birthday of either Student or Parent for ACTIVE courses. Data Model: Following four tables are in picture here. Course Role table ...
-2
votes
0answers
52 views

How can I place an SQL Server query result into an array and then extract specific values from the array in PHP?

I have an SQL Server database which runs the following query: SELECT t_Addresses.Coord_X, t_Addresses.Coord_Y, t_Addresses.Cust_ID INTO #temptable --Hash prefix specifies a temporary table FROM ...
-2
votes
0answers
27 views

How to use a relative path in sqlcmd script

Can someone tell me how to swap this absolute path with a relative one for my sqlcmd upgrade script? -- how can I get rid of the following absolute path? :SETVAR ScriptDir "C:\absolutePath\" ...