(Paul White) I briefly mentioned that batch mode data is normalized in my last article Batch Mode Bitmaps in SQL Server. All data in a batch is represented by an eight-byte value in this particular normalized format, regardless of the underlying data type.
Community
New video: Versioning for IBM Db2 for z/OS REST services
(ealameida) A new addition to the REST services series on the World of Db2 Youtube channel is now available.
Thoughts on ‘Are We Done Yet?’
(K. Scott Allen) A classic question in software is “are we done yet?”. This is not just a question for software developers. Anyone who is working in IT needs to ask the question when writing code, testing a feature, upgrading a network, or designing a user experience.
Using Secrets in Azure Pipelines
(Subodh Sohoni) Azure Key Vault is a service from Azure that allows storage of keys, secrets and certificate in a safe and encrypted repository. In this tutorial, I am going to show you different ways that Azure Key Vault can be used by Azure DevOps Pipelines.
MySQL 8 support for custom SQL CHECK constraints
(Vlad Mihalcea) In this article, we are going to test the MySQL 8 implementation of custom SQL CHECK constraints.
Dynamic tabs with Angular 6+ and ng-bootstrap
(Emmy Hermans) One of our Angular applications required the use of dynamic tabs. Since the project already uses ng-bootstrap components and bootstrap for the styling, I decided to use the tabset component from ng-bootstrap.
Not all GROUPING SETS are created equal
(Oren Nakdimon) I’ve just realized, once again, that the Oracle Optimizer is even smarter than I thought. The comments (by Iudith Mentzel and Thomas Mautsch) to my previous post, GROUPING SETS and COLLECT don’t get along, made me understand that not all GROUPING SETS were created equal.
Wipe APEX mail queue
(Jeffrey Kemp) Refreshing any of our non-prod environments (e.g. dev, test, etc.) with a clone from production is a fairly regular process at my client.
Some Query Filtering Examples in ORDS
(Jeff Smith) I said on Twitter yesterday that this was one of my favorite features…
SQL SERVER – Best Value for Max Worker Count
(Pinal Dave) I have been working as a SQL Server Performance Tuning Consultant for over 10 years. During the last 10 years, I have worked with over 100s of clients helping them with Comprehensive Database Performance Health Check. My experience says that most of the performance problems occur becaus