Technical Article

WebService - Enabling SQL Server 2005 Procedures

  • Article

One of the most interesting features that I'll explore is that you can now create WebServices in the database tier directly, without resorting to "add ons" or even the use of IIS at all. One of the many extensions to Transact SQL is the new CREATE ENDPOINT statement, which allows the developer to create an endpoint directly from SQL Server 2005, which hooks right into the Kernel Mode HTTP.SYS driver, exposing functions and stored procedures written either in T-SQL or native CLR methods/classes.


3,131 reads

Technical Article

Optimized ADO.NET

  • Article

This article contains guidelines compiled by examining the .NET implementations of shipping .NET applications and analyzing the common performance mistakes that we found. The guidelines discuss selecting .NET objects and methods, designing .NET applications, retrieving data, and updating data.


3,043 reads

Technical Article

Schemas in ADO.NET 2.0

  • Article

When you decide on a connection string and add a Data Connection, each Data Connection also displays a tree of information about the database objects (like tables, views, and stored procedures) visible directly through the connection. But where does this information come from? Read this article from MSDN on the new features of ADO.NET.


853 reads

SQLServerCentral Article

SQL Server Express

  • Article

SQL Server Express 2005 is a new product that has been released (in Beta) as a followon to the MSDE product. A number of new features as well as complementary products for all of the .NET development tools are now available. Read on for a quick summary of what this new product line is all about.

You rated this post out of 5. Change rating


14,176 reads

SQLServerCentral Article

We Studied, We Passed, Was It Worth It?

  • Article

Several months ago Andy posted a 'Review of Developing Windows Based Applications for VB.Net and C#.Net' and mentioned that his company was requiring all developers to achieve the MCAD within 12 months. Read this to find out how the first exam went, how they studied, what they achieved, and their plans for taking the rest of the exams.

You rated this post out of 5. Change rating


7,742 reads


How I implemented database migration on AWS using AWS DMS


As a Software Engineer, I would like to replicate a copy of my database...

My personal experience dockerizing a Rust Application: Deploy to AWS ECR using Github Actions


I have heard about many interesting things about programming in Rust and I decided...

Terraform Elastic Jobs


I did a couple of other posts on Elastic Jobs. But now I want...

Read the latest Blogs


Unable to add the database back into AG

By LearningDBA

I took the full backup of the DB Backup database MyDB to disk =...

Planes, Trains, and Automobiles

By Ryan Booz

Comments posted to this topic are about the item Planes, Trains, and Automobiles

How do I get a certificate for a SQL Server database?

By Doctor Who 2

I'm working on a new application at home, using SQL Server 2019 Developer Edition....

Visit the forum

Question of the Day

Synapse Analytics History I

Before Synapse Analytics was a service in Azure, what was the name of the analytic data warehouse platform in the Azure cloud?

See possible answers