New Course: “SQL Server: Database Creation, Configuration, and Alteration”


Today Pluralsight published my new course, “SQL Server: Database Creation, Configuration, and Alteration”.

This is a demo-centric, short course on how to how to use T-SQL to create and configure databases, files, and filegroups.  Areas I cover include:

  • How to create a database
  • How to configure files and filegroups
  • Configuration of file settings
  • Configuration of recovery model, security, collation
  • How to create a database snapshot
  • How to support FILESTREAM data
  • Enabling containment
  • Adding, removing and modifying files and filegroups
  • Changing growth options
  • Relocating files
  • Changing logical file names
  • Making a filegroup read-only
  • Modifying compatibility levels, “AUTO” options, access and database state
  • Changing a database to read-only
  • Restricting database access
  • Changing recovery and recovery time options
  • Changing various options like page verification, snapshot isolation, ANSI settings
  • Enabling change tracking
  • Enabling Transparent Data Encryption
  • Changing security and Service Broker options
  • Changing containment settings

There are now 29 courses from the SQLskills team as of today and much more to come.

Other articles

Imagine feeling confident enough to handle whatever your database throws at you.

With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.