In this article we explore schema evolution capabilities and limitations in Databricks with regular parquet format and explore schema evolution features and capabilities through delta format with inserts, appends, and overwrites.
Introduction In my last article, An Introduction to Azure Data Explorer, I discussed the process of creating and using Azure Data Explorer. Azure Data Explorer is mainly used for storing and running interactive analytics on Big Data. First, I need to create the ADX cluster. Then, one or more databases should be created inside the […]
The three themes for speakers at this year's PASS Data Community Summit are: Back to Basics, Reach for the Clouds, and Level Up. The goal here is content that covers a wide variety of areas, with many fewer restrictions from previous years. Perhaps the big thing to note for this year's event is: Free. That's […]
In this article we cover what a Common Table Expression CTE is and how to write a CTE for doing selects, inserts, deletes, updates and more.
Director at ThoughtWorks Pramod Sadalage explores trends such as rapid digital transformation and an ever-changing tech landscape, that'll change the way we work with databases and DevOps in the next 20 years.
Tesla is updating their software in a real world, real life DevOps that their customers experience every day. It impresses Steve and tempts him to get one of their cars.
This article examines how to split a data set for training and testing and evaluating our model using Python.
How to create and maintain a 'data dictionary' for your databases, in JSON format, which you can then use to add and update the table descriptions, whenever you build a new version using Flyway.
Using sequences when scaling up with Oracle RAC presents more issues with contention. In this article, Jonathan Lewis explains how to avoid the problems.
It's a holiday weekend in the US this weekend. As such, many of you will be taking a break from work and enjoying time with family, as well as remembering some history in the US. If you're in the rest of the world, hopefully you have a holiday coming up soon you can enjoy. One […]
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Comments posted to this topic are about the item BIT_COUNT II
Comments posted to this topic are about the item I Can't Make You Learn
Comments posted to this topic are about the item Why Your SQL Permissions Disappeared
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers