Data Efficiency in SQL Server: DATETIME
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
Home » Archives for Randolph »
Randolph
What is your SQL Server 2005 Upgrade Plan?
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?
Lazy Loading and Tries
This post has nothing to do with SQL Server, but if you like performance tuning, stick around. I learn technology by using it, pushing it… Read More »Lazy Loading and Tries
The ongoing saga of a slow tempdb on a fast server
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
98% of I/O is taken up by tempdb
During a recent engagement, the customer explained that the performance on their relatively small system was especially slow on Monday morning, but generally bad that… Read More »98% of I/O is taken up by tempdb
Professionalism doesn’t mean a collared shirt and tie
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
Max Server Memory Matrix
When we perform diagnostics on an existing SQL Server instance, or if we are setting up a new machine, it’s very important to make sure… Read More »Max Server Memory Matrix
Forecast: Azure Skies Over the Amazon
Microsoft Azure and Amazon Web Services are taking over. Last week, a client approached me to migrate their complex environment in two phases from two… Read More »Forecast: Azure Skies Over the Amazon
Update to Azure Blob Storage Sync and Restore
Blob Storage Sync tool updated During a SQL Server migration this month, I found some inconsistencies in my Azure Blob Storage Sync tool, so I… Read More »Update to Azure Blob Storage Sync and Restore
Basic Availability Groups in SQL Server 2016
One of the new features in SQL Server 2016 Standard Edition, which may appeal to users of the deprecated Database Mirroring feature, is Basic Availability… Read More »Basic Availability Groups in SQL Server 2016
Filmmaking as a Metaphor for the DBA
I worked on four films in 2015, three shorts and one feature-length movie, all shot in Calgary where I live. That has resulted in seven… Read More »Filmmaking as a Metaphor for the DBA
Happy New Year
Instead of a survey or a technical post, I will take this opportunity to wish everyone a happy new year. 2015 was a good year for… Read More »Happy New Year
Survey: Light or Dark
This week I am continuing with the simple survey series. Today my question is, do you prefer using a dark or light background when writing… Read More »Survey: Light or Dark
Survey: Tabs or Spaces
This is my second survey for the month of December. Last week I asked about join predicate order. This week, it’s a simple question: Do… Read More »Survey: Tabs or Spaces
Survey: Join Predicate Order
It’s a quiet month as we look forward to 2016, so I’m asking a series of survey questions for the next few posts. My first… Read More »Survey: Join Predicate Order