2012-02-22
7,528 reads
Articles
Database Storage Survey – win 3 x $50 Amazon vouchers
We’d like to find out about who handles SQL Server database storage at your organization. Enter our quick survey now for the chance to win one of three $50 Amazon vouchers.
2012-02-22
1,528 reads
SQL Server Reporting Services Image Source Report Options
Companies often need to generate reports and forms from scanned images and various government supplied formats. Proper knowledge of how to incorporate images in a report is a must.
2012-02-22
2,649 reads
Disaster Recovery: How to regain your lost sysadmin access
This article shows you the process which you require to regain your sysadmin access.
2012-02-21
19,766 reads
2012-02-21 (first published: 2010-10-06)
9,434 reads
Unit Testing Myths and Practices
We all understand the value of Unit Testing, but how come so few organisations maintain unit tests for their in-house applications? We can no longer pretend that unit testing is a universal panacea for ensuring less-buggy applications. Instead, we should be prepared to actively justify the use of unit tests, and be more savvy about where in the development cycle the unit test resources should be most effectively used.
2012-02-21
3,133 reads
An Implementation of the FNV1a Hash Algorithm for SQL Server
Three CLR-resident functions for 16-, 32-, and 64-bit FNV1a hashing
2012-02-20
6,002 reads
2012-02-20
59 reads
TSQL Challenge 76 - Identify the sequence of accounting transactions
The challenge is to identify the sequence of accounting transactions.
2012-02-20
1,631 reads
How to Kill a Company in One Step or Save it in Three
The majority of companies that suffer a major data loss subsequently go out of business. Wesley David remembers vividly the day when the organisation he worked for found that they couldn't restore their data, and the subsequent struggles that ensued. Shoulda-woulda-coulda.
2012-02-20
4,949 reads
Blogs
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...
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...
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