Data Platform

2020

Why use the Common Data Service?
Mar 4 2020

2016

Azure SQL Databases - An overview
May 9 2016

2015

SQL Server for SharePoint–Best Practices
Mar 1 2015
SharePoint Databases Knowledge Base
Mar 1 2015
PowerPivot for SharePoint: Lessons Learned and Useful Links
Feb 21 2015

2014

Replace a GUID in a DB
Jun 10 2014
SQL Server 2014 – What to Know
Apr 13 2014
SQL Healthcheck
Apr 6 2014
Golden nuggets - SQL Saturday Exeter 2014
Mar 23 2014

2012

CRM 2011 on a SQL 2008 Cluster
Jun 6 2012

2010

Stored Procedure Error Handling Best Practices - Scripts
Dec 31 2010
Stored Procedure Error Handling Best Practices, Part 3
Dec 30 2010
Stored Procedure Error Handling Best Practices, Part 2
Dec 30 2010
Stored Procedure Error Handling Best Practices, Part 1
Dec 30 2010
System Stored Procedures
Dec 28 2010
Database Mail, Part 5 - Monitoring
Dec 16 2010
Best Practices for the Management of SQL Scripts
Dec 16 2010
Database Mail, Part 4 - Sending an e-mail
Dec 15 2010
Database Mail, Part 3 - Creating a Profile
Dec 14 2010
Database Mail, Part 2 - Creating an Account
Dec 14 2010
Database Mail, Part 1 - Set up
Dec 14 2010
Space on Server Disk Drives
Dec 11 2010
My stored procedure best practices
Dec 11 2010
When was a database backed up?
Dec 10 2010
How to change the default location of SQL Server Backups
Dec 9 2010