Before I start the whining (whinging if you prefer), let me just say I have the greatest job in the world. I'm exceedingly lucky to have it. I'm grateful as can be. And someone else (looking at you Tim) can get it when they pry it from my dead cold fingers. With that out of […]
Who among us hasn't deleted a production data file? Steve hopes most of us have not.
Learn how you can conduct a sentiment analysis on data loaded into an Excel spreadsheet.
What advice would you give to someone new to Power BI? What are common Power BI mistakes to avoid? In this article, we will discuss several Power BI mistakes to avoid to help you navigate this powerful tool effectively.
AI is changing work, sometimes for the better, sometimes not. Steve continues to examine and evaluate how GenAI systems might be used in today's world and asks if there is work that might help you.
This article discusses the different types of backup and recovery models and gives the essential facts that will guide you to being able to achieve a recovery of a database to a point in time.
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?
They run, they return data. So what? Some SQL queries just waste your time...
By Steve Jones
I read Brent’s first look at SSMS and Copilot in there. He didn’t have...
By Steve Jones
falesia– n. the disquieting awareness that someone’s importance to you and your importance to...
Comments posted to this topic are about the item Calculating Month End
We have very large tables in our database, some even more 1 B records,...
I want to calculate the end of the previous month as a date that I can use in running a report. What is the best way to do this in SQL Server 2022, assuming I have a date stored in @d?
See possible answers