Though the Key/Value pair paradigm is common to almost every computer language, there is no clear agreement yet for the definition of a Key/Value Pair database. However, Key/Value pair databases are valuable for special applications where speed of writing data is more important than searching and general versatility. Buck Woody experiments.
2013-08-16
3,457 reads
This article describes different methods for deploying your SSIS projects to a server.
2013-08-15
10,079 reads
I’ve introduced my manager to SQL Server’s cloud based platform, SQL Azure and Windows Azure Virtual Machine. He wants to test functionality with some of our applications, which would require me to move my on premise databases to the Azure Virtual Machine. What is the easiest way to accomplish this task? See how it is done in this tip.
2013-08-15
2,928 reads
The SQLServerCentral.com survey will end on Wednesday August 21st. Let us know how we're doing and be in with a chance to win a $100 Amazon gift card. Winners will be announced later that week.
2013-08-15
2,625 reads
In this article Greg Larson outlines the exciting new features that come along with SQL Server 2014. He'll also let you know where you can download CTP1, as well as where you can find additional resources related to SQL Server 2014.
2013-08-14
4,381 reads
Specialized tasks like cryptography require external libraries that are not available in SQL Server. Methods for such tasks can be compiled in a .NET language and deployed to SQL Server as a CLR assembly where the assembly's methods can be referenced by SQL Server stored procedures and functions.
2013-08-13
9,113 reads
Join Red Gate for a free seminar on September 20 (the day before SQL Saturday San Diego). SQL Server MVPs, Steve Jones and Grant Fritchey will present informative sessions featuring best practices for SQL Server database administration, in addition to showing Red Gate tools in action.
2013-08-13
1,611 reads
Some SQL problems are intriguing because, just when good methods emerge and are accepted, other alternative solutions are discovered. The fun of exploring problems such as 'Gaps and Islands' is all the greater when we have a thorough test-harness to try out the alternative solutions.
2013-08-13
2,738 reads
This PASS VC Webinar will take place August 14, 1PM EDT. Creatively resolving differences and negotiating mutually beneficial agreements is crucial in all walks of life. It’s especially important and challenging in the IT industry where soft skills are not necessarily prevalent. ??In this session, we’ll introduce the basic concepts and precepts that will aid you in negotiating better agreements with your neighbors, peers and co-workers, and even your boss.
2013-08-12
2,763 reads
K. Brian Kelly is trying to use SQL Server's built-in encryption and sees there are three different options available for an asymmetric key, corresponding to key length. What's the impact of the key length?
2013-08-12
3,228 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...
Jl. Transyogi Cileungsi-Cibubur. 3-4 RT 002/003, Cileungsi, Kec. Cileungsi, Kabupaten Bogor, DKI Jakarta 16820
Jl. Raya Bandung - Garut No.KM 21, RW.5, Mekargalih, Kec. Jatinangor, Kabupaten Bandung, Jawa...
Jl. Raya Laswi No.212 A, Majalaya, Kec. Majalaya, Kabupaten Bandung, Jawa Barat 40382
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