The Problem Recently, while working with one of my clients, I came across a script in which I had to introduce a scalar User-Defined Function in the SELECT statement. The SELECT used to return around 750K records. However, after introducing the UDF, the row count significantly increased to 826K. There were no other changes made […]
As we grow and evolve in our careers, we face new challenges all the time. Steve highlights on of those that some tech workers worry about today.
Machine learning is a skill that many data professionals are learning as they plan their careers over the next five to ten years. In this article, Supriya Pande gives an overview of machine learning and walks through a practical example.
You’ve probably heard of Compliant Database DevOps, but to take it from buzzword to boardroom relies on demonstrating value across your business. IT leaders must think more broadly than cost savings and ROI calculations when investing in scaling DevOps across database teams.
Our latest whitepaper explains how to lay the foundations for a successful DevOps implementation, and how to track success against global metrics that demonstrate your team’s impact across the business.
Principal components analysis is a standard, but usually terrible, technique for visualising complex data. We're using network diagrams to solve this problem.
We tend to keep data around for a long time. Today Steve Jones is looking to see how long you've kept your databases around.
In this tip we look at a PowerShell script you can use to gather information about the installation date for all of your SQL Servers.
Referential constraints ensure data integrity, but in at least one case can cause occasional problems. Read on to see what can happen and why it can occur...
Developers and testers can be blocked from having a local, private database to work in because of disk space, refresh times, and data privacy. Download this free solution brief to learn how SQL Provision removes these blockers and enables production-like data to be delivered at speed.
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...
Jl. Inspeksi Kav. PTB Blok A 2 No. 2 C-D, RT.1/RW.4, Pd. Klp., Wil,...
Pondok Bambu Center, Jl. Pahlawan Revolusi No.30 Blok A/5-6, RT.2/RW.2, Wil, Kec. Duren Sawit,...
Jl. Tarum Barat Blk. E No.5, Wil. Kota, Kec. Duren Sawit, Kota Jakarta Timur,...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers