Surprise, in case you didn’t create your Exchange server 2016 OS volume with 200 GB or larger and/or have Exchange installed on the system drive – logging of Exchange activity (not to be confused with the individual database(s) activity logs) can easily fill up your drive. There are several scripts and approaches out there to […]
I come across this problem every now and then – especially in performance cases in BI environments where troubleshooting becomes time consuming due to the often extended runtimes. I found a query at some point and added some more logic to it. It will return the weekday and the overall runtime in hh:mm:ss format which […]
This one is an annoying bug/problem I recently came across when configuring SQL 2016 on Windows 2016 server. In case you just installed SQL 2016 and applicable updates and haven’t installed Net framework 3.5 on your server you may run into this problem as well. You don’t need to install Net framework 3.5 to make […]
If you ever came across SMS_DISTRIBUTION_MANAGER starring at you in red instead of the normalcy indicating sedating green under Monitoring > System Status > Component Status — chances are you might be missing a file and/or folder from a deployment. The example I am describing here pertains to a missing download from a Automatic Deployment Rule – […]
If you have seen DHCP lease pools lately you may have come across unique IDs that look nothing like a MAC addresses you are used to see. Below a sample of what you may find. Taking a closer look you may recognize 48 character long hexadecimal strings. So now what? Thankfully Microsoft SQL Server can easily help […]
Did I forget to check that box? Instant File Initialization (IFI) has been around dating back to SQL 2005 and the requests to easily allow us to check this feature during Setup reach way back as well. For the less SQL experienced IFI allows SQL server to make use of a file space right away instead of […]
A quick way to get some SQL 2016 feature pack components downloaded and installed.