SQL Tutorials & Articles
-
Microsoft Indexing Service and ASP.NET
by Barry DorransMicrosoft Indexing Service is a service that provides a means of quickly searching for files on the machine. Barry investigates how we can use the indexing service to expose full-text searching in ASP.NET.
-
Creating Applications for Handheld Devices Using eMbedded Visual Basic
by Rob BickelA no nonsense tutorial designed to give Visual Basic developers an insight into developing VB applications for handheld devices such as PDAs.
-
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.
-
Custom ASP.NET Datagrid Paging With Exact Count
by Dimitrios MarkatosA demonstration on creating custom DataGrid paging such that we actually know the total number of pages for a result set - something that the default paging for the DataGrid doesn't tell us.
-
SQL In Simple English
by Kiran PaiKiran Pai introduces the basics of Structured Query Language in an Q & A session
-
LINQ to Objects for the .NET developer
by Mike JamesMike James explains that LINQ isn’t just for SQL programmers but is usable by every .NET developer. Learn how take the power of LINQ queries to your every-day coding through the lowly IEnumerable interface.
-
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
-
ActiveX Data Objects
by TahoniLearn about ADO in VB and ASP, and how to create connectionless recordsets in this tutorial from Tarhoni of Wali Systems Inc.
-
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.
-
Testing for Security in the Age of Ajax Programming
by Bryan SullivanAjax programming, which allows a web page to refresh a small portion of its data from a web server, is an exciting technology that has recently been introduced. However, this type of programming can also leave applications open to SQL injection and similar attacks. Learn more about Ajax programming and what it means in terms of security.
-
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.
-
Replicating GetRows in .NET
by Dimitrios MarkatosDimitrios explains how replicating GetRows in .NET is easy and shows how it offers precise control of the details of the data and its display.
-
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.
-
Bluffer's Guide to C# 3
by Jon SkeetPretend you know what you're talking about in suitably geeky company. More seriously, it will give you a very rough overview to give some context if you choose to investigate a particular feature further.
-
Developing for Office 2007
by Matt NicholsonThe forthcoming 2007 Microsoft Office System offers many new opportunities for software developers. Matt Nicholson looks at the new user interface and the Open XML file format, finds out what's happened to VSTO, and explores the possibilities opened up by SharePoint Server 2007 and Groove 2007.