Defragment Your Indexes For Better Database Performance

Defragment Your Indexes For Better Database Performance

Providing information is the most fundamental purpose of a database. This is accomplished through queries that are submitted by the database’s users. Based on the parameters submitted in a query, the database is searched for appropriate results. Hopefully, an...

How can you prevent SQL Server intrusions?

How can you prevent SQL Server intrusions?

Understanding how SQL Server can be infiltrated 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, decrease in customer confidence, and...

Finding the Best Way to Present Your Data

Finding the Best Way to Present Your Data

Modern organizations use their data resources for many essential activities. The information contained in enterprise databases is used to drive corporate strategy and assist in making informed business decisions. Health-related organizations may use data assets to...

Which items do you need to audit in SQL Server?

Which items do you need to audit in SQL Server?

SQL Server provides robust capabilities to monitor itself, and it can be easy to be overwhelmed with the choices presented through catalog or dynamic management views, extended events, server-side traces (for older versions of SQL Server), or performance counters....

It is Never a Bad Time to Revisit User Permissions

It is Never a Bad Time to Revisit User Permissions

A database needs users to provide any value to an organization. While it might be instructive from an academic point of view to simply collect large amounts of information in electronic format, the data serves no valid purpose unless someone accesses and uses it....

How can you balance database security and database performance?

How can you balance database security and database performance?

The security of any database can be improved. However, that likely degrades the performance of the database. The cost increases to improve database security while maintaining database performance. That is, the trade-off consists of three axes: Performance, security,...

Addressing Out of Control SQL Server Sprawl Effectively

Addressing Out of Control SQL Server Sprawl Effectively

Data is the driving force in business these days. Organizations rely on their information resources to make informed decisions regarding all aspects of their operations. Productive use of data assets can provide huge competitive advantages over less-enlightened...

Вышел второй пакет исправлений для RAD Studio 10.4

Вышел второй пакет исправлений для RAD Studio 10.4

В субботу 18 июля компания Embarcadero объявила о доступности для пользователей второго пакета оптимизации и исправлений для последней версии RAD Studio 10.4. Этот пакет содержит изменения для решения многих ситуаций, когда RAD Studio 10.4 работает некорректно, в...

The Benefits of Using a Unified Interface

The Benefits of Using a Unified Interface

Individuals in many different fields of endeavor make use of tools or processes that exhibit a certain degree of consistency. Finding something that works and sticking with it is one of the hallmarks of successful professionals. You can see this methodology in action...

Are you aware of these database risks?

Are you aware of these database risks?

Databases are vitally important to modern businesses across all market sectors. They are the repository of an organization’s information resources which are essential assets used to run its business and gain an edge over its competitors. Big data and the...

Why are health checks for SQL Server life savers?

Why are health checks for SQL Server life savers?

SQL Server health checks have garnered a great deal of notoriety over the last five years. What was originally a niche offering more than ten years ago has evolved into a mainstream must-have for the SQL Server community. A health check should: (1) Validate the...

Backups Are Important Because Hackers Never Rest

Backups Are Important Because Hackers Never Rest

It’s an aspect of human nature that people tend to ignore repeated warnings that do not manifest themselves into real problems. Letting their guard down or minimizing protective measures is often the unfortunate response to longstanding vigilance that does not...

A Tool for Creating More Efficient SQL Code Quickly

A Tool for Creating More Efficient SQL Code Quickly

Information technology has become one of the most important manifestations of society’s technological advancements. IT systems are widely used for such diverse activities as shopping, banking, controlling large physical objects, and providing decision-makers...

1 22 23 24 25 26 124