Hello dear reader! This is the third post in a series to help you get started automating things with PowerShell. You will be looking at how to start and stop SQL Server using PowerShell as well as setting the Max Server Memory setting, measuring free disk space and more. This series is just an introduction … Continue reading Introduction To PowerShell For The DBA Part 3
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
One of the foundational responsibilities of a DBA is making sure that backups are available. SQL Server has several foundational types of backups that can be made. Before I dive into that though, I want to ask a question that seems to have a fairly obvious answer. Why take backups? You want to be able … Continue reading 5 Types of 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?