2020-11-12
508 reads
Editorials
2020-11-11
100 reads
Do What Hurts
When you struggle with a software task, the best advice is to do it more often and get better at the task, not avoid doing it.
2020-11-10 (first published: 2019-10-22)
266 reads
Building Bad Software Faster
DevOps doesn't mean just building software faster. Quality matters as well.
2020-11-09
139 reads
Automatic Install of Azure Data Studio
Microsoft recently announced that you’ll get Azure Data Studio (ADS) when you install SQL Server Management Studio (SSMS) starting with version 18.7.1. Azure Data Studio has been around for a couple of years, and it has some great features that most of us never imagined for SSMS, like the ability to connect to PostgreSQL databases […]
2020-11-07
1,208 reads
Going On-Prem?
Is the decision for a new database starting to switch from the default of on-premise to in the cloud? Steve Jones has a few thoughts on when we'll get there.
2020-11-06 (first published: 2016-07-11)
245 reads
The Forever Technology War
The differences in our understanding of technologies can make for some communication challenges.
2020-11-05 (first published: 2016-11-01)
160 reads
Maintaining Data in a Flow
One of the challenges of using scripts is maintaining them and ensuring the adapt over time.
2020-11-04
109 reads
2020-11-03
124 reads
The Separation of Tools
SSMs and ADS are the new tools for SQL Server and the data platform, both of which are now available separately from SQL Server.
2020-11-02
507 reads
Blogs
From Data Custodian to Innovation Catalyst: The Evolving Role of the CDO
By Chris Yates
There was a time when the Chief Data Officer lived in the shadows of...
Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests
By Rayis Imayev
"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...
Adding a Local Model to Ollama through the GUI
By Steve Jones
I saw some good reviews of the small gemma3 model in a few places...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Cruelty-Free Cosmetics Market Subject Mastery for Competitive Edge
The global Cruelty-Free Cosmetics market is a dynamic and promising industry that has shown...
We Should Demand Better
Comments posted to this topic are about the item We Should Demand Better
Question of the Day
Estimated Rows
I have two calls to the GENERATE_SERIES TVF in this code:
SELECT TOP 10 gs.value FROM GENERATE_SERIES(1, 10) AS gs ORDER BY NEWID () OPTION (RECOMPILE); go DECLARE @a int = 10; SELECT TOP (@a) gs.value FROM GENERATE_SERIES(1, @a) AS gs ORDER BY NEWID () OPTION (RECOMPILE);In the actual query plans, what is the estimated number of rows for each batch? See possible answers