(Chris Webb) Do you have a Power BI report that has a row of card visuals on it, something like this:

(Grant Fritchey) I know I’m a weirdo. I’ve always been a weirdo. When I was a DBA (now I only play one on TV), I was a weirdo too. Case in point, ORM tools. Whether we’re talking nHibernate, Linq, or Entity Framework, the degree of loathing for these tools by most DBAs is really hard to measure.

(John Miner) The concept of a network of smart devices was discussed as early as 1982, with a modified Coke vending machine at Carnegie Mellon University becoming the first Internet-connected appliance.

(James Serra) As I see a huge number of customers migrating their on-prem databases to the Azure cloud, the main question they ask is about whether they should go with an IaaS solution (SQL Server in a VM) or a PaaS solution (SQL Database).

(Julie Koesmarno) G’day! In this blog post, I’d like to touch on how Data Analysts can leverage SQL Notebooks (available in Azure Data Studio) to document their analysis, to share their methods / techniques and to collaborate with others so that they can reproduce the analysis and/or they can extend

(Pinal Dave) SQL Server Performance tuning is an amazing subject, it never stops to amaze me. Every single day, I take only one Comprehensive Database Performance Health Check and keep the rest of the time open for either learning new stuff or helping people with On Demand (50 Minutes).

(Joe Gavin) You need to create an automated process to transfer files using Secure File Transfer Protocol (SFTP) with SQL Server Agent. Check out this article to learn how.

(Pinal Dave) While preparing for a demo for my client Comprehensive Database Performance Health Check, I was installing necessary applications on my laptop. In this blog, I would share my experience with SQL Server Management Studio SSMS install error – Setup is blocked due to another install curren

(Jack Vamvas) Question: In the application error logs there is a message – The DELETE statement conflicted with the REFERENCE constraint FK_xxxxxxxxx

(Nai Biao Zhou) Many organizations have known the fact that data have been evolved from the by-product of corporate applications into a strategic asset [1]. Like other corporate assets, the asset requires specialized skills to maintain and analyze.