Trace Flag 1117 and SQL Server 2019
For VLDBs I've always created multiple files for each file group and had to set the trace flag 1117 on to ensure that all files grow at...
top of page
Mar 15, 20213 min read
Data Types - Does size really matter? - DateTime vs. DateTime2
How many of us have just created a new table and put a Created Datetime and Modified Datetime field in with the default DateTime...
Sep 28, 20202 min read
How To Restore TDE Keys and Database to a New or Different SQL Server
In this article, we will cover the specific steps to restore a set of TDE keys and a database to a new and or different server. This...
bottom of page