Azure DP-900 (Data Fundamental) Certification perpetration
Nothing Is hard when you decide to do it, from two weeks I earned my Certification of Azure Data Engineer and today I passed Exam DP-900 and I got...
2020-08-22
282 reads
Nothing Is hard when you decide to do it, from two weeks I earned my Certification of Azure Data Engineer and today I passed Exam DP-900 and I got...
2020-08-22
282 reads
Nothing Is hard when you decide to do it, from two weeks I earned my Certification of Azure Data Engineer and today I passed Exam DP-900 and I got...
2020-08-22
8 reads
I have now printed over 20,000 ear savers. I hit 20k printed yesterday on Aug 5th, exactly 4 months after starting this project. As of 7PM Eastern today, my...
2020-08-21 (first published: 2020-08-06)
280 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-21
20 reads
In this episode of Dear SQL DBA, I talk about how Redgate runs "Down Tools Week," what I'm working on as part of the project, and how this has...
2020-08-21 (first published: 2020-08-06)
195 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-20
20 reads
One of the most versatile and awesome power tools given to SQL Server now has a new home! This new home will serve as a fabulous repository of extensive...
2020-08-20 (first published: 2020-05-18)
438 reads
This is just going to be a quick post but I was asked the question the other day, how can I find all the tables in the database that...
2020-08-20
942 reads
The new SQL on-demand (to be renamed SQL serverless) offering within Azure Synapse Analytics opens up a whole new world of getting insights into data immediately, at low-cost, using...
2020-08-20 (first published: 2020-08-10)
951 reads
A quick 2 minute overview video (from me) about ADS – Advanced Data Security. The unified package from Microsoft providing the ability to discover / classifying sensitive data, mitigate...
2020-08-19
24 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...
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