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


POWER BI CUSTOM VISUALS CLASS (MODULE 43 – GANTT)
How to use the Gantt Power BI Custom Visual to visualize project timelines and deliverable completion. read more...

Hadoop at Strata: Not Exactly ‘Failure,’ But It Is Complicated
Has Hadoop failed to deliver the goods? That was a question on the minds of Strata + Hadoop World attendees last week, with opinions expressed both pro and con. Regardless of your stance on that question, it’s clear that the center of gravity has moved beyond the yellow elephant. read more...

What kind of JOIN syntax is this?
Vladimir Oselsky stumbles across some very puzzling join syntax and tries to figure out its intent. read more...

Drill from a mobile report to a paginated report in SSRS (SSAS)
What if the data in the parameter of the paginated report was populated from a SQL Server Analysis Services (SSAS) model? Does the drill URL change? It absolutely does. Let me show you how. read more...

Backing up SQL Server on Linux using Ola Hallengrens Maintenance Solution
Rob Sewell on how to back up SQL Server databases on Linux using Ola Hallengren’s maintenance solution and the SQL Agent. read more...

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. read more...

Variable scoping in TSQL isn't a thing
It seems that unlike every other language I've worked with, in T-SQL all variables are scoped to the same local scope regardless of where in the script they are defined. read more...

Selecting and Configuring Hardware for SQL Server 2016 Standard Edition
Glenn Berry describes some common issues and pitfalls that you may run into when you install and use SQL Server 2016 Standard Edition on a new server with modern hardware. read more...

SQL Server on Linux: Running jobs with SQL Server Agent
SQL Server Team has announced that in CTP 1.4 you can schedule tasks using SQL Server Agent, when SQL Server is running on Linux. read more...

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. read more...

Hidden Gem TRY_CONVERT to troubleshoot data type conversion
Many of us have experienced a dreaded data type conversion error when doing tasks like importing files, converting to new database schemas, etc. Which record caused the problem? I have used a few tricks in the past for this, but TRY_CONVERT makes it easy. read more...

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. read more...

Plan Caching
Klaus Aschenbrenner investigates Plan Caching and its side-effects in SQL Server. read more...

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. read more...

Performance and Stability Related Fixes in Post-SQL Server 2014 SP2 Builds
If you are running on the SQL Server 2014 SP2 branch, you really should be running the latest SQL Server 2014 SP2 Cumulative Update. read more...

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. read more...

Registration is Open for GroupBy.org’s April Free Conference
GroupBy.org is BrentOzar.com's community training initiative where your votes pick the session lineup. read more...

DBCC CHECKDB And Read Only Databases
Do you need to run DBCC CHECKDB even on a read only database? YES! Here’s why: many forms of corruption come from storage. read more...

Why Developers Should Consider Microsoft SQL Server
Brent Ozar give the good, bad and ugly of choosing SQL Server. read more...

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. read more...