 |
|
|
|
||
 |
|
|
| Home |
|
|
| Remote DBA Service |
|
|
| Consulting and Performance |
|
|
| Server Health Checks |
|
|
| Training |
|
|
| Resources |
|
|
| Calendar |
|
|
| What our Customers say |
|
|
| What our Students say |
|
|
| About SQLskills.com |
|
|
Paul's Articles |
||
Paul writes for TechNet Magazine and SQL Server Magazine, and is a Contributing Editor of both. He writes the bi-monthly SQL Q&A column, and a feature article ever other month or so.
See Paul's TechNet Magazine blog category for the full list |
||
| November 2010: Top-10 Secrets of a SQL Server Expert | ||
| This article lists my top-10 hints and tips for being a successful enterprise DBA. | ||
| November 2009: SQL Server: Recovering from Disasters Using Backups | ||
| The main reason a backup exists is to be restored in the event of a disaster. Although most people are comfortable taking regular backups of their SQL Server databases, restoring a database from backups can be a lot more complicated. This article explains how restore works and walks you through some simple restore scenarios. | ||
| July 2009: Understanding SQL Server Backups | ||
| In most situations, database backups are critical for recovering from a disaster, but there are lots of misconceptions about how backups work and what a good backup strategy is. In this article, the fi rst in a three-part series on disaster recovery, Paul S. Randal explains how the three most common types of backups work and how you can combine them into an effective backup strategy. | ||
| May 2009: Security: Common SQL Server Security Issues and Solutions | ||
| Have you found yourself inadvertently in charge of a SQL Server database and don’t know all the best practices for making it secure? Paul Randal covers the top 10 security areas you should worry about, detailing common problems and their solutions. | ||
| February 2009: SQL Server: Understanding Logging and Recovery in SQL Server | ||
| Logging and recovery are critical parts of SQL Server, but they are often poorly understood. Paul Randal gives an overview of how the logging and recovery features work in SQL Server and explains the transaction log and recovery models to help you maintain a better database. | ||
| January 2009: SQL Server 2008: Advanced Troubleshooting with Extended Events | ||
| SQL Server 2008 includes a new “eventing” mechanism called SQL Server Extended Events that enables some sophisticated troubleshooting. Get an overview of Extended Events and find out how you can use this new functionality for monitoring and troubleshooting. | ||
| November 2008: SQL Server 2008: Tracking Changes in Your Enterprise Database | ||
| SQL Server 2008 introduces two new features that allow you to track changes more easily and efficiently. Paul Randal examines the new Change Tracking and Change Data Capture features and discusses the implications these features will have for database administrators. | ||
| 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. | ||
|
|
||
|
Bob's Articles |
||
Bob writes the regular Under the Table column for MSDN Magazine. |
||
| May 2009: Under the Table: Programming with FileStreams in SQL Server 2008 | ||
| There's always been disagreement about whether large blobs, such as document and multimedia items, should be stored in the database or file system. In SQL Server 2008 you don't have to choose; filestream storage provides the best of both approaches. | ||
| February 2009: Under The Table: Spatial Data Support In SQL Server 2008 | ||
| New spatial data support in SQL Server 2008 opens the door to mapping and querying geometric and geographic data, allowing you to build exciting new applications. | ||
|
|
||
|
Kimberly's Articles |
||
Kimberly writes for SQL Server 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 | ||
| 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. Copyright 2011 SQLskills.com |
|