Articles

SQLServerCentral Article

Using Containers to Avoid Installing SQL Server

I got a new laptop recently and instead of installing SQL Server, I decided to try and use containers to see how well this works. This article looks at how I got this working relatively quickly. The short list of things I did is: Install Docker Desktop Create a location for data/logs/etc. Create a docker-compose […]

5 (2)

You rated this post out of 5. Change rating

2024-09-06

3,536 reads

SQLServerCentral Article

How to Recover a Corrupted Azure Data Factory Integration Runtime

I would like to share my recent experience with Azure Data Factory (ADF) where AutoResolveIntegrationRuntime become corrupted and how did I recover it. I still don't know how the Integration Runtime (IR) was corrupted. However, if it happens, then this article will help you to solve the issue. Problem In general, the ADF AutoResolveIntegrationRuntime should […]

5 (2)

You rated this post out of 5. Change rating

2024-09-02 (first published: )

3,701 reads

SQLServerCentral Article

How to Delete Large Amounts of Data

As a DBA, we are often tasked with maintenance work on the database. Often this includes making sure that old data is purged from the tables.  This is especially true with logging tables.  Sometimes multiple applications write to the same logging tables, and they can grow very quickly. Let’s say we have a logging table […]

4.56 (9)

You rated this post out of 5. Change rating

2024-08-30 (first published: )

21,625 reads

Technical Article

Is it still worth it to sponsor PASS Summit?

Conference planning is underway. Several folks have asked me whether I think the PASS conference is still worth exhibiting. I thought an article would be best to break down my thoughts. I’m in an interesting position, being a marketing leader who also specializes in SQL Server and doesn’t work for Microsoft. I’ve worked directly for several companies in the ecosystem, so I know how difficult reaching the DBA market has been post-pandemic.

You rated this post out of 5. Change rating

2024-08-30

Blogs

Free webinar – Tackling the Gaps and Islands Problem with T-SQL Window Functions

By

I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...

Counting Groups with Window Functions: #SQLNewBlogger

By

I looked at row_number() in a previous post. Now I want to build on...

Read the latest Blogs

Forums

Find rows with very close time stamps

By daytonbrown2

Given the following table and query, this will return any records(based on message_id) that...

How to merge two tables with unlike fields

By landonh

How to merge two tables with unlike fields. I have two table with one...

Visual Studio 22 / SSIS Project / (Project) Connection problem

By WilburSmith

Hello, First of all, I find it odd/annoying that I can't exclude a Project...

Visit the forum

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  9
If 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