(Pinal Dave) During my consultancy engagement, my client’s DBA team was installing SQL Server and getting an error. Since they know my work style, I got pulled into fixing that issue. In this blog, we would learn how to fix SQL installation error: Validation for setting ‘AGTSVCACCOUNT’ failed. Error
Community
T-SQL Formatters
(Kenneth Fisher) The other day I was given a truly horribly formatted piece of SQL. Something a bit like this only worse, and with plenty of dynamic SQL.
Database Fundamentals #18: The SELECT Statement
(Grant Fritchey) In my previous Database Fundamentals post, I showed you how to use the Query Designer to build a query. That was a SELECT statement. The basic construct of all your SELECT statements will be the same.
Improving Testability of Java Microservices with Container Orchestration and a Service Mesh
(Sebastian Daschner) In enterprise test scenarios, software needs to be tested in the same way as it will run in production, in order to ensure that it will work as expected. A common challenge is that microservice applications directly or indirectly depend on other services that need to be orchestr
Getting Started with LiteDB in .NET
(Tapas Pal) LiteDB is a simple, serverless, fast and lightweight, embedded .NET document database written in .NET C# managed code. It’s completely open source and free to use, even for commercial use.
Query Types in Entity Framework Core
(Mike Brind) In previous versions of Entity Framework, it is possible to return a subset of the columns of a table by projecting to a non-entity type. Up until version 2.1 there was no way to return non-entity types from queries in Entity Framework Core.
3 Types of PHP Profilers and Why You Need All of Them
(Ben Putano) PHP is one of the most popular languages in the world, and some say it’s one of the easiest to learn. Still, even the best languages need some help.
Guru: Refactoring RPG – Indicators
(Ted Holt) Occasionally I hear someone comment about how terrible indicators are. I don’t think they’re bad. Indicator-laden RPG helped me graduate debt-free with a computer science degree and housed, clothed, and fed my family for several years.
Using TSA/db2haicu to Automate Failover Part 5: Additional Configuration Best Practices
(Ember Crooks) IBM has published a document with some additional best practices for configuring TSAMP, so I thought I would add an article to my TSA series covering these settings.
Stream Analytics: batching events and trigger on ‘last’
(Maarten van de Bospoort) For a side project, I had to write a few Azure Stream Analytics queries. Not being a SQL — let alone Stream Analytics — person, it required some effort and substantial assistance. Hope it helps.