It’s been a goal for several years to write (or help write) a book on a topic I love. While I can’t share details yet, there’s some movement on this dream and I’m excited about it. And I’m even more excited that I get to do it alongside someone that I’ve respected for a long […]
Learn how you can query JSON data from a CLI to check it before importing the data into a database.
Your challenge for this week is to tune a query. Say Stack Overflow has a dashboard that shows the top-ranking users in their most popular location. It’s even got an index to support it
Microsoft will be featured at SQL Bits with a keynote speaker, a full day of training and a few other sessions. Register today for the conference in March and we hope to see you there.
In this next level of the Stairway to Biml, learn how metadata makes your Biml code more efficient and helpful in generating packages.
Git is a good tool for DBAs and other Operations staff. Today Steve gives you a few reasons why.
Microsoft Power BI Desktop provides users with multiple ways to help shape and transform their data. One of the options users have is scientific calculations, which support operations like cube, square, logarithms, etc. Power BI has this option in the Power Query Editor mode, where the user can easily apply one of these transformations for any number-based columns. In this tip, we will overview this utility in Power BI and how to benefit from it.
At Redgate, the teams change every year and Steve has a few reasons why this is good.
Introduction In this article, we will see how to work with GitHub Copilot. GitHub copilot is an interesting plug-in that generates code using AI. The technology is from Microsoft and OpenAI. We will show how to install Copilot, and how to generate SQL Server code (T-SQL) using Copilot. First, we will answer some FAQs about Copilot […]
This June, LearnSQL is throwing down the gauntlet with a fresh SQL Practice challenge....
By Steve Jones
I delivered a talk today on database deployment best practices at the Denver Dev...
By Steve Jones
desanté – n. the brooding delirium of being sick, which makes time slow to...
Comments posted to this topic are about the item On Being an "Expert"
Advice on how to script out existing Azure (logical) SQL Server logins and mapped...
Hi I have a sequence container which contains an execute package task which loads...
I have a query that is being tracked in the SQL Server 2022 Query Store. I want to add a hint to this query to ensure that the MAXDOP for this query is one. How can I do this with minimal code changes
See possible answers