Is it time to move from SQL Azure to Amazon RDS SQL Server?
Amazon RDS SQL Server is the new kid on the block. Is it better than SQL Azure?
2012-07-11
10,437 reads
Articles
SQL Server Report Server 2008 R2 Execution Log Reports
As you design and deploy more and more reports to your Report Server, how do you review which reports are being run, how often, and how long the reports take to render?
2012-07-11
4,110 reads
SQL Server Central Webinar Series #20: Using SQL Storage Compress in the Real World
Join us on July 10 at 4:00pm GMT/11:00am EDT for an in-depth look at SQL Storage Compress and learn how you can shrink the storage needs for your databases.
2012-07-10 (first published: 2012-06-26)
1,961 reads
Troubleshooting SQL Server with PowerShell - Virtual Chapter Meeting
Come join Laerte Junior on Wednesday ,July 18th 12 noon EDT (GMT -4), for a virtual meeting on Powershell and
2012-07-10
840 reads
Views and Dependencies
Be sure to understand the consequences of modifying underlying tables and the affects they can have on Views
2012-07-10
5,359 reads
Handling Constraint Violations and Errors in SQL Server
The database developer can, of course, throw all errors back to the application developer to deal with, but this is neither kind nor necessary. How errors are dealt with is dependent on the application, but the process itself isn't entirely obvious.
2012-07-10
3,666 reads
Turbocharge Your Database Maintenance With Service Broker: Part 1
Are your maintenance windows too wide? Find out how to shrink them with Service Broker.
2012-07-09
8,870 reads
Software Developer Survey
We'd like to grow our understanding of the software you create and how you get it to your users. This survey should only take a few minutes and we really appreciate your input!
2012-07-09
2,000 reads
SQL Server 2012 Integration Services- Using Environments in Package Execution
SQL Server 2012 Integration Services offers several different options for deploying and storing SSIS packages along with their associated projects, two of which are directly related to two deployment models available in SQL Server Data Tools console. Marcin Policht presents one of these methods, which deals with packages deployed using Project Deployment Model and leverages newly introduced Environments.
2012-07-09
2,715 reads
Introduction to Indexes: Part 2 – The clustered index
In the second part of her series on indexing, MVP Gail Shaw examines clustered indexes. Learn what this index is, how it differs from a heap, and how it can help your queries.
2012-07-06 (first published: 2009-11-11)
63,363 reads
Blogs
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Forums
BCA KCU MUARA KARANG Hub.0851•8812•0691
BCA KCU MUARA KARANG Hub.0851•8812•0691 Jl. Muara Karang Timur, Blok B VIII No.116-117, Daerah...
BCA KCP Kramat Jaya Baru Hub.0851•8812•0691
BCA KCP Kramat Jaya Baru Hub.0851•8812•0691 Jl. Percetakan Negara II No.16 B-C, RT.3/RW.3, Johar...
BCA KCP Mutiara Taman Palem Hub.0851•8812•0691
BCA KCP Mutiara Taman Palem Hub.0851•8812•0691 Perum Perumnas, Ruko Mutiara Taman Palem, Jl. Outer...
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