Bert Wagner

SQL Server Quick Tips

Earlier this year I made a series of videos that were played before the start of several DBA Fundamentals presentations. These videos gave viewers something SQL related to watch while the...

2019-09-24 (first published: )

795 reads

Tracking Who Last Changed a Row

This post is a response to this month’s T-SQL Tuesday #118 prompt by Kevin Chant.  T-SQL Tuesday is a way for the SQL Server community to share ideas about different database and professional...

2019-09-19 (first published: )

1,012 reads

SQL Server Execution Plan Operators

Watch this week’s Execution Plan Operators episode on YouTube. SQL Server Execution Plan Operators When examining a query’s execution plan, certain operators tend to crop up over and over...

2019-08-26 (first published: )

791 reads

Blogs

How a new custom PowerPoint template is helping us to be more effective presenters

By

DCAC recently had a custom PowerPoint template built for us. We use PowerPoint for...

New Event Calendar

By

Speaking Engagements Check out my new Event Calendar, to see my upcoming and past...

Databricks Delta Lake

By

Introduced in April 2019, Databricks Delta Lake is, in short, a transactional storage layer...

Read the latest Blogs

Forums

More Network Restrictions

By Steve Jones - SSC Editor

Comments posted to this topic are about the item More Network Restrictions, which is...

SQL COUNT issue

By TJ_T

I could use some help with the following COUNT issue. Select distinct Model_id, COUNT(CASE...

Finding out mismatch between time lines.

By koti.raavi

CREATE TABLE #Source ( PlanId BIGINT, StartDate DATE, EndDate DATE ) GO CREATE TABLE...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers