Library tutorials & articles tagged with sql

• 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

• Filtering and Sorting in ADO.NET

  by Martin Zahn

  ADO.NET supports many ways to manage memory-resident data returned in a DataSet. This example demonstrates how to use the additional functionality exposed by ADO.NET to sort and filter data. c#, .net, ado.net, sql

• SQL Injection Attacks by Example

  by Stephen J. Friedl

  Steve 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. php, sql, db, security

• 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 MySQL with .NET

  by cardinals33

  Ever wanted to combine the power and ease of the .NET platform with a free database like MySQL? Well thanks to ODBC database functions in ADO.NET it's really easy. This article shows how. c#, mysql, 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

• MySQL Tutorial

  by Gez Lemon

  An introduction to using MySQL, from creating databases to modifying tables to creating and deleting rows. php, mysql, sql

• 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 In Simple English

  by Kiran Pai

  Kiran Pai introduces the basics of Structured Query Language in an Q & A session 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

• SQL vs DAO

  by James Crowley

  Performance differences between SQL and DAO visual basic, sql

• SQL Commands

  by James Crowley

  If you want to use databases, in VB, Access, ASP or anything else, at some stage you will need to learn SQL. This tutorial shows you how to use this powerful and universal language. sql