Chris

Chris started in computing and I.T. in the mid to late 1990's. After the dust had settled from Y2K, he found himself a bit more focused and working with database servers on the Unix platform. His first exposure to SQL Server was in 2007 and he has been working on that platform ever since. Chris is currently a Sr. SQL Server DBA in more of a DevOps role with a main focus on operational reliability, stability and performance. His specialty is automation. He truly enjoys the days he gets to spend building tools with PowerShell to help his fellow DBA's manage their ever growing SQL Server environment.

All authors

Blog Post

Configure SQL Server Agent using SMO

Saw this on twitter and thought I would throw it up on the blog. Easier than responding on twitter.

[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") | Out-Null;

$SQLServerInstance...

2015-03-24

398 reads

Blog Post

Get-DiskSpace

My cheap and dirty PowerShell script for dumping the disk space usage for a Windows machine. It was originally some...

2015-03-24

459 reads

Blog Post

My Specialty

So I was reading the following blog post by Brent Ozar and I think it finally hit me right between the...

2015-03-24

307 reads

Blog Post

Who is cjsommer?

I’ve been a problem solver as far back as I can remember, always looking for a new challenge. I love...

2015-03-24

259 reads

All authors

Blogs

Giving AI Agents Visibility Into SQL Server with MCP

By

I’ve been thinking a lot lately about what it actually takes to make an...

The Book of Redgate: Profits

By

Redgate is a for-profit company. We look to make money by building and selling...

Session Materials for Techorama & DataGrillen 2026

By

I’ve uploaded the slides for my Techorama session Microsoft Fabric for Dummies and my...

Read the latest Blogs

Forums

Even When You Know What You're Doing, You Can Screw Up

By Grant Fritchey

Comments posted to this topic are about the item Even When You Know What...

The New Software Team

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The New Software Team

Database Mail in SQL Server 2022

By Abdellateef Ibrahim

Comments posted to this topic are about the item Database Mail in SQL Server...

Visit the forum

Question of the Day

The string_agg function

We create the following table and then insert some records in it: 

create table t1 (
   id int primary key,
   category char(1) not null,
   product varchar(50)
);

insert into t1 values
(1, 'A', 'Product 1'),
(2, 'A', 'Product 2'),
(3, 'A', 'Product 3'),
(4, 'B', 'Product 4'),
(5, 'B', 'Product 5');
What happens if we execute the following query in both Sql Server and PostgreSQL? 
select id, 
category, 
string_agg(product, ';')
                 over (partition by category order by id
                 rows between unbounded preceding and unbounded following) as stragg
from t1;

See possible answers