Certifiably SQL
|

19 results found for Certifiably SQL, displaying items 1 - 19
|
|
[October 22, 2000]
|
|
All About Stored Procedures
Tips for SQL Server certification exams
SQL Server Magazine
—
Michael D. Reilly
|
[September 24, 2000]
|
|
Restoring Databases
Planning and practice can ensure a smooth, efficient restore when the inevitable happens.
SQL Server Magazine
—
Michael D. Reilly
|
[September 18, 2000]
|
|
Practice Questions--Restoring Databases
Test your knowledge of restore processes.
SQL Server Magazine
—
Michael D. Reilly
|
[September 18, 2000]
|
|
Answers to Practice Questions--Restoring Databases
Check your answers to the practice questions.
SQL Server Magazine
—
Michael D. Reilly
|
[September 12, 2000]
|
|
Practice QuestionsBackup Strategies
Test your knowledge about SQL Server's backup process.
SQL Server Magazine
—
Michael D. Reilly
|
[September 12, 2000]
|
|
Answers to Practice QuestionsBackup Strategies
Check your answers to the practice questions.
SQL Server Magazine
—
Michael D. Reilly
|
[August 22, 2000]
|
|
The Transaction Log
Before you can plan an effective backup and restore strategy, you need to understand the interaction among SQL Server's transaction log, checkpoints, and automatic recovery process.
SQL Server Magazine
—
Michael D. Reilly
|
[August 22, 2000]
|
|
Setting the Record Straight
Contrary to SQL Server Books Online, SQL Server 7.0 checkpoints write all changed pages to disk immediately.
SQL Server Magazine
—
Michael D. Reilly
|
[August 22, 2000]
|
|
Practice Questions--The Transaction Log
Test your knowledge about SQL Server's transaction log, checkpoints, and automatic recovery process.
SQL Server Magazine
—
Michael D. Reilly
|
[August 22, 2000]
|
|
Answers to Practice Questions--The Transaction Log
Check your answers to the practice questions.
SQL Server Magazine
—
Michael D. Reilly
|
[August 21, 2000]
|
|
Backup Strategies
Explore SQL Server's three types of backups: full, log, and differential.
SQL Server Magazine
—
Michael D. Reilly
|
[May 11, 2000]
|
|
Lab Files: Defining Jobs
Use these exercises to practice defining SQL Server 7.0 jobs.
SQL Server Magazine
—
Michael D. Reilly
|
[May 11, 2000]
|
|
Practice Questions: Defining Jobs
Test your knowledge of how to define jobs that fire when a previous job completes or when an alert condition arises.
SQL Server Magazine
—
Michael D. Reilly
|
[May 11, 2000]
|
|
Answers to June Practice Questions: Defining Jobs
Check your answers to the June practice questions about defining SQL Server 7.0 jobs.
SQL Server Magazine
—
Michael D. Reilly
|
[April 20, 2000]
|
|
Lab Files: Alerts and Operators
Use these exercises to practice setting alerts and operators.
SQL Server Magazine
—
Michael D. Reilly
Defining Jobs
SQL Server 7.0 lets you set up not just a single task, but a series of tasks with dependencies.
SQL Server Magazine
—
Michael D. Reilly
|
[April 13, 2000]
|
|
Answers to May Practice Questions: Alerts and Operators
Here are answers to the May practice questions about alerts and operators.
SQL Server Magazine
—
Michael D. Reilly
|
[April 13, 2000]
|
|
Practice Questions: Alerts and Operators
Test your skill on setting SQL Server alerts and operators.
SQL Server Magazine
—
Michael D. Reilly
Alerts and Operators
To master SQL Server 7.0's automated administrative tasks, you need to know how to configure alerts and set up operators.
SQL Server Magazine
—
Michael D. Reilly
|
|