(Kenneth Fisher) Ok, that title sounds silly, but it’s actually a real point. The first parameterized refers to using parameters within dynamic SQL, while the second refers to how the optimizer treats parameters differently from variables.

(Esat Erkec) Power BI offers a data entry option which allows users to enter data directly and this data can then be used on reports and visuals. How can we create and use this type of data in SQL Server Reporting Services?

(Grant Fritchey) Once upon a time, someone, somewhere, wrote a list of bad query performance tips and they’ve been copied all over the internet, over and over.

(Rajendra Gupta) In this article, we’ll take a look into SQL truncate improvement in SQL Server 2019.

In the past, SQL Server on Linux has required SSSD to be configured for AD Authentication to work. SSSD is a very powerful service which provides support AD authentication and integration.

(Pinal Dave) Every day I spend a good amount of time with my regular and new clients, helping them with SQL Server Performance Tuning issues. Today, in this blog, I will discuss a situation faced where I was engaged in Comprehensive Database Performance Health Check.

(Pinal Dave) Just another day, I received an email from a user who has over 350 thousand tables in a single database. He was my earlier customer of Comprehensive Database Performance Health Check. He was facing indeed a very strange issue where his metadata table was locking up and we fixed that by

(Craig Stedman) Microsoft embeds its SSRS reporting software and more-advanced data preparation tools in Power BI, part of a plan to blend self-service and enterprise BI for users.

(Kenneth Fisher) Upper management at my company has started asking for something called T-Shaped knowledge. The idea is that we have a broad range of knowledge in an area that may not be overly deep and one or more spikes of deeper knowledge.

(CliveW) This week there was a good discussion on how to show an SLA view in Log Analytics, which was similar to a feature in System Center Operations Manager, the output and query I’m sure will be useful for others.