SQL, and Ye Shall Find
Phil Factor reflects on how hard it really is to develop a really effective database that meets the SQL Standards, and how as a result we are only beginning to realize fully the vision of relational orthogonality in databases.
Exploration of SQL Server 2016 Always Encrypted – Part 3
In this third article of the exploring SQL Server 2016 Always Encrypted series, Greg Larsen looks at the differences between an Always Encrypted column that uses an encryption type of Deterministic and those that use encryption type of Randomized.
Centrally collect replication conflicts and send an alert
Automatically capture replication conflicts and generate an automated email notification.
Who's Got a Preteen SQL Server?
This week Steve Jones wonders about the age of your instances and whether you are planning on upgrades or aware of how many out of support instances you might have.
How to read data from multiple Excel worksheets with SQL Server Integration Services
Read this tip to learn how to import data from multiple Excel worksheets into SQL Server using SSIS.
SQL Azure Performance Benchmarking
An evaluation of the SQL Azure Database Performance Levels recommended by the DTU Calculator service, and a comparison with on premise SQL Server performance.
The New Operating System
We have an operating system for how our organizations are run. Steve Jones talks about a new one that might be important for the world rules by software.
Monitoring In-Memory OLTP: What's Important?
In-Memory OLTP has evolved to be a great solution. However, a production system that uses it needs careful monitoring to avoid stress conditions becoming problems. As with many new features of SQL Server, it pays to plan a monitoring strategy to ensure that you are alerted as soon as possible when things go awry.
Queues in Databases
The idea of using a queue in a database is one that some people try to avoid, preferring to use a messaging service. However, Steve Jones notes that this isn't always necessary.
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 Bulevar Hijau Lyn Cs 083835110341
Ruko Sentra Niaga 2, Jl. Harapan Indah Raya No.1A Blok SN-2, Pejuang, Kecamatan Medan...
BCA KCP Summarecon Bekasi Lyn Cs 083835110341
Jl. Bulevar Ahmad Yani, Graha Bulevar Signature (GBS) Blok C No. 3, RT.001/RW.011, Harapan...
BCA KCP Juanda Lyn Cs 083835110341
Jl. Insinyur H. Juanda No.54, RT.003/RW.001, Margahayu, Kec. Bekasi Tim., Kota Bks, Jawa Barat...
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