Top five tips for SQL Server developers
Check out these handy database development best practices, with tips on dealing with batch updates, stored procedures and more.
Basically Available, Soft State, Eventually Consistent
The use of non-relational databases is a fascinating topic but they will remain special-purpose and are not competing with SQL-based relational databases.
No Google
Recently Google was unavailable for a good part of one day. Steve Jones felt the impact and thinks this could slow the adoption of cloud computing.
Database Mirroring in SQL Server 2008
Learn the basics of the Database mirroring in SQL Server 2008. Mak provides a step-by-step on how to create database mirroring. Subsequent installments will discuss how to add data on the principal server and how data is mirrored to the mirrored server.
No Google
Recently Google was unavailable for a good part of one day. Steve Jones felt the impact and thinks this could slow the adoption of cloud computing.
No Google
Recently Google was unavailable for a good part of one day. Steve Jones felt the impact and thinks this could slow the adoption of cloud computing.
No Google
Recently Google was unavailable for a good part of one day. Steve Jones felt the impact and thinks this could slow the adoption of cloud computing.
Shrinking the Log
It seems that I see more and more posts about people trying to shrink their transaction logs. It's getting to be close to the time when I need a cut-and-paste snippet stored in a file I can pull out for my standard "it is recommended that you...
Transfer Logins Task and Transfer Database Task in SSIS
The Transfer Logins and Transfer Database tasks can be used in combination to easily and efficient migrate databases and users across different SQL Servers.
A Generic Process to Convert XML Data - Part 2
Continuing with his series on loading and transforming XML data, Leo Peysakhovich shows how to create the generic process to perform the convesions.
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 Sumbersari Telp/wa 085169998803
Telp/wa 085169998803 Jl. Sumber Sari No.23 T 12, Babakan, Kec. Babakan Ciparay, Kota Bandung,...
Apakah UOB ada WhatsApp
Kini Anda bisa menerima info penting resmi dari UOB Indonesia melalui WhatsApp bisnis yang...
BCA KCP Mohamad Toha Telp/wa 085169998765
Telp/wa 085169998765 Jl. Moch. Toha No.197, Cigereleng, Kec. Regol, Kota Bandung, Jawa Barat 40253
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