Every SQL Server database administrator needs one or more vendor tools such as:
- Backup and restore tool because anything is better than the SQL Server maintenance plans
- View SQL Server activity
- SQL Server Health Check
These free SQL Server tools are the one I worked with as a SQL Server Database Administrator on a daily basis. There are many, many other free tools.
- Ola Hallengren – SQL Server Maintenance Solution
- Adam Machanic – sp_whoisactive
- Brent Ozar – sp_blitz
Since these tools are completely free, there is no reason to not try these free SQL Server tools in your environment. It takes awhile to run and interpret what exactly the free SQL Server tools can and cannot do. But free is free. And of course, you should always have your own bag of home grown SQL Server scripts that you have developed over time.
Advertisement
Amazon Prime Visa - Get a Amazon Gift Card instantly upon approval of Amazon Prime Visa
Chase Checking - Open your Chase checking account and get a bonus!
Chase Freedom Flex - Earn unlimited cash back with the Chase Freedom Flex credit card.
Chase Freedom Unlimited - Earn cash back with the Chase Freedom Unlimited credit card.
Chase Saphire - Open your Chase Saphire Preferred or Reserve and get bonus points and more!
Discover - Get a bonus when you open an eligible Discover account.
Marriott Bonvoy Credit card - Open your Marriott Bonvoy Credit card and get a new Cardmember bonus!
Rakuten - Sign up for Rakuten and earn cash back on your purchases at 3500+ stores. 20M+ members in the U.S. have earned over $3.2B in Cash Back at their favorite stores.
Schwab - Open a Schwab account and get up to $1,000 depending on your net deposit.
Xfinity - Open an Xfnity mobile or internet account and get a bonus