SQL Server Temporary Stored Procedures
Learn about creating stored procedures in the SQL Server tempdb database and why you might want to create temporary stored procedures.
Takeaways from Data Grillen 2024
Two days of Data, Beer and Bratwurst. What did it bring me, find out by reading this photo-rich article.
The Costs and Rewards of Speaking
Steve has had a good time sharing knowledge with others at events. He gives you a few thoughts on why you might join him at a future event.
How to Build Metadata Driven Pipelines in Microsoft Fabric
Over the past years, “traditional” ETL development has morphed into data engineering, which has a more disciplined software engineering approach. One of the benefits of having a more code-based approach in data pipelines is that it has become easier to build metadata driven pipelines.
Empowering Lakehouse Users – Data Engineering with Fabric
Learn how to use the OneLake Explorer and Data Wrangler extension in VS Code to empower users to work with data in Microsoft Fabric.
Invisible Downtime
Steve has a few thoughts on invisible downtime, a term he had never heard until recently.
Troubleshoot SQL Server Always On Availability Groups with SQL LogScout
We experienced several unplanned outages and failovers on our SQL Server Always On Availability Groups. We want to know the root cause to prevent them from happening in the future. How do we identify the root causes of unplanned Availability Group outages and failovers?
How Big Data Supports Gen AI
This article includes an overview of how big data and Artificial Intelligence (AI) models work together.
Kubernetes is Cool, But ...
Steve has a few thoughts on Kubernetes and how much data professionals should care about the technology.
Recursive CTEs: Transforming and Analyzing Data in PostgreSQL, Part 3
The first two articles in this series demonstrated how PostgreSQL is a capable tool for ELT – taking raw input and transforming it into usable data for querying and analyzing. We used sample data from the Advent of Code 2023 to demonstrate some of the ELT techniques in PostgreSQL.
Blogs
Free webinar – Tackling the Gaps and Islands Problem with T-SQL Window Functions
I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...
Counting Groups with Window Functions: #SQLNewBlogger
By Steve Jones
I looked at row_number() in a previous post. Now I want to build on...
The query processor ran out of internal resources and could not produce a query plan – When You’ve Managed to Confuse SQL With a Crazy IN Clause.
Recently I received a cry for help over Teams. The issue was that an...
Forums
How to merge two tables with unlike fields
How to merge two tables with unlike fields. I have two table with one...
Visual Studio 22 / SSIS Project / (Project) Connection problem
Hello, First of all, I find it odd/annoying that I can't exclude a Project...
How to determine if a DB is currently being used
Hi - I'm looking for advice regarding the best & quickest way to establish...
Question of the Day
The LAGging NULL
I have this data in a SQL Server 2022 table:
player yearid team HR Alex Rodriguez 2012 NYY 18 Alex Rodriguez 2013 NYY 7 Alex Rodriguez 2014 NYY NULL Alex Rodriguez 2015 NYY 12 Alex Rodriguez 2016 NYY 9If I run this code, what are the results returned in the hrgrowth column?
SELECT player , yearid , hr , hr - LAG (hr, 1, 0) IGNORE NULLS OVER (ORDER BY yearid) AS hrgrowth FROM dbo.playerstats;See possible answers