Home > Articles > Data > SQL Server

SQL Server

179 Items

Sort by Date | Title

SQL Server Forensic Investigation Scenario
Apr 13, 2009
This chapter walks through an actual forensic investigation scenario, showing the logical progression of events during an investigation.
What Is Integration Services and Why Do I Need It?
Mar 9, 2009
Kirk Haselden provides a brief introduction to SQL Server 2008 Integration Services.
Normalizing a Data Model in SQL Server 2005 and 2008
Jul 7, 2008
This chapter gives you the tools necessary to identify the current state of your data, set your goals, and normalize (and denormalize) your data as needed.
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.
Implementing Access Controls on SQL Server Data
Mar 14, 2008
Provide fine-grained access control to individual records in the most sensitive tables of your database.
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.
Relational Databases 101
Sep 14, 2007
Design relational databases that can perform better, be easier to maintain, and be more successful.
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.
Relational Databases 101
Dec 29, 2006
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.
Practical Business Intelligence with SQL Server 2005: Data Mining
Nov 10, 2006
This sample chapter looks at how to use some of the data mining features in SQL Server Analysis Services 2005 to perform tasks such as customer segmentation and market basket analysis.
SQL Server 2005 Transactional Replication Agents
Oct 20, 2006
SQL Server 2005 replication agents are configured optimally out of the box, but occasionally you might need to alter the default behavior by tweaking the agent's parameters. Baya Pavliashvili encourages you to learn the new options available with each replication agent and how to fine-tune these options for your applications.
Migrating from Data Transformation Services to Integration Services in SQL Server
Sep 22, 2006
The question on most SQL Server Data Transformation Services (DTS) users' minds is how Integration Services (IS) will affect their current packages. The answer is both simple and complex. Kirk Haselden explains the available resources for performing migrations from DTS to IS and some of the problems you might encounter.
Replicating Code Modules with SQL Server 2005
Sep 15, 2006
As with previous releases of the software, SQL Server 2005 enables you to replicate code modules. Baya Pavliashvili gives you an overview of replicating code modules and explains when it is beneficial to do so.
Monitoring and Troubleshooting Replication Using SQL Server 2005
Sep 1, 2006
Replication Monitor is a fine monitoring and troubleshooting tool included with SQL Server 2005. In this hands-on article, Baya Pavliashvili discusses ways in which the replication monitoring tools have improved significantly with SQL Server 2005, as compared with previous releases.
Maintaining Transactional Replication with SQL Server 2005
Aug 18, 2006
Baya Pavliashvili demonstrates the steps necessary to maintain a typical SQL Server 2005 publication, and explains how new options for delivering data changes can help you tailor a replication solution to your application's needs.
Setting Up Transactional Replication with SQL Server 2005
Aug 11, 2006
Baya Pavliashvili walks us through the use of the SQL Server 2005 wizards and scripts for setting up transactional replication and points out some of the cool new features of the latest version.

< Prev Page 1 2 3 4 5 Next >