SQL Server Web Service

The estimated reading time for this post is 1 minutes

SQLServerWebService LogoSQL Server Web Service is external software that enhances SQL Server abilities in order to provide proper web service with minimal development and administration effort. This software generates the web service codes dynamically and creates the assembly on memory for flexibility purposes. We are specialized in SQL Server database development and administration, and we are able to develop software to extend the SQL Server ability. By this software every SQL Server databases can expose their stored procedures as web method and let third party software consume the data. Be aware that web service security is managed by SQL Server itself.

Features:

  • Easy installation steps on SQL Server instances.
  • Easy administration steps for pure DBAs.
  • Transport channel and data is encrypted and signed in the generated web service.
  • The user authentication and authorization is managed by SQL Server.
  • It is able to generate web method for every stored procedure in the target database.
  • It is able to host multiple web services at same time.
  • It is able to export the web service assembly as DLL file.
  • It is able to filter specific stored procedures.
  • It is able to rebuild and restart every web service easily when the web service is published.
  • It is able to distribute all modified and new data in every specific table automatically.(New)
  • It can generate web methods base on specific user privileges. (New)
  • It uses Net.TCP protocol to increase the web service performance and security. (New)
  • All data transferred through network is compressed. (New)

Software Requirements:

  • Microsoft .Net Framework 3.5 or later.
  • Microsoft SQL Server 2008 or later.
  • Microsoft Windows XP SP3, Windows 7, Windows Server 2008, Windows Server 2008 R2 or Windows Server 2012.

Hamid J. Fard

I am SQL Server Data Platform Expert with more than 9 years’ of professional experience, I am currently Microsoft Certified Master: SQL Server 2008, Microsoft Certified Solutions Master: Charter-Data Platform, Microsoft Data Platform MVP and CIW Database Design Specialist. I also do Pig, Hive and Sqoop development regarding Hadoop Big Data platform. After a few years of being a production database administrator I jumped into the role of Data Platform Expert. Being a consultant allows me to work directly with customers to help solve questions regarding database issues for SQL Server.

More Posts

Follow Me:
FacebookLinkedIn