2020-07-24
81 reads
The Lighter Side
2020-02-21
735 reads
Unreliable Data Sensors
Steve doesn't like the idea of cars using data from cameras to update a display instead of a mirror.
2019-09-30
172 reads
NASA officially orders its first segment of a lunar space station
"This time when we go to the Moon, we're actually ...
2019-05-23
2019-05-10
Pop Quiz: SQL 2000 Bug or SQL 2017 Bug?
Brent Ozar asks if you can tell if each of these SQL Server bugs is brand-new, or almost 20 years old.
2019-05-03
Massachusetts offshore wind project gets green light at roughly 8.9 cents/kWh
The Vineyard Wind project will also commit $15 million to battery development.
2019-04-24
These are the best new vehicles of the 2019 New York International Auto Show
American auto shows are in decline, but we still found a few things to excite.
2019-04-22
The Porsche Panamera Turbo Sport Turismo—to hybrid or not to hybrid?
The Panamera Turbo comes in two flavors, and the more powerful one is a hybrid.
2019-04-11
T-SQL Tuesday #113: A year of marriage and boardgames
This week’s T-SQL Tuesday is about where you use databases in your personal life. And I have a database I don’t use any more that’s a little happy and...
2019-04-09
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
Wrong frames in blocked process report
Hi all, I'm on a sql server 2019 standard edition (15.0.4375.4) where I've a...
SRSS Failed Setup " The System cannot find the file specified (0x80070002)
Dear All, I am facing issue when update my license SRSS 2022 from...
Git Repo(s) for SQL Server Database, SSIS, SSAS, SSRS, PowerBI
Hey all, Just wondering how do you guys / girls set up git repo(s)...
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;