Data Bits – Episode 4 – Jules Behrens
SQL Server DBA Jules joins us on the show to talk DBA work, Chickens, Charity work, Mentoring and Shepherding (actual sheep!) See more at Jules’ site Edit: Honorable mentions: Minionware,...
2020-04-02
6 reads
Kevin3NF
- Interests: Cycling, family, sci-fi, DBA stuff
Data BIts – Episode 3 – Ginger Grant
Trainer and Consultant extraordinaire Ginger Grant stops by to talk Machine Learning, Data Bricks, Certifications, Norwegian pastries and proper chocolate frosting Find Ginger at Desert Isle SQL or on Twitter
The post Data BIts...
2020-04-01 (first published: 2020-03-26)
203 reads
SQL Server HADR overview
My Pluralsight course for new SQL Server DBAs Image credit to Jeff (t) Back in June of 2019, I published this YouTube video covering the highlights of the various...
2020-03-25
50 reads
SQL Server Identity Skipping
My Pluralsight course for new SQL Server DBAs SQL Server may skip 1000 numbers on an Identity column if the server crashes. Here’s why: Too long, didn’t watch version:...
2020-02-04
16 reads
Blogs
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...
Webinar tomorrow: The Role of Databases in the Era of AI
By Steve Jones
I’m hosting a webinar tomorrow with Rie Merritt from Microsoft. We’ll be talking about...
Forums
Vending Machine Proposal Template
The Super Proposal Vending Machine Proposal Template is a comprehensive and customizable tool designed...
best choice for index when creating a composite key
hi everyone I am planning on adding a composite key for my tables. I...
Best Approach to cutover from Test to Live with new columns and tables added
We have a Production/Live version with up-to-date data and a Test version with older...
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;