Change Fonts in SQL Server Management Studio SSMS 2017

Until the bug is fixed, SQL Server Management Studio 2017 does not allow you to change the environment fonts and colors. If you are like me, in order to be productive in SSMS, that tiny print has got to go! These settings are controlled by the file ssms.pkgundef found...
SQL Add Auto-increment Identity Column to Existing Table

SQL Add Auto-increment Identity Column to Existing Table

SQL server uses the Identity Specification to add a numbered column that automatically increments. You can add this to a new table you are designing or to an existing one. SQL uses integer as the data type, so you are restricted to integers for your automatic...
SQL Enable Broker

SQL Enable Broker

Some applications require broker to be enabled on SQL in order for the application to work correctly. This includes System Center Operations Manager (SCOM) and System Center Service Manager (SCSM). If broker is not enabled for those applications, changes that you make...
Check One Drive Storage Limits

Check One Drive Storage Limits

Microsoft announced last November that OneDrive Storage was being dropped to 5GB. They are removing both the camera roll bonus and the free plan bonus. After they backlash, they had a short time where they allowed you to opt-in to keep your bonuses, but that expired...
Install Hyper-V on Windows 10

Install Hyper-V on Windows 10

You install Hyper-V in the “Turn Windows features on or off” settings. If Hyper-V platform is disabled, hover over it and you may see an error similar to this one: “Hyper-V Virtualization Disabled in Firmware” This means you need to go into...