Monthly Archives: December 2018

Advice for young Professionals

By | December 20, 2018

Every year I get asked a standard set of question during my trainings. Most of the time the question is phrased differently like “What do you think I should do next in my career?” or “Which technology should I focus on?” Having heard the question multiple times I have gotten lazy and stuck to my… Read More »

SQL 2019:- Truncation Error message and where it fails

By | December 6, 2018

I was wondering if I should even bother checking this feature out since it was pretty obvious what it does and how useful it is. I can’t even begin to explain how many times I have had to troubleshoot truncations errors when working with customer data. The basic thing about this feature is that now… Read More »

Laws for Robotics

By | December 3, 2018

Recently I finished reading the late Stephen Hawking’s book “Brief Answers to the Big Questions”. One of the chapters it covers is Artificial Intelligence. A point he covers in the book mentions a framework for how AI should be used; a set of guidelines for AI to follow or more simply put some rules for… Read More »

SQL 2019:- Table Variable deferred compilation – PART 2

By | December 3, 2018

In the last post we ended with two questions remaining unanswered. Shouldn’t a more accurate row count have resulted in the correct amount of memory being granted and more importantly why didn’t intelligent Query processing detect and correct the issue in subsequent runs? We were exploring the improved performance of Table Variable deferred complication to… Read More »