(Pinal Dave) It has been over 3 weeks since SQL Server 2019 launched and after reading my recent blog posts about the Memory Grant Feedback, I was approached by one of the leading banks in Europe to help them build an efficient architecture and performance-optimized system Comprehensive Database Per
Community
A basic icon editor running on ReactOS
(Steffen Ploetz) Create a basic icon editor, that is running on ReactOS and Windows, with as little code as possible.
Db2 12 implicitly drops explicitly created universal and LOB table spaces with function level 506
(Regina Liu, Long Tu, and Jennie Chang) With Db2 12 function level 506 at application compatibility level V12R1M506 or higher, Db2 now automatically drops explicitly created universal (UTS) and LOB table spaces when the tables they contain are dropped.
Collation in SQL Server
(Mohammed Moinudheen) You must have already heard the term “Collation” in SQL Server. Collation is a configuration that determines how character data sorting is done. This is an important setting that has a huge impact on how the SQL Server database engine behaves in dealing with character data.
Turning off Parameter Sniffing for a SQL Server Database by Default
(Greg Larsen) Have you been experiencing vastly different execution times for the same query over time? If so, you might be experiencing what is known as “Parameter Sniffing”.
IHostingEnvironment vs IHostEnvironment – obsolete types in .NET Core 3.0
(Andrew Lock) In this post I describe the differences between various ASP.NET Core types that have been marked as obsolete in .NET Core 3.0.
Use IHttpClientFactory To Invoke Web API In ASP.NET Core
(Bipin Joshi) If you have worked with ASP.NET Core Web APIs before, chances are you used HttpClient to invoke them. Although instantiating HttpClient directly is a common way of using it, there is a better alternative.
Tutorial: Get Comfortable with .NET Core and the CLI
(Jeremy) I’ve created a walkthrough to get started using .NET Core and the command-line interface (CLI). It’s available on GitHub:
Java 13: Enhancements to Switch Expressions
(Fahd Shariff) You may remember from my previous post that, in Java 12, the traditional switch statement was enhanced so that it could be used as an expression. In Java 13, there has been a further change to this feature.
Experience the power of big data with Apache Spark and Cloud Pak for Data
(Shikha Garg) Data is all around us. By 2020, IDC expects the entire store of data to be as large as 44 zettabytes, amounting to a single bit of data for every star in the physical universe.