Always Encrypted (AE) is a feature Microsoft introduced to SQL Server 2016. This post will provide an overview of AE and talk about how it can be...

Always Encrypted (AE) is a feature Microsoft introduced to SQL Server 2016. This post will provide an overview of AE and talk about how it can be...
Logical data modeling is the second of the three stages of data modeling and one of three types of data model. The three types of data model -...
We are pleased to announce the general availability of SQL Diagnostic Manager 12.0. Existing users may upgrade to this version through the Idera...
Not having a good recovery process One big part of your backup process needs to include the recovery procedures. You should have a rehearsed...
IDERA’s DB PowerStudio provides a powerful cross-platform toolset for database development, tuning and database management. What's new in DB...
Data modeling tools should be competent at the basics of database modeling. They should be able to create logical and physical data models,...
Aqua Data Studio is the industry leading multi-platform Database Integrated Development Environment (IDE) with Visual Analytics. Data and...
We’re excited to announce the release of SQL Inventory Manager 2.6.3 Database administrators need a simple, efficient way to discover, document, and...
We’re excited to announce the release of SQL Enterprise Job Manager 2.4 SQL Enterprise Job Manager is an industry leading monitoring, scheduling and...
We are pleased to announce the general availability of SQL Secure 4.1 SQL Secure is the industry-leading, state of the art auditing and security...
We’re excited to announce the release of SQL Safe Backup 9.1 SQL Safe Backup provides the industry's shortest time from starting a SQL Server backup...
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...
An understanding of business glossary best practices - such as what goes into a business glossary and what should not - is a vital factor in...
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...
We’re excited to announce the release of SQL Safe Backup 9.0 SQL Safe Backup provides the industry's shortest time from starting a SQL Server...
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...