Database Tutorials & Articles
-
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.
-
Surviving the Release Version
by Joseph M. NewcomerOK, you've built the project, debugged it, and you're ready to ship. You compile the Release version of the program, and your world crumbles to dust. Find out what can be wrong, and what you can do about it.
-
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.
-
SharePoint, Document Library and SQL Server
by S.S. AhmedThis tutorial shows how you can capture a document in SharePoint's document library, retrieve information from its properties and store in in SQL Server. It will teach you how to use Event Handler Toolkit.
-
High-Performance .NET Application Development & Architecture
by Dimitrios MarkatosThis article demonstrates the art of creating and architecting high-performance and scalable .NET applications, covering all stages, from planning to development and their perspective best practices.
-
DataGrid/GridView Paging and Sorting Using A DataReader
by Dimitrios MarkatosThis article will demonstrate two ways one could implement the DataReader to bind a DataGrid, that includes caching, paging and persistent bi-directional sorting, all without the use of a DataAdapter/DataSet at all, and includes ASP.NET 2.0 GridView version!
-
Selecting, Confirming & Deleting Multiple Checkbox Items In A DataGrid (i.e. HotMail & Yahoo)
by Dimitrios MarkatosIn this article, we will examine how to create a fully functional DataGrid with all the features you'd find set up on Hotmail or Yahoo. As an added bonus we'll be performing all of our data tasks strictly utilizing Microsoft's new Data Access Application Block or DAAB v2.
-
Implementing ODBC in ASP .NET
by Jason G. WilliscroftWith Microsoft's ODBC data server controls, .NET finally supports ODBC... but not very well. HotQuant, LLC, has published an in-depth technical article demonstrating an effective workaround.
-
XML Strengths & Weakness’ with DOM, ASP & XSL
by Nakul GoyalNakul Goyal introduces the XML technology, and how it can be used in your ASP and Visual Basic programs.
-
SQL Distributed Management Objects
by S.S. AhmedYou will learn how to administer SQL Server remotely. I have selected VB to develop a component that will be used in ASP scripts to harness the power of SQL-DMO.
-
Implementing Error Logging
by Carvin WilsonHow to implement error logging in ASP 3.0
-
Password Program in ColdFusion
by Julia Lynne GreenThis program provides clues, automatic messaging systems for lost passwords etc.
-
Creating a Members Area in ASP
by James CrowleyA complete tutorial on how to create your own 'members-only' area on your website.
-
SQL Server Locks
by Michael BalloniSQL Server Lock Contention Tamed: The Joys Of NOLOCK and ROWLOCK