The Setup administrator rule failed for a client even though they were logged on as an administrator. The setup log showed that sqlsccn.dll could not be loaded. The setup media had files missing, and downloading the media again fixed it.
How to Join Two Tables Without Using Join Keywords? – Interview Question of the Week #266
Question: How to Join Two Tables Without Using Join Keywords?
Answer: In my life, I have attended many interviews as an interviewer.
Listing Objects Changed Since the Last Release With modify_date
modify_date shows what changed after a release, but never what was dropped. Here is a small baseline trick that fills the gap.
Error 17138: Not Enough Memory to Start SQL OS Boot
Error 17138 stopped SQL Server from starting on a server with close to 2 TB of RAM after a client added trace flag 834 for large pages. The large page allocation failed during memory manager initialization. Check max server memory and restart the operating system.
How to Forecast the Size of Restore of Backup in SQL Server? – Interview Question of the Week #265
Question: How to Forecast the Size of Restore of Backup in SQL Server?
Answer: Recently, I had discussed this in consulting engagement:
Choosing a Processor for SQL Server: Count the Licensed Cores
Choosing a processor for SQL Server starts with the license, because SQL Server is licensed per core and the cores you buy decide the bill. This post reads what the server reports, counts the cores that matter, and explains the edition limits and the per-core speed trade. It ends with a way to size cores from measured CPU use.
How to Measure Resource Status on Azure? – Interview Question of the Week #264
Every single time when I start working with Azure, I always want to know what is the status of Azure resource status or consumption in the last hour.