Microsoft TechnologiesSQL ServerSSAS Restoring SSAS Cubes to a SQL 2022 Server with CU5 I have a client who was... Aug 18, 20234 Comments on Restoring SSAS Cubes to a SQL 2022 Server with CU5
SQL ServerSSIS The Many Oracle Connectors for SSIS I recently worked with a client... May 17, 20235 Comments on The Many Oracle Connectors for SSIS
AzureAzure SQL DBMicrosoft TechnologiesSQL Server How to Change the Browser Used by SSMS for AAD Auth Did you know that you can... Mar 28, 202310 Comments on How to Change the Browser Used by SSMS for AAD Auth
Azure SQL DBAzure SQL DWData WarehousingMicrosoft TechnologiesPythonSQL Server pandas.DataFrame.drop_duplicates and SQL Server unique constraints I’ve now helped people with this... Aug 20, 20221 Comment on pandas.DataFrame.drop_duplicates and SQL Server unique constraints
AzureMicrosoft TechnologiesSQL Server Check if File Exists Before Deploying SQL Script to Azure SQL Managed Instance in Azure Release Pipelines I have been in Azure DevOps... Feb 22, 20221 Comment on Check if File Exists Before Deploying SQL Script to Azure SQL Managed Instance in Azure Release Pipelines
AzureAzure SQL DBMicrosoft TechnologiesSQL Server New Centralized View of SQL Resources in Azure Yesterday some new views were made... Aug 22, 2019Apr 18, 20251 Comment on New Centralized View of SQL Resources in Azure
AzureMicrosoft TechnologiesPowerShellSQL Server Using Azure Automation to Shut Down a VM only if a SQL Agent Job is Not Running I have a client who uses... Aug 15, 20194 Comments on Using Azure Automation to Shut Down a VM only if a SQL Agent Job is Not Running
Data WarehousingMicrosoft TechnologiesSQL ServerSSIST-SQL Why We Don’t Truncate Dimensions and Facts During a Data Load Every once in a while, I... Jul 25, 20194 Comments on Why We Don’t Truncate Dimensions and Facts During a Data Load
Microsoft TechnologiesSQL Server Insufficient Disk Space (T-SQL Tuesday #88) This month’s T-SQL Tuesday – hosted... Mar 14, 20172 Comments on Insufficient Disk Space (T-SQL Tuesday #88)
AzureMicrosoft TechnologiesSQL Server PolyBase Is A Picky Eater – Remove Carriage Returns Before Ingesting Text Update: As Gerhard points out in... Aug 1, 20168 Comments on PolyBase Is A Picky Eater – Remove Carriage Returns Before Ingesting Text