Combining many crossing intervals
This article demonstrates how the geometric functions in SQL can be use to solve the Islands and Gaps problem.
The WFH Challenges
Working from home can be hard and Steve has a few ideas that might help you transition during these challenging times.
Moving on from Volunteer Projects
I can’t remember a time when I was not involved in side-projects, usually as a volunteer but also writing books or creating courses. New projects are like bright, shiny objects, and it’s easy to get involved in too many of them.
Overview of Azure Cache for Redis
Caching data is one way to improve application performance. In this article, Chandra Kudumla explains a service for caching data found in Azure called Azure Cache for Redis.
Secure Enclave Concerns
A new security flaw in Intel SGX is found by researchers. This may or may not be a problem, but you should be aware.
Approaches to Import JSON in SSIS (SQL Server 2016+) Part 1
In this article, 1st of 2-part series, we will look at 2 approaches to import JSON in SSIS using 2 methods: the new functionality of SQL Server 2016 and the Json.NET library.
Updating Certifications
Microsoft is retiring some certifications and offering others. Steve has a few thoughts on this.
Free Fundamentals of Index Tuning Week: Part 2, Indexing for ORDER BY
I’m teaching my Mastering Index Tuning pre-con at SQLBits and SQL Saturday Iceland, and part of the prerequisites is that you’re already familiar with my How to Think Like the Engine class and my Fundamentals of Index Tuning class. To make that easier, I’m running the Fundamentals of Index Tuning class this week on the blog.
Using the RANKX function in Power BI
Introduction In this article, I'll explain the use of the RANKX function available in DAX. The RANKX is a sortation function which is capable of performing a quite complex sorting and ranking based on the groups and values available in the dataset. It returns the ranking of a particular number available in each row of […]
Enterprise Insights from the 2020 State of Database DevOps report
17% of Enterprise respondents in this year's State of Database DevOps survey reported that DevOps has been adopted across all projects in their organization. This year’s State of Database DevOps report gave us some great insights into the landscape of Database DevOps. Kendra Little walks us through those insights specific to Enterprise organizations.
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Kapasan No.Telp 083831617937
Whatsapp.083831617937 Jl. Kapasan 155, RT.007/RW.09, Kapasan, Kec. Simokerto, Kota SBY, Jawa Timur Surabaya, Jawa...
BCA KCP Jembatan Merah Plaza No.Telp 083831617937
Whatsapp.083831617937 Ruko Jembatan Merah Plaza Blok A No. 36-37, 38-39 Surabaya, Jawa Timur, Indonesia...
BCA KCP Jagalan No.Telp 083831617937
Whatsapp.083831617937 Jl. Jagalan No. 117 B, Peneleh, Kec. Genteng, Kota SBY, Jawa Timur Surabaya,...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers