The executable process that is the SQL Server Database Engine is called the Database Engine service. The Database Engine service is an executable...
Blog
What are the top cluster setup mistakes for SQL Server?
Windows Failover Clustering can keep your SQL Server databases online and your customers happy when hardware or operating system problems strike....
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...
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...
RAD Studio 10.4 Patch 3 is out: VCL Grids, C++ Win64 Debugging, and C++ Android Exception Handling and Resources
We've just released patch (or hotfix) 3 for Delphi, C++Builder and RAD Studio 10.4. If you use VCL grids or C++Builder, we recommend you install...
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...
C++Builder support for ISO C++ in version 10.4 Sydney
There have been several questions on forums and Stack Overflow about ISO C++ language support in the most recent release of C++Builder. This post...
The Value of an IT Capacity Planning Strategy
Planning to ensure that requirements are met is a practice that is performed in many different situations. The need to accurately plan manifests...
How should you handle the complexities of regulatory compliance?
The reliance on digitally stored information continues to grow and now dominates society in the 21st Century. The use of the Internet for business...
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...
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...
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...
10.4 Patch 2 Installation Guide
RAD Studio 10.4 patch 2 was released yesterday, but installing has some manual steps. Here’s how to do it. 10.4 Patch 2 (see Marco’s blog post)...
Revised: 10.4 Patch and C++ Android Exception Handling
Edit 28 July 2020: Patch 3, released today, resolves this issue. We recommend you install it. Please see the blog post for installation instructions...
10.4 Patch #2: Delphi code completion and IDE fixes
10.4 Patch #2, released yesterday, makes many tweaks and changes to DelphiLSP code completion Delphi 10.4 redesigned Code Insight, one of the most...
Fixed in 10.4 Patch #2: Instability debugging in RAD Studio 10.4
10.4 Patch #2 fixes the issue where debugging could be unstable and show an unexpected dialog. Last month, I posted about an issue in 10.4 that...
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...
Вышел второй пакет исправлений для RAD Studio 10.4
В субботу 18 июля компания Embarcadero объявила о доступности для пользователей второго пакета оптимизации и исправлений для последней версии RAD...
Patch 2 for RAD Studio 10.4 now available
This patch addresses a number of issues in RAD Studio 10.4, pertaining to Delphi Compiler, the RAD Studio IDE in general and the new LSP-based Code...
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...
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...
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...
How can you protect personally identifiable information (PII) in databases?
The data resources of an organization are one of its most valuable assets. Except for its people, the information contained in enterprise databases...
Uptime Infrastructure Monitor 7.8.6 General Availability
We are pleased to announce the general availability of Uptime Infrastructure Monitor 7.8.6. Existing users may upgrade to this version through the...