(Peter Zaitsev) At AWS Re:Invent 2018 there were many great announcements of AWS New Services and New Features, but one basic feature that I’ve been waiting for years to be released is still nowhere to be found.
Community
Compatibility Levels and Cardinality Estimation Primer
(Glenn Berry) Between 1998 and early 2014, SQL Server used one cardinality estimator (CE), but would introduce a new database compatibility level with every new major version of SQL Server, (with the exception of SQL Server 2008 R2).
Storage options for SQL Server database files in Azure
(James Serra) If you are using SQL Server in an Azure VM (IaaS) you have a number of options of where to store the database files (.mdf, .ldf, and .ndf). Most customers use managed disks, available in a number of offerings: Standard HDD, Standard SSD, Premium SSD, and Ultra SSD.
Why every Data Scientist should know SQL
(Rav Ahuja) Still waiting…it’s been over an hour and still nothing. I watch the clock, get some tea, ruminate on the structure of dark matter….
Unit testing DynamoDB applications using JUnit5
(Biju Kunjummen) In a previous post I had described the new AWS SDK for Java 2 which provides non-blocking IO support for Java clients calling different AWS services.
COM Object Access and dynamic in .NET Core 2.x
(Rick Strahl) I’ve been playing around with some old legacy code that uses an ASP.NET front end to some really old FoxPro COM servers. Yup – very Old Skool! It’s part of an old framework that works well on full .NET.
Recreate dropped database on Azure SQL Managed Instance
(Jovan Popovic) Azure SQL Database – Managed Instance is fully-managed PaaS service that provides advanced disaster-recovery capabilities. Even if you accidentally drop the database or someone drops your database as part of security attack,
Creating A Pandora Radio Station List Animation In Vue.js 2.5.21
(Ben Nadel) In the morning, when I’m doing my Research & Development, I tend to listen to a Pandora radio station based on the song, Say My Name by Odesza.
ASP.NET Core: Learning the Ropes, Part 3
(Eric Vogel) Welcome to Part 3 of ASP.NET Core Learning the Ropes, wherein I show how to create the Contact Controller and Razor views for creating, updating, viewing and deleting contact records from a SQL Server database using ASP.NET Core MVC with Entity Framework Core.
Generate Dynamic MySQL Multi-row INSERT Statements
(Rob Gravelle) In the Optimize MySQL Inserts Using Batch Processing article, a couple of ways to achieve faster INSERT speeds in MySQL were explored.