PASS Summit Volunteers Needed
Well, we are coming around into a new year. With this new year there is once again PASS Summit preparations that are well under way. Time has come again...
2011-02-16
5 reads
Jason Brimhall
PASS Summit Volunteers Needed
Well, we are coming around into a new year. With this new year there is once again PASS Summit preparations...
2011-02-16
624 reads
Feb 2011 S3OLV Meeting
I am getting this out extremely late. I seriously have good excuses for that. Due to my location and Charley feeling ill, we will be doing the S3OLV UG...
2011-02-09
2 reads
Feb 2011 S3OLV Meeting
I am getting this out extremely late. I seriously have good excuses for that. Due to my location and Charley...
2011-02-09
342 reads
T-SQL Tuesday #15 DBA Automaton
Often, we hear about DBA's automating everything under the sun. Why? It simplifies the job and creates time to work on other projects.
Related Posts:
Automating like an Enterprise DBA January...
2011-02-09
8 reads
T-SQL Tuesday #15 DBA Automaton
I have been incognito for the last couple of weeks and nearly missed TSQL Tuesday this month. If it weren’t...
2011-02-09
822 reads
Immersions Training
The last week of January 2011, I wrote a blog post entering a contest for free training at the hands of SQLSkills. Later that week an announcement was made...
2011-02-08
4 reads
Immersions Training
The last week of January 2011, I wrote a blog post entering a contest for free training at the hands...
2011-02-08
538 reads
Toys V. Tools
What's a toy and what's a tool? This Friday, a guest editorial from Jason Brimhall asks what in technology might be considered a toy or a tool, or perhaps, both.
2011-02-04
221 reads
Immersion in Internals
Paul Randal (Blog | Twitter) and Kimberly Tripp (Blog | Twitter) of SQLSkills are hosting an Immersions training event in Dallas. This is not run of the mill training, but it...
2011-01-26
9 reads
Blogs
The Book of Redgate: Profits
By Steve Jones
Redgate is a for-profit company. We look to make money by building and selling...
Session Materials for Techorama & DataGrillen 2026
I’ve uploaded the slides for my Techorama session Microsoft Fabric for Dummies and my...
Stop Using Pandas for Aggregations — Try DuckDB Instead
If you've ever loaded a 2 GB CSV into pandas just to run a...
Forums
Even When You Know What You're Doing, You Can Screw Up
Comments posted to this topic are about the item Even When You Know What...
The New Software Team
Comments posted to this topic are about the item The New Software Team
Database Mail in SQL Server 2022
Comments posted to this topic are about the item Database Mail in SQL Server...
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