Before a production copy reaches a developer, replace the real emails and phone numbers. Here is a small, checked way to do it with REGEXP_REPLACE.
Get-AzureStorageBlob: The Remote Server Returned an Error: (403) Forbidden. HTTP Status Code: 403 – HTTP Error Message: This Request is Not Authorized to Perform This Operation
A runbook cleaning old backup blobs in Azure failed with (403) Forbidden: This request is not authorized to perform this operation. Here is the fix.
Recent Rows Only: A Filtered Index for the Data Everyone Reads
A filtered index for recent rows is small and fast, but its date never moves by itself. Here is how to build it, test it and keep it fresh.
SSMS – Azure Storage Error – A Connection Attempt Failed Because the Connected Party did not Properly Respond After a Period of Time
SSMS could not open Azure Storage: a connection attempt failed because the connected party did not properly respond. Here is what caused it.
SQL SERVER – Unable to Set Cloud Witness. Error: The Client and Server Cannot Communicate, Because They do Not Possess a Common Algorithm
Adding a cloud witness to my cluster failed: The client and server cannot communicate, because they do not possess a common algorithm. I share the fix that worked.
How to Grow All Files in a File Group Equally? – TRACE FLAG 1117 – Interview Question of the Week #201
How do you grow all files in a file group equally? The answer is Trace Flag 1117, plus the AutoGrow option that SQL Server 2016 brought for filegroups.
Index Key Size Limits: 900 and 1,700 Bytes Explained
Check index key size against the 900-byte clustered and 1,700-byte nonclustered limits, then narrow keys without losing query semantics.