Monday, November 2, 2009
Beginning T-SQL 2008 by Apress
The type of the release is: eBook
In the PDF format with ISBN: 1430224614 and Pub Date: October 24, 2009
The size of the release is: 03 disks x 2.88mb
And released on: 11/01/2009
Even if you have little or no knowledge of T-SQL, Beginning T-SQL 2008
will bring you up to intermediate level and teach you best practices
along the way. You'll learn how to write code that will help you to
achieve the best-performing applications possible.
introduction to databases, normalization, and SQL Server Management
Studio. You'll understand how data is stored in a database and learn how
to use at least one of the available tools to get to that data.Each
subsequent chapter teaches an aspect of T-SQL, building on the skills
learned in previous chapters. Exercises are included in each chapter
because the only way to learn T-SQL is to write some code.This book will
do more than just give the syntax and examples. It will teach you
techniques to help you avoid common errors and create robust and
well-performing code.Imparts best practices for writing T-SQLHelps
readers avoid common errorsShows how to write scalable code that yields
good performanceWhat you'll learnUnderstand the fundamentals of
relational theory, upon which Transact-SQL is basedWrite accurate
queries that are scalable and perform wellCombine set-based and
procedural processing, obtaining the best from both worldsEmbed business
logic in your database through stored procedures and functionsSimplify
your work through new and advanced features such as common-table
expressions and virtual tablesEnhance performance by knowing when to
apply features such table value parametersWho is this book for?This book
is for developers who will be writing database applications against SQL
Server databases.About the Apress Beginning SeriesThe Beginning series
from Apress is the right choice to get the information you need to land
that crucial entry–level job. These books will teach you a standard and
important technology from the ground up because they are explicitly
designed to take you from “novice to professional.” You’ll start your
journey by seeing what you need to know—but without needless theory and
filler. You’ll build your skill set by learning how to put together
real–world projects step by step. So whether your goal is your next
career challenge or a new learning opportunity, the Beginning series
from Apress will take you there—it is your trusted guide through
unfamiliar territory!
Pro SQL Server 2008 Mirroring by Apress
The type of the release is: eBook
In the PDF format with ISBN: 1430224231 and Pub Date: October 11, 2009
The size of the release is: 02 disks x 2.88mb
And released on: 11/01/2009
Pro SQL Server 2008 Mirroring is your complete guide to planning, using,
deploying, and maintaining database mirroring as a high-availability
option. Mirroring protects you by maintaining one or more duplicate
copies of your database for use in the event the primary copy is
damaged. It is a key component of any production-level,
high-availability solution. This book covers the full spectrum of
database mirroring, taking you from the planning phase through the
implementation to the maintenance phase and beyond.Easy to follow,
step-by-step instructions for beginner and intermediate usersIn-depth,
detailed information for advanced and expert usersCovers all phases of
database mirroring from planning to sustained maintenanceWhat you'll
learnPlan effectively for database mirroring. Learn what questions to
ask and what problems to anticipateGet step-by-step instructions on how
to set up database mirroringAutomate the initial setup and the ongoing
maintenance of mirrored databasesMonitor database mirroring, detect
failures, and generate automated alertsBuild a system that automatically
responds to and fixes common problemsBuild in support for the missing
facets of database mirroring, such as support for cross-database
dependenciesDefine groups of databases that all fail over together to
their mirrors when just one of those databases failsCreate operational
processes so that even nontechnical staff can manage mirrored
databasesWho is this book for?General audience: Pro SQL Server 2008
Database Mirroring is aimed at SQL Server 2008 database administrators,
and especially those who desire to mirror their databases in support of
high availability. System administrators and operational engineers who
manage Windows Server systems that support mirrored database
environments will also find much in the book of interest.About the
Apress Pro SeriesThe Apress Pro series books are practical, professional
tutorials to keep you on and moving up the professional ladder.You have
gotten the job, now you need to hone your skills in these tough
competitive times. The Apress Pro series expands your skills and
expertise in exactly the areas you need. Master the content of a Pro
book, and you will always be able to get the job done in a professional
development project. Written by experts in their field, Pro series books
from Apress give you the hard–won solutions to problems you will face in
your professional programming career.
Ultra-fast ASP.NET: Building Ultra-Fast and Ultra-Scalable Websites
Using ASP.NET and SQL Server (c) by Apress
The type of the release is: eBook
In the PDF format with ISBN: 1430223839 and Pub Date: October 30, 2009
The size of the release is: 02 disks x 2.88mb
And released on: 11/01/2009
Ultra-Fast ASP.NET presents a practical approach to building fast and
scalable web sites using ASP.NET and SQL Server.In addition to a wealth
of tips, tricks and secrets, you'll find advice and code examples for
all tiers of your application, including the client, caching, IIS 7,
ASP.NET, threads, session state, SQL Server, Analysis Services,
infrastructure and operations.By applying the ultra-fast approach to
your projects, you’ll squeeze every last ounce of performance out of
your code and infrastructure, giving your site unrivaled speed.The
approach is mostly prescriptive; rather than drowning you in options,
the book presents and explains specific high-impact recommendations and
demonstrates them with detailed examples.Using this knowledge, you will
soon be building high-performance web sites that scale easily as your
site grows.What you'll learnA way of thinking about performance issues
that will help you obtain real results.How to apply key principles that
will help you build ultra-fast and ultra-scalable web sites.How to use
the ultra-fast approach to be fast in multiple dimensions.You’ll have
not only fast pages but also fast changes, fast fixes, fast deployments
and more.Techniques that are being used by some of the world's largest
web sites.How to structure your HTML and CSS to create pages that load
ultra-fast.Tips for using Silverlight, Ajax and IIS 7 to improve the
performance of your site.How to use comprehensive caching at all tiers
to deliver content faster.Why you should avoid traditional session state
and how to make the best use of cookies.Tips and tricks for optimizing
your ASP.NET and SQL Server code for performance and scalability.How to
use Analysis Services to offload your relational database.Why many sites
that serve individual pages quickly are not scalable.How to avoid common
pitfalls that can have an adverse impact on your site's performance,
both now and as it grows.How to apply an end-to-end systems-based
approach to web site performance and scalability, which includes
everything from the browser and the network to caching, back-end
operations, hardware infrastructure, and your software development
process.Who is this book for?This book will be useful for intermediate
to advanced developers and architects who want to improve the
performance of their ASP.NET-based web sites. Some knowledge of ASP.NET,
SQL Server, and IIS is assumed.Example code is provided in C#.
Experienced web developers who have recently moved from Java or PHP to
.NET will find lots of valuable and interesting information.This book
will also be useful for non-developers who have a technical interest in
what makes a web site fast. In particular, if you’re involved with web
site operations, testing, or management, you will discover many of the
principals and issues that your development teams should be addressing,
along with demonstrations that help drive the points home.
C# an invaluable reference for professional developers wanting to
discover the new features of Silverlight 3. Author Matthew MacDonald's
expertly crafted tutorial guides you through creating rich media
applications using Silverlight in the environment you're most productive
in—no matter what the target platform.As you learn about the features
that put Silverlight in direct competition with Adobe Flash, such as
rich support for 2D and 3D drawing, animations, and media playback,
you'll experience the plumbing of .NET and the design model of WPF
through Silverlight–all of the same .NET technology that developers use
to design next-generation Windows applications. Author Matthew MacDonald
provides an expertly crafted tutorial written from professional
developer to professional developer. You'll learn to create rich media
applications using Silverlight in the environment you're most productive
in–no matter what the target platform.What you'll learnDevelop rich
media applications using Silverlight across browsers and
platforms.Create a project, set up a layout, and use controls.Handle
both 2D and 3D drawing, animation, and media playback through Windows
Presentation Foundation (WPF).Integrate web services support.Use
Silverlight in conjunction with ASP.NET and its interactions with
HTML.Silverlight 3 is the latest iteration of Microsoft's cross-browser
technology for creating rich user experiences on the Web. Like its
predecessor, Silverlight 2, it rides atop the .NET Framework for maximum
ease of use and coding efficiency. The new technology carries forward
much of the work that has been done before and augments it in many
important respects, including support for H.264 video, major
improvements to the graphics engine (including true 3D rendering), and
much richer data-binding options for interfacing with other
applications.Who is this book for?.NET developers encountering
Silverlight for the first time. No prior knowledge of WPF or ASP.NET is
assumed.About the Apress Pro SeriesThe Apress Pro series books are
practical, professional tutorials to keep you on and moving up the
professional ladder.You have gotten the job, now you need to hone your
skills in these tough competitive times. The Apress Pro series expands
your skills and expertise in exactly the areas you need. Master the
content of a Pro book, and you will always be able to get the job done
in a professional development project. Written by experts in their
field, Pro series books from Apress give you the hard–won solutions to
problems you will face in your professional programming career.
