(Koen Verbeeck) A webinar about SQL Server Development best practices was hosted on MSSQLTips.com. In this webcast, several tips and tricks were shared which could save a lot of time and headaches when writing T-SQL code.
Other News
Introduction To React Hooks
(Priyanka Jain) This article talks about the concept of Hooks in ReactJS and basics of useState() hooks.
Should I Stop Contacting a Customer Who Isn’t Responding to My Emails or Phone Calls?
This question came from a busy business owner. Should I stop contacting a customer who isn’t responding to my emails or phone calls? Two months ago, we sent our response to a bid. I’ve been trying to get feedback and follow up with the customer, but they have gone silent. I’ve tried reaching them by email and phone. How long...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
How to import JSON file into a SQL recordset with OPENJSON
(Jack Vamvas) Question: I have a JSON file loaded daily onto a drive . I need to set up a process to read the JSON file and translate into a SQL recordset.
Using JUnit to Test Your Java Apps: An Advanced Guide
(Matt Raible) What’s a good way to show that you care about your code? Using unit and integration tests to ensure your code is up to par.
Db2 and JCL 72 characters
(Peter Hartmann) Sometimes it is useful to generate JCL executable code for //SYSIN via SQL mass operations, e.g. change specific tables from one option to another.
Upload Files Using JQuery Ajax And JavaScript Interop In Blazor
(Bipin Joshi) Uploading files from client machine to the server is one of the fundamental operations in web applications. In ASP.NET Core MVC applications you can accomplish this task easily using HTML5 file input field and server side logic.
Q&A with Alex Thissen: Developing .NET Solutions in Docker Ecosystem
(Becky Nagel) Architecting and creating a .NET solution that uses Docker at its core comes with many questions, ranging from “How do you design a solution architecture that fits well with containers?” to “What changes in the .NET implementation from pre-Docker solutions with micro-services?”
MySQL 8.0: if I should optimize only one query on my application, which one should it be ?
(Frederic Descamps) Answering this question is not easy. Like always, the best response is “it depends” !
OIC: How to Force Dehydration in Processes
(Jan Kettenis) OIC Process uses the database to store its state, which is called dehydration. In contrast, restoring that state from the database is called hydration.