Azure Synapse Analytics – Introduction and Getting Started
This is a relay to my colleague’s YouTube channel (Arshad Ali – Aas Trailblazers), that has started a series of[…]
Read more
Category: Database
Migrating SQL Server to Azure at Scale (Pass Summit 2020)
In November 2020, for the (until then) paid conference SQL Pass 2020, my colleague Avnish Rastogi and myself, presented the[…]
Read more
Create External Tables on Azure Synapse Analytics
As we continue working with Azure Synapse Analytics on Peruvian voting data, as I have posted before, we are extending[…]
Read more
Creating External Table AS (CETAS) in Parquet format on Azure Synapse Analytics
This is an extension of a prior post that shows how to create an external table in CSV format with[…]
Read more
Creating External Table AS (CETAS) on Azure Synapse Analytics
This is a continuation from a prior post that allows users leverage Peruvian voting data with Azure Synapse Serverless. This[…]
Read more
Taking Assumptions with Peruvian Presidential Voting Data with Azure Synapse Serverless
Taking Assumptions with Peruvian Presidential Voting Data with Azure Synapse Serverless
Read more
Peruvian Presidential Voting Data with Azure Synapse Serverless
It has been a controversial voting scenario for Peruvians, on the second round of voting Between Pedro Castillo (far left)[…]
Read moreVCenter Server 4.1 Running under SQL Server pushes tempdb storage allocation through the roof
And to alleviate the problem temporarily we needed to bounce the instance and clear up the temp database files. But[…]
Read moreMax Memory Configuration set too low [SQL Server]
We have been experiencing an issue with a clustered node where instances will run extremely slow and the only process[…]
Read moreExcel X64 driver and SQL Server 2008 R2 on cluster node [Fix]
As we continued with the execution of our migration plans from SQL Server 2005 to 2008 R2 X64, we found[…]
Read more