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,259 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
740 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,777 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
941 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,602 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,761 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
525 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
894 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
How to change the FDLaunch Error log file location
The file FDLAUNCHERRORLOG gets created in the default <instance>\MSSQL\Log folder. So far, I've found...
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers