Percy Reyes

Understanding SQL Server's internal architecture and components, such as the Relational Engine, Storage Engine, indexes, and locking mec...

Managing SQL Server databases may sometimes be challenging especially when it comes to dealing with transaction log file internal space usag...

While SQL Server provides automatic statistics management, manually updating statistics allows for greater control over database performance...

SQL Server query hints are directives that can be included in your SQL queries to guide the SQL Server Query Optimiser in executing them. Ty...

The SQL Server Query Optimiser is a crucial component of Microsoft SQL Server, responsible for determining the most efficient way to execute...

Undoubtedly, poor cursor usage is a critical issue to review in order to mitigate the risk of CPU bottlenecks and to assess whether cursors ...

Beyond all doubt, it is essential to have a good understanding of the Transaction Log (T-Log) so that we can diagnose unforeseen performance...

Regardless of the method employed to take SQL Server backups, they must be carefully monitored around the clock, particularly in critical da...

In the realm of SQL Server database management, the integration of artificial intelligence is transforming how organisations optimise their ...

SQL Server 2022 brings a comprehensive suite of features designed to enhance the development experience, improve performance, and strengthen...

SQL Server 2022 brings a wealth of new features that empower DBAs to enhance database performance, security, and usability. By leveraging th...

Computer circuitry has crept into nearly everything we use nowadays, and almost all of which gather information from us and about us. As a r...

I have never worked for Microsoft, but SQL Server has given me a lot in terms of learning, community and opportunities, all these together h...

Undoubtedly, many of us have the task of installing a new stand-alone SQL Server instance which includes the database engine service only. F...

With the arrival of AlwaysOn Availability Group in SQL Server 2012, implementing HA+DR solutions have been an easier and not expensive task ...

Monitoring the state of database statistics is crucial because they significantly influence overall performance. When statistics become outd...

Not having another way of fixing some specific errors, at times some people may consider turning off any ANSI database options as a final s...

Clearly, it is of paramount importance to standardise the collations for all databases in a SQL Server instance in order to avoid dealing wi...

While restoring a replicated database without KEEP_REPLICATION  option, SQL Server will remove replication settings by executing  sp_restore...

When it comes to altering database collations we may face some problems that tend to slow us down at the beginning. Nevertheless, digging in...