2008-03-17
241 reads
Editorial
2008-03-16
42 reads
2008-03-14
118 reads
Scaling Out
Scaling out is hard to do with SQL Server, but why doesn't Microsoft build a better solution?
2008-03-13
276 reads
NCAs and NDAs
When accepting an offer of employment, what do you do about NCAs and NDAs that you might be asked to sign? Steve Jones offers some advice. (This editorial was originally published on Mar 12, 2008. It is being re-run as Steve is on holiday.)
2016-09-05 (first published: 2008-03-12)
287 reads
The Social Contract
How much of a contract for servicing SQL Server should we expect? Has Microsoft broken an implied contract with us?
2008-03-11
91 reads
Bad Meetings
A joint editorial this week from the Red Gate team looking back at the news of the week.
2008-03-10
54 reads
The Daily Routine
Steve Jones compares his daily routine now to that of being a DBA. This editorial was originally published on Mar 10, 2008. It is being re-run as Steve is on holiday.
2012-12-27 (first published: 2008-03-10)
584 reads
Masking Data
As DBAs we go to great lengths to ensure the security of our production data. But what happens when it moves off of a production server?
2015-10-28 (first published: 2008-03-07)
1,310 reads
Dreams of the Future
Steve Jones looks ahead to an interesting trip for the future of a couple of technical geeks.
2008-03-06
87 reads
Blogs
SQL Server Alerts
By Kevin3NF
Don’t Let Trouble Sneak Up on You Most SQL Servers run quietly. Until...
Prompt AI helping with Auditing
By Steve Jones
I had a conversation with a customer asking this question: how can I tell...
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...
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...
Collation errors...what is best way to deal with it?
Hi I have a SP that occasionally get this error: Cannot resolve the collation...
Was the index created or not?
Hi everyone I am getting an error when I create the index but I...
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 in SQL Server 2022? See possible answers