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
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA KCP Mangga Dua ITC Tlpn/Wa 0853.7373.7551
No. 20-25, 29-32, Gedung ITC Mangga Dua, Jl. Mangga Dua Raya Lt. IV Blok...
BCA KCP Talavera Telpon/WA:08137887595
BCA KCP Talavera Telpon/WA:08137887595.Talavera Office Park, Jl. TB Simatupang No.Kav. 26, RT.1/RW.1, Cilandak Bar.,...
BCA KCP Panglima Polim Raya Telpon/WA:08137887595
BCA KCP Panglima Polim Raya Telpon/WA:08137887595.Ruko Grand Panglima Polim, Jl. Panglima Polim No.16-17, RT.2/RW.1,...
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