A Quick SQL Change Automation Build
I was going through a few of the Redgate products with a customer recently and they wanted to perform some validation of the build and release process with SQL...
2020-08-27 (first published: 2020-08-19)
530 reads
I was going through a few of the Redgate products with a customer recently and they wanted to perform some validation of the build and release process with SQL...
2020-08-27 (first published: 2020-08-19)
530 reads
TL;DR; Yes Frequently in our industry we talk about gatekeepers as bad things. We talk about breaking down barriers and ... Continue reading
2020-08-27
188 reads
I really like the automatic tuning aspect of Azure SQL Database. This post is not a full explanation and demo. Instead, I want to point out a small point...
2020-08-27 (first published: 2020-08-17)
265 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-08-27
19 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-08-26
21 reads
[MSSQLFUN & Decode ITeS becomes a family of 1700 individuals across the globe. Please join us onFacebook & YouTube.] Let’s review our GCP concepts. Refresher – Intro, Free account with 300$...
2020-08-26
68 reads
Note: co-authored with Christine Assaf, originally published in the now-defunct PASS Blog.
In January 2020, Robert Williams was arrested on his front lawn in a suburb of Detroit, Mich., after police...
2020-08-26
11 reads
SQL Clone is an amazing product that virtualizes your data, allowing multiple instances to share a read only image, but still produce writeable databases that look normal to SQL...
2020-08-26 (first published: 2020-08-12)
210 reads
This is not a post about SQL Server, but I need to write about something that I’ve been struggling with for a number of weeks so that other people...
2020-08-26
244 reads
On August 4, 2020, I presented this on the weekly Pragmatic Works webinar series. You can view that presentation here. As part of that presentation, I committed to give...
2020-08-26 (first published: 2020-08-13)
900 reads
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
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...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
WA:08218154393 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta Timur, Daerah Khusus...
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
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