SQL Server Tutorials & Articles
-
Creating a database connection
by Tony HoCreating connections and all your data objects are really easy Design-Time, but what if you need it for runtime? Here's how.
-
ActiveRecord for Ruby and Rails
by Kevin JonesKevin Jones explains how ActiveRecord works in Rails, and in a standalone Ruby application.
-
Concurrency handling techniques in ADO.NET
by Joydip KanjilalJoydip Kanjilal looks at the problems caused by concurrency when accessing data, both online and offline, and how to overcome them.
-
VB 6 Tutorial
by James CrowleyCompletely new to Visual Basic? Overwhelmed with the confusing instructions? Read this tutorial and get a head start - learn what VB is, what you can do with it, how much it costs, and how to get star
-
Iterator blocks in C# 2: auto-generated state machines
by Jon SkeetEver wondered how the magic "yield" statement works? Jon Skeet digs into the inner workings of C# 2.0 and how this innocuous statement gets you a whole load of "free" generated code for your iterators.
-
SLOBbing about with .NET
by Dave WheelerPersisting objects is all about SLOB (serialized large objects), or so says Dave Wheeler who explains how it's now all so much easier.
-
How to access Outlook and post to a blog using C#
by Simon SoanesAn article for all those like Robert Scoble who would like to be able to drag and drop an item to a folder in their Outlook and post it instantly to their Blog. We also briefly cover web services and talking to Outlook.
-
Uploading Images to a Database
by Dave WantaLearn how to allow a user to upload an image to your server and store the binary data in a Microsoft SQL database.
-
Reading, Storing and Transforming XML Data in .NET
by Dimitrios MarkatosThis article illustrates a mixture of common .NET methods for formatting and presenting in a readable fashion any XML document you may encounter. The latest hype with XML Web Services and even the .NET Framework itself relies on XML as its backbone, therefore this is no light matter.
-
Dynamic Search Conditions in T-SQL
by Erland SommarskogA very common requirement in an information system is to have a function (or several functions) where the users are able to search the data by selecting freely among many possible criterias. In this text I will look at various techniques to solve this problem.
-
Locking the Door behind You: Hacker Protection for Your Web Applications
by Caleb SimaYour Web applications can be the most important and most vulnerable entry point into your organization, and, as such, ensuring adequate hacker protection in your Web applications can be critical. This article discusses some of the issues.
-
SQL Trusted Connections with ASP.NET
by Barry DorransHard coding passwords into your application or your web site is a bad thing. Barry looks at how we can use trusted connections to provide the authentication we need, without the need for these potential security hazards.
-
Implementing two-way Data Binding for ASP.NET
by Rick StrahlASP.NET simplifies many things but data binding simple controls like textboxes and checkboxes leaves a lot to be desired. Databinding is one-way only and you end up doing lots of repetitive work to publish your data. In this article I'll show you how simple databinding in .Net works and then show how to create custom controls that implement two-way binding to make short work of creating databound forms.
-
Identifying Your New Records
by Bruce JohnsonWhile the use of AutoNumber and Identity fields in tables is greatly applauded by database designers the world over, they can be annoying for developers to use. This article reveals two techniques for retrieving the value of an AutoNumber/Identity field.
-
ADO Data Control
by Susan HarkinsLearn everything you need to know about using the ADO Data Control
-
Using SQL Server for ASP.NET session state
by Barry DorransLearn how you can use an alternative session storage method, using SQL Server - very useful if you're running sites across multiple servers, or need session state to persist across application restarts.
-
Top 10 Application Security Vulnerabilities in Web.config Files - Part One
by Bryan SullivanIn part one of this two part article, you will learn about five of the top ten “worst offenders” of misconfigurations of application security that can cause overall problems for ASP.NET Web-based applications. Learn more about how to secure the Web.config files of an ASP.NET application.
-
New features for web developers in ASP.NET 2.0
by Alex HomerASP.NET 2.0 brings enhanced performance and many new features that make the web developer's life easier. Alex Homer takes you through what's new.
-
Floating-Point in .NET Part I: Concepts and Format
by Jeffrey SaxThe first in a three part series, this article introduces the basic concepts of floating-point arithmetic: number formats, accuracy and precision, and round-off error. It includes an in-depth discussion of the .NET floating-point types.
-
Spatial data in SQL Server 2008
by Jason FollasJason takes you back to those high school geometry lessons and demonstrates how to take advantage of the new geospatial and geometric data types in SQL Server 2008.