Helping Students with a Data Professional Career
Steve has advice for students looking to become data professionals.
Steve has advice for students looking to become data professionals.
Building pipelines in Microsoft Fabric can be complicated, and it's easy to write code that is hard to maintain. Using parameters in your connections helps to build pipelines that are easily configured.
What DMVs were added to Azure SQL Databases, and which DMVs are missing from Azure SQL Databases but still exist on SQL Server 2019 or other versions?
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
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 Helping Students with a Data...
Comments posted to this topic are about the item Calculating Month End
Comments posted to this topic are about the item Parameterize Connections in Microsoft Fabric...
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