SQL Dirty Pages
Lazy writing , eager writing and checkpoint use asynchronous IO in writing pages to disk. The purpose of asynchronous IO is...
2011-11-28
12,256 reads
Blog Posts
SQL Server A to Z – Waits
In the world of SQL Server, a process is either running, runnable, or waiting. A running process is, obviously, running;...
2011-11-28
877 reads
What Opportunity Are You Looking For?
http://www.flickr.com/photos/mencho-22/6218974134/
A lot has been happening this year. I decided to throw my hat in the ring at being a blogger...
2011-11-28
739 reads
And the winners of SafePeak’s SQL Server Performance Contest are...
SafePeak’s SQL Server Performance Contest – Winners
(In coordination with SQLAuthority.com) Back in September, 2011, SafePeak ran a new contest asking participants to share...
2011-11-27
1,850 reads
Installing SQL Server 2012 RC0 from an iPhone
Short version – Installed SQL Server 2012 RC0 onto a Server 2008 SP2 VM using an RDP connection from my iPhone...
2011-11-27
2,775 reads
MS Days 2011 in Albania, Tirana
I would like to write about the tech events in my country and our brother-neighbor Albania, that everyday we are...
2011-11-27
940 reads
Data Loading Performance Guide
Bulk loading with large amounts of data requires strategy. The Data Loading Performance Guide for SQL Server 2008 and SQL...
2011-11-26
3,594 reads
Hotfix for SQL Server 2008/2008 R2 Periodically Does Not Accept Connections Bug
Microsoft has released a hotfix for a very frustrating issue that plagued me for a couple of years at NewsGator. ...
2011-11-26
9,760 reads
Adelaide SQL Server User Group Slides and Scripts
You can find the slides and scripts from Monday’s Extended Events session for the Adelaide SQL Server User Group in the...
2011-11-25
524 reads
Re-blog – November 18 – November 24
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer...
2011-11-25
893 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Optimism Without Illusion or Why AI Needs Blunt Technologists
Comments posted to this topic are about the item Optimism Without Illusion or Why...
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers