Stop Food Waste - OS Open Data & SQL Azure
An attempt to use Ordanance Survey OS Open Data, SQL Server and SharePoint in the construction of a system for supermarkets to supply expiring food to nearby homeless shelters.
2012-06-14
2,836 reads
Articles
SQL Server Prefetch and Query Performance
Prefetching can make a surprising difference to SQL Server query execution times where there is a high incidence of waiting for disk i/o operations, but the benefits come at a cost. Mostly, the Query Optimizer gets it right, but occasionally there are queries that would benefit from tuning.
2012-06-14
4,026 reads
A SSIS Design Pattern for Change Data Capture
The design pattern described in this article can be used to develop very efficient CDC operations in large scale implementations.
2012-06-13
10,941 reads
Developing a SSRS report using a SSAS Data Source
After designing several SSRS reports based on regular relational databases, your boss would now like several new reports to be designed and rolled out to production based on your organization's SSAS OLAP cube. How do you get started with designing a report based on a cube?
2012-06-13
4,754 reads
SQL Saturday #141 - South Florida
A free day of training in Davie, FL this weekend. Come by if you can
2012-06-13
1,861 reads
A first look at SQL Server 2012 Availability Group Wait Statistics
If you are trouble-shooting an AlwaysOn Availability Group topology, a study of the wait statistics will give a pointer to many of the causes of problems. Although several wait types are documented, there is nothing like practical experiment to familiarize yourself with new wait stats, and Joe Sack demonstrates a way of testing the sort of waits generated by an availability group under various circumstances.
2012-06-12
2,331 reads
SQL Server Central Webinar Series #19: Proactive Data Growth Management
Our 19th webinar will feature Brad McGehee talking about storage challenges, costs, and potential solutions for better managing your data. Tuesday, June 12, at 4:00pm GMT.
2012-06-12 (first published: 2012-05-29)
4,980 reads
The Database Recovery Advisor in SQL Server 2012
The Database Recovery Advisor in SQL Server 2012 will aid the ability of DBAs to recover their databases to a point in time in a crisis. Read about this new feature and how it can speed the process of recovery.
2012-06-11
3,560 reads
FileTable in SQL Server 2012
Among the many new features released in SQL Server 2012 is FileTable, which facilitates database storage of file and directory storage.
2012-06-11
4,806 reads
Comparing Table Variables with Temporary Tables
This articles brings a comparison of temporary tables with table variables from SQL Server author, Wayne Sheffield. In includes an in-depth look at the differences between them.
2012-06-08 (first published: 2009-06-10)
61,240 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
BCA KCP CILEUNGSI TLP/WA 083800209966
Jl. Transyogi Cileungsi-Cibubur. 3-4 RT 002/003, Cileungsi, Kec. Cileungsi, Kabupaten Bogor, DKI Jakarta 16820
BCA KCP KAS RANCAEKEK TLP/WA 083800209966
Jl. Raya Bandung - Garut No.KM 21, RW.5, Mekargalih, Kec. Jatinangor, Kabupaten Bandung, Jawa...
BCA KCP MAJALAYA TLP/WA 083800209966
Jl. Raya Laswi No.212 A, Majalaya, Kec. Majalaya, Kabupaten Bandung, Jawa Barat 40382
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