(David Fitzjarrell) Occasionally bugs creep in to code trees and end up in production.
Community
XSL 2.0 and XQuery 1.0 in .NET
(Gavin Sinai) This small project started when I wanted to use XSL 2.0 and XPath 2.0 in my .NET code. The problem is that the .NET framework only provides XSL 1.0 and XPath 1.0 out of the box.
Visual Studio Toolbox: Unit Testing: Test Driven and Scenario Based Testing
(Robert Green) This is the first of a four part series, recorded this summer, where I am joined by Phil Japikse to discuss unit testing. This series expands on the 2017 Unit Testing episode.
sql_mode
(Peter Gulutzan) The following statement usually is valid and the function returns 1. But sometimes it is invalid and sometimes the function returns 0.
Recover From Redo Log File
(Anuradha Mudgal) This post explains about the steps are used by DBA for recovery From Redo Log File.
Faceted Search and Filtering in Power BI Reports
(Siddharth Mehta) Data search is a very common requirement and filters in reports is one way of letting users search the data and adjust the scope of data as desired. When reporting with large datasets, reports tend to have a substantial number of records on a single screen and even filters can have
Pipes In Angular 6
(Sanwar Ranwa) In this article, we are going to learn about Pipes in Angular 6.
The Right Way to Do Insensitive String Comparison
(Srinath M S) We often do String.ToUpper() on two strings to compare them.
SQL SERVER – Database Performance Analyzer – Table Tuning Advisors
(Pinal Dave) I am a SQL Server Performance Tuning Expert who acts as a consultant for many organizations across the world who have performance tuning issues.
Monitoring S.M.A.R.T. Metrics with Prometheus and PMM
(Peter Zaitsev) In his excellent blog post, Pavel Trukhanov showed the value of S.M.A.R.T. metric collections, so I wondered how hard would it be to enable their collection in Percona Monitoring and Management (PMM)