Home > Sample chapters > Servers > SQL Server

SQL Server

24 Items Sort by date|Sort by title
21.

DML and DDL Triggers in in Microsoft SQL Server 2008

  • Nov 12, 2008
  • Learn how to create DML triggers that execute when you add, modify, or remove rows in a table, in this lesson from Microsoft SQL Server 2008 Step by Step. You will also learn how to create DDL triggers that execute when DDL commands are executed or users log in to an instance.
22.

Data Warehousing in Microsoft SQL Server 2008

  • Oct 29, 2008
  • This chapter from Programming Microsoft SQL Server 2008 explains what data warehousing is and why you should care about it, and then shows how to take advantage of specific Microsoft SQL Server 2008 data warehousing features.
23.

Table Expressions in Microsoft SQL Server 2008 T-SQL

  • Oct 22, 2008
  • The focus of this chapter from Microsoft SQL Server 2008 T-SQL Fundamentals is SELECT queries against table expressions. This chapter also introduces the APPLY table operator used in conjunction with a table expression.
24.

Extracting and Loading Data in Microsoft SQL Server 2005 Integration Services

  • Jun 20, 2007
  • Learn how to set up a new Microsoft SQL Server Integration Services (SSIS) project, add a data flow task to extract data from a source, and load the results into a destination in this chapter from Microsoft SQL Server 2005 Integration Services Step by Step.