To change Power BI audit log settings to retain audit logs, you need to configure the retention settings within the Microsoft 365 compliance center, as…
Mihir Shah17/07/2024
Stale Datasets in Data Management One of the common issue that organizations often face is dealing with stale datasets. A stale dataset refers to data…
Mihir Shah12/07/2024
In the ever-evolving landscape of artificial intelligence and data visualization, Microsoft Copilot Studio emerges as a powerful tool, enabling users to extend and customize their…
Mihir Shah29/02/2024
To get the information about how long has your server been running since the last SQL Server startup? SELECT @@Servername AS ServerName , create_date…
Yash Shah31/07/2023
Problem Statement: Long running queries have been found in the plan cache. These may be ETL, reports, or other queries that should run long. Or…
Yash Shah07/12/2022
Problem Statement: In SQL, a running total is the cumulative sum of the previous numbers in a column. Code Snippet: -- Create a view that…
Yash Shah28/11/2022
We can use DATEADD() function to Subtract days from DateTime in Sql Server. DATEADD() functions first parameter value can be day or dd or d all will…
admin25/11/2022
Problem Statement: This article describes how to display the data and log space information for a database in SQL Server by using SQL Server Management…
Yash Shah24/11/2022