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


Microsoft Data Science Virtual Machine Tutorials
There are so many interesting data science and AI tutorials, which are open-sourced, and ready for the DSVM These tutorials available at https://github.com/Microsoft/ Here some of my favourite tutorials which are perfect for introducing students to Data ... read more...

Temporal Tables - Part 6 - Start and End Times in UTC Time Zone
In my first 5 blogs on Temporal , I failed to note something pretty important about their usage. The start and end times for the row (and it follows, the historical rows) are likely not in your local time zone. They are stored in UTC time zone. This ... read more...

Geek City: Changing How To Change Your Database Properties — ALTER DATABASE
(This article was originally published at https://www.dbbest.com/blog/ Long ago (in SQL Server years) many metadata changes were implemented with special one-off stored procedures. For example, we had sp_addindex and sp_dropindex , as well as sp_addtype ... read more...

Bluetooth Vulnerabilities
A bunch of Bluetooth vulnerabilities are being reported, some pretty nasty. BlueBorne concerns us because of the medium by which it operates. Unlike the majority of attacks today, which rely on the internet, a BlueBorne attack spreads through the air. read more...

Apple's FaceID
This is a good interview with Apple's SVP of Software Engineering about FaceID. Honestly, I don't know what to think. I am confident that Apple is not collecting a photo database, but not optimistic that it can't be hacked with fake faces. I dislike ... read more...

PowerShell Classes Part 4 — Constructors and Inheritance
Now that you’re familiar with PowerShell classes, as well as its programming concepts and terminology, it is time to show you some other benefits to using PowerShell classes. In this article, I’m going to talk about constructors and how you can use different ... read more...

AI is the new electricity
Andrew Ng shares his thoughts on where the biggest opportunities in AI may lie.Continue reading AI is the new electricity. read more...

Cumulative Update #5 for SQL Server 2016 SP1
The 5th cumulative update release for SQL Server 2016 SP1 is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. To learn more about the release or servicing ... read more...

Cumulative Update #8 for SQL Server 2016 RTM
The 8th cumulative update release for SQL Server 2016 RTM is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. To learn more about the release or servicing ... read more...

SQLpassion Online Training in October 2017
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.) Today I’ve announced my SQLpassion Online Training for ... read more...

SQL SERVER – How to Move SQL Server Cluster to Different Domain?
One of my blog readers sent an email where he wanted my quick opinion about SQL Server cluster. Hi, We are having SQL Server 2014 clustered instance running on top of Windows Server 2012. As a part of the acquisition, we need to move the domain servers. read more...

SQL SERVER – Login Failed – Error: 18456, Severity: 14, State: 38 – Reason: Failed to Open the Explicitly Specified Database
Those who are my regular clients would know that I am very active in replying to emails. My average time of response is around 24 minutes. Many of the emails are for suggestions and I don’t get much time to help everyone, but I do reply to them letting ... read more...

SQL SERVER – FIX: Msg 5123, Level 16 – CREATE FILE Encountered Operating System Error 5
This blog is about another common error reported by many DBA to me. He faced error related to create file in OS. Here is the text of the message. CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create ... read more...

SQLintersection Fall 2017
As we head towards our 10th SQLintersection in October, I’m excited to say that it’s once again our most diverse, complete, and information-packed show yet! One of the pieces of feedback we hear ... read more...

SQLskills SQL101: Azure SQL Database Monitoring
As Kimberly blogged about earlier this year, SQLskills has an ongoing initiative to blog about basic topics, which we’re calling SQL101. We’re all blogging about things that we often see done incorrectly, technologies used the wrong way, or where there ... read more...

SEC Reveals 2016 Hack that Breached Its Filing System
The Securities and Exchange Commission said Wednesday that a cyber breach of a filing system it uses may have provided the basis for some illegal trading in 2016. In a statement posted on the SEC's website, Chairman Jay Clayton said a review of the ... read more...

Report: Hackers Were Snooping Inside Equifax for Months
Hackers broke into Equifax's computer systems in March, two months earlier than the company had previously disclosed, according to a Wall Street Journal report . That gave the intruders months to probe vulnerabilities and eventually gain access to the ... read more...

SQL Server PolyBase supports Hadoop.rpc.protection
This post was authored by Casey Karst; Program Manager II; Data Systems. We are pleased to announce that PolyBase in SQL Server 2016 and later can connect to Hadoop clusters with the hadoop.rpc.protection configuration set to Integrity, Privacy or Authentication. read more...

What Would You Put in SQL Server 2018?
If you were leading Microsoft’s development programs, what would you add or change in SQL Server 2018? Forget licensing or pricing changes – that’s dictated by the marketing teams, and those decisions are made really close to the release date. Instead, ... read more...

So, what is GDPR and why should Database Administrators care?
You’ve no doubt heard at least something about the GDPR, the EU’s new privacy and Data Management law with its greatly increased maximum fines for non-compliance and tighter definitions for acceptable use of personal information. If you’ve continued ... read more...