The API Bottleneck
Using an API for data access can be good, but it can also be a performance problem if everyone uses it.
2021-11-17
732 reads
software development
Making Software Decisions
The process of building software for others involves lots of decisions. Ensuring that you are making good decisions can impact how others view your final product.
2021-09-27
186 reads
New Old Architectures
The idea of event driven, rather than tightly coupled architectures is one that Steve thinks data professionals should learn more about.
2021-09-10
272 reads
Patterns and Potential Problems
We use patterns in software development to make things easier. This is especially true in database changes. Steve reminds you that all solutions might have a downside of which you need to understand.
2021-09-08
169 reads
Eyes Wide Open
Trying to architect a new database system so that you don't outgrow it is a challenge, but the more you think about early, the better off you will be.
2021-08-30
174 reads
2021-08-21
370 reads
What's Important to Your Organization
Some organizations see their IT organization as an expense, and not as valuable as it might otherwise be. Steve has a few comments on why this might not be a good idea, or a good place to work.
2021-08-13
256 reads
Do as I say, not as I do
Steve wishes that Microsoft would follow some of their own advice on SQL Server development in their other software.
2021-08-04
248 reads
Enterprise Software
Building software in an enterprise is hard, and often, large organizations don't quite know how to do it.
2021-07-12
460 reads
Useless Hackathons
Are hackathons a good way to get a project started? It's not clear to Steve that open ended events are good.
2021-06-14
173 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
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...
Average Height For A Man In India
The average height for a man in India is approximately 5 feet 5 inches...
Limb Lengthening Surgery Cost in India
Limb lengthening surgery in India is a specialized orthopedic procedure aimed at increasing the...
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;