The Best of SQLServerCentral.com: Essays and Ideas from the SQL Server Community

Be the first to write a review

Overview

In 5 years SQLServerCentral.com has grown to be the premier SQL Server community site on the Internet, bringing you daily articles, the famous Question of the Day, and a script to help you learn more about SQL Server and ensure your databases are running at peak efficiency. With over 2,000 articles, 1,000 scripts, and many other resources, our goal is to be the premier SQL Server learning resource on the Internet. SQLServerCentral.com brings you a variety of articles on all aspects of SQL Server from ...
See more details below
Available through our Marketplace sellers.
See All Options
Other sellers (Paperback)
  • All (3) from $9.98   
  • New (1) from $9.98   
  • Used (2) from $12.94   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$9.98
Nye Discount Books, Inc.
Seller since Tue Oct 07 09:42:27 EDT 2014

Feedback rating:

(10)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
0975901583 Ships Quickly. New, unopened, may have slight shelf wear. Excellent customer service.

Ships from: Venice, FL

Usually ships in 1-2 business days

  • •Standard, 48 States
  • •Standard (AK, HI)
  • •Express, 48 States
  • •Express (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

More About This Book

Overview

In 5 years SQLServerCentral.com has grown to be the premier SQL Server community site on the Internet, bringing you daily articles, the famous Question of the Day, and a script to help you learn more about SQL Server and ensure your databases are running at peak efficiency. With over 2,000 articles, 1,000 scripts, and many other resources, our goal is to be the premier SQL Server learning resource on the Internet. SQLServerCentral.com brings you a variety of articles on all aspects of SQL Server from administration to XML and everything in between. Our articles are written by real DBAs and developers who use the techniques and code they write about in their daily work. And this book is a collection of the best articles we've seen from the past year from over 50 authors.

This book spans the gamut of topics on both SQL Server 2000 and SQL Server 2005, bringing you advice on interviewing and how to update your customer's database with a new release of software. Over 60 articles from 2005 and 2006 are collected here for your perusal. This year's book also includes the very popular Spotlight on SQL Server series with interviews of the SQL Server development team. These are the people who actually write the SQL Server software and build the product. We spend a few minutes with quite a few well known names getting to know the people behind the software.

Read More Show Less

Product Details

  • ISBN-13: 9780975901588
  • Publisher: Central Publishing Group, The
  • Publication date: 5/28/2007
  • Pages: 218
  • Product dimensions: 8.20 (w) x 10.60 (h) x 0.50 (d)

Table of Contents


Introduction     6
Administration     7
An Audit Trail Generator   Leo Peysakhovich     8
Are Your Database Backups Current and Available?   Thomas LaRock     11
Arriving at Database Growth Factor in SQL Server 2000   Suresh Maganti     13
Differential Backup Prediction   Darwin Hatheway     14
Dynamic Management Objects   Christoffer Hedgate     17
Detecting Performance Issues With Sysprocesses   Terry Troisi     19
Enterprise Manager Tricks for Newbies   Sushila Iyer     20
More Intelligent Backup and Restore   Vince Iacoboni     24
No Outlook for Alerts!   Roy Carlson     28
Small Scale SQL Server Deployment   Tim Mitchell     32
SQL Server Agent 2005   Dinesh Asanka     33
SQL Server 2005 Best Practices   Nanda Kishore     37
SQL Server 2005 Logon Triggers   Frederik Vandeputte     40
SQL 2005 Symmetric Encryption   Michael Coles     43
SQL Server Job Scheduling   Peter He     50
Triggers for Auditing   Tiago Andrade e Silva     53
T-SQL andProgramming     55
Updated SQL Injection   Michael Coles     56
Introduction to SQLCMD   Haidong Ji     59
Customer Database Update A Practical Solution   Serhiy Snisarenko     61
Outer Join Mystery   Grant Fritchey     72
Complex Computed Columns   Tim Chapman     74
Aggregate Queries   Kathi Kellenberger     77
Stored Procedure Naming Conventions   Joseph Sack     80
Manipulating Text Columns   Raj Vasant     82
The GO Command and the Semicolon Terminator   Ken Powers     83
The Dodgy GO Statement   Subramanyam Krishnamurthy     85
Quick Hints for using the RAISERROR Command   David Poole     87
The Array in SQL Server   Alex Grinberg     89
Think Twice Before You Convert   Aries Manlig     93
The Zero to N Parameter Problem   Sloan Holliday     93
Use SQL-DMO and Excel to Quickly Create Reports for Auditors   Chad Miller     94
Finding the Next Business Day Recursively   Rob Scholl     96
Printing in .NET   Jereme Guenther     98
Get Away From Confusing Code   Sean McCown     99
SQL Server 2005 for SQL2k Developer (Part 1)   M. Choirul Amri     100
Generating Permutations in T-SQL   Eli Leiba     102
Practical Uses of Patlndex   Robert Davis     103
Deduping Data in SQL Server 2005   Charles Hawkins     105
Business Intelligence, Reporting Services, and ETL     109
DTS Polling   Andre Quitta     110
SSIS - Code Reuse and Complex Control Flows   Kristian Wedberg     113
Handling Zero Byte Files in DTS   James Greaves     117
Clustering Reporting Services   Zach Mattson     119
Upgrading SQL Server 2000 DTS Packages to SSIS   Brian Knight     121
Reporting Services 2005   Anubhav Bansal     122
DTS and Global Variables   Alex Kersha     129
DTS Standards   Jonathan Stokes     133
Overview of DTS Packages   Rama Nageshwara     135
Database Design     141
Database Design and Reference Tables   Ranga Narasimhan     142
Male, Female and The Other One (NULL)   Peter Ward     144
The Pitfalls of Foreign Keys    David Poole     146
XML     151
Importing XML Files Into SQL Server   Steve Moore     152
Simplify the Creation of XML from SQL Server Data   Hugh Lynch     154
Using OPENXML Part I   Raj Vasant     160
Using OPENXML Part II   Raj Vasant     164
Replication     166
Handling Conflicts in Merge Replication   Satia Madimchetty     167
Moving Replicated Databases   Andy Warren     173
Adventures in Replication   Chris Rock     175
Everything Else     177
Employee Retention   Steve Jones     178
Being Retained   Steve Jones     179
Retention - Keeping Your Job   Steve Jones     182
Retention - Finding Your Job   Steve Jones     184
Employee Retention From the Managers Perspective   Steve Jones     187
Interviewing   Steve Jones     192
Spotlight on SQL Server     195
Euan Garden   Steve Jones     196
Thierry D'Hers   Steve Jones     197
Brian Welcker   Steve Jones     199
Shyam Pather   Steve Jones     201
Donald Farmer   Steve Jones     203
Christian Kleinerman   Steve Jones     206
Kirk Haselden   Steve Jones     208
Dan Jones   Steve Jones     211
About the Authors     214
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)
    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)