Home > Articles > Data > SQL

SQL

RSS Feed Subscribe to this topic  RSS details

83 Items

Sort by Date | Title

Querying SQL with LINQ
By Paul Kimmel
Jul 28, 2008
With LINQ and LINQ to SQL, never again should you have to write a data access layer.
Managing Database Objects in SQL
By Arie D. Jones, Ron Plew, Ryan Stephens
Jul 1, 2008
This chapter discusses what database objects are, how they act, how they are stored, and how they relate to one another.
Using LINQ to SQL in an ASP.NET Application
By Stephen Walther
Apr 9, 2008
Build database-driven ASP.NET applications by taking advantage of LINQ to SQL.
Generating Atom Feed from SQL Data
By Ivan Pepelnjak
Mar 31, 2008
Ivan Pepelnjak describes how you can create an Atom feed directly on the SQL Server with Transact SQL commands.
SQL Queries for Mere Mortals: Thinking in Sets
By John L. Viescas, Michael J. Hernandez
Nov 30, 2007
This sample chapter discusses the concept of a set along with each of the other major set operations in SQL.
Administering the SQL Server 2005 Database Engine
By Alec Minty, Chris Amaris, Ross Mistry, Rand Morimoto
Nov 2, 2007
Learn to administer the Database Engine component and manage the SQL server properties and database properties.
XML Handling in Microsoft SQL Server 2005
By Ivan Pepelnjak
Oct 19, 2007
Increase the speed of your SQL queries and updates.
Serve SQL Data in XML Format
By Ivan Pepelnjak
Sep 28, 2007
Learn how to extract data from SQL databases and serve it to an AJAX application running in a web browser.
Using CLR Integration in SQL 05 for Writing Stored Procedures
By Jesse Smith
Apr 13, 2007
Join Jesse Smith to learn more about writing stored procedures using a .NET-based language with SQL Server 2005.
Inside SQL Server 2005 Management and Administration Tools
By Dima Sonkin, Thierry D’Hers, Kami LeMonds, Michael Raheem
Dec 22, 2006
SQL Server Management Studio is a rich and comprehensive tool that enables many management and administration scenarios. This sample chapter provides some tips and tricks for using the tool, straight from the Microsoft team that created it.
SELECT Statement: The GROUP BY Clause in SQL
By Rick F. van der Lans
Nov 17, 2006
Rick F. van der Lans explains how SQL's GROUP BY clause groups rows on the basis of similarities between them. He goes on to explain the use of adding aggregation functions to display summations, averages, frequencies, and subtotals.
SQL 2005 Web Synchronization for Merge Replication
By Hillary Cotter
Oct 13, 2006
Hilary Cotter provides a tutorial on how to set up Web synchronization in SQL 2005.
PostgreSQL SQL Syntax and Use
By Korry Douglas
Sep 9, 2005
This chapter covers the basic operation of PostgreSQL, including naming conventions, creating a database, and indexing. When you finish with it, you should be able to use PostgreSQL for most basic functions.
Loading Images into SQL Server with C#
By Jesse Smith
Jul 8, 2005
As your web site grows and images multiply, storing those images on the hosting server's hard drive can turn a zippy hare of a site into a pokey tortoise. (Yes, they get there eventually, but users are impatiently waiting for a "photo finish"!) Jesse Smith provides a set of simple C# scripts that you can use to pop your images into your SQL Server database, for faster image retrieval and better load balancing on your site.
MySQL Overview and New Performance-Related Features
By Robert Schneider
Jun 24, 2005
This chapter provides an overview of the various MySQL iterations, and how they are covered within the rest of the book, along with the environments in which they were used for the book. Finally, there is a list of performance enhancements and the version of MySQL in which they were introduced.
XML Data to SQL Data: There and Back Again
By Jesse Smith
Jun 17, 2005
Jesse Smith shows you how to use SQL Server 2000 to convert relational data to XML and vice versa, giving your applications easy XML support and compatibility.
Getting Started with MySQL and SQL
By Paul Dubois
Apr 1, 2005
Perfect for SQL novices, this chapter provides an introduction to the MySQL relational database management system (RDBMS), and to the Structured Query Language (SQL) that MySQL understands.
The Simplest SQL Notification Application: Stock Quotes
By Shyam Pather
Oct 8, 2004
This chapter by Shyam Pather introduces you to the basics of SQL-NS and shows you how coding in this environment works.
SQL Server Log Shipping
By Baya Dewald
Aug 20, 2004
Baya Pavliashvili gets you started with log shipping (ensuring failover capability, not moving lumber) by discussing its advantages and drawbacks, and then shows you how to set up log shipping and how to fail your database over to the standby server.
SQL Building Blocks and Server Settings
By Deac Lancaster
Aug 6, 2004
This chapter covers the building blocks available to the database designer and database user to create and modify database objects and data. The SQL Data Types will be covered along with data representation as literals (constants) and expressions.

< Prev Page 1 2 3 4 5 Next >