(Pinal Dave) Some concepts are so good in SQL Server, they keep on coming back to me one way or another way. After reading my recent blog posts about CHECKPOINTS lots of people wanted to see the demonstration of the same.
Community
T-SQL Performance Tip: NOT IN vs NOT EXISTS
(Hannes du Preez) Avoid using NOT IN whilst comparing nullable columns.
Understanding the SQL Server CASE statement
(Ben Richardson) SQL Server CASE statement is equivalent to the IF-THEN statement in Excel.
Why dsmtop isn’t Even Half as Good as db2top
(Ember Crooks) I think I’m beginning to better understand why IBM is not fond of tools like db2top. The truth is that the developers really only get exposure to the largest Db2 clients.
4 Awesome Things In Xamarin.Forms 4.0 | The Xamarin Show
(James Montemagno) This week, James is joined yet again by friend of the show David Ortinau, Xamarin SDK & Xamarin.Forms Program Manager, tells us all about the latest features to love in Xamarin.Forms 4.0 including Shell, visual, accessibility improvements, image optimizations, and a lot more!
State in Multi-threaded C# Applications
(Yacoub Massad) In this tutorial, I will talk about ways to handle state in multi-threaded C# applications, including race conditions.
The Transient Keyword in Java and Its Use
((Alexius Diakogiannis) I recently came a cross in a study project of one of my friends that are studding the basics of programming in Java some forgotten sensitive information printed in text files and remembered the transient keyword in Java.
Creating asyncAll(), asyncSettled(), And asyncRace() Functions Using runAsync() And Parallel Iteration In Lucee 5.3.2.77
(Ben Nadel) The other day, I was delighted to discover that Lucee 5.3.2.77 supports asynchronous iteration of collections, including “each”, “map”, and “filter” operations.
How to properly shutdown MySQL before any maintenance activity
(abhinav prasad gupta) We might have different scenarios once we need to stop MySQL service before performing either server or database activity like patching/upgrade.
Fix for Oracle VBCS ‘Error 404–Not Found’
(Andrejus Baranovskis) We are using Pay As You Go Oracle VBCS instance and had an issue with accessing VBCS home page after starting the service.