Solved

MS SQL Server Presentation Layer

Posted on 2014-12-03
7
305 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 79

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 83

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Java functions are among the best things for programmers to work with as Java sites can be very easy to read and prepare. Java especially simplifies many processes in the coding industry as it helps integrate many forms of technology and different d…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
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 SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

770 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