A DMV a Day – Day 25
The DMV for Day 25 is sys.dm_os_memory_cache_counters, which is described by BOL as:
Returns a snapshot of the health of a...
2010-04-25
1,698 reads
Glenn Berry
A DMV a Day – Day 24
The DMV for Day 24 is sys.dm_exec_requests, which is described by BOL as:
Returns information about each request that is executing...
2010-04-24
960 reads
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,399 reads
A DMV a Day – Day 22
The DMV for Day 22 is sys.dm_exec_query_memory_grants, which is described by BOL as:
Returns information about the queries that have acquired...
2010-04-22
1,753 reads
Big SQL Server Announcement This Morning at 7:30AM PDT
Microsoft’s Ted Kummert and Tom Casey are holding a public conference call this morning at 7:30AM Pacific time, where:
Microsoft...
2010-04-21
730 reads
A DMV a Day – Day 21
The DMV for Day 21 is sys.dm_os_ring_buffers, which is helpfully NOT described by BOL as:
The following SQL Server Operating System–related...
2010-04-21
2,584 reads
Staying Current with SQL Server Builds
There was some conversation on Twitter about how to get notification when new Cumulative Updates are released for SQL Server...
2010-04-20
974 reads
A DMV a Day – Day 20
The DMV for Day 20 is sys.dm_exec_cached_plans which is described by BOL as:
Returns a row for each query plan that...
2010-04-20
1,089 reads
SQL Server 2005 SP3 Cumulative Update 9 (Build 4294)
Microsoft has released SQL Server 2005 SP3 Cumulative Update 9, which is Build 4294. I count 13 fixes in this...
2010-04-19
1,078 reads
A DMV a Day – Day 19
The DMV for Day 19 is sys.dm_os_wait_stats, which is described by BOL as:
Returns information about all the waits encountered by...
2010-04-19
2,050 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 Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers