Library tutorials & articles tagged with sql server

• Spatial data in SQL Server 2008

  by Jason Follas

  Jason 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. sql server, sql server 2008, geometry, geospatial

• Dynamic Search Conditions in T-SQL

  by Erland Sommarskog

  A 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. sql, sql server

• SQL Trusted Connections with ASP.NET

  by Barry Dorrans

  Hard 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. .net, sql server, iis, asp.net

• Using SQL Server for ASP.NET session state

  by Barry Dorrans

  Learn 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. asp.net, .net, sql server, sql

• SharePoint, Document Library and SQL Server

  by S.S. Ahmed

  This 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. sharepoint, sql, sql server

• High-Performance .NET Application Development & Architecture

  by Dimitrios Markatos

  This 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. c#, asp.net, sql, vb.net

• To SP or not to SP in SQL Server

  by Douglas Reilly

  The 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 server, sql

• Tree structures in ASP.NET and SQL Server

  by James Crowley

  Takes 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. c#, asp.net, sql server, sql

• Using ADO.NET with SQL Server

  by James Crowley

  An 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. c#, .net, ado.net, sql

• Uploading Images to a Database

  by Dave Wanta

  Learn how to allow a user to upload an image to your server and store the binary data in a Microsoft SQL database. asp.net, sql server

• Identifying Your New Records

  by Bruce Johnson

  While 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. db, sql server

• Using Triggers to track database action history

  by Super Tal

  Tal Kelley demonstrates how to use triggers in SQL Server in order to keep track of who is modifying your database tables. sql server

• Using SQL-DMO To Backup and Verify a Database

  by Carvin Wilson

  The SQL Distributed Management objects (SQL-DMO) extend the functionality of SQL Server by providing developers a way to execute common tasks using programming and scripting languages. This article shows you how to use SQL-DMO to create an Active Server Page application to backup and verify a SQL Server database. sql server, sql

• SQL Distributed Management Objects Part 2

  by S.S. Ahmed

  Learn how to administer SQL Server remotely. visual basic, sql server, sql

• SQL Distributed Management Objects

  by S.S. Ahmed

  You 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. visual basic, sql server, sql

• SQL Distributed Management Objects

  by Carvin Wilson

  How to use the SQL Distributed Management Objects from ASP visual basic, asp, db, sql server

• SQL Server Locks

  by Michael Balloni

  SQL Server Lock Contention Tamed: The Joys Of NOLOCK and ROWLOCK visual basic, db, sql server, sql