Writing R Code in SQL Server - Level 3 of the Stairway to Machine Learning Services
In this level, learn about how to get the tools needing for coding in R and how to execute some code that connects to SQL Server.
Enable SQL Server Agent Mail Profile
Learn how to configure SQL Server Agent to allow emails to be sent for job notifications and alerts.
The BI Journey: The Expert’s Advice – Part 2
A BI project should return value to the company quickly, not only after months or even years of work. In this article by Gogula Aryalingam, Ruthie, the intern, determines which items from her manager's requirements she can complete before the big meeting. She continues working on her semantic model by including a Date table, the star schema, measures, formatting, and more.
The Blast Radius of a database
Phil Factor feels that the database gets the short shrift in any outage - it's time to stop saying "the database has gone down" and time to start thinking about the resilience of the entire system.
The Difference Between Rollup and Cube
Learn about the fundamental differences between the ROLLUP and CUBE operators.
Change Not For Replication Value for SQL Server Identity Columns
In this tip we look at how to change the SQL Server setting for a tables identity column to not for replication for existing tables.
Designing Highly Scalable Database Architectures
While architecting cloud native applications, you need to ensure that your system is highly available, performant, scalable, fault tolerant, and has the capability to recover from a disaster scenario. In this article, Samir Behara discusses the options available when designing the database architecture to achieve scalability.
A Self-Serve System that Allows Developers to Refresh Databases (Part 1)
Empower developers to refresh their own test systems with production backups.
Serverless
The idea of serverless computing is interesting, and with Azure Stack, might be something more of us embrace.
Introduction to SQL Server Security — Part 5
SQL Server contains many built-in views and functions that can be used to understand what is going on “under the hood,” and security is no exception. In this article, Robert Sheldon explains the security related catalogue views, dynamic management views, and system functions
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 KCP Kartini Telp:0817866887
Tlp/Wa_Cs:0817-866-887 Komplek Apartemen Grand Kartini, Ruko. 18, Jl. Kartini Raya No.57, Daerah Khusus Ibukota...
Alamat kontak resmi BCA KCP Sultan Agung Telp:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. Sultan Agung No.115, Gajahmungkur, Kec. Gajahmungkur, Kota Semarang, Jawa Tengah 50232
SQL Server Showing Out of Space But Plenty of Drive Space
We have a SQL Server installed. We have a 500GB drive for the database....
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