Microsoft SQL Server: Current Identify Column Value in a Table
Learn how to find the current identify column value in your Microsoft SQL Server tables.
Really Important Software
Software often controls hardware, which can make it the critical part of a system. That's something we should be learning from the Boeing 737-Max crashes.
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.
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
Alamat kantor resmi BCA KCU THAMRIN Telp:083178278662
Telp:083178278662Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, Menteng, Kec. Menteng, Kota Jakarta Pusat,...
Alamat kantor resmi BCA KCU PLUIT Telp:083178278662
Telp:083178278662Landmark Pluit, Jl. Pluit Selatan Raya Blok A8, RT.8/RW.10, Pluit, Penjaringan, North Jakarta City,...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
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