Peter

Not having a good recovery process One big part of your backup process needs to include the recovery procedures. You should have a rehearsed...

Data modeling tools should be competent at the basics of database modeling. They should be able to create logical and physical data models,...

Not knowing what tools are available There are several tools that come with SQL Server that can be used for backup processing, such as SQL Server...

Inconsistent backup plans While it is hard enough to manage SQL Server, you find that having inconsistent backup plans from server to server will...

Data modeling tools should be competent at the basics of database modeling. They should be able to create logical and physical data models,...

Writing directly to tape A lot of third–party backup tools have agents that allow you to write directly to tape. This was great in the old days when...

Not understanding options Another big problem is people not being aware of the different options that are available using T-SQL commands and using...

Testing Not using restore verify option The last thing you want is to discover that your backup is not good when trying to restore it. A restore...

As a seasoned SQL Server database administrator or developer, you already know that there is an abundance of tools you can use to collect server and...

Writing and tuning SQL code are two different things. There are many ways to write code so that it does the intended function. But there are also...

There are several things that could cause performance issues for a query. You can identify these by breaking down the processing time for a query...

There are many things that can cause slowdowns in SQL Server, such as resources like disk, memory, and network. But the one place where database...

Deadlocking is a common problem that can occur in an SQL Server database. This is like blocking. But instead of being blocked forever, SQL Server...

Blocking is a normal activity that occurs in SQL Server and it does that to control data integrity and make sure only one resource can change a set...

Data modeling tools should be competent at the basics of database modeling. They should be able to create logical and physical data models,...

There are many advantages of using SQL Diagnostic Manager over building your own tools and one of these is the enterprise management view of all...

As a database administrator, monitoring database systems for performance, corruption, and data issues is an ongoing task. It is also an overwhelming...

Development is a big undertaking and most of the time it focuses on making sure all the features are in place and working. Once this is done, tuning...

One can improve how secure databases are. However, that often degrades how well the database performs. The cost increases to improve database...