TechNet WebCast: SQL Server Locking & Blocking
Next Monday, I’m presenting a TechNet WebCast for Microsoft Thrive Live! The subject: SQL Server Locking & Blocking Made Simple. Here...
2009-11-30
1,504 reads
Blog Posts
Unwired
I didn’t have Internet access for 4 days while we were in the mountains. Actually I could have purchased it,...
2009-11-30
1,466 reads
What’s Using Space in Tempdb?
It happens, not often, but I do regularly see people talking about their tempdb growing too large. Often that means...
2009-11-30
14,991 reads
When it rains…
It pours.
I come back from 4 days unwired, a bunch of writing done, to a laptop that’s head, a site...
2009-11-30
1,424 reads
XQuery For Idiots
I’m still struggling with learning XQuery. My latest little revelation was small, but vital.
The difference between:
@inXML.nodes('/rss/channel/item')and
@inXML.nodes('/rss[1]/channel[1]/item')Is the difference between a...
2009-11-30
1,746 reads
Featured Blogger: Rob Garrison
I met Rob via email early this year as a volunteer helping with content for PASS, and I’ve been following...
2009-11-29
1,417 reads
Kevin Kline on PASS
Brian Moran (incoming Board member) did a nice interview with Kevin, worth reading, and some good stuff about areas where...
2009-11-29
1,385 reads
Link: Top 200 Developer Blogs
Ran across this list a while back, Jurgen posted his Top 200 Developer Blogs list and an OPML file of...
2009-11-29
1,399 reads
weekly update
Well I said that I would try to post regularly and seeing as its Sunday and I haven’t posted for...
2009-11-29
597 reads
Picking a Branch
Do you know that there are actually two branches of SQL Server 2008 code right now? Actually I would bet...
2009-11-27
988 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers