A DMV a Day – Day 23
The DMV for Day 23 is sys.dm_os_process_memory, which is described by BOL as:
Most memory allocations that are attributed to the...
2010-04-23
2,400 reads
Blog Posts
Adding Administrator
I installed a new VM with SQL Server in it, along with Win 7 and Reporting Services. The plan was...
2010-04-23
798 reads
Besides Being a DBA, Do You Also Happen to be an Exchange Administrator?
I know a lot of DBAs fall into the category of part-time DBAs, because they work in small IT shops...
2010-04-23
550 reads
Book Review - Rework
I have been a fan of 37 Signals for some time, and I read their blog regularly. I think they...
2010-04-23
790 reads
Book Review: Knives at Dawn: America’s Quest for Culinary Glory at the Legendary Bocuse d’Or Competition
Another find from the new book shelf at the local library, Knives at Dawn: America’s Quest for Culinary Glory at...
2010-04-23
476 reads
Increasing deadlocks with NoLock
One of my personal pet issues is with inappropriate use of the NOLOCK hint (and read uncommitted) . Don't get me...
2010-04-23
750 reads
Looking forward to Optimize for Ad hoc Workloads in Sql Server 2008
Looking forward to Optimize for Ad hoc Workloads in Sql Server 2008
One of the features of SQL Server 2008 that...
2010-04-23
3,243 reads
Presenting at 2010 European PASS – Sort Of
I was so looking forward to the trip to Germany to speak at the European PASS Summit
on April 22nd. Two...
2010-04-23
422 reads
Results of Microsoft Certification Poll
In a recent poll at www.bradmcgehee.com, I asked website visitors if they had any Microsoft SQL Server certifications, and if...
2010-04-23
1,195 reads
Rules to Live By: Do the Hard Things First
I can’t say I stick to this one 100 percent of the time, but it’s definitely a deeply held belief....
2010-04-23
511 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