Back to Basics: SQL Indexes
SQL Server Index Basics Given the fundamental importance of indexes in databases, it always comes as a surprise how often the proper design of indexes is neglected. It often turns …
SQL Slow Performance
Useful SQL to check your indexes. If avg fragmentation is larger than 15% consider rebuilding the indexes: SELECT OBJECT_NAME ( object_id,database_id), * FROM [sys].dm_db_index_physical_stats, NULL, NULL, NULL, DEFAULT) AS ddips …
Find something in a SQL Database
Previously posted about finding content in a SQL Stored Procedure. Here is a nice script that creates a new Stored Procedure called SearchAllTables that will scan all tables and columns for …
Azure Backup
Now in public preview, Long-Term Retention (LTR) allows you to enable your databases to create weekly backups stored in your own Azure Backup vault and extend the retention period built …
Restore local database to Azure
If you are on the right track and started moving to Azure 🙂 then sooner or later you will need to move some of your databases to Azure. One option …
SharePoint Audiences
We use audiences extensively and required a way to do a recon on which users are in which audiences. Obviously we can run some C# to get this but I …
SQL Server: HDD vs SSD
Nice article on SQL Server running on a HDD vs a SSD. I am sure there are loads of more technical articles available, but nice to read something simple and …
Find something in a Stored Procedure
Forgive me if this is something old (like using a…well using statement in SQL). I remember a time when you had to download some obscure freeware application to scan through …
SharePoint SQL Queries
Some useful SQL queries to get web, site and list data: 1) Query to get all the top level site collections SELECT SiteId AS SiteGuid, Id AS WebGuid, FullUrl AS …