(Ben Nadel) I just wanted to share a cool feature of TypeScript that I stumbled across the other day: TypeScript will silently ignore the attempt to spread Null or Undefined values into an Object literal.
Community
MySQL Challenge: 100k Connections
(Vadim Tkachenko) In this post, I want to explore a way to establish 100,000 connections to MySQL. Not just idle connections, but executing queries.
Final Elimination
(David Fitzjarrell) Occasionally a join using primary key columns in a query can be eliminated because of the data involved.
Introduction to Bash Scripting: Pipes and Redirections
(Daniel Farina) There have been several tips about using bash scripting to help the SQL Server DBA working in a Linux environment. In this tip you will learn about the importance of pipes and redirections for bash scripting in Linux and its usage.
IGNORE_DUP_KEY slower on clustered indexes
(Paul White) The IGNORE_DUP_KEY option for unique indexes specifies how SQL Server responds to an attempt to INSERT duplicate values: It only applies to tables (not views) and only to inserts
Securing ASP.NET Core in Docker
(Muhammad Rehan Saeed) Some time ago, I blogged about how you can get some extra security when running Docker containers by making their file systems read-only.
Same action method and different parameters in .NET core
(Sheo Narayan) In this article, we will learn how to use same action method name with different parameters and return different views in .NET Core.
Keeping Configuration Settings in Memory
(Peter Vogel) In an earlier column, I showed how to access configuration settings in your project’s appsettings.json file and then make those settings available throughout your application as IOptions objects.
MySQL Exact Row Count For All The Tables
(Bhuvanesh R) Getting the row count from mysql tables are not a big deal and even there is no need for a blog for this. Simply go and query the INFORMATION_SCHEMA and get the row count for the tables. But this is not your actual row counts.
Migrating DB2 Databases to Azure
(Kellyn Pot’Vin-Gorman) Yep, still doing a lot of database migrations. Just too many people wanting to migrate their other database platforms over to Azure…
