Abdullah KhanCOVID-19 Analytics: Leveraging SQL and Power BI for Data-Driven Insights -Part 1An SQL-based data visualizationAug 17
Rahul GosaviEfficiently Managing Slowly Changing Dimensions Type 2 (SCD Type 2) Using SQL INSERT-MERGE in…Slowly Changing Dimensions (SCD) are essential in data warehousing for tracking changes in dimension data over time. SCD Type 2 maintains…May 171
Morsi MasmoudiHow to move TempDB to a new hard disk in SQL Server?Sometimes as a database administrator, you need to move the TempDB database and log files to a new hard drive.Nov 30, 2022Nov 30, 2022
Fabari AgboraHotel Chain BI Dashboard For Hilton Hotels— End to End (AzureSQL to Power BI Service)Just a little back story… Late July to Early August I imagined how a typical Hotel can track KPIs, stay competititive andAug 12Aug 12
SACHIN SHRIKANT PAIsp_help_revlogin –Simplest way to transfer logins to SQL Server Instancesp_help_revlogin is a stored procedure which helps to transfer logins and passwords from one instance of a server to another instance of…Sep 23, 2020Sep 23, 2020
Abdullah KhanCOVID-19 Analytics: Leveraging SQL and Power BI for Data-Driven Insights -Part 1An SQL-based data visualizationAug 17
Rahul GosaviEfficiently Managing Slowly Changing Dimensions Type 2 (SCD Type 2) Using SQL INSERT-MERGE in…Slowly Changing Dimensions (SCD) are essential in data warehousing for tracking changes in dimension data over time. SCD Type 2 maintains…May 171
Morsi MasmoudiHow to move TempDB to a new hard disk in SQL Server?Sometimes as a database administrator, you need to move the TempDB database and log files to a new hard drive.Nov 30, 2022
Fabari AgboraHotel Chain BI Dashboard For Hilton Hotels— End to End (AzureSQL to Power BI Service)Just a little back story… Late July to Early August I imagined how a typical Hotel can track KPIs, stay competititive andAug 12
SACHIN SHRIKANT PAIsp_help_revlogin –Simplest way to transfer logins to SQL Server Instancesp_help_revlogin is a stored procedure which helps to transfer logins and passwords from one instance of a server to another instance of…Sep 23, 2020
Dusan VelimirovicEffective Strategies for Handling NULL Values in T-SQLHandling NULL values in T-SQL is critical for maintaining database integrity and ensuring accurate data operations. NULL represents the…Jul 17
Antoine CichowiczMonitoring Microsoft SQL Server with Grafana: A Comprehensive GuideToday, I am share with you a comprehensive Grafana dashboard I created for monitoring Microsoft SQL Server. The best part? It’s built…Jun 24
Amir ZahreddineA Modern Approach to Aggregating Multiple Databases within a Microsoft EnvironmentLeveraging .dacpac’s to merge databasesJun 12