Monitor SQL Server Performance with SQL Server Mobile Reports
Learn how to build a mobile ready SQL Server report to help visualize SQL Sever performance metrics.
Esat Erkec is a SQL Server professional who began his career 10+ years ago as a Software Developer. He is now a Microsoft SQL Server Certified Solutions Expert. Most of his career has been focused on SQL Server Database Administration and Development. His current interests are in Database Administration and Business Intelligence.
Enter and Edit Data in SSRS
In this tip we show how you can create additional tables and add data on the fly when building reports using Report Builder for SQL Server Reporting Services.
How to use SQL Database Query Editor in Azure Portal
In this tip we take a look at the query editor tool that is available in Azure to execute queries against a SQL Server database on Azure.
Creating a Rolling Average Graph with Power BI
In this tip we walk through the steps on how to create a rolling average report using Power BI.
Locally Weighted Scatterplot Smoothing (Lowess) approach in Power BI
In this tip, we will define some essential statistics terms about Lowess and demonstrate how to use this in Power BI.
How to use the Azure SQL Database DTU Calculator
In this tip we cover the steps of how to use the Azure SQL Database DTU Calculator to determine the correct configuration in Azure to match your on-premises workload.
Word Cloud in Power BI Example
Learn the step by step instructions to setup a Word Cloud visualization in Power BI, configure the visualization and setup exclusion terms.