One of the benefits of SQL is the ability to write a query and use parameters to dynamically act upon the resultset. Depending on the situation, there can be benefits to parameterizing queries, but it is not always clear when or how to do this. In this tip we look at different ways to pass in values as parameters to queries and the advantages and disadvantages.
Missing data is a difficult and common problem to solve. In this article, Joe Celko explains several approaches to deleting or replacing missing data.
A means of importing large csv files (where there may be commas in quote-delimited free text) into SQL Server tables using PowerShell
In recent years, technology landscape has undergone dramatic changes, driven primarily by cloud computing and a continuously increasing level of attention dedicated to security, privacy, and compliance. One of the more significant initiatives that attempts to address these challenges is General Data Protection Regulation (GDPR. In this article, we will explore how Azure SQL Database could help with addressing the GDPR requirements.
Watch out, watch out, there's a NOLOCK hint about. And probably a few other SQL code smells.
Steve Jones talks about the practical benefits of using DevOps to smooth out your software development.
This article (1) demonstrates an artificial neural network as it learns to recognize alphanumeric characters and (2) elucidates the mathematics of the feed-forward/back-propagation algorithm the artificial neural network employs.
R is a powerful language for manipulating data and creating visualizations. In this article in the series, Robert Sheldon demonstrates how R can be used within Power BI Desktop to import data and to create visualizations.
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
BCA KCP Fatmawati Telpon/WA:087768193341.Jl. Komp. Rs. Fatmawati No.1, Cilandak Bar., Kec. Cilandak, Kota Jakarta...
BCA KCU KEBAYORAN BARU Telpon/WA:087768193341.Jl. Melawai Raya No.Blok B, RT.7/RW.5, Kramat Pela, Kec. Kby....
BCA KCP Pasar Minggu Center Telpon/WA:087768193341.Jl. Lenteng Agung Raya No.26 E-F, Ps. Minggu, Kota...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers