In this new series, I will share some things that took place early in my career that could have resulted in my looking for new… Read More »Career Limiting Moves – Dropping a Table
During a recent engagement with a client transferring large files from on premises to Azure Storage, we discovered that files over a certain size are automatically… Read More »Saving Time By Splitting Files for a Backup
We back up our databases regularly. We store them on a secure network location so that if the database drive fails, we can still satisfy… Read More »Compressed and Encrypted Backups on the Cheap
Update: Paul Randal told me I had made a mistake in my post. The correction is below. On Wednesday last week, Kenneth Fisher (b |… Read More »Is DBCC SHRINKFILE (filename, EMPTYFILE) fully logged?
On Saturday 9 April 2016, four days from today, I will be speaking at the first ever SQLSaturday in the province of Alberta. Edmonton is… Read More »Speaking at SQLSaturday 507 this weekend in Edmonton
This is the first in a short series of posts about how I assign efficient data types when designing a new table or database. Use… Read More »Data Efficiency in SQL Server: DATETIME
SQL Server 2005 will no longer be supported by Microsoft as of 12 April 2016. One of the services I offer my customers is an… Read More »What is your SQL Server 2005 Upgrade Plan?
Last week, I wrote about what should have been a fast system but was performing very poorly, weighing heavily on tempdb I/O performance. Our original… Read More »The ongoing saga of a slow tempdb on a fast server
Working from home, consulting with companies all over the world, has changed how I interact with customers. The last time I was physically on site… Read More »Professionalism doesn’t mean a collared shirt and tie