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 […]
Ideal for a lab environment setup on a laptop. Nothing dramatically exciting – on the other hand a great way to use the powerful laptop hardware you may already have. I built out this lab using Windows Server 2016 Datacenter as the OS for a Lenovo Thinkpad W530 (BIOS 2.66) running on a by now outdated […]