.Net

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.

2004-11-04

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.

2004-10-06

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.

2004-09-06

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

2004-07-02

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

2003-03-21

7,742 reads

Blogs

Using T-SQL Snapshot Backup - Are Snapshots Backups?

By

Introduction Traditional SQL Server backups can struggle with large databases, resulting in longer backup...

Developer Q&A: Dika Fei of Jelly Pixel Studio

By

"Let me know where you get your magic pixie dust from!"

A New Word: Flashover

By

flashover – n. the moment a conversation becomes alive and real, when a spark...

Read the latest Blogs

Forums

GIT Configuration and Automated Release for Azure Data Factory

By Sucharita Das

Comments posted to this topic are about the item GIT Configuration and Automated Release...

It's Time to Play

By Ryan Booz

Comments posted to this topic are about the item It's Time to Play

Call Dates Effective Range

By Yash34

Hi Everyone, I have the data in the below form : Desired output: Here...

Visit the forum

Question of the Day

Synapse Analytics History III

What was the originally name of the appliance that eventually became Azure Synapse Analyics?

See possible answers