UEU-co logo


[ Team LiB ]
Previous Section
Next Section

List of Exercises

Exercise 3.1 Monitoring Process CPU Usage

Exercise 3.2 Monitoring Thread Creation in SQL Server

Exercise 3.3 Listing Modules and Processes within SQL Server

Exercise 3.4 Exceptions in Extended Procedures

Exercise 3.5 Displaying Thread Information Using a Debugger

Exercise 3.6 Running SQL Server at Real-Time Process Priority

Exercise 3.7 Determining How SQL Server Sleeps

Exercise 3.8 Viewing Thread Priorities, Affinities, and Other Useful Information

Exercise 3.9 What Happens When Threads Aren’t Synchronized?

Exercise 3.10 Implementing a Kernel Mode Spinlock by Using a Mutex

Exercise 4.1 NULL Pointer References

Exercise 4.2 An Obscured NULL Pointer Reference

Exercise 4.3 A NULL Pointer Reference Due to a Memory Overwrite

Exercise 4.4 A GetSystemInfo Extended Stored Procedure

Exercise 4.5 Exploring the Process of Reserving Virtual Memory

Exercise 4.6 Reserving, Committing, and Releasing Virtual Memory

Exercise 4.7 Guarding Memory with the PAGE_GUARD Attribute

Exercise 4.8 Inspecting SQL Server Memory Allocations with VirtualQuery

Exercise 4.9 Overloading New and Delete to Allocate Memory from a Custom Heap

Exercise 4.10 Allocating Heaps within SQL Server

Exercise 4.11 Using Shared Memory to Share Data between Processes

Exercise 4.12 Using WinObj to View Named Shared Memory Objects

Exercise 5.1 A Simple Utility That Demonstrates Synchronous I/O

Exercise 5.2 A Utility That Converts a UNICODE Text File by Using Asynchronous I/O

Exercise 5.3 A String Search Utility That Uses Nonbuffered Asynchronous I/O

Exercise 5.4 A File Search Utility That Uses Scatter-Gather I/O

Exercise 5.5 A Multithreaded, Multifile Search Utility That Uses an I/O Completion Port

Exercise 5.6 A File Search Utility That Uses an I/O Completion Port for Both Input and Output

Exercise 5.7 Using Memory-Mapped File I/O to Perform a File Search

Exercise 5.8 A Multithreaded File Scanner That Uses Mapped File I/O

Exercise 6.1 A Find String Utility That Uses Named Pipes

Exercise 6.2 A Basic Socket Server and Client

Exercise 6.3 A Winsock Server App That Uses Win32 I/O Functions to Interact with a Client

Exercise 6.4 An fstring Variant That Works with Both Sockets and Pipes

Exercise 9.1 Inspecting SQL Server’s Use of Windows Networking API Functions

Exercise 11.1 Using WinDbg to Find the Buffer Pool

Exercise 18.1 Determining How MSXML Computes Its Memory Ceiling

Exercise 18.2 Determining Whether Server-Side FOR XML Uses MSXML

Exercise 18.3 Determining Where OPENXML Is Implemented

Exercise 18.4 Building and Consuming a SQLXML Web Service

Exercise 20.1 A Parameterized Package

Exercise 20.2 Creating a Custom DTS Task in Visual Basic

Exercise 20.3 Creating a New Custom Task by Using a Sample Task

Exercise 20.4 Debugging a Custom Task

Exercise 21.1 Running a Replication Agent from the Command Line

Exercise 22.1 Validating a Transactional Publication

    [ Team LiB ]
    Previous Section
    Next Section

    Leave a Reply

    Time limit is exhausted. Please reload the CAPTCHA.


    apply_now Pepperstone Group Limited