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.
2024-05-24
105 reads
Public Speaking
To Which Experts Should You Listen?
Many experts that speak to at events are working for vendors. Steve notes that this might mean they are making sales pitches, not not always.
2022-09-14
158 reads
Back to Basics, Reaching for the Clouds, and Leveling Up
The three themes for speakers at this year's PASS Data Community Summit are: Back to Basics, Reach for the Clouds, and Level Up. The goal here is content that covers a wide variety of areas, with many fewer restrictions from previous years. Perhaps the big thing to note for this year's event is: Free. That's […]
2021-06-02
208 reads
Looking to Role Models
Each of us can inspire and be a role model for others. Steve notes that the WIT group is doing that with an event on March 5th.
2021-02-13
105 reads
Join the New Stars of Data
There are plenty of opportunities to grow your career by sharing knowledge. Steve points out a few today.
2020-12-17
132 reads
A Virtual Trip Down Under
Steve returns from vacation and gets ready for a virtual trip to Australia.
2020-06-29
69 reads
Dummies Guide for a SQL Server Presentation
Preparing for SQL Server presentations is always a challenge. This article provides a few guidelines for the same
2016-10-27
2,299 reads
Blogs
Convert SQL Audit Files to a CSV Using Read-SqlXEvent
By Patrick
SQL Server Audit is an efficient way to track and log events that occur...
Control Flow Restartability in Azure Data Factory
I presented at SQL Saturday Pittshburgh this past weekend about populating your data warehouse...
Monday Monitor Tips: Knowing Your RPO
By Steve Jones
A customer was asking recently about the RPO for their estate, and I showed...
Forums
changing over to a tab delimited file in my pkg that walks thru folders
hi, we just decided to change over to a tab delimited format in a...
how to query that stores mulit select field data
Hi everyone, I have a table as below, I would like to strip out...
Getting all ancestral parents of a table
From this link - https://stackoverflow.com/questions/22005698/how-to-find-all-the-dependencies-of-a-table-in-sql-server I can find all the child dependencies starting from my...
Question of the Day
STRING_AGG's behavior
Executing the following script (Sql Server 2022), you get the table t0 with 10 rows:
CREATE TABLE t0
( id INT PRIMARY KEY
, field1 VARCHAR(1000)
, field2 VARCHAR(MAX));
INSERT INTO t0
SELECT
gs.value
, REPLICATE ('X', 1000)
, REPLICATE ('Y', 1000)
FROM generate_series(1, 10, 1) gs;
GOWhat happens if you execute the following statements?
select STRING_AGG(field1, ';') within group (order by id) from t0;
select STRING_AGG(field2, ';') within group (order by id) from t0;