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
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
In late 2019, a project that had been in progress for well over a year finally came to a conclusion. I had collaborated with a number of people to migrate a stand alone SQL Server 2008 and two stand alone SQL Server 2008 R2 instances. Each stand alone SQL Server was migrated to a three … Continue reading Lessons Learned Updating to SQL Server 2017 AlwaysOn Availability Groups
For those who have taken an interest in the latest SQL Server release, SQL Server 2019, you may have noticed a new feature called Data Virtualization. Perhaps you’ve seen a presentation about it, or maybe you’ve read about it in Bob Ward’s book entitled “SQL Server 2019 Revealed.” I myself was curious about this … Continue reading Querying An AS400 Using SQL Server 2019 Data Virtualization
I’m in part 3 of a series on installing SQL Server. In the previous post I began discussing steps to take after the install is complete. Because there are quite a number of things to consider post-install, this part 3 will continue discussing the post-install configuration items. Configure SQL Server Alerts One of the things … Continue reading SQL Server Install Guide Part 3
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
In part 1 of a series on installing SQL Server, I’m going to discuss things to do prior to running the installation program for SQL Server. There are a number of install guides for SQL Server on the internet and plenty of recommendations around installation best practices and how-to’s. This will be what I’ve arrived … Continue reading SQL Server Install Guide Part 1
Have you ever looked at sys.dm_os_virtual_file_stats and saw horrible latency for your database files? Generally speaking, you want to see latency below 20 ms on your database files. much above that and there are some problems somewhere that need some tuning. But, how do you know what queries are causing your issue? What’s causing those … Continue reading Correlating IO Wait with Queries
Suppose you’ve been working on cleaning up SQL Agent jobs and their email operators and find that you have more than one operator with the same email address. How would you tidy this up to ease administration? Let’s do a little setup to demonstrate the scenario. The T-SQL below will create three operators with different … Continue reading Consolidate Multiple Email Operators