@Business__Data profile picture
Business Intelligence @Business__Data

#Analytics #SSIS #SQLServer #BusinessIntelligence

Joined February 2018
  • Tweets 1,243
  • Following 171
  • Followers 70
4 Photos and videos
Do you remember when you joined Twitter? I do! #MyTwitterAnniversary
Line of Best Fit: What it is, How to Find it statisticshowto.com/line-of-… #Analytics #BusinessIntelligence

Line of Best Fit: What it is, How to Find it - Statistics How To

The line of best fit (or trendline) is an educated guess about where a linear equation might fall in a set of data plotted on a scatter plot.

statisticshowto.com
What “Brain Rules” teaches us about Business #Analytics performance-ideas.com/2011/0… #BusinessIntelligence
How to DROP Multiple Tables Using Single DROP Statement? blog.sqlauthority.com/2018/1… #SQLServer #BusinessIntelligence

SQL SERVER - How to DROP Multiple Tables Using Single DROP Statement? - SQL Authority with Pinal...

In my earlier post, SQL SERVER – How to DELETE Multiple Table Together Via SQL Server Management Studio (SSMS)? I showed you how to DROP Statement multiple tables together using a wizard in SQL...

blog.sqlauthority.com
What is Read Ahead Read in #SQLServer ? blog.sqlauthority.com/2018/1… #RAR #BusinessIntelligence

What is Read Ahead Read in SQL Server? - Interview Question of the Week #197 - SQL Authority with...

Question: What is Read Ahead Read in SQL Server?Answer: This is SQL Server's feature which brings data pages into the buffer cache.

blog.sqlauthority.com
Does Sort Order in #Index Column Matters for #Performance ? blog.sqlauthority.com/2018/1… #BusinessIntelligence

Does Sort Order in Index Column Matters for Performance? - Interview Question of the Week #199 -...

Question: Does Sort Order in Index Column Matters for Performance?Answer: Wow, it has been a long time since I have heard this question and the matter of fact, I have never blogged about this subject...

blog.sqlauthority.com
Get List of the Logical and Physical Name of the Files in the Entire #Database blog.sqlauthority.com/2018/1… #SQLServer #SQLScript #BusinessIntelligence

SQL SERVER - Get List of the Logical and Physical Name of the Files in the Entire Database - SQL...

One of the most popular questions I often receive is why do I like to do consultation - my answer is very simple - it gives me an opportunity to learn continuously learn new things from my clients....

blog.sqlauthority.com
How to Trim TIME Part in DATETIME Values? blog.sqlauthority.com/2018/1… #BusinessIntelligence

How to Trim TIME Part in DATETIME Values? - Interview Question of the Week #200 - SQL Authority...

Question: How to Trim TIME Part in DATETIME Values?

blog.sqlauthority.com
You Are Not Logged on as the Database Owner or System Administrator blog.sqlauthority.com/2018/1… #Error #SQLServer #SSMS #BusinessIntelligence

SQL SERVER - You Are Not Logged on as the Database Owner or System Administrator - SQL Authority...

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...

blog.sqlauthority.com
Finding User Who Dropped #Database Table blog.sqlauthority.com/2018/1… #SQLServer #BusinessIntelligence

SQL SERVER - Finding User Who Dropped Database Table - SQL Authority with Pinal Dave

Though I mainly focus on SQL Server Performance Tuning as my primary consulting engagement, there are moments when I am asked questions from my regular clients which are not related to SQL Server...

blog.sqlauthority.com
Small #Backup for Large #Database blog.sqlauthority.com/2018/1… #BestPractice #BusinessIntelligence

SQL SERVER - Small Backup for Large Database - SQL Authority with Pinal Dave

Recently, I had a very interesting experience with one of my customer while working with them on Comprehensive Database Performance Health Check. The issue was related to small backup for the large...

blog.sqlauthority.com
How to Start #Database in a #SingleUserMode? blog.sqlauthority.com/2018/1… #SQLServer #BusinessIntelligence

How to Start Database in a Single User Mode? - Interview Question of the Week #202 - SQL Authority...

Question: How to Start Database in a Single User Mode? 

blog.sqlauthority.com
Finding The Oldest #QueryPlan From #Cache blog.sqlauthority.com/2018/1… #BusinessIntelligence

SQL SERVER - Finding The Oldest Query Plan From Cache - SQL Authority with Pinal Dave

Often people ask where do I come up with a new blog idea everyday. Well, answer is that I am not the one who comes up with new idea, it is all of you who inspire everyday with a new idea. Recently...

blog.sqlauthority.com
How to Shrink All the #LogFiles for #SQLServer? blog.sqlauthority.com/2018/1… #BusinessIntelligence

How to Shrink All the Log Files for SQL Server? - Interview Question of the Week #203 - SQL...

Question: How to Shrink All the Log Files for SQL Server?

blog.sqlauthority.com
#SQLServerAgent Missing in SQL Server Management Studio blog.sqlauthority.com/2018/1… #SSMS #SQLServer #BusinessIntelligence

SQL SERVER - SQL Server Agent Missing in SQL Server Management Studio (SSMS) - SQL Authority with...

Learning never stops when you are a consultant. While doing my recent Comprehensive Database Performance Health Check my client asked an interesting question. He informed that he is not able to see...

blog.sqlauthority.com
Using Jitter to Avoid #OverPlotting in #PowerBI myonlinetraininghub.com/usin… #JitteredData #BusinessIntelligence

Using Jitter to Avoid Over Plotting in Power BI • My Online Training Hub

Plotting data that has one variable where values are similar, can result in points that are plotted over each other. Use jitter to avoid this overplotting.

myonlinetraininghub.com
A Few Thoughts About #GaugeCharts performance-ideas.com/2011/0… #BusinessIntelligence
#TableLens ncva.itn.liu.se/education-ge… #Visualization #FisheyeTechnique #Statistics #BusinessIntelligence
How to Visualize Multivariate Relationships Using #PowerBI ? mssqltips.com/sqlservertip/5… #MultivariateDataAnalysis #ScatterplotMatrix #BusinessIntelligence

How to visualize multivariate relationships using Power BI

Learn how to visualize multivariate relationships using Power BI with the R script visual control.

mssqltips.com
1
#Dashboarding – Insights from Mike Duncan – Part 2 performance-ideas.com/2011/0… #KPI #Mistakes #BusinessIntelligence
Load more