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.
What is it? Where does it reside? How do we get inside? A quick blurb since these questions do come up occasionally. *** Warning this may only be interesting to the inquisitive -SQL minded IT folks roaming the face of this planet 🙂 *** Then again in case you are responsible for a i.e. WSUS […]
Why in the world would you go there? Easy enough – then again no – especially not if you are contemplating to change trace flags for more than one server in your environment using what all experienced DBAs would attempt to do a TSQL approach. With a little bit of research you’ll find where the […]