MERS
The foreclosure issues that are occurring in the US might be due to database issues at one company. Steve Jones notes that when your database is the legal system of record, it has to be accurate.
The 2010 SQLServerCentral Opening Night Party
SQLServerCentral is hosting an opening night party at the 2010 PASS Summit. Read more about this and learn how to get a ticket.
Working with null values in SQL XML
We all know NULL values must be dealt with carefully in T-SQL, but how exactly do you best deal with them in SQL XML?
Top 10 Mistakes When Building and Maintaining a Database
Building and maintain a SQL Server database environment takes a lot of work. There are many things to consider when you are designing, supporting and troubleshooting your environment. This article identifies a top ten list of mistakes, or things that sometimes are overlooked when supporting a database environment.
Do You Really Need Surrogate Keys? Part 1 – Concepts and Methods
This is the first of a series of articles to analyze the use of surrogate keys in different scenarios.
End of October Free Training from PASS Virtual Chapters
This wraps up the last of the free training the PASS Virtual Chapters are providing in October.
Remote Security
As more and more people look to work away from inside traditional networks, security becomes an issue. As a data professional, Steve Jones reminds you to be sure that your data is protected.
SQL Slammer
It's been seven years since SQL Slammer, the worst SQL Server security worm struck. Steve Jones remembers that time.
SQLServerCentral Webinar Series #3: Optimize your SQL Server storage with SQL Storage Compress
Another webinar from SQLServerCentral that examines how you can compress your data on any edition of SQL Server.
Introducing ADO.NET Entity Framework
The challenge of bringing data from efficient storage engines such as SQL Server into object-oriented programming models is hardly a new one. Most developers address this challenge by writing complex data access code to move data between their applications and the database. This requires an understanding of the database so that you can access data either from the raw tables, from views, or from stored procedures.
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
BCA KCP Yos Sudarso WhatsApp 0838-8331-786
WhatsApp 08388331786.Jl. Kebon Bawang VII No.40 2, RT.2/RW.6, Kb. Bawang, Kec. Tj. Priok, Jkt...
Alamat kantor resmi BCA KCU MANADO Telp:0817866887
WhatsApp:0817866887 Jl. Sam Ratulangi No.17-19, Wenang Utara, Kec. Wenang, Kota Manado, Sulawesi Utara 95111
Alamat kantor resmi BCA KCP Negara Telp:0817866887
WhatsApp:0817866887 Jl. Ngurah Rai No.83, Pendem, Kec. Jembrana, Kabupaten Jembrana, Bali 82211
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