SQL 2016: Columnstore row group Merge policy and index maintenance improvements
Denzil Ribeiro looks at how SQL Server 2016's new Merge functionality in INDEX REORGANIZE simplifies Columnstore index maintenance significantly.
NoSQL inside SQL Server
This week Steve Jones looks at the idea of combining some NoSQL concepts inside of SQL Server.
What Kind of DBA Are You?
Are you a do-it-all DBA, or do you specialize in one aspect of database work?
Building Databases: One Man’s Best Practice?
One man’s meat is often another man’s poison. In this editorial Tony Davis looks at why a migrations-based approach to database version control might not always be best practice.
Adjusting Model
This Friday Steve Jones looks at the topic of defaults and whether you use the model database to adjust yours.
Hidden Tricks To SQL Server Table Cleanup
How to delete millions of rows with virtually no contention.
An Introduction to the OpenPOWER Foundation
In a bid to challenge Intel's dominance of high performance computing environments, IBM have introduced OpenPOWER, a flexible open-source framework based on their POWER processor architecture. Robert Sheldon looks at the potential of this new platform.
The Case for Upgrading
When is it worth upgrading your SQL Server? It's a question Steve Jones explores today.
Understand the Limitations of SQL Server Dynamic Data Masking
Dynamic data masking provides a simple way to implement obfuscation of private data. However it's important to understand the limitations, and to keep in mind that it is not true encryption and that the data cannot be protected in all scenarios. Aaron Bertrand explains.
Blogs
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
T-SQL Tuesday #199: Back to the on-prem
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
Forums
BCA KCU PANAKKUKANG Telp/WA:0817844112
phone/Wa, Cs. 0817844112 Jl. Boulevard No.5 Blok F5, Masale, Kec. Panakkukang, Kota Makassar, Sulawesi...
BCA KCU MAKASSAR Telp/WA:0817844112
phone/Wa, Cs. 0817844112 Jl. Ahmad Yani No.31, Pattunuang, Kec. Wajo, Kota Makassar, Sulawesi Selatan...
BCA KCU AMBON Telp/WA:0817844112
phone/Wa, Cs. 0817844112 Jl. Sultan Hairun No.24, Kel Honipopu, Kec. Sirimau, Kota Ambon, Maluku...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers