(blobeater) Checking out the transaction log in Azure SQL Database. If you are curious like me, you will want to know about what your transaction log is doing in the cloud.
Community
system_health Extended Events in Azure SQL Database
(Grant Fritchey) The system_health Extended Events session is incredibly useful. Further, it’s running, by default, in every server you have under management that is 2008 or greater. Things are not the same in Azure though.
The DB2Night Show #212: Db2 LUW SQL Tuning; Find, Fix, and Prevent Problems
(Scott) 100% of our audience learned something!Klaas gave us another amazing presentation! From monitoring commands to utility recommendations, Klaas covered it all! Watch our replay to learn MON_GET queries, OS commands, configuration settings, and best practices for making your Db2 SQL run crazy f
A New JDK12 Stream API Collection: Collectors#teeing
(Grzegorz Piwowarek) When following major Java releases, we usually focus on bold and controversial JEPs while humble and tiny changes get introduced unnoticeably.
PHP Error Log Basics
(Gaege Root) When developing PHP applications, error logs tend to be underutilized due to their apparent complexity. The reality is that PHP error logs are extremely helpful, especially when configured and used properly.
Using Dynamic Template-Driven Forms In Angular 7.2.7
(Ben Nadel) In Angular, there are two types of forms: template-driven forms and reactive forms. I’ve only ever used template-driven forms. And, I’ve never run into a forms-based problem that I couldn’t solve with the template-driven paradigm.
Dealing with Databases (and Data) in Docker
(Peter Vogel) There are lots of ways to handle databases in a containerized environment like Docker. Here’s how to create SQL Server in a container, how to load it with the data you want and how to integrate that container into whatever project needs it. Be warned: Some PowerShell is used.
SQL SERVER – Update Table Statistics in Parallel with FULLSCAN
(Pinal Dave) SQL Server Performance Tuning is a much simpler job if you know exactly where to look for and how to tune the configurations.
Group Replication – Consistency Levels
(Nuno Carvalho) The MySQL Group Replication (GR) feature is a multi-primary update anywhere or single-primary replication plugin for MySQL with built-in conflict detection and resolution, automatic distributed recovery, and group membership.
The elegant NUMTODSINTERVAL to transform numbers
(Alex Nuijten) There is a database table with three columns into which data from an external source is loaded.