Setting up a SQL Server 2019 environment for testing/development is very easy and does not cost anything. To setup a complete environment, all the following must be installed in order: Install and configure Virtual Machines. You can use any free Virtualization software, such as Virtual Box or VMWare Player Install Windows Server 2019 Evaluation copy. This is currently the most […]
Windows Server Shuts Down After 1 Hour
The physical server abruptly shutting down can be due to faulty hardware like a power supply or a failing hard drive. Or it can possibly be a response to overheating. The Systems Administrator is usually responsible for the hardware and will have monitoring tools in place to determine the problem. However, if Windows Server shuts itself down, this can sometimes […]
Automating SQL Server Backups With Windows Task Scheduler
SQL Server Standard and Enterprise editions come with their own version of Task Scheduler called Maintenance Plans. However, this feature is not available for SQL Server Express Edition. If you want to automate the backups, you will need to use Windows Task Scheduler instead. Step 1 => Create the backup script You may write a simple backup script, such as: […]