FileBeta

Delve inside the core SQL Server engine—and put that knowledge to work—with guidance from a team of well-known internals experts. Whether database developer, architect, or administrator, you’ll gain the deep knowledge you need to exploit key architectural changes—and capture the product’s full potential.

Discover how SQL Server works behind the scenes, including:

• What happens internally when SQL Server builds, expands, shrinks, and moves databases
• How to use event tracking—from triggers to the Extended Events Engine
• Why the right indexes can drastically reduce your query execution time
• How to transcend normal row-size limits with new storage capabilities
• How the Query Optimizer operates
• Multiple techniques for troubleshooting problematic query plans
• When to force SQL Server to reuse a cached query plan—or create a new one
• What SQL Server checks internally when running DBCC
• How to choose among five isolation levels and two concurrency models when working with multiple concurrent users

More Info:

http://www.amazon.com/exec/obidos/tg/detail/-/0735626243/

Continue Reading »

Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples to master the intricacies of this programming language—solving complex problems with real-world solutions.

Discover how to:

Work with T-SQL and CLR user-defined functions, stored procedures, and triggers.
Handle transactions, concurrency, and error handling.
Efficiently use temporary objects, including temporary tables, table variables, and table expressions.
Evaluate when to use set-based programming techniques and when to use cursors.
Work with dynamic SQL in an efficient and secure manner.
Treat date- and time-related data in a robust manner.
Develop CLR user-defined types and learn about temporal support in the relational model.
Use XML and XQuery and implement a dynamic schema solution.
Work with spatial data using the new geometry and geography types and spatial indexes.
Track access and changes to data using extended events, SQL Server Audit, change tracking, and change data capture.
Use Service Broker for controlled asynchronous processing in database applications.
All the book’s code samples will be available for download from the companion Web site.

More Info:

http://www.amazon.com/exec/obidos/tg/detail/-/0735626022/

Continue Reading »

A hands-on resource for SQL Server 2008 troubleshooting methods and tools

SQL Server administrators need to ensure that SQL Server remains running 24/7. Authored by leading SQL Server experts and MVPs, this book provides in-depth coverage of best practices based on a deep understanding of the internals of both SQL Server and the Windows operating system.

You’ll get a thorough look at the SQL Server database architecture and internals as well as Windows OS internals so that you can approach troubleshooting with a solid grasp of the total processing environment. Armed with this comprehensive understanding, readers will then learn how to use a suite of tools for troubleshooting performance problems whether they originate on the database server or operating system side.

• Shows how to develop a methodology for troubleshooting based on a thorough understanding of SQL Server 2008 and Windows OS internals
• Covers mastering specific troubleshooting tools and interpreting their output so that you can quickly identify and resolve any performance issue
• Details all the free and proprietary tools that allow you to analyze and determine the source of a system-wide performance problem
• Examines how it is critical for both SQL Server and Windows technologies to run smoothly in order to ensure effective SQL Server performance

This practical guide will help you pro-actively monitor and avoid SQL Server problems.

More Info:

http://www.amazon.com/Professional-Server-2008-Internals-Troubleshooting/dp/0470484284/

Continue Reading »

Microsoft SQL Server Integration Services is Microsoft’s powerful platform for building enterprise-level data integration and data transformation solutions. It’s a powerful product, but it’s also complex and can be confusing if you don’t have a clear map for the journey. Microsoft SQL Server 2008 Integration Services Unleashed will be the only book you’ll need to harness the power that Integration Services provides.

Through clear, concise explanations and samples, you’ll grasp a clear understanding of working in the Integration Services environment, including how to set up stock components, how to use the various designer features, and how to gain practical knowledge on configuring, deploying, securing, and managing packages. Sample packages are provided to reinforce the discussion and quickly help you gain hands-on experience, and more complex topics such as Data Flow Task internals and tuning, advanced transformations, and writing custom components are all illustrated in easy-to-understand graphics. In addition, there are several custom tasks and transformations and two useful utilities with full source code available for you to use and study, including an ADO.NET destination, a text file encryption task, and a data profiling transform.

Detailed information on:

• Using the powerful Integration Services tools to create solutions without the need to write lines of code
• Creating packages programmatically or developing custom tasks via the Integration Services object
• Building robust packages to solve common requirements
• Securing packages for different environments
• Using often overlooked or unknown platform features
• Setting up all the stock components, including data flow components, tasks, Foreach enumerators, connection managers, and log providers
• Writing robust and useful custom tasks
• Building packages that seamlessly deploy to other environments
• Writing custom data flow adapters and transforms
• Using script tasks and components
• Easily modifying configurations for multiple packages simultaneously
• Writing a Task UI that looks just like the stock tasks
• Tapping into the power of Integration Services for accessing heterogeneous data sources
• Using expressions to make packages more responsive to the environment
• Migrating your DTS packages with no stress

Kirk Haselden is the Group Program Manager for the Microsoft Master Data Management product forthcoming in the next wave of Office SharePoint Services and owns the long term strategy, vision, planning, and development of that product. Kirk has been with Microsoft for 12 years in various groups including Hardware, eHome, Connected Home, SQL Server, and Office Business Platform. He was the development manager for Integration Services and the primary designer for the runtime, as well as many of the tasks. He has written a number of articles for SQL Server Magazine, speaks regularly at industry events, writes profusely on his personal and MSDN blog, and holds 35 patents or patents pending.

More Info:

http://www.amazon.com/Microsoft-Server-Integration-Services-Unleashed/dp/0672330326/

Continue Reading »