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)
41,642 reads
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)
41,642 reads
Learn about various options to migrate an entire SQL Server database to a PostgreSQL database.
2024-07-26
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
Learn how you can create and use a Jupyter Notebook in VS Code.
2024-07-22
1,796 reads
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,156 reads
2024-07-19 (first published: 2024-01-10)
336 reads
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
In this tip, we explore how to configure mirroring for a Snowflake database to be available in Microsoft Fabric.
2024-07-17
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
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers