 |
|
 |
My Account
|
|
| Home |
|
| Events |
| Current Events |
| Past Events |
| SQL Immersion Events |
| Event Log |
|
| Services |
| Mentoring |
| Custom Courses |
|
| Resources |
| Articles |
| Blogs |
| Books |
| Event Resources |
| Knowledge Base Articles |
| Q & A |
| SQL Scripts |
| Useful Links |
| Whitepapers |
|
| Partners |
|
| Communications |
|
| Contact Us |
|
 |
|
|
Paul's Articles |
||
Paul writes for TechNet Magazine, both in-depth articles and a regular SQL Q&A column |
||
| August 2008: Top Tips for Effective Database Maintenance | ||
| Far too often, people who are not trained database administrators somehow end up responsible for a database. They lack the proper training and knowledge to maintain their database, and problems begin to develop. Here’s a primer for all those involuntary DBAs who need a crash course in database maintenance best practices. | ||
| August 2008: SQL Q&A: Partitioning, Consistency Checks, and More | ||
| Paul Randal answers your SQL Server questions, showing you how to perform consistency checks and other maintenance on very large databases, how to handle an accidental upgrade, and the benefits of using partitioning for manageability and disaster recovery. | ||
| June 2008: SQL Q&A: I/O Errors, Database Mirroring, and More | ||
| Paul Randal answers your SQL Server questions, showing you how to create corruption in a test database, helping you avoid a shrink-grow-shrink-grow cycle, and explaining how you can determine how many databases you can mirror before performance starts to degrade. | ||
|
|
||
|
Kimberly's Articles |
||
Kimberly writes for Penton Media, Inc. who publish SQL Server Magazine and Windows IT Pro Magazine. |
||
| Performance Tuning and Database Design - All about SQL Server 2005 database design techniques to improve performance and scalability. | ||
| Essential Aspects of Database Design, February 2007 InstantDoc #94585 | ||
| Using the newsequentialid() GUID Function, February 2007 InstantDoc #94587 | ||
| Database Design for Performance, November 2006 InstantDoc #93633 | ||
| Disaster Recovery Strategies for VLDBs - All about SQL Server 2000 Backup & Restore techniques for Very Large Databases. | ||
| Recovering from Isolated Corruption, September 2003 InstantDoc #39657 | ||
| An ounce of prevention, September 2003 InstantDoc #39658 | ||
| The Best Place for Bulk_Logged, August 2003 InstantDoc #39782 | ||
| Before Disaster Strikes, September 2002 InstantDoc #25915 | ||
| Filegroup Usage for VLDBs, September 2002 InstantDoc #26031 | ||
| Restoring After Isolated Disk Failure, September 2002 InstantDoc #26067 | ||
| Log Backups Paused for Good Reason, August 2002 InstantDoc #26032 | ||
| MSDB Quick Tip, September 2002 InstantDoc #26068 | ||
| All About Raiserror | ||
|
This article gives you a nice understanding of all of the RAISERROR parameters
especially, Severity and State. Read this to know when to user various settings
as well as how they will display, whether or not they will set @@ERROR and how
they will display if logged to the Windows NT Event Viewer's Application Log.
InstantDoc #22980
|
||
| Detailed Aggregates | ||
|
This article will allow you to understand the benefits of using COMPUTE and
COMPUTE BY, non-ANSI standard extensions when you want more than just the
summary data that GROUP BY can give. By using COMPUTE and COMPUTE BY you can
get the details as well as the aggregate totals.
InstantDoc #38150
|
||
| Understanding Datetime Data - A series of 5 main articles, a couple of sidebars and a bit of homework! | ||
| Part1 - The Datetime Dilemma, June 2002 InstantDoc #25173, Homework | ||
| Just In Time, June 2002 InstantDoc #25174 | ||
| Part2 - Manipulate and Calculate, July 2002 InstantDoc #25433, Homework | ||
| Part3 - Datetime for Durable Databases, September 2002 InstantDoc #26170, Homework | ||
| Part4 - Simplify, Parameterize, Reuse, October 2002 InstantDoc #26538, Homework | ||
| Unleashing the Power of Views | ||
| Part1 - The View from Here, December 2002 InstantDoc #27229 | ||
| Part2 - Viewer Advisory, February 2003 InstantDoc #37660 | ||
| All About Joins - A series of 5 main articles, a couple of sidebars and a bit of homework! | ||
| Part1 - Joins 101, October 2001 InstantDoc #22071, Homework | ||
| Aliases in T-SQL, November 2001 InstantDoc #22690 | ||
| Part2 - The Outer (Join) Limits, November 2001 InstantDoc #22689, Homework | ||
| Part3 - n-Table Joins, February 2002 InstantDoc #23733, Homework | ||
| Part4 - n-Table Outer Joins, April 2002 InstantDoc #24319, Homework | ||
| Part5 - n-Table Joins and Search Conditions, May 2002 InstantDoc #24854, Homework | ||
| Saving Production Data from Production dBAs | ||
|
This quick tip
|
||
| For a complete list of articles written by Kimberly L. Tripp for Penton Media publications, see http://www.sqlmag.com/Authors/AuthorID/1242/1242.html | ||
|
Privacy Policy. All Rights Reserved. ©2007 SYSolutions, Inc. |
|