In 2021, many companies had employees leave positions. The number of people resigning from their jobs was so high that the term "The Great Resignation" began appearing in many publications. A number of industries were affected, and there are no shortage of pundits and experts analyzing why. This happened primarily in the US, but the […]
This short piece shows how to add logging for the Delete activity and track which files or folders are deleted.
A data lake is a scalable data storage repository that can ingest large amounts of raw data and make it available on-demand. Robert Sheldon explains the benefits and challenges of data lakes.
The 2021 report from the DevOps Research and Assessment (DORA) team at Google Cloud has now been published and provides highlights from seven years of research and data from more than 32,000 professionals worldwide.
The next level of the Stairway to Integration Services looks at how you can execute your package.
DevOps is a journey, not a project. Today Steve reminds us that while we want to work across time and constantly improve, we also need some urgency. A marathon is the balance.
Phil Factor offers a programmer's guide to Flyway's configuration settings, explaining the different categories of parameters, the role of each of parameter within each category, and how to exploit Flyway's multi-level configuration file system.
Learn how to conduct deep SQL Query optimization with SQL Grease with the Enterprise dashboard, historical data, troubleshooting SQL Server Wait Stats, capturing anomalies and intelligent notifications.
Video chat is how many of us see our colleagues every week. It's not a great system, but maybe it can get better.
Learn how to install PostgreSQL and using Azure Data Studio to work with 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