SQL Server Tutorials & Articles
-
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.
-
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
-
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
-
Interview with Matthew Reynolds
by James CrowleyA technical Interview with Matthew Reynolds, author of Beginning E-Commerce with Visual Basic, ASP, SQL Server 7.0 and MTS
-
Introducing Windows Forms
by MicrosoftLearn about the new forms package, allowing developers to take full advantage of the rich user interface features available in Windows
-
Domain Driven Design: A Step by Step Guide - Part 1
by Casey CharltonThere is a lot of interest in DDD recently, both in the book, and in the methodology, and in the buzzword. Casey aims to clear up the confusion and start to demystify it.
-
Generate Thumbnail Images from PDF Documents in .NET
by Jonathan HodgsonThis article presents VB.NET code to create thumbnail images from a directory of Adobe Acrobat PDF documents using the .NET Framework.
-
To SP or not to SP in SQL Server
by Douglas ReillyThe topic of using or not using stored procedures reaches the level of religious fervor in many quarters. Douglas Reilly, a Microsoft MVP, weighs in on the topic with an in-depth analysis.
-
SQL Injection Attacks by Example
by Stephen J. FriedlSteve Friedl takes a look at how your site could be vulnerable to SQL injection attacks - complete with numerous examples - and the action you can take to prevent them.
-
Tree structures in ASP.NET and SQL Server
by James CrowleyTakes a look at how tree structures can be usefully stored in a relational database such as SQL Server, and how to implement web directory-like features such as breadcrumbs.
-
Introducing a post-relational database for .NET
by John SasakThis is a step by step guide for a post-relational database for .NET, Matisse. The article is aiming at helping developers quickly evaluate this alternative solution as .NET database when they face problems of productivity, flexibility, extensibility, or maintainability.
-
Using ADO.NET with SQL Server
by James CrowleyAn extensive examination of using ADO.NET to access SQL Server databases, from establishing connections and executing stored procedures, to connection pools, data readers and data sets.
-
.NET Data Caching
by Dimitrios MarkatosAn introduction to using data caching in your ASP.NET pages, from simple time-specific data expiration to file dependencies, plus a real-world example with caching for data in a pagable DataGrid control.