(Denny Cherry) Cost Threshold for Parallelism is a setting in SQL Server that’s been around for as far back in the product that I can think of. It decides how expensive an operator needs to be because SQL Server will use multiple threads for that operator instead of a single thread.
Community
Using Azure Data Factory to Migrate Data
(blobeater) Quite simply the objective as follows: Move data from Azure SQL Database to Azure SQL DW via Azure Data Factory v2 (ADF).
Guru: Emulate Control Break Reporting With DB2 For i SQL
(Michael Sansoterra) When generating ad hoc user reports, it’s often the case that developers don’t have the time or luxury to write a high-level language program or to use a reporting tool such as DB2 Web Query or Crystal Reports to format the data appropriately.
Visual Studio Code Remote Development may change everything
(Scott Hanselman) OK, that’s a little clickbaity but it’s surely impressed the heck out of me. You can read more about VS Code Remote Development (at the time of this writing, available in the VS Code Insiders builds) but here’s a little on my first experience with it.
Integrating Blazor into Existing ASP.NET Core Applications
(Peter Vogel) If you want to add server-side Blazor to your existing ASP.NET Core applications, you can. There’s not much to it, fortunately. In fact, there’s probably more work involved in creating a View or Page that will play well with your component
Ajax file upload in Node.js
(Shahid shaikh) We all love Ajax, don’t we? And there is an obvious reason. Ajax is great for user experience.
Test Remote Asynchronous Request Response services
(Martien van den Akker) A few years ago, I described how you can test Asynchronous Request Response services.
Recovering database from loss of datafile in NOARCHIVELOG MODE
(Jagruti Jasleniya) We have seen an ERROR in the opening database. let’s recover it.
Tutorial: Exporting Query Results
(Jeff Smith) This is a 101 level type of topic – a fundamental bit of SQL Developer that I would encourage everyone to be familiar with. Why? Because it’s probably something you’ll be doing, A LOT. So let’s get into it, already!
SQL SERVER – Installation Error: System.ArgumentNullException – Value Cannot be Null
(Pinal Dave) One of my clients was trying to automate SQL deployment. While testing they were stuck with an interesting error and then they contacted me. In this blog, I would share my learning about an installation error: System.ArgumentNullException – Value cannot be null.