Mindblown: a blog about philosophy.
-
20761 – Querying Data with Transact-SQL contents
Manual – Download Here Lab files – Download Here
-
Dynamic Data Driven Subscription in SSRS
Dynamic Data Driven Subscription in SSRS Business Problem: In one of our report requirement, we need to feed the data files to robot for every one hour. For that, we have created an hourly subscription for that report. As a result, we were sending many empty files to robot, which makes the system resource degradation.…
-
Dynamic Data Driven Subscription in SSRS
Dynamic Data Driven Subscription in SSRS Business Problem: In one of our report requirement, we need to feed the data files to robot for every one hour. For that, we have created an hourly subscription for that report. As a result, we were sending many empty files to robot, which makes the system resource degradation.…
-
Azure Data factory-Power BI dataset refresh
Overview: The Power BI dataset must be refreshed according to the schedules defined so that the reports will have latest data. We must manually configure the refresh intervals in Power BI scheduler. Once data is populated in Structured Zone from landing Zone in Azure environment, Power BI refresh must be scheduled. Thus, always manual intervention…
-
Azure Data factory-Power BI dataset refresh
Overview: The Power BI dataset must be refreshed according to the schedules defined so that the reports will have latest data. We must manually configure the refresh intervals in Power BI scheduler. Once data is populated in Structured Zone from landing Zone in Azure environment, Power BI refresh must be scheduled. Thus, always manual intervention…
-
Power BI – Finding total number of rows in a table
INTRODUCTION AND USE CASE In PowerBI we can’t select entire the column and see the number of rows in the table. To do this we have to export the data in excel and then we can do it by selecting the column. In the scenario we have a table with different column and when I…
-
Power BI – Finding total number of rows in a table
INTRODUCTION AND USE CASE In PowerBI we can’t select entire the column and see the number of rows in the table. To do this we have to export the data in excel and then we can do it by selecting the column. In the scenario we have a table with different column and when I…
-
Adventure works Sample
-
Adventure works Sample
-
Backup & Restore in Azure SQL Database
What are SQL Server Database Backups? The SQL Server backup provides an essential safeguard for protecting critical data stored in your SQL Server databases. To minimize the risk of catastrophic data loss, you need to back up your databases to preserve modifications to your data on a regular basis. A well-planned backup and restore strategy…
Got any book recommendations?