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,779 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
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Forums
Two foreign keys to the same table. Can't cascade deletes.
Not sure if this is really a relational theory question but it seems about...
Connecting Power BI to SSAS and effective user not working
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Question of the Day
Encoding URLs
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers