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.
If you aspire to drive Database DevOps at your company, regardless of the sector you work in, this webinar provides a unique opportunity to learn from experts in the finance sector who have successfully paved the way. Join us December 6th.
Learn about various PowerShell commands that can be used to administer virtual machines on Amazon AWS.
Someone generated a fake speaker profile for their conference, which Steve finds disturbing.
Learn the basics of how to work with objects in Cassandra, a NoSQL database.
It’s me again with my apparently semi-annual blog post. This time we’re going to...
By Steve Jones
I saw an article on this and realized I had no idea how to...
In this blog post I wrote a tip about fixing the PostgreSQL backup failure...
Hey all, Currently trying to build a report in SSRS using SSAS cube. Load...
Comments posted to this topic are about the item A Partial Count
Comments posted to this topic are about the item The Stagnant Career
Ask SSC