Skip to main content

Setting Up the SQL Database

Coming Soon

This tutorial is currently under development. We're creating a comprehensive guide to SQL database configuration and optimization for ScrewDrivers.

What You'll Learn​

This tutorial teaches you database administration for ScrewDrivers Pro/Enterprise. You'll learn to:

  • Size and configure SQL Server appropriately
  • Optimize database performance for ScrewDrivers
  • Configure backup and recovery procedures
  • Monitor database health and growth
  • Plan for scalability as usage grows
  • Troubleshoot common database issues

What You'll Need​

Before starting this tutorial:

  • Completed the First Deployment tutorial
  • SQL Server installed (2016 or later)
  • SQL Server Management Studio (SSMS)
  • Administrator access to SQL Server
  • Basic SQL Server administration knowledge
  • About 90 minutes to complete the tutorial

Tutorial Overview​

The database is the heart of ScrewDrivers Pro/Enterprise. Proper configuration ensures reliability, performance, and scalability. This tutorial teaches you to manage it like a pro.

What We'll Build Together​

You'll configure a production-ready database:

  1. Initial Sizing - Set appropriate initial database size and growth settings
  2. Performance Tuning - Configure indexes, statistics, and query optimization
  3. Backup Strategy - Implement automated backup and recovery
  4. Maintenance Plans - Set up index maintenance and statistics updates
  5. Monitoring - Configure alerts and health checks
  6. High Availability (Optional) - Database mirroring or Always On

By completing this tutorial, you'll have a robust, production-ready database.

Learning Approach​

This tutorial provides hands-on database administration:

  • Understand why each setting matters
  • Learn monitoring techniques to spot issues early
  • Practice backup and recovery procedures
  • Build confidence through testing scenarios

Prerequisites​

You should understand:

  • Basic SQL Server concepts (databases, tables, indexes)
  • How to use SQL Server Management Studio
  • Windows server administration
  • Your organization's backup requirements

Database Requirements​

Different deployment sizes have different needs:

  • Small (1-100 users): SQL Express often works fine
  • Medium (100-500 users): SQL Standard recommended
  • Large (500+ users): SQL Standard or Enterprise, possibly clustered

This tutorial focuses on Standard edition, which covers most deployments.

Current Resources​

While we're developing this tutorial, you can find database information:

Coming Soon​

This tutorial will include:

  • Step-by-step configuration procedures with screenshots
  • SQL scripts for optimization and maintenance
  • Monitoring query examples
  • Troubleshooting common database issues
  • Sizing calculators for different usage levels
  • High availability configuration walkthroughs

We're committed to helping you run a healthy, performant database. Contact Tricerat support if you need database assistance now!