Two of the top cloud services right now are Azure Synapse and Snowflake. Whatever your organization is implementing or if you need to transfer data to/from those services, it is important to know how to interconnect them and be able to transfer data between services.
2023-06-09
In this article, we look at how Snowflake handles deadlocks and the process of creating a deadlock and detecting a deadlock.
2023-05-29
Sometimes people say to avoid the snowflake schema and stick to a clean star schema. Why is that? Is something wrong with creating a snowflake schema?
2023-05-15
When working with Snowflake, it is important to understand the different types of tables available and when to use each one. In this tutorial, we will compare Snowflake temporary and transient tables, highlight their similarities and differences, and provide examples of when to use each type of table.
2023-03-31
SQL Server Analysis Services (SSAS) is an analytical data engine used in decision support and business analytics. It provides enterprise-grade semantic data models for business reports and client applications, such as Power BI, Excel, Reporting Services reports, and other data visualization tools. When paired with ADO.NET data providers, you can create cubes from external data […]
2019-04-30
3,422 reads
By Steve Jones
I posted that I was thinking about the AdventOfCode this year, but wasn’t sure...
It’s me again with my apparently semi-annual blog post. This time we’re going to...
By Steve Jones
I saw an article on this and realized I had no idea how to...
Hello, I am deploying SQL 2019 Enterprise edition with AOAG ( without windows clustering)....
Hello @all, i am facing a problem and can not find a solution... I...
We are used to the job activity monitor in SQL server allowing quick checks...
Ask SSC