(Richard Foote) In my previous post on Automatic Indexing, I discussed how the default index column order (in absence of other factors) is column id, the order in which the columns are defined in the table. In this post, I’ll explore if this changes if index compression is also implemented.
Other News
SQL Database Project Code Branching in Git
(Haroon Ashraf) As a SQL Server database developer, I need to understand and implement the concept of database code branching particularly in the case of state based database development using SQL Server Data Tools (SSDT).
Modal Popup Example and Tutorial with Angular 9 Material
(Ahmed Bouchefra) In this tutorial, we’ll build by example a modal popup using Angular 9 Material.
Different methods to identify the SQL Server version number
(Nisarg Upadhyay) In this article, I am going to show different methods to identify the SQL Server version number and its edition. Also, I have included the list of known SQL Server version numbers, Service Packs (SP), and Cumulative Updates (CU of MS SQL Server 2019, 2017). I have not included the
Overview of Azure SQL Database Serverless
(Marcin Policht) Public cloud offers a wide range of benefits, including scalability, agility, and on-demand resource provisioning. While these benefits apply to majority of cloud services, they are most apparent in the context of serverless computing.
Getting to Know Deep Java Library (DJL)
(Kesha Williams) Amazon’s DJL is a deep learning toolkit used to develop machine learning (ML) and deep learning (DL) models natively in Java while simplifying the use of deep learning frameworks. A toolkit open-sourced just in time for re:Invent 2019, DJL provides a set of high-level APIs to train,
Practical RPG: Encapsulating Your Data with Extension Files, Part 1
(Joe Pluta) As business programmers, we spend most of our time working with the database, one way or another. Unless we’re lucky enough to be in on the ground floor of a new installation of a modern package, chances are that database will require modifications to support changing business requiremen
Localising Data Annotation Attributes in Razor Pages
(Mike Brind) This is the third article in a series that explores various aspects of localisation in ASP.NET Core Razor Pages applications. The first article looked at how to work with cultures, and the second covered the basics of using resource files for static content translations.
A Quantum Random Number Generator for .NET: The quantum measurement problem and many-worlds approach
(Andrew Lock) I’ve been listening to a lot of Sean Carroll’s Mindscape podcast recently, and in a recent episode with Rob Reid he discussed the Everettian or “many-worlds” approach to explaining the measurement problem in quantum mechanics.
Common .NET Controls Crash Course, Part 2: RadioButtons
(Hannes DuPreez) Part One of my “Common .NET controls crash course” articles, “Common .NET Controls Crash Course, Part 1: Checkboxes,” spoke about the Checkbox control and how to use it. In Part 2, I am going to speak about the RadioButton control.