(Ben Snaidero) As SQL Server database professionals we are always tasked with moving data around. One of the methods I use quite often when copying data between instances (especially when it is just a one-off table copy between test environments) is to setup a linked server between the instances an
Community
Azure SQL Database – Aborting Scale Request
(blobeater) Scaling up or down an Azure SQL Database is a very common task. Whilst common it is also very easy to do via the Azure portal or even PowerShell.
Java’s Future-Looking Projects: Panama, Loom, Amber, and Valhalla
(Dustin Marx) The press release “Oracle Code One Java Keynote Outlines the Future of Java” describes the Java Keynote at Oracle Code “highlight[ing] future projects” Project Valhalla, Project Panama, Project Amber, and Project Loom.
Deploying A Blazor Application On Azure
(Ankit Sharma) In this article, we will learn how to deploy an ASP.NET Core hosted Blazor application on Azure. We will use Visual Studio 2017 to publish the app and create a SQL database server on Azure to handle DB operations.
Understanding The Limitations Of Template Syntax Desugaring In Angular 7.0.4
(Ben Nadel) Last week, I looked at the fact that the Async Pipe “as” syntax is nothing more than the “$implicit” view context property provided by the current directive (which turns out to not be exactly true, as demonstrated below).
How to Encrypt SQL communication on the wire
(SanketBa) A lot of applications are moving to the cloud. The Iaas model provides a great way to lift and shift the applications and start leveraging the goodness of the cloud without having to re-write to adapt to the Platform-As-a-Service (Paas) model.
SQL SERVER – Unable to Start Service SQLSERVERAGENT on Server (mscorlib)
(Pinal Dave) There are several reasons for the error mentioned in the blog title. In this blog, we would learn about one of the causes of error Unable to start service SQLSERVERAGENT on a server.
Db2 12 and the IBM Data Server Drivers with FL 501 and Above
(Chris Crone) Db2 12 has been available for over 2 years and many customers have migrated to Db2 12 Function level 500. Function Level (FL) 500 enables all the new Db2 12 base capability and is equivalent to what we used to call New Function Mode (NFM) in Db2 11 and below.
Replication Monitoring with the Performance Schema
(Jesper Krogh) The traditional way to monitor replication in MySQL is the SHOW SLAVE STATUS command. However as it will be shown, it has its limitations and in MySQL 5.7 and 8.0 the MySQL developers have started to implement the information as Performance Schema tables.
Parallel_degree_policy AUTO caused serial plan in qat
(Bobby Durrett) Recently during testing a merge statement was running forever in our qat environment after a simple change. We had simply added a few columns to an existing table.