Automatically Indexing Millions of Databases in Microsoft Azure SQL Database

Automated SQL Server Indexing at massive scale Read more →

How to use Database Compatibility to increase your migration success

Understanding SQL Server database compatibility levels helps in understanding risk in upgrades Read more →

SQL Server Performance Tuning

Find Loads of SQL Server Performance Tuning articles Read more →

How to measure Transparent Data Encryption (TDE) Performance

Measuring SQL Server performance impact when applying TDE is an interesting challenge Read more →

Should Developers manage database read status

A programmer asked me if he can include the a function to change the database status out of READ_ONLY , add some data and then put it back into READ_ONLY. These are the basic commands ALTER DATABASE database-name SET READ_ONLY ALTER DATABASE database-name SET READ_WRITE There are some considerations for deciding if a Developer should be able to include as part of an ETL process , the capacity to change the READ STATE of a SQL database 1) Requires ALTER permission on the database. This is an elevated privilege - and may break the organisations sql server security policy 2)... Read more →