Database Weekly is the seven-day roundup from SQLServerCentral. We scour the Internet with a fine-toothed set of queries to compile the most informative weekly newsletter about SQL Server. Over 670,000 SQL Server professionals rely on it to kick-start their week.
Sign up to our newsletter now, to keep up to date with all the latest news.
Latest Database Weekly Newsletter Articles
Data breach disclosure 101: How to succeed after you've failed
Organisations rarely plan for how they should handle data breaches and when an incident does happen (and that seems to be a near certainty these days), they're left unprepared; they're in unfamiliar territory, there's enormous stress and pressures on them and frankly, they usually react pretty badly.
SQL Server Replication enhancement in SQL Server 2016
Replication is a widely-adopted feature in SQL Server to copy and distribute data and database objects from one database to another and then synchronizing between databases to maintain consistency. SQL Server 2016 brings a few enhancements that should make it easier to use, and work better with other SQL Server features.
Hackers Threaten to Erase Apple Customer Data
This is a weird story, and I'm skeptical of some of the details. Presumably Apple has decided that it's smarter to spend the money on secure backups and other security measures than to pay the ransom. But we'll see how this unfolds.
SQLskills SQL101: Indexes on Foreign Keys
If I have a table that has 6 foreign key columns/references should I create one index with all 6 foreign key columns in it, or should I create 6 individual indexes – one for each foreign key reference? Kimberly Tripp provides the answer.
SQL Server 2016 Service Pack 1 CU2 Released
Microsoft released SQL Server 2016 Service Pack 1 CU2, which is Build 13.0.4422.0. This CU has 101 fixes in the public fix list, by my count. This is a pretty large CU, and if you look at the fix list in more detail, many of them are for pretty significant issues with AGs, columnstore indexes, and general performance.
SSAS 2016 Locking Improvements
People have long been aware of the server-wide lock taken out by SSAS when processing finishes – and the issues that this can cause. Fortunately, commit operations have been optimized considerably for tabular models in SQL Server 2016, meaning noticeable improvements in locking and blocking.