Solved

MS SQL Server Presentation Layer

Posted on 2014-12-03
7
298 Views
Last Modified: 2014-12-06
What is the most common technology used to build the presentation layer for  MS SQL Server?
Is it visual studio?
0
Comment
Question by:Benki Canoso
7 Comments
 
LVL 65

Assisted Solution

by:Jim Horn
Jim Horn earned 50 total points
ID: 40479791
There is no presentation layer for SQL Server, as it's a database only, and I'm not aware of any limitations for front-end applications to use SQL Server versus any other database.

Tell us what you're trying to pull off here in more detail, and we'll see what we can cough up.
0
 

Author Comment

by:Benki Canoso
ID: 40479861
I am just trying to know if Visual Studio is the most typical interfacing tool used as the front-end? I just want to become more familiar with the front-end options used for MS SQL Server.
Thanks.
0
 

Author Comment

by:Benki Canoso
ID: 40479870
One of the reason I wan to know about the front-end options for SQL Server is because if I want to build a query that requires a user input, I do not believe I am able to test it right on SQL Server environment. If I may, how do you normally test queries that require user input on SQL Server?
0
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 
LVL 78

Assisted Solution

by:David Johnson, CD, MVP
David Johnson, CD, MVP earned 150 total points
ID: 40480004
SQL Management Studio is good for limited testing and for of course,management of Sql Server.
For a User interface you can use anything that can talk to sql server.Excel,Access,Visual Studio (pick your language and project type (windows form, wpf, web, console app) .. at a database level SSRS, SSIS (reporting services/integration services), this is far from an exhaustive list.. Don't forget that SQL Server clients are not limited to the Windows Operating System. Just anything that can access tcpip port 1433..  For a windows client I'd use Visual Studio but that is only MY preference.
0
 
LVL 40

Accepted Solution

by:
Jacques Bourgeois (James Burger) earned 250 total points
ID: 40480010
Yes. The front end that is used the most is Visual Studio.

The more obvious reason is that both are Microsoft technologies, so they can more easily work together than technologies from 2 different companies.

But the main reason is the very intimate integration between both of them. Microsoft has designed them to work together.

SQL Server installs with a simplified version of Visual Studio to enable programmers to build code into the database itself when they need to do stuff that is not possible or too difficult to do in Transact-SQL.

On the other side, Visual Studio comes with tools that lets you work without your server. You can create databases, tables, stored procedures, you name it, directly in Visual Studio. The SQL Server debugger integrates into Visual Studio so that you can debug your stored procedures directly in Visual Studio, with tools that work almost the same way as those you use to debug your VB or C# code.

No other front end provides that level of interrelation with SQL Server.
0
 
LVL 82

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 50 total points
ID: 40480146
As another alternative, PHP on Windows and on Redhat Linux with the Microsoft driver is quite capable of interfacing and displaying queries from SQL Server.  This is the current driver info: http://php.net/manual/en/book.sqlsrv.php  You can also use the old driver on Linux but it does not support all the features of the newer versions of SQL Server.
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Introduction This article is the last of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers our test design approach and then goes through a simple test case example, how …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now