Securing the Things
The Internet of Things is coming, and bringing lots of data, but security needs to be included as well.
Setting up R in SQL 2016 – Avoiding Pitfalls
Setting up R in SQL 2016 proved to be trickier than expected, but here is how to avoid the frustrations.
Questions About SQL Server Collations You Were Too Shy to Ask
Of course we all like our colleagues to think that we know everything there is to know about SQL Server Collations. However, the truth is that it is a rather complicated topic to fully understand and the cost of getting collation wrong can be great. If only one could ask certain questions on forums or at conferences without blushing. Help is at hand, because Robert Sheldon once again makes the complicated seem simple by answering those questions that you were too shy to ask.
Stairway to U-SQL Level 15: U-SQL Global Scalar Functions With C#
In this article, see how to created shared functions using C# assemblies in U-SQL.
Setting Variables in Calling T-SQL Code While Using sp_executesql
In this tip, Greg Larsen shows you how to set variables in your calling T-SQL code when using sp_execute sql.
What is normal? Finding outliers with R
How do you currently set alerting thresholds? What is normal? And more importantly, what is truly abnormal? We will explore these questions.
UNION ALL Optimization
Paul White digs into row goals as he explains some interesting and inconsistent behavior with UNION ALL queries in SQL Server.
Guilty of Over-Customising
Am I guilty of over-customising software? Read this and let us know what you think.
Blogs
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Forums
Alamat kontak resmi BCA KCU BATAM Telp:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. Raja Ali H. No.18, Sei Jodoh, Kec. Batu Ampar, Kota Batam, Kepulauan...
Alamat kontak resmi BCA KCP Buah Batu Telp:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. Buah Batu No.192, Cijagra, Kec. Lengkong, Kota Bandung, Jawa Barat 40226
Alamat kontak resmi BCA KCP Buaran Raya Telp:0817866887
WhatsApp:0817866887 Jl. Buaran Raya Blok A No. 100, RT.6/RW.dan 101, Wil, Kec. Duren Sawit,...
Question of the Day
Creating a JSON Document IV
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 YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers