(Carlos Robles) SQL Server Query Store data persists on disk even after backup and restore operations, let’s imagine a production database is restored in a QA environment for UAT because testers want to use the latest data from production.
Community
Angular 7 with .NET Core 2.2 – Global Weather (Part 3)
(Fred Song) In Global Weather Part 1 and Global Weather Part 2, we built an Angular 7 app and a .NET Core 2.2 micro API service step by step. In this article, we’ll start to look at unit tests.
Preparing for SQL Server Database Corruption; initial reaction and analysis
(James Rhoat) Corruption is a looming thought through every administrator’s mind, from sysadmins to database administrators there is always a monster hiding in the shadows.
Automating T-SQL for Azure SQL Database via Logic Apps
(blobeater) Have you ever wanted to capture the T-SQL, waits, sessions IDs (etc) at a specific time for Azure SQL Database?
Db2 SQL Basics: The Column List
(Ember Crooks) Learning SQL can feel intimidating, even to some experienced DB2 DBAs. For years, you could administer Db2 without using SQL. There are a lot of developers, too who want to learn SQL. The set-thinking of SQL can be confusing.
Java XML and JSON: Document processing for Java SE, Part 1
(Jeff Friesen) XML and JSON are important to me, and I’m grateful to Apress for letting me write an entire book about them. In this Java Q&A post I will briefly introduce the second edition of my new book, Java XML and JSON.
C# SqlException: Procedure or function has too many arguments specified
(Steve Endow) I’ve been fighting this error for years in my Data Access class. Only yesterday did I figure out the cause.
Extracting Text from an Image Using Tesseract in C#
(Tapas Pal) Tesseract engine optical character recognition (OCR) is a technology used to convert scanned paper documents, PDF files, and images to searchable text data.
Using ASP.NET Core SignalR with Vue.js (to create a mini StackOverflow rip-off)
(Daniel Jimenez Garcia) Using an ASP.NET Core backend, and a Vue.js frontend, we will look into the main concepts and building blocks of SignalR by implementing a minimalistic version of StackOverflow.com
Collecting .NET Core Linux Container CPU Traces from a Sidecar Container
(Jeremy) In recent years, containerization has gained popularity in DevOps due to its valuable capacities, including more efficient resource utilization and better agility.