An Alternative (Better?) Method to UNPIVOT (SQL Spackle)
Normalizing or UNPIVOTing data may be improved by using this lesser known approach in SQL Server 2008 or later.
2024-07-26 (first published: 2012-08-02)
45,770 reads
Articles
Migrate a SQL Server Database to a PostgreSQL Database
Learn about various options to migrate an entire SQL Server database to a PostgreSQL database.
2024-07-26
Microsoft Fabric, the Land of Wizards and Trolls
In my previous article (What is Microsoft Fabric All About) I explained what Microsoft Fabric is, how it came about and whether it brings anything new to the data insights domain.
2024-07-24
How to use Jupyter Notebook in VSCode
Learn how you can create and use a Jupyter Notebook in VS Code.
2024-07-22
4,496 reads
Using Query Store to Identify CPU Intensive SQL Queries and Creating Proper Indexes
Learn how to use SQL Server Query Store to identify what resources are using CPU to help fine-tune queries and reduce the processing load.
2024-07-22
2024-07-19
1,729 reads
Deleting Documents from a MongoDB Collection
So far in this series, we’ve looked at different ways that you can add, retrieve, and update documents in a MongoDB collection. This article continues that discussion by explaining how to use MongoDB Shell to delete documents from a collection.
2024-07-19
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.
2024-07-17
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.
2024-07-17
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.
2024-07-15
30,841 reads
Blogs
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers