Day 25 Optimization
Locking is depends upon Isolation level and Storage Engine. MySQL uses table level locking (instead of page, row, or column...
2018-05-25
272 reads
Blog Posts
dbachecks – Improved Descriptions
With the latest release of dbachecks we have added a new check for testing that foreign keys and constraints are...
2018-05-25 (first published: 2018-05-19)
2,363 reads
Fix For Using Azure Active Directory and DacFX
Update:
Refer to this post instead
Hello!
One of the things I feel strongly about is that a build/release pipeline needs to be as complete as possible - that is all configuration...
2018-05-25
5 reads
Is your SQL Server environment ready for GDPR? Part 1
Unless you have been living under a rock lately, you have not heard about GDPR. This has been hot topic...
2018-05-25
134 reads
Techorama 2018 Session Materials
Techorama 2018 is over, sadly enough. It was a great conference: lots of awesome speakers and sessions and very nicely...
2018-05-25
267 reads
When Good Query Plans Go Bad
Today's story starts again with a page escalation:
--
We are seeing very high CPU usage on DistServer01. Could you please take...
2018-05-25 (first published: 2018-05-18)
3,144 reads
Back to basics: What is a HEAP table?
Understanding the fundamentals is key for success, with everything you do. These days SQL Server has expanded into much more...
2018-05-24 (first published: 2018-05-16)
5,683 reads
Convert a Positive Number To a Negative In SQL With a Spot of Bitwise Logic
Now this is something that I’ve seen asked a few times and it’s always a question that gets a fair...
2018-05-24
2,519 reads
Cosmos DB for the Data Professional
Cosmos DB is one of the fastest growing Azure services in 2018. As its popularity grows, data professionals are faced...
2018-05-24 (first published: 2018-05-16)
2,850 reads
Day 24 Replication Setup
Today we will discuss how setup a replication: Master – Slave Replication: Requirement: 2 (Linux) System (MasterServer and SlaveServer) MySQL Installed...
2018-05-24
284 reads
Blogs
AI: Blog a Day – Day 4: Transformers – Encoder, Decoder, and Attention
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
Flyway Tips: Multiple Projects
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
What DevOps Look Like in Microsoft Fabric
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
Forums
Can an Azure App Service Managed Identity be used for SQL Login?
I'm fairly certain I know the answer to this from digging into it yesterday,...
Azure Synapse database refresh
Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...
how to write this query?
hi everyone I am not sure how to write the query that will produce...
Question of the Day
Fun with JSON I
I have some data in a table:
CREATE TABLE #test_data
(
id INT PRIMARY KEY,
name VARCHAR(100),
birth_date DATE
);
-- Step 2: Insert rows
INSERT INTO #test_data
VALUES
(1, 'Olivia', '2025-01-05'),
(2, 'Emma', '2025-03-02'),
(3, 'Liam', '2025-11-15'),
(4, 'Noah', '2025-12-22');
If I run this query, how many rows are returned?
SELECT *
FROM OPENJSON(
(
SELECT t.* FROM #test_data AS t FOR JSON PATH
)
) t; See possible answers