Hot Fixes
I wrote about Hot Fixes being inclusive of previous hot fixes. Someone questioned this and so I went back to...
2007-04-03
1,416 reads
Blog Posts
Post Timeouts
Well one problem was solved. Or at least identified.
We've had an issue for a few years where you'd hit the...
2007-03-31
1,415 reads
Late Projects
I was talking with Andy Warren, my partner and fellow partner here, today about the Code Camp in Orlando last...
2007-03-27
1,437 reads
Ambition
I was always someone that was ambitious as a kid. For whatever reason, I've been driven most of my life...
2007-03-22
1,442 reads
Updated Website
I've taken some time to update my website. In particular I have updated:
ArticlesReading ListChess Reading List
Nothing fancy or special, but...
2007-03-20
1,343 reads
Whitepaper on ESX Server 3.0 and SAN-attached Storage
First saw this at Blade Watch. VMWare has released a white paper on using SANs with VMWare ESX Server 3.0....
2007-03-20
1,491 reads
SQL Server 2005 Security Best Practices Whitepaper Released
Saw this first here: SQL Server 2005 Security Best Practices. It's on the blog for Microsoft UK's SQL Server Premier...
2007-03-19
1,872 reads
Windows PowerShell and Windows Server 2003 SP2
Saw this on the Windows PowerShell blog:
Since W2K3 SP2 is an update to W2K3 SP1, if you install Powershell on...
2007-03-19
2,554 reads
"Wet" Pet Food Recall
Animals are near and dear to my heart, to the point where I have a cat even though I am...
2007-03-17
1,345 reads
The Great Migration
We migrated to a new set of servers tonight. Actually am for the Red Gate folks and a late, 11pm-2am...
2007-03-17
1,461 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
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...
BCA Multifinance Surabaya Timur Tlpn.Wa 083834802131
Ruko Soho Emas, Jl. Klampis Jaya No.39, Klampis Ngasem, Sukolilo, Surabaya, Jawa Timur 60117
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