When considering an Azure SQL instance, one of the decisions you need to make is the pricing level (Basic, Standard or Premium) and then for the selected level the number of DTU’s you need. Now you might be asking, "which service tier and performance level should I use and how many database throughput units (DTUs) am I using now?"
First lets look at explaining what a DTU is and then we can look at how the DTU Calculator will help.
What are Database Transaction Units (DTUs)?
“A DTU is a unit of measure of the resources that are guaranteed to be available to a standalone Azure SQL database at a specific performance level within a standalone database service tier. A DTU is a blended measure of CPU, memory, and data I/O and transaction log I/O in a ratio determined by an OLTP benchmark workload designed to be typical of real-world OLTP workloads. Doubling the DTUs by increasing the performance level of a database equates to doubling the set of resource available to that database.”
How can I determine the number of DTUs needed by my workload?
If you are looking to migrate an existing on-premises or SQL Server virtual machine workload to Azure SQL Database, you can use the DTU Calculator to approximate the number of DTUs needed.
Following the instructions for the DTU Calculator, download either the Command Line Utility or PowerShell Script and run it to measure your server resource utilization. You want to get an hour worth of data.
Once the script completes, go to the DTU Calculator website and enter in the number of cores for your server and then upload the CSV file that was generated. Then click on the “calculate” button as show below.
After the DTU Calculator measures your server resource utilization, it will provide you the best recommendation for the number of DTU’s you should be using in Azure SQL.
Came across an excellent blog post from @TroyHunt on using Azure Functions to track abusive IP addresses to a website and log them to an Azure storage account and then have another Azure Function on a timer to validate those IP addresses and block them if necessary.
Windows 10 has some very handy sign-in options for unlocking your computer including using a fingerprint, a picture or a numeric PIN. I’ve used all three and by far my favorite is the PIN option.
Recently I reformatted my Surface Pro 3 and after installing Windows 10 Anniversary edition (build 1607), I noticed that as soon as I joined my work domain, the PIN option for sign-in was disabled. This was strange since hours earlier I was using this sign-in option with Windows 10 Anniversary edition prior to reformatting my device. I decided to try signing in to my device using a local profile and the PIN sign-on option was now available, but strangely on my Windows Domain account it was not.
After doing some research online I found that with Windows 10 Anniversary edition, this feature has reverted back to how it functioned in Windows 8, which requires it to be authorized before you can use it when on a Windows Domain.
Here is what you need to do to enable it.
Steps to Enable PIN Sign-In Option for Windows 10
- Open up regedit.exe
- Browse to [HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\System]
- Add a new DWORD key named “AllowDomainPINLogon” and set its value to “1”
- Restart your computer
- After logging back in to your computer, go to SETTINGS, ACCOUNTS, SIGN-IN OPTIONS and you should see that the PIN option is now available to be set