Archive

Archive for the ‘SQL Tricks’ Category

BI SQL # 281 : All Power BI Dashboard Query consolidated & Information

April 4, 2018 Leave a comment

Hi Friends,

I have publish “SQL Server Info Dashboard” on Global Power BI series “Dashboard for Life Series ” on Episode 1.

I have used bunch of SQL Server queries in this dashboard, so thought of explaining you here.

This dashboard is inspiration and another example for DBA how they can use Power BI to simplify and structure Database Administration.

You all might know how

Following query used in Dashboard, Lets go one by one

  • ServerInfo
  • ServerSpace
  • Database
  • DatabaseLastBackup
  • DatabaseMasterFile
  • CurrentProcess

Dashboard look like –

Vishal's SQL Info Dashboard

Query Editor

When you will open dashboard in query editor mode, you will be able to see all of these point as data source as shown

Query Editor

ServerInfo

This is custom query to get maximum information related to SQL Server

I have publish all details regarding this query recently on my blog –

Server Space

All details publish on 30 may 2013 – BI SQL # 115 : SQL Server DBA Scripts : Simply find DB Size in MB and GB

image

2016-11-19 19_34_56-SQLQuery4.sql - DESKTOP-E1J6A4F.master (DESKTOP-E1J6A4F_Vishal (55))_ - Microsof

Database

Simple system table query

SELECT * FROM master.dbo.sysdatabases

DatabaseLastBackup

All details are publish on recent blog – BI SQL # 279 : Get all last back up date and time with physical bak file path

image

DatabaseMasterFile

Simple system table query

Select * from sys.master_files

CurrentProcess

All details publish on 4th November 2011 – BISQL # 68 – How to Kill Process Very Fast , With Analysis and Efficiently

Advertisement
Categories: Query, Script, SQL Mentalist, SQL Server 2016, SQL Tricks, TSQL, Vishal Pawar, ZeroToBasic
%d bloggers like this: