2022-03-30
114 reads
Microsoft
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
274 reads
Power Apps Canvas Apps Examples
In this article we will focus on Power Apps canvas apps which are natively optimized for mobile devices and we will look at potential use cases for canvas apps.
2021-04-15
2021-03-11
109 reads
Microsoft Fights Back
Microsoft fights back against hackers after a recent vulnerability in a management framework.
2021-01-14
217 reads
2020-11-11
100 reads
2020-10-13
156 reads
Compatibility Level Confidence
The database compatibility level ought to provide some protection from database upgrade changes, but do you believe that?
2020-09-21
321 reads
The Evolution of Windows
Today Steve looks back at Windows, and how Windows 10 might be the last version. Perhaps this is the model we'll see with SQL Server in the future.
2020-09-01
267 reads
The Computing Revolution
Steve reflects on some of the ideas of how Microsoft imagines the future of computing.
2020-07-27
128 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...
We Should Demand Better
Comments posted to this topic are about the item We Should Demand Better
Estimated Rows
Comments posted to this topic are about the item Estimated Rows
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