SQL Diagnostic Manager 13 General Availability

Not protecting physical backups You should think about the value of the data or the consequences of it getting into the wrong hands since a full database backup contains all data in your database. You will want to make sure you always protect this data when it is live...

To understand how malicious actors can infiltrate SQL Server is the key to understanding how to prevent intrusions. The consequences for inadequate permissions are tremendous. Organizations could incur data breaches, fines, loss of customers, a decrease in customer...

There are several examples where data theft has brought organizations to a halt or resulted in a bad press that will leave a tarnished image. For example, in 2017, Equifax disclosed how malicious actors exposed the personal information of over 145 million people,...

Today, business is about data. Database systems and the elements they store are the most valuable assets in any enterprise. Not only are business executives and Information Technology leaders responsible for doing what is right to protect the best interest of the...

Not understanding recovery needs The whole point of creating backups is to retrieve data in case data is lost or there is a failure. But to set up the proper backup and recovery plan, you need to understand what needs to be recovered to determine if the recovery was...

Werner Enterprises is a transportation and logistics leader with more than 8,000 trucks, 24,000 trailers and nearly 13,000 employees. Today, 65 years since the company was founded, it is an asset-based logistics provider and one of the five largest truckload carriers...

Keep sensitive and mission-critical data safe by performing regular backups of all important databases. Identify any non-backed up databases. Determine which databases are not backed up within the last specified number of days.Display the last backup time stamp for...

Cardinality is a term from set theory that deals with the size of a set. Data cardinality can affect query plans and performance. Minimize the effects of cardinality adjustments. Create efficient SQL queries in low cardinality environments. Read the whitepaper...

Every database administrator hates to wake up at midnight just to learn there is an emergency with their database. Sometimes, even though their hardware specifications are above par and they know everything was working fine earlier that day, database administrators...

For over three decades, organizations have relied on data warehouses to support business information consumers’ needs for descriptive analytics to help inform about the current state and to help influence ongoing business decisions. People augment organizational...

SQL Server resellers often send true-up forms to their customers more frequently than Microsoft requires. Some customers receive them every month. They may feel compelled to fill them out each time. However, Microsoft only requires one true-up each year. This true-up...

Effective data governance programs are partnerships between the business and technical parts of the organization. Often, organizations focus more on one side of the house than on the other, when in reality, governance-like activities are already taking place all over....

A large enterprise telecommunications company that provides wireless services and internet services in the United States of America uses a third-party application to gather configuration and performance data on their servers. However, a batch job that runs at midnight...

Monitoring applications, networks, and servers (physical, virtual, and cloud) across multiple platforms has become essential, making smart server monitoring software critical for building a successful Information Technology department. However, with the many products...

Today’s complex applications execute hundreds of SQL procedures and maybe thousands of SQL statements during a typical workload. Database administrators and developers can use load testing to verify that the system can handle the workload with reasonable performance....

Today, many roles within an organization often work with the ever-growing amounts of data in databases. No longer are databases the purview of just the information technology professionals, such as application developers and database administrators. Business-oriented...

One of the beautiful things about SQL Server is how accessible it is. It is about as difficult to install as, say, Microsoft Office. This is great if you want a sandbox, or a database to support just a handful of users. The problem is that in order for SQL Server to...