With the popular data transformation tool dbt (data build tool), we have a bunch of interesting features at our disposal to write SQL more efficiently. One of those features is macros, which we’ll introduce in this article
Learn how you can use Power BI to forecase the future trends of data.
Microsoft announced that Linux runs on more machines in Azure than Windows. Steve isn't surprised and thinks that Linux use will continue to grow.
What are some of the most common mistakes when working with Power BI? For example, when a junior colleague starts on a Power BI project for the first time, what are the pitfalls you try to warn them about? What advice would you give them?
This article examines how tempdb is affected by recursive queries, using a few different methods.
Today, Kendra Little talks about how DevOps adoption affects developer productivity and time.
In this article, you’ll learn about the many options for using a GitHub-hosted runner, including Docker.
Steve finds a lot of people don't use version control and don't want to learn how to use it.
The STRING_AGG function concatenates strings separated by a specified separator. This was introduced with SQL Server 2017.
Learn a few tips and tricks to make your work with SSMS much more efficient and helpful.
Setting page visibility and the active page are often overlooked last steps when publishing...
By Steve Jones
It’s time for T-SQL Tuesday again and this time Todd Kleinhans has a great...
By Steve Jones
Recently I was working in VS Code and I saw a walkthrough for the...
Comments posted to this topic are about the item Password Guidance
Comments posted to this topic are about the item Using table variables in T-SQL
I am trying to check out elastic query between two test instances we have...
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers