Configuring The Model Database

Monica Rathbun explains why you might want to configure your model database:

Top (in no particular order) Settings I have Implemented Through Model

  • Default Growth Settings

  • Query Store Settings

  • Recovery Models

  • Read Committed Snapshot Isolation

  • Allow Snapshot Isolation

  • Auto Update Statistics Asynchronously

  • Compatibility Levels

Click through for more information and to see how to make some of these changes.

Related Posts

Sizing Azure SQL Database

Arun Sirpal takes us through finding the right size for Azure SQL Database: Do you want to identify the correct Service Tier and Compute Size ( was once known as performance level) for your Azure SQL Database? How would you go about it? Would you use the DTU (Database Transaction Unit) calculator? What about the […]

Read More

Cleaning Up After Yourself in Azure Data Factory

Rayis Imayev shows how you can automatically delete old files in Azure Data Factory: File management may not be at the top of my list of priorities during data integration projects. I assume that once I learn enough about sourcing data systems and target destination platform, I’m ready to design and build a data integration […]

Read More

Categories

October 2017
MTWTFSS
« Sep Nov »
 1
2345678
9101112131415
16171819202122
23242526272829
3031