You need to implement a high availability solution for one of your SQL Server databases, but you’re not sure of which option to implement to satisfy your company’s needs. Check out this tip to learn about the five native SQL Server High Availability options:
You have a data set about durations that you want to plot it in a graph. You need to display the minimum, maximum, average and other statistical information in a convenient way.
How can you do this using SQL Server Reporting Services (SSRS)?
Solution
An efficient way to display different statistical properties is a box plot. It allows us to display the following statistical information in a condensed representation: Continue reading Box plot graph in SQL Server Reporting Services
Scenario proposal
When you install SQL Server the path for the installation is generally something such as the following: C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL.
In this directory there are also folders for your DATA files and also your BACKUP files. Within SQL Server Management Studio you have the ability to change the default location for your Data and Log files for all new databases, but you can not change the default directory for your backups.
Is it possible to change the default directory for backups, so it does not need to be specified each time I run a backup?