Cloud vs On-premises
Is the cloud better or worse for a workload? One company, BlueSky, has moved on-premises despite their rapidly growing workload.
Updating a Cryptographic Provider for EKM with Azure Key Vault - Level 5 of the Stairway to TDE
This next level of the Stairway to TDE shows how to upgrade your EKM cryptographic provider.
Configure Microsoft Fabric Database Mirroring for Snowflake
In this tip, we explore how to configure mirroring for a Snowflake database to be available in Microsoft Fabric.
Four steps towards tackling the complexity of managing multiple database platforms
79% of us are now using two of more database platforms - fantastic for leveraging a range of benefits, but not so great when it comes to levels of complexity. Looking for ways to overcome this? Here are four steps to take towards multi-database simplicity.
Exploring Generative Adversarial Networks (GANs) for Butterfly Image Generation
Exploring Generative Adversarial Networks (GANs) for Butterfly Image Generation to gain some understanding of how this class of Artificial Intelligence technologies work.
Least Privilege
Steve wonders how well most organizations and their staff adhere to the principle of least privilege.
Prompt+ EAP: your AI-powered database development partner in the making
Last year, we introduced AI capabilities to SQL Prompt via the Prompt+ Early Access Program (EAP). Using generative AI-powered insights and context-based awareness, Prompt+ takes natural language queries and turns them into SQL coding suggestions. Check out this blog to learn more about Prompt+ and how to join the EAP waitlist.
XML Performance Tuning and Added Options
SQL Server provides a variety of ways to tune XML so that it provides consistent performance, consumes less space, all while ensuring efficient access to critical data. At its core, the metadata-styled XML format runs counter to the data that SQL Server is optimized to manage.
The Danger of Safety Assistance Tools
During a speaker dinner the other week, a lot of topics were swirling around and a few caught my ear. One of these topics dovetailed nicely with a mistake I recently made. More on that later. The discussion was on the effect on safety that all the new safety-based tech is having on driving. Some […]
Streaming Event Data through RabbitMQ to a Microsoft Fabric Eventstream
In this article, you will learn how to send messages through a RabbitMQ queue and deliver those to a Microsoft Fabric Eventstream.
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
Work out closing balance using opening balance of prior month
Hello, I think I need a recursive cte query but unsure of the logic....
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Revisiting SQL Server Window Functions- A Practical Walkthrough
Comments posted to this topic are about the item Revisiting SQL Server Window Functions-...
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers