Journalism Ethics
I try to be pretty careful about what I write about, and now being an MVP and actually getting information...
2008-01-27
1,432 reads
Blog Posts
Inexpensive Video Training from Internals Expert, Kalen Delaney
I saw this in my blog reader today:
You can pre-order the Kalen Delaney SQL Server Internals Course - Lesson 1 DVD...
2008-01-25
1,073 reads
New Technique to Steal From Baggage
I first saw this on funsec security discussion list:
Dwarves zipped in
suitcases steal from Swedes
The gist of the story...
2008-01-25
787 reads
Post on Troubleshooting Memory Issues
Here's a post from the Windows Server Performance Team:
An Overview of Troubleshooting Memory Issues
The post discusses the following issues:
Physical...
2008-01-25
1,186 reads
SQL Server 2008 RTM looks to be 3rd Quarter
On the Microsoft Data Platform Insider blog, there is a post indicating new roadmap dates:
Microsoft SQL Server 2008 Roadmap...
2008-01-25
1,642 reads
System Sessions/Spids Rather than Spid < 50
Saw System Sessions posted on the PSS blog and it shows an example of information being written to the error...
2008-01-23
607 reads
Finding missing rows
One way to find the rows from one table that don't match another table is to use a sub-query. Here is...
2008-01-22
536 reads
A Holiday Posting
It's Martin Luther King, Jr. day here in the US where we remember the famous civil rights leader. So my...
2008-01-21
676 reads
Free Subscriptions to Visual Studio Magazine
First time I've noticed this being offered, saw it posted on the Orlando .Net Users Group (ONETUG) site. Sign up...
2008-01-21
1,444 reads
We Are Microsoft Charity Challenge Weekend
This weekend, I had the unique opportunity to donate some time to a worthwhile charity organization. Through the efforts of...
2008-01-21
842 reads
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Forums
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers