Twas the Night Before the MCM ...
T'was the Night Before the MCM ...
SQL Server MCM starts tomorrow. My wife thinks it's cute that I'm excited. The...
2010-03-14
969 reads
Robert Davis
- Interests: Poker, computers, reading/writing horror fiction
Top 6 Myths of Transaction Logs
Top 6 Myths of Transaction Logs I think there is a lot of misunderstanding concerning database transaction logs in SQL Server. I...
2010-03-10
4,530 reads
Breaking Down TempDB Contention
Breaking Down TempDB Contention
What is tempDB contention? From the outside looking in, tempDB contention may look like any other blocking. There...
2010-03-10
2,763 reads
T-SQL Tuesday #004: IO -- Where Are My TempDB Objects?
T-SQL Tuesday #004: IO -- Where Are My TempDB Objects?
This blog entry is participating in T-SQL Tuesday #004, hosted this month...
2010-03-09
1,452 reads
SQL LiteSpeed Error: XML returned from Engine was invalid
SQL LiteSpeed Error: XML returned from Engine was invalid
This is a very common error returned from SQL LiteSpeed. So what...
2010-03-06
2,871 reads
Breaking Down TempDB Contention
Breaking Down TempDB Contention
What is tempDB contention? From the outside looking in, tempDB contention may look like any other blocking. There...
2010-03-05
81,761 reads
Do I have to snatch the pebble?
Attending the Microsoft Certified Master (MCM) program in March
This is the most excited I've been since I heard that Alice...
2010-02-17
810 reads
SQL Saturday returns to Redmond, WA
SQL Saturday returns to Redmond, WA, Saturday, June 12, 2010, in the Microsoft Commons.
I have submitted 2 proposals for presentations,...
2010-02-17
740 reads
SQLSaturday 26 Session Files
SQLSaturday 26 Sessions: 10/3 in Redmond, WA
Thanks to everyone that attended my sessions at SQLSaturday 26 in Redmond, WA on...
2009-10-04
1,022 reads
What mechanism allows SQL Server 2008 to commit transactions on the mirror faster than SQL Server 2005?
Question: What mechanism allows SQL Server 2008 to commit transactions on the mirror faster than SQL Server 2005? This question was asked on a technical discussion group. My reply follows.
2009-05-19
3,115 reads
Blogs
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Forums
The Max PK Length
Comments posted to this topic are about the item The Max PK Length
My experience using the GitHub Copilot in SSMS 22
Comments posted to this topic are about the item My experience using the GitHub...
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
Question of the Day
The Max PK Length
If I create a multiple column Primary Key constraint, what is the most number of bytes I can include in the constraint?
See possible answers