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


Announcing SQL Server 2012 Service Pack 4
Microsoft have announced the last service pack for SQL Server 2012. read more...

Now Available: Guide for enhancing privacy and addressing GDPR requirements with the Microsoft SQL platform
The GDPR takes effect on May 25, 2018 and sets a new global bar for privacy rights, security, and compliance. It mandates many requirements and obligations on organizations across the globe. Complying with this regulation will necessitate significant investments in data handling and data protection for a very large number of organizations. read more...

SSRS Subscription Schedules – Enhanced
SSRS provides the capability to review the scheduled reports (subscriptions) in a highly-detailed fashion. This article will dive into the source of this scheduling information within the ReportServer database. read more...

How to compute index numbers at top speed
This article presents different techniques to compute a rownumber column in DAX-based on a specific ranking, comparing slow and optimized approaches. read more...

When a Nonclustered Index and Statistics Make a Query Slower
Nonclustered indexes are awesome in SQL Server: they can get you huge performance gains. But we can’t always create the perfect index for every query. And sometimes when SQL Server finds an index that isn’t quite perfect and decides to use it, it might make your query slower instead of faster. read more...

Chief Data Officer Playbook: How to Be Successful in This Ground-Breaking Role
Companies looking to grow and extract value from their data are increasingly turning to Chief Data Officers (CDOs) to execute their data strategy. The role is new, and a playbook is necessary to address the many challenges CDOs face. read more...

Flaming Hair And The Apocalypse
There will be times when you're approached by someone in a frenzy, their hair seemingly on fire. They'll go on to insist the world will come to an end if you don't handle some task for them immediately. read more...

Announcing HASSP
Oh, you put your database in the cloud? We're putting one through them. read more...

Experienced DBA: Rookie Mistake
The other day I had to update some records, in Production. I’m a firm believer of using explicit transactions and double checking things before committing a transaction. However, this means that I have to COMMIT said explicit transaction. And not go to lunch without doing so. Can you see my mistake? I bet you can. read more...

Disabling the identity cache in SQL Server 2017
In SQL Server 2017, we can disable the cache that SQL keeps on identity values by using the ALTER DATABASE SCOPED CONFIGURATION command. This prevents any gaps in the IDs, if there is an unexpected restart or a failover to a secondary database. read more...

SSRS Subscription Schedules
Jason Brimhall uncovers one of the sources of report scheduling information, within the ReportServer database. read more...

Tracking Lookup Operations in SQL Server
How can I find out on which Clustered Index the most Lookup Operations have been performed? read more...

Scalar Functions In Views: Where’s The Overhead?
Erik Darling explores the side effects of relying on an old view that has scalar valued functions in it. read more...

Technoloy Gender Gap by State
Despite overwhelming evidence showing the harm done to the companies themselves by gender discrimination, corporations around the world persist in overlooking qualified candidates based on gender. read more...

Dynamic Power BI reports using Parameters [video]
Patrick LeBlanc shows you how you can use a parameter, within a Power BI report, to dynamically change the data in a report. read more...

Reusing Datasets Imported to the Power BI Service
I'm a big fan of reusing Power BI datasets whenever possible to minimize redundant datasets floating around the organization. It's less maintenance, less chance of calculation differences, and less data refreshes to schedule. read more...

WannaCry Over Spilled Data
Is the WannaCry incident a wakeup call for the industry? William Brewer discusses the recent ransomware attack on the NHS read more...

SQL Server User-Defined Functions
User-Defined Functions (UDFs) are an essential part of the database developers' armoury. They are extraordinarily versatile, but just because you can even use scalar UDFs in WHERE clauses, computed columns and check constraints doesn't mean that you should. Multi-statement UDFs come at a cost and it is good to understand all the restrictions and potential drawbacks. Phil Factor gives an overview of User-defined functions: their virtues, vices and their syntax. read more...

We’re making SQL Server audits easier – can you help us?
Redgate's Foundry team are starting work on a solution to reduce the pain and time-cost of providing audit evidence for SQL Server user access. If you have an audit coming up in the next quarter, they'd love to hear from you. This blog post lays out what they learnt from their research, and how you might be able to help. read more...

Getting What You Need From Azure Storage Disks
If you need persistent data disks for Azure IaaS VMs that are supported on both Windows and Linux then you will be interested in Azure Storage Disks. These can increase the storage capacity of your VMs by up to a terabyte per disk, and they not only allow several availability options, but also offer a range of performance in terms of I/O throughput and latency. With right configuration, you can create as much of the right sort of storage as you need. read more...