In this two-part tip, we are created a metadata-driven pipeline which will copy multiple flat files from Azure blob storage to an Azure SQL Database. The flat files can have different delimiters and are stored in different folders and there are multiple destination tables as well.
I recently came across an issue in a SQL Server Availability Group scenario where queries against a heavily-used queue table were taking longer and longer over time.
Floating point datatypes accommodate very big numbers but sacrifice precision. They are handy for some types of scientific calculations, but are dangerous when used more widely, because they can introduce big rounding errors.
There is a need to ensure we decide what ethics a computer system ought to have.
In this article, you will learn how you can set the attribute relationships between dimensions in SSAS.
Robert Sheldon continues his series on storage. This article covers some of the basics of performance metrics, HDDs, and SSDs.
Because of my job with Redgate (which I love and will never leave even after I’m dead), I spend a lot of time learning about compliance and all the new laws and regulations coming out of things like the GDPR and the CCPA (they changed the name evidently). However, I’m a nerd. I’m not a […]
This article provides step by step instructions to deploy individual SSIS packages in a project deployment model.
Phil Factor delves into SQL Prompt's performance rule, PE012, which will advise you if it detects the use of the SET statements within a stored procedure or trigger, which might cause unnecessary recompilations, though the issue extends to other types of batches.
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Whatsapp.083831617937 JL. Mulyosari, No.364 A Blok Z.56, 60113, Kalisari, Kec. Mulyorejo, Kota SBY, Jawa...
Whatsapp.083831617937 ITC Mega Grosir, Ground Floor Blok H2 No. 7-8-9, Jl. Gembong No. 20-30...
Whatsapp.083831617937 Jl. Kombes M. Duryat Blok A No. 5-6 Surabaya, Jawa Timur, Indonesia 60262
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers