Microservices for Databases
The idea of using microservices is gaining traction, but Steve Jones notes that the issues of databases might prevent adoption for many applications.
2018-12-10 (first published: 2015-04-02)
265 reads
Editorial
2015-04-01
319 reads
Source Code Security
The code you use may contain security information. Be extra careful in this case, especially when you use encryption.
2015-03-31
154 reads
One Rule, Umpteen Constraints
Despite being deprecated for many years, Phil Factor explains why RULEs are still hanging on in there in SQL Server 2014.
2015-03-30
108 reads
Software Engineering in Practice
Is there a need for apprenticeships in the data world? Should we consciously seek to view our first year as an apprenticeship? Should companies provide learning paths for new hires?
2018-10-31 (first published: 2015-03-30)
182 reads
SSMS or SSDT
The question this week deals with tools. Steve Jones is looking to see which tools are preferred by most database developers.
2019-06-17 (first published: 2015-03-27)
1,256 reads
Mastery – Repetition, Variations, and Depth
Today we have a guest editorial from Andy Warren. Andy look sat the ways in which we might solve problems and become better over time.
2019-05-31 (first published: 2015-03-25)
293 reads
Microservices, SOA and Service Broker
If you want to implement a service-oriented architecture on Windows, Service Broker is still your best choice, argues Phil Factor.
2015-03-23
461 reads
First Episodes
Today we have a guest editorial from Andy Warren where he looks back at how things have changed.
2015-03-23
123 reads
Common Mistakes
This week Steve Jones is wondering what the common mistakes that T-SQL developers make are.
2018-06-22 (first published: 2015-03-20)
534 reads
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 KCP Batu Ceper Telpon/wa:0813.7887.595
BCA KCP Batu Ceper Telpon/wa:0813.7887.595.Jl. Batu Ceper No.18 A-B, Kb. Klp., Kecamatan Gambir, Kota...
BCA KCP Penjernihan Telpon/wa:0813.7887.595
BCA KCP Penjernihan Telpon/wa:0813.7887.595.Jl. Penjernihan I No.23, Tikungan. Hilir, Kecamatan Tanah Abang, Kota Jakarta...
Kantor BCA KCP Kas Rancaekek Telp/wa 085169998803
Telp/wa 085169998803 Jl. Raya Bandung - Garut No.KM 21, RW.5, Mekargalih, Kec. Jatinangor, Kabupaten...
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