(Thomas LaRock) Many people (and companies) say they are “data-driven”. Unfortunately, what that means is “hey, I think this is true, go get the data that supports my idea. No, not that data, get the other data.” This is the common definition I see on a regular basis. If this describes you (or your

(Christopher M Schmidt) How do you monitor Azure Analysis Services? How many users are connected and who are they? These are great questions to understand around your AAS environment

(Siddharth Mehta) Performance comparison and analysis is a standard exercise in any organization and is widely applicable from employee performance to product performance. There are different charts that can be used for this purpose like: line charts, waterfall charts, stacked column charts, etc.

(Paul White) This post is part of a series about row goals. You can find the other parts here:

(Anoop Kumar) There are various methods to monitor query performance in SQL Server. One of the best ways is to analyze the query execution plan and identify the queries that can cause performance bottlenecks.

(Pinal Dave) One question I always ask all of my customers before I start Comprehensive Database Performance Health Check is that if they have taken backup of their server. The answer to this question honestly does not matter to me during consultancy I never change anything which brings to the situa

(Tim Smith) We’re new to the bulk insert command in T-SQL and we have files that specify new rows and columns without using a common structure, like commas or vertical bars.

(Pinal Dave) During recent Comprehensive Database Performance Health Check, I had a very interesting situation I encountered where we found a stored procedure which was a root cause of the slowness. What we needed to do is to change the code and test if our new stored procedure is better than previo

(Melissa Coates) This is part 2 in a short series on Azure Data Lake permissions.

(Krishnakumar Rukmangathan) In general, there are several links available to download the ODAC components from the Oracle official site. It varies across the Oracle versions, and the type of installer that we would need. Most of the time, we look for the .exe installer to install the Oracle related