Minimize Downtime with SQL MI Disaster Recovery
I speak to many people who use cloud technologies, especially database tech and how little consideration they give to their MISSION CRITICAL Databases that run in the cloud and...
2024-10-18
19 reads
All About SQL
Snowflake + Azure blob
Let’s go back to data platforms today and I want to talk about a very common integration I see nowadays, Azure Blob Storage linked to Snowflake via a storage...
2024-10-18 (first published: 2024-10-04)
142 reads
Blockchain + RWAs
Blockchain technology is still at the hype stage for an emerging technology cycle, it gets a bad image from all the dodgy web3 “crypto” fake projects out there (based...
2024-09-05
10 reads
WHAT IS A SPV?
Why am I focussing on RWA (real world assets) as the next big thing? The WEF predicted that by 2027, 10% of the world’s GDP could be stored on...
2024-08-09
11 reads
Tech in 2030
What will the technology world look like in 2030? Cloud computing will naturally be the backbone of the world but I think with variants in “decentralising” concepts. By this...
2024-08-09 (first published: 2024-07-31)
114 reads
Azure SQL MI License free?
A common setup when leveraging the cloud is to use the cloud for Disaster recovery (DR) purposes, some say it becomes a logical extension of your on-prem / data...
2024-03-11 (first published: 2024-02-27)
421 reads
Azure chaos STUDIO
Chaos engineering is fun but especially important when building solutions in the cloud. It is great leveraging the cloud to build something, whether that’s a globally distributed website with...
2023-06-28 (first published: 2023-06-08)
257 reads
Azure SQL Managed Instance – Cost Saving!
We all would like to save money when operating in the cloud, Microsoft has released a stop / start concept for SQL Managed Instances – preview mode! At the...
2023-01-12
42 reads
Snowflake Classic UI vs Snowsight
This blog post is not about which User Interface is better, Classic or Snowsight – If anyone does want my feedback on what I like and don’t like about...
2022-11-25
219 reads
Cloning in Snowflake
Cloning is a powerful feature within snowflake (also known as zero copy clone). You can obviously clone at the database or schema level but also tables too. It’s a...
2022-11-11
79 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers