(Ranga Babu) In this article, we will review SQL Server MERGE statement, alternatives to MERGE statement, different clauses and examples of MERGE statement in SQL Server.
Other News
What permissions do temp stored procedures use?
(Kenneth Fisher) In a performance tuning class I recently took with Brent Ozar (b/t) he mentioned temporary stored procedures and an interesting question came up.
The DBA is Dead? No, the DBA as Gatekeeper is Dead!
(Ember Crooks) I still remember this meeting when I had been a DBA for less than a year at IBM. It was IBM, so I was the lone primary DBA for this internal client.
Prerendering a Client-side Blazor Application
(Chris Sainty) While prerendering is now the default for server-side Blazor applications, I only recently discovered (as in the last 48 hours via Daniel Roth’s work) that client-side Blazor applications can take advantage of this as well.
Creating A Composite Index Using Ancestral Keys In A Hierarchical Database Table Design
(Ben Nadel) For the most part, when designing database tables that exist in some sort of an hierarchical relationship, the “child” table will contain a key reference to the “parent” table.
How to Internationalize and Localize Your Java and Spring Boot Apps
(Matt Raible) First, what even is internationalization (i18n) and localization (l10n)?
Performance Schema Functions
(Jesper Krogh) The sys schema was created to make it easier to use the Performance Schema. This included several functions, for example to convert the picoseconds used by the Performance Schema into human readable strings.
The Fault Encapsulation Pattern
(Jan Kettenis) This posting discusses an integration pattern where you return a fault as a message instead of as a fault, to prevent that the execution of the integration is indicated as having errored.
RMAN Incremental & Demo Part 2 (Level 1)
(Zahid Anwar) This blog post is part of the “RMAN Back to Basics” series, which can be found here.
Creating a Backup Schedule
(Jagruti Jasleniya) Being a DBA it is your key responsibility to set a proper backup strategy. Today we will see how we can schedule backup :