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 Arun Sirpal
In the previous blog post I did a quick overview building a SQL VM...
By Ed Elliott
It has been a little while but I have updated SQLCover to include a...
By Rayis Imayev
(2019-October-16) Developing conditional logic of your Azure Data Factory control flow has been simplified with...
Hye, I've table and data as following, CREATE TABLE [dbo].[WeightStory]( [Idx] [int] IDENTITY(1,1) NOT...
I have a query that creates an xml file but I'm getting errors because...
Hi all, hope you can help. I'm not a DBA so have been googling...
Ask SSC