Social Engineering Dangers
Social engineering is one of the most effective ways to hack information out of a company. Steve Jones looks at this technique and a recent contest at DefCon that featured social engineering.
Ways to minimize sort operations
In this article Brian Ellul explorea how it's possible to eliminate the SORT operator (and its performance cost) on performing SELECTS statements.
Issuing Current Time Increments in StreamInsight (A Practical Example)
The issuing of a Current Time Increment, Cti, in StreamInsight is very definitely one of the most important concepts to learn if you want your Streams to be responsive. A full discussion of how to issue Ctis is beyond the scope of this article but a very good explanation in addition to Books Online can be found in these three articles by a member of the StreamInsight team at Microsoft, Ciprian Gerea.
SQL Saturday #49 - Orlando
A free, one day training event taking place on October 16, 2010 in Orlando, FL.
Inside the Optimizer: Constructing a Plan - Part 3
Join Paul White in part three of a four-part series exploring the internals of query optimization as he looks at the rules that are used to build the execution plan.
More Than SQL
Today Steve Jones talks about the upcoming SQL Saturday #52 in Colorado, and how it's encompassing more than just a day of SQL learning.
SQL Saturday #55 - San Diego
The first SQL Saturday in San Diego kicks off fall with a full day of free SQL Server information, lectures, and seminars from the experts on the West Coast.
SQL Social - Kent, UK
Andrew Calvett talks Analysis Services for the September meeting of the Kent SQL Server user's group.
Synchronizing SQL Server and SQL Azure
SQL Azure Data Sync provides data synchronization between the cloud and local SQL Server databases. Learn how SQL Azure Data Sync allows you to keep the most concurrent information in the cloud while allowing mobile users, businesses, and enterprise data sources all to have access to this data.
Getting Fired from an Unpaid Job.
Phil Factor initially brooded about being fired from a job he was just doing unpaid to help out. Then he suddenly realized that they were probably right.
Blogs
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...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Forums
Kantor BCA KCP Kas Kendal Telp/wa 085169998803
Telp/wa 085169998803 Jl. Raya Soekarno-Hatta No.258, Pekauman, Pakauman, Kec. Kendal, Kabupaten Kendal, Jawa Tengah...
BCA KCP Pondok Gede Hub.0851•8812•0691
BCA KCP Pondok Gede Hub.0851•8812•0691 Jl. Raya Pd. Gede No.43, RT.1/RW.7, Lubang Buaya, Kec....
BCA KCU Bogor Telp/wa 085169998765
Telp/wa 085169998765 Jl. Ir. H. Juanda No.28, RT.03/RW.02, Paledang, Kecamatan Bogor Tengah, Kota Bogor,...
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