2007-11-22
37 reads
Editorial
Contract or Perm
If you are accepting a DBA position, does it make sense to work as a contractor or permanent employee?
2007-11-21
227 reads
2012-10-29 (first published: 2007-11-20)
215 reads
Open Enrollment
It's the time of year where employment benefits renew for many US employees. Steve Jones talks about how much your company should care about your health.
2007-11-19
64 reads
The Weekly News for November 19, 2007
A few comments on the news of the past week: SQL Server 2008 CPT5, a 1.6SSD Array, Non-Compete agreements and more.
2007-11-19
19 reads
Finding a Balance
This editorial was originally published on Nov 19, 2007. It is being republished as Steve is on vacation. With the tremendous amount of digital storage that people can carry around these days, how do you balance the security risks.
2012-08-31 (first published: 2007-11-16)
153 reads
2007-11-15
104 reads
Incommunicado
Communication is important, and it's a real problem when people can't reach you. Read about an interesting phone accident the some hints for better communication.
2007-11-14
63 reads
Data Breaches
Security is hard, but are we doing a good job? Steve Jones shares a few thoughts on our security development practices
2007-11-13
50 reads
The Pace of Information
Is the rapid pace of information being fed to us a problem? Steve Jones has a few thoughts.
2007-11-12
38 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