This is likely the last in a series of three posts about backups and restores. My aim with this series has been to give you an idea of the options available and a basic start on using those options. I’m not trying to go in-depth on the subject of backups and restores. Today will be … Continue reading 3 Ways to Restore SQL Server Databases
Last time we discussed 5 backup types for SQL Server. Now I want to introduce you to five ways to make backups in SQL Server. I can’t possibly explore all the options available with each of these six methods. There is a lot to cover for even a “simple” topic like backups. Method 1: Using … Continue reading 5 Ways to Make SQL Server Backups
What process can you use to find SQL Server training resources that will be valuable? After all, not everything on the internet can or should be trusted. If you want training on something in this constantly changing world of technology, how do you locate that training? How do you find information that is … Continue reading How Do You Find Good SQL Server Training Resources?
In part 1 of this series, I discussed pre-installation steps. There are many guides available online for the actual installation process so I’m not going to give a step by step installation guide here. Rather, I’m going to focus on what to think about after the install is complete. Recent versions of SQL Server will … Continue reading SQL Server Install Guide Part 2
Configuring the min and max server memory settings for SQL Server has a number of things to consider prior to making changes. Before we jump into those considerations, let’s learn what the min and max server memory options do. What does the min server memory option do? The min server memory option specifies the minimum … Continue reading Setting Min and Max Server Memory Setting
We’re probably all familiar with the fact that SQL Server by default will install not only the program binaries but all your databases on the C drive as well. Accidental DBA’s, i.e. System Administrators and Developers who inherited the maintenance of a database, may not be aware of how bad it can be if someone … Continue reading 3 Reasons Not to Install Databases On the C Drive