(Pinal Dave) I really like my work as every single day I get to see different SQL Server and new interesting problems to solve when I work with Comprehensive Database Performance Health Check. Recently, while working with a client we noticed that they have a huge index with a first key column as uni
Community
Azure SQL Database Failover – Grace Period?
(blobeater) The Azure SQL Database service triggers an automatic failover after a failure is detected and the grace period has expired. What is the grace period?
Db2 Persistent Diagnostic Data – Use Case: Isolating high CPU operations
(David Sciaraffa) The Db2 Persistent Diagnostic Data scripts (available here) collect various Db2 and Operating System diagnostic information, and retain this info for a period of time, allowing for basic triage of many types of issues.
Mastering Java exceptions, Part 1: Exception handling basics
(Jeff Friesen) Java exceptions are library types and language features used to represent and deal with program failure. If you’ve wanted to understand how failure is represented in source code, you’ve come to the right place.
Using FluentValidation in ASP.NET Core
(Shawn Wildermuth) I’m working on an example to explore some more complex modeling in EF (for SQL and NoSQL) but that’s not ready so I thought I’d use it as a bed for some Validation testing I’m doing.
Understanding Automatic Type Conversion in C++
(Manoj Debnath) There are many data types in C++; some are related to each other. Conversion between related types is implicitly supported by C++.
Accessing and Extending Authorization Claims in ASP.NET Core and Blazor
(Peter Vogel) When you need to integrate authorization with procedural code, you’re going to need your application’s ClaimsPrincipal object so that you can check the user’s authorization claims. Here’s both how to get to the ClaimsPrincipal and how to extend it with custom claims.
Percona XtraDB Cluster 8.0 (experimental release) : SST Improvements
(Kenn Takara) Starting with the experimental release of Percona XtraDB Cluster 8.0, we have made changes to the SST process to make the process more robust and easier to use.
Calling an Oracle DB stored procedure from Spring Boot using Apache Camel
(Maarten Smeets) There are different ways to create data services. The choice for a specific technology to use, depends on several factors inside the organisation which wishes to realize these services.
Understanding/Modifying Oracle GoldenGate Microservices Settings
(Bobby Curtis) Oracle GoldenGate Microservices provide a wide range of options from administration and security to enhance the replication setup and experience. The Microservices architecture makes interaction with Oracle GoldenGate much easier compared to the traditional Classic architecture.