- Querying SQL with LINQ
- 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
- 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
- Apr 9, 2008
- Build database-driven ASP.NET applications by taking advantage of LINQ to SQL.
|
- Generating Atom Feed from SQL Data
- 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
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
- 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
- Oct 19, 2007
- Increase the speed of your SQL queries and updates.
|
- Serve SQL Data in XML Format
- 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
- 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
- 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
- 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
- Oct 13, 2006
- Hilary Cotter provides a tutorial on how to set up Web synchronization in SQL 2005.
|
- PostgreSQL SQL Syntax and Use
- 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#
- 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
- 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
- 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
- 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
- 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
- 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
- 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.
|