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 […]
What's the true and permanent cost of lowering the Fill Factor of an index in SQL Server? It's a lot more than many people think. 9 year SQL Server MVP veteran, Jeff Moden, demonstrates how to calculate the extra space that will be used by lowering the Fill Factor and saved by increasing it.
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
If you’ve been watching AI roll through the data community and thinking, “this seems...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Comments posted to this topic are about the item Spending Time in the Office
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers