PASS Summit 2016 Program Committee
As I usually do, I applied to be a member of the Program Committee for the 2016 PASS Summit. I...
2016-02-13
358 reads
Jack Corbett
- Interests: Sports, books, Bible
PASS Summit 2016 Program Committee
As I usually do, I applied to be a member of the Program Committee for the 2016 PASS Summit. I have been on the program Committee the last 4...
2016-02-13
7 reads
I’m Speaking at SQLSaturday #156–Providence
I’m excited to be back on the speaking circuit. I was able to attend SQLSaturday #122 – Louisville thanks to Idera...
2012-08-22
725 reads
I’m Speaking at SQLSaturday #156–Providence
I’m excited to be back on the speaking circuit. I was able to attend SQLSaturday #122 – Louisville thanks to Idera and the ACE program. Now I’m on...
2012-08-22
9 reads
Restarting
Well, it’s been awhile since I’ve written anything. I have lots of excuses for not writing, but none of them...
2012-08-17
782 reads
Restarting
Well, it’s been awhile since I’ve written anything. I have lots of excuses for not writing, but none of them are rally valid. There are 2 real reasons for...
2012-08-17
10 reads
OT: Goodbye Dad
This is a bit of ramble.
At about 2:15AM November 21st, 2011 my dad, Arthur Corbett, went home to be with...
2011-11-21
848 reads
OT: Goodbye Dad
This is a bit of ramble. At about 2:15AM November 21st, 2011 my dad, Arthur Corbett, went home to be with his Lord and Savior, Jesus Christ. I...
2011-11-21
9 reads
Me an MVP? It Really Happened
Yes, I was named a SQL Server MVP the most recent round of awards. I honestly can’t believe it. It...
2011-10-04
673 reads
Me an MVP? It Really Happened
Yes, I was named a SQL Server MVP the most recent round of awards. I honestly can’t believe it. It is a great honor to have been recognized for...
2011-10-04
4 reads
Blogs
Why Optimize CPU for RDS SQL Server is a game changer
One feature that I have been waiting for years! The new announcement around optimize...
Performance tuning KubeVirt for SQL Server
Following on from my last post about Getting Started With KubeVirt & SQL Server,...
T-SQL Tuesday #193 – A Note to Your Past, and a Warning from Your Future
By DesertDBA
I haven’t posted in a while (well, not here at least since I’ve been...
Forums
i noticed the sqlhealth extende event is on by default , so can i reduce
hi, i noticed the sqlhealth extended event is on by default , and it...
Looking for advice on improving SQL Server performance for a service management
Hi everyone, I’m looking for some guidance on a SQL Server performance issue I’ve...
New-AzSqlInstanceServerTrustCertificate - Failed and no clues
Using New-AzSqlInstanceServerTrustCertificate to import a certificate and get the message New-AzSqlInstanceServerTrustCertificate: Long running operation...
Question of the Day
The Read Committed Snapshot Isolation behaviour
I am currently working with Sql Server 2022 and AdventureWorks database. First of all, let's set the "Read Committed Snapshot" to ON:
use master; go alter database AdventureWorks set read_committed_snapshot on with no_wait; goThen, from Session 1, I execute the following code:
--Session 1 use AdventureWorks; go create table ##t1 (id int, f1 varchar(10)); go insert into ##t1 values (1, 'A');From another session, called Session 2, I open a transaction and execute the following update:
--Session 2 use AdventureWorks; go begin tran; update ##t1 set f1 = 'B' where id = 1;Now, going back to Session 1, what happens if I execute this statement?
--Session 1 select f1 from ##t1 where id = 1;See possible answers