My first useful powershell script – capturing performance counters
After playing around with powershell a bit, I managed to do something quite useful. There are a multitude of ways...
2009-11-30
1,776 reads
Blog Posts
OT: Maximizing My Time, Using Technology
Well I've taken the plunge. I have finally broken down and decided to dictate blog post, articles, and other documents....
2009-11-30
1,558 reads
PASS Update #20
On the Friday at the end of the Summit we had a 4 hour Board meeting, welcoming new board members...
2009-11-30
1,747 reads
SQL Saturday #34/New England Data Camp v2.0
It’s official sports fans. Well, it’s been official since last week since Adam Machanic set up the web site. The...
2009-11-30
1,381 reads
SQL Saturday Dallas – Registration and Call for Speakers is Open!
I’m happy to announce that SQL Saturday Dallas is officially scheduled, and the registration and call for speakers is open. ...
2009-11-30
1,559 reads
SQL Server 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,549 reads
Teaching SQL Server 2008 Class at University of Denver – University College
I will be teaching ICT 4461 SQL Server with Lab starting Tuesday, January 5, 2010. This will be an on-campus...
2009-11-30
1,569 reads
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,505 reads
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,467 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,993 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers