In the expansive landscape of software development, the relationship between Database Administrators (DBAs) and Developers has been a subject of intrigue, debate, and occasional drama. Do they collaborate harmoniously...
2024-04-30 (first published: 2024-04-29)
57 reads
Hey there happy coders! Last weekend I had the pleasure of speaking at the SQL Saturday Atlanta event in Georgia! It was an awesome time of seeing data friends...
2024-04-30
8 reads
It was great being at dataMinds Saturday 2024 this past weekend. A great crowd of data enthusiasts was present to learn from a bunch of local speakers (both old...
2024-04-29
5 reads
I know if you are a SQL Server DBA using Azure SQL DB, you’ve been sorely missing the agent. Enter Elastic Jobs to help you schedule jobs more easily...
2024-04-29 (first published: 2024-04-16)
209 reads
Microsoft Fabric is the new data offering in Microsoft Azure and there is a great deal of interest in it. How do you get started? Where are the tutorials?
2024-04-29
43 reads
Starting last week is a rollout of the public preview of a new and fully reimagined Microsoft Purview data governance solution. Data governance has become so much more important...
2024-04-29 (first published: 2024-04-17)
328 reads
On Thursday, May 2, we have the Redgate Seminar in Brisbane. I’ll be at there along with fellow Redgate engineers, account executives, Octopus Deploy engineers, fellow Microsoft MVPs, and...
2024-04-29
7 reads
We’re working through the major refresh of my Certified Kubernetes Administrator series at Pluralsight!
The next course “Certified Kubernetes Administrator: Working With Your Cluster” in the updated series is now...
2024-04-28
30 reads
In a previous blog post we went through how to build a Docker container image from a remote (Github) repository. Here we’re going to expand on that by actually...
2024-04-27 (first published: 2024-04-25)
79 reads
In information security (INFOSEC), there several foundational concepts and principles. One of the ones that’s introduced almost immediately is called the CIA triad or the Information Security Triad. While...
2024-04-27 (first published: 2024-04-26)
30 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers