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


Webinar: How to get started with DevOps
More and more teams are turning to DevOps as way to improve the efficiency and quality of software delivery but it’s not always clear what's the best way to get started. We’ve invited Steve Thair, CTO of the DevOpsGuys, to share some practical tips on how you can start implementing DevOps in your organization. Register for the free webinar. read more...

Universal Architecture
Andrea Angella considers the Universal Architecture idea in light of the question "How can we prevent code becoming an intricate mess over time?" read more...

Upgrading to SQL Server 2016: New Data Privacy and Security Features
Chances are, it is less expensive to upgrade to SQL Server 2016 than to suffer a data breach. read more...

Easy way to get statistics histogram programmatically
Demonstrating use of the new Dynamic Management Function (DMF) sys.dm_db_stats_histogram, in the latest release of SQL Server 2016 SP1 CU2. read more...

Is a Cost Threshold For Parallelism of 5 right…for me?
Tim Peters' Cost Threshold For Parallelism is set to 5. he hopes never to have to defend his settings in a dark alley with Erik Darling. read more...

Schedulers To Rule Them All
One of our production servers has 4×8 (4 sockets, 8 core) processors with hyper threading enabled. This results in 32 physical cores or 64 logical cores. Therefore, this particular server should have 4 NUMA nodes available. And yet, I was seeing 3 buffers aligned with 3 NUMA nodes. Where was the fourth buffer? Did it just not show up for work? read more...

Prediction: SQL server DBA role
Long gone are the days where a DBA stays busy backing up databases and creating indexes. Today DBAs need to think about Automation, Powershell, Cloud technologies, SQL Server on Linux. read more...

Basics of Probability
A refresher on some of the basic principles of probability that one needs while dealing with more advanced programming in R and data analysis. read more...


Comparing performance of data access libraries using StackExchange/Dapper benchmark
What data access library should you use to access your data in SQL Server database? Jovan Popovic shows how to use the StackExchange Dapper benchmark to compare the performance of Dapper ORM and Entity Framework at returning a single row from a database. read more...

Power BI Custom Visuals (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...