(Peter Wayner) It’s been a long trip for Java, a language that began as the lingua franca for the box on top of the television set in the days when TVs didn’t come with Roku or Chromecast built-in.
Community
SQL Server Profiler in Azure Data Studio
(Rajendra Gupta) In this article, we will explore SQL Server Profiler in Azure Data Studio in detail including download and installation, execution plans, coding T-SQL and more.
Savings changes is not permitted. The changes you have made require the following tables to be dropped and re-created.
(Kenneth Fisher) Microsoft does a lot of things to try to help us not shoot ourselves in the foot. This little error is one of them. It’s an annoying error, and almost everyone turns it off automatically, so what is it and why is it there?
Guru: Arranging Query Logic in DB2 for i Routines
(Michael Sansoterra) Hey, Mike: We use a stored procedure to return the result set to Java and display the results to a screen. I would like to make this stored procedure put the result set into a temporary table and then do some processing on the temporary table. Is this possible and if so how c
Don’t let ASP.NET Core Console Logging Slow your App down
(Rick Strahl) Earlier today I put my foot in my mouth on Twitter by running a quick and dirty perf test application to check out a question from a customer, without properly setting up configuration.
Backing Up and Restoring Your SQL Databases Through .NET
(Hannes DuPreez) A very important part of every developer’s daily routine is to ensure that the SQL Server’s backups were done properly.
The GetRegionData function fails if the buffer is allocated on the stack. Is it allergic to stack memory or something?
(Raymond Chen) If you pass a NULL buffer to the GetRegionData function, the return value tells you the required size of the buffer in bytes.
Caveats With pt-table-checksum Using Row-Based Replication, and Replication Filters
(James Lawrie) As per the documentation, pt-table-checksum is a tool to perform online replication consistency checks by executing checksum queries on the master, which produces different results on replicas that are inconsistent with the master.
Step by Step Installation of PostgreSQL 11 on Oracle Linux 7
(Fahd Mirza Chughtai) This is quick spit-out of commands, I used on my test virtual machine to install PostgreSQL 11 on Oracle Enterprise Linux 7.
Machine Learning – Date Feature Transformation Explained
(Andrejus Baranovskis) Machine Learning is all about data. The way how you transform and feed data into ML algorithm – greatly depends training success. I will give you an example based on date type data.