(Jack Vamvas) Question: I have a JSON file loaded daily onto a drive . I need to set up a process to read the JSON file and translate into a SQL recordset.

(Pinal Dave) One of my recent clients had a very interesting situation of memory pressure, which we detected during the Comprehensive Database Performance Health Check. In most of the cases, my clients have either CPU pressure issue or the disk/IO issue. However, in this particular case, we had memo

(blobeater) A small but useful change has been made to the Azure Portal for Data Platform objects.

(Denny Cherry) While the GUI (SSMS) has UNLIMITED in there, that’s actually not the right answer here. If you set the truncation log file to UNLIMITED and click save, it’ll actually reset the maximum file size to 2TB, since that’s actually the max supported size of a transaction log file.

(Aleksejs Kozmins) In my SQL Server Integration Services (SSIS) projects I faced a situation where my data flow tasks that were running in parallel and transferring large volumes of data lost their data transfer speed which impacted the entire process.

(Esat Erkec) In this article, we will learn multi-statement table-valued functions (MSTVFs) basics and then we will reinforce our learnings with case scenarios.

(Pinal Dave) We are all techies and we love to use a dark theme in our IDEs. I get quite often a question about how to enable dark theme in SQL Server Management Studio during Comprehensive Database Performance Health Check. Let us see how we can change the theme and enable hidden themes in SQL Serv

(Chris Webb) Now that we can apply custom format strings to fields and measures in Power BI in the September 2019 release, I thought it would be useful to provide some examples of what’s possible with this very flexible new feature because the existing documentation for VBA isn’t easy to make sense

(Kenneth Fisher) If you look at your error log you’ll (hopefully) see entries like this shortly after the instance startup:

When using SSMS the query window is usually made up of the Editor on the top half and after you execute code, the Results are displayed on the bottom half. The problem with this is that if you need to modify the code in the Editor section the display is limited because the results pane takes up the