Focus on Growth in Your Career
Steve has some advice on how to grow your career by growing your skills and developing deeper knowledge.
Steve has some advice on how to grow your career by growing your skills and developing deeper knowledge.
This article looks at the basics of the OVER() clause and how the PARTITION section works.
The rise of cross platform databases which are both on-premises and in the cloud, alongside decreasing customer satisfaction and trust in digital channels, has increased the importance - and value - of enhanced database monitoring. Find out how using a database monitoring tool creates value for the whole organization.
This article covers how to use the different date and time functions when working with Spark SQL.
The first three levels of this series have been the lead-up to this level, automating the database deployment with Azure Pipelines. First, we started with an introduction to Azure DevOps and the Git client. Next, SQL Source Control was introduced to manage a database’s schema and manually deploy changes from the database to source control […]
A stagnant career can be stifling, and it can make you unhappy at work, where you spend a lot of time. Steve has a few thoughts on how to avoid that.
Cardinality estimation (CE) is a process used by the query optimizer to estimate the number of rows returned by a query or sub-part of a query. These estimates rely on two underlying things: statistics about the data and a set of assumptions—known as the model.
Welcome to part twenty of the plansplaining series. It has been a long time since I last wrote a plansplaining post, partly because of my health, but also for a large part because I was out of ideas. But recently I decided to dig a bit deeper into a feature that was released in SQL Server 2017 and that I had so far not played with: SQL Graph.
This article examines how GitHub Copilot might be used when working with T-SQL Code.
Steve reminds people today that the recommendations from execution plans aren't always what you want to use when tuning your database.
By DataOnWheels
Hey folks, fun personal post today. A few weeks ago, I got married! My...
In June this year I took redundancy from the company I’d worked at for...
By Steve Jones
I posted that I was thinking about the AdventOfCode this year, but wasn’t sure...
Comments posted to this topic are about the item Backing Up Master
Comments posted to this topic are about the item Window Function Basics - PARTITION...
Comments posted to this topic are about the item Focus on Growth in Your...