SQL Saturday visits Salt Lake City on September 7 for a free day of SQL Server training and networking. SQL Saturday has partnered with with the Utah Hadoop User Group and Utah Geeks Events to create the Big Mountain Data Conference.
2013-08-22
312 reads
Microsoft Business Intelligence stack provides several tools for analyzing data from different perspectives, in different format and different ways. Power View is a new addition to this arsenal which provides intuitive ad hoc reporting capabilities for business users to provide an interactive data exploration, visualization, and presentation experience. But how does it work and how to get started with it?
2013-08-22
4,296 reads
Jonathan Allen takes a peak at the EAP release of SQL Prompt 6 and some of the cool new things you can do to speed up writing SQL.
2013-08-21
1,637 reads
In this article I will mention a specific issue that I experienced during my last GIS application and database upgrade.
2013-08-20
3,540 reads
The columnstore index in SQL Server 2012 stores columns instead of rows, and is designed to speed up analytical processing and data-warehouse queries. Whilst columnstore indexes certainly do that effectively, they are not a universal panacea since there are a number of limitations on them. When used appropriately, they can reduce disk I/O and use memory more efficiently.
2013-08-20
3,335 reads
A foreign key points to a primary key that must exist in another table, for example, column X in Table 1 must also be present in Table 2. The key protects this link, and only valid data can be inserted in the foreign key column. An untrusted foreign key may threaten a database’s referential and data integrity.
2013-08-20
2,554 reads
Join Red Gate for a free seminar on September 27 (the day before SQL Saturday Denver). Steve Jones, SQL Server MVP and editor-in-chief of SQLServerCentral.com, will present best practices for SQL Server database development, in addition to showing Red Gate tools in action.
2013-08-20
1,406 reads
This article shows how to implement a Slowly Changing Facts Table, how to overcome the problems encountered when using the MERGE statement to process the data and suggest a minimal set of indexes to aid data loading and quering.
2013-08-19
10,195 reads
It’s hard to avoid privacy-based stories at the moment, with growing concern over government snooping and the limits of power. But where I’m based, in the UK, there’s a new, fully-privatised invasion of privacy. One marketing company has created an outdoor wi-fi basestation that grabs your phone’s MAC address as you pass, with the idea […]
2013-08-19
81 reads
How much of an improvement in processing time can a simple SQL Server Analysis Services (SSAS) partitioning structure provide? Can you provide any examples? Does this processing time improvement only apply to the fact tables? Check out this tip to learn more.
2013-08-19
4,512 reads
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Blk. MN, Ruko Sentra Menteng, Bintaro, Sektor 7 No.3, Pd. Jaya, Kec. Pd. Aren,...
Komp. Sukabumi Raya, WHATSAPP 087781685658 Jl. Tipar Gede 10-11, Ruko No.1, Tipar, Kec. Citamiang,...
Jl. Matraman Raya No.14-16, RT.2/RW.1, Kb. Manggis, Kec. Matraman, Kota Jakarta Timur, Daerah Khusus...
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