Fun Data Analysis
This week Steve wants to know if you'd have some issues when analyzing data and you've mistaken correlation for causation.
Using the Konesans File Watcher Task in SSIS to Process Data Files
With the Konesans File Watcher Task for SSIS we can import files as soon as they arrive.
Compare SQL Server Performance of In-Memory vs Disk Tables
With the release of SQL Server 2014 there came a lot of new features, including “In-Memory OLTP”. One would assume that storing a table in memory would most definitely be faster than using the conventional disk-based table storage engine. But just how much faster is it?
Continuous Delivery for Windows?
It seems as though Microsoft might be moving to a Continuous Delivery process for Windows 10. Steve Jones isn't sure that's a good thing, but it is interesting.
Deleting Files in the Cloud
The public perception is that, when something is deleted, it no longer exists. Often that's not really the case; the data you serve up to the cloud can be stored out there indefinitely, no matter how hard to try to delete it. Rob Sheldon investigates, and finds the cloud a worryingly public place.
SQL Saturday #337 - Portland, OR
SQL Saturday is coming to Portland on November 1! Join us for a free day of SQL Server training and networking. Speakers at this event include Red Gate's Grant Fritchey, Kathi Kellenberger, Benjamin Nevarez, and more. There are also 3 paid-for pre-con sessions for this event. Register while space is available.
Data Mining Part 18: Excel and Data Mining
In this new article, we will introduce you to Microsoft Excel and Data Mining.
Data Mining Part 18: Excel and Data Mining
In this new article, we will introduce you to Microsoft Excel and Data Mining.
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
BCA KCU KALIMALANG HUB/CS 08216366654
Jl. Tarum Barat Blk. E No.5, Wil. Kota, Kec. Duren Sawit, Kota Jakarta Timur,...
Kantor BCA KCP Cipto Mangunkusumo Telp/wa 085169998803
Telp/wa 085169998803 Jl. DR. Cipto Mangunkusumo No.4E, Pekiringan, Kec. Kesambi, Kota Cirebon, Jawa Barat...
BCA KCP Kelapa Gading Hibrida Telp/WA.0821°3111°179
By Cakhia TV Bóng Đá Trực Tuyến
Telp/WA.0821°3111°179 Jl. Boulevard Raya No.14 Blok RA-1, RW.15, Klp. Gading Tim., Kec. Klp. Gading,...
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