(Richard Foote) As I discussed in my previous posts, Oracle Automatic Indexing will try and create as few indexes as possible to satisfy existing workloads, even if that means reordering the columns in an existing index.
Community
Shared Responsibility Model in the Cloud – Part 2
(Mike Benshoof) In an earlier post, I discussed the Shared Responsibility Model in the cloud and how it relates to databases. With either IaaS or DBaaS deployments, much of the operational and security burden is shifted away from the DBA to the cloud provider.
How to Restore Model Database in SQL Server
(Daniel Farina) You are facing a problem with one of your SQL Server instances. Something happened to one of the disks and the result is a damaged model database, so SQL Server won’t start up. In this tip I will show how you can fix this issue.
Master Chef (Part 1) ASP.NET Core MVC with Fluent NHibernate and AngularJS
(Fred Song) This article will walk you through the elements involved in building a Single Page Application. It covers Fluent NHibernate, its installation, adding data model classes, mapping classes, and repository glass.
How to trace SQL Server Backup
(Jack Vamvas) Question: I’m trying to understand for educational purposes , what are the exact steps the SQL Server Backup is taking to progress through a SQL Server backup.
Awesome Forward & Reverse Geocoding API: positionstack
One awesome web functionality we take for granted is geolocation. Based on geolocation data, we can get someone to their destination, provide them suggestions based on their location, and so on.
Jenkins Pipeline H2 Database Integration Testing
(David Morris) An Agile software development principle is continuous delivery and integration of working software. Jenkins software automates this process.
An Overview of Convention-Based Routing in ASP.NET Core 3.0 MVC
(Matthew Jones) Now that we’ve discussed some basics of routing in ASP.NET Core 3.0, we can move on to talking about convention-based routing in MVC.
An Introduction to Object Serialization in C++
(Manoj Debnath) Serialization is a mechanism to convert an object into a sequence of bytes so that it can be stored in memory. The byte stream, once created, also can be streamed across a communication link to a remote receiving end.
Blazor’s Future: gRPC Is Key
(David Ramel) Blazor guru Steve Sanderson detailed what Microsoft is thinking about the future of the revolutionary project that enables .NET-based web development using C# instead of JavaScript, explaining how gRPC is key, along with a new way of testing and a scheme for installable desktop apps.