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


Updating Azure SQL Managed Instance properties using ARM templates
Azure SQL Managed Instance is fully managed SQL Server Database Engine hosted in Azure cloud. Azure SQL Managed Instance allows you to easily change instance settings such as changing number of cores assigned to the instance, adding more storage, etc. read more...

Azure SQL Managed Instances – Pros and Cons
Here are few notes I took at SQLSaturday Atlanta about Azure SQL Managed Instances   Today there are two managed db options in Azure: Azure SQL and Azure Managed SQL Instance Azure SQL database Pros: – Simple, easy – most things are managed like backups, ... read more...

Azure Stack on-premises (and how it’ll blow your mind)
Azure Stack Summary Today I watched Ultan Kinahan (from Microsoft Global Black Belt Consulting team) presentation on Azure Stack. Short summary – it blew my mind. It reminded how powerful Microsoft really is. And how advanced things are. And that really ... read more...

Surface Book 2: Six Months Later
When the Surface Book 2 was announced late last year, I had high hopes that this was going to be among my favorite laptops, ever. All Microsoft had to do was take the original Book and address the few issues with the hardware and voila, a hero device ... read more...

Intel Set to Patch Two New Meltdown, Spectre Vulnerabilities
Two new variants of the Meltdown and Spectre CPU vulnerabilities have been disclosed by Google and Microsoft. read more...

Journey to GDPR compliance
May 25 is an important day for data protection in the EU and elsewhere. Alison Howard explains how Microsoft has prepared for May 25 and beyond.Continue reading Journey to GDPR compliance. read more...

SQL SERVER – Setup / Installation Error – Updating Permission Setting for File ResumeKeyFilter.Store Failed
My client contacted me for a quick assistance in a setup trouble. She informed me that it’s a brand-new install and its failing at the end. She was installing SQL Server 2016 on Windows Server 2016. Let us learn about how to fix Installation Error. Below ... read more...

Trivial Plans, Simple Parameterization and Check Constraints
Trivial Plans Are Weird They’re the optimizer’s “Yes, Dear”.  The thing is, sometimes “Yes, Dear” can miss some important details. Cost based decisions about operators Potential index improvements Contradiction detection for check constraints Simple ... read more...

How to Reduce the CPU Overhead of Dynamic SQL
Dynamic SQL is a good choice for catch-all type queries, but you have to be careful how you execute the dynamic string. For frequently executed queries, “EXEC sp_executesql @sql”is a good choice but at the risk of encountering parameter sniffing issues. For ... read more...

The 2018 State of DevOps Survey. Don’t just wait for it. Be a part of it.
The annual State of DevOps Survey from DevOps Research and Assessment (DORA) has become a valued part of the IT information landscape. Each year, it identifies the issues that matter the most to IT professionals, and unlocks new findings to help improve ... read more...

Comcast bug made it shockingly easy to steal customers’ Wi-Fi passwords
Enlarge (credit: Comcast) A security hole in a Comcast service-activation website allowed anyone to obtain a customer's Wi-Fi network name and password by entering the customer's account number and a partial street address, ZDNet reported yesterday. The ... read more...

Dell XPS 15 2-in-1 review: Meet the child of Intel and AMD’s unholy union
Samuel Axon This new Dell XPS 15 2-in-1 is the first convertible in the XPS 15 line, but that’s not the most interesting thing about it. Since 2010, Dell’s XPS 15 has been a reliable, 15-inch performance workhorse and a light gaming option for users ... read more...

In absence of fog, the images from a SpaceX launch Tuesday are stunning
SpaceX Most of us associate Southern California with Hollywood, beaches, and sunny weather. However, with relatively cold waters offshore and typically higher pressures over the Pacific Ocean, there is essentially a competition between air rising from ... read more...

Import a Power BI Custom Visual
All you need to import a Custom Visual from the Power BI App Store is a Microsoft account and one Power BI report. You can import the custom visual into Power BI on the web by visiting  https://powerbi.microsoft.com/en-us/ and clicking “Sign In” Note: ... read more...

YOLO on Azure Deep Learning Virtual Machine (DLVM – Linux)
In a previous post I covered setting up YOLO on an Azure DLVM.  In this I'll cover setting up YOLO on a Linux DSVM/DLVM using Docker. First spin up a new Deep Learning Virtual Machine on Linux - this is already setup with Nvidia GPU CUDA drivers and ... read more...

Microsoft: Our chatbots can converse like humans, too
Microsoft is touting the 'full duplex' conversational capabilities of its Chinese chatbot, Xiaoice, while promising similar functionality will come soon to its Zo.ai bot. read more...

Time-dependent ROC for Survival Prediction Models in R
Use of receiver operator curves (ROC) for binary outcome logistic regression is well known. However, the outcome of interest in epidemiological studies are often time-to-event outcomes. Using time-dependent ROC that changes over time may give a fuller ... read more...

Zomato Web Scraping with BeautifulSoup in Python
The Data Science projects start with the collection of data. The data can be collected from the database, internet/online and offline mode. These days most of the information is available online and in order to extract that information Data Engineers/Data ... read more...

Time intelligence issues in DAX for fiscal years starting in March
If you have a fiscal year starting in March, you can have a problem using the time intelligence functions in DAX. For example, by using February 28, the fiscal year starts on February 29th in leap years. DATESYTD ( 'Date'[Date], "02-28" ) By using ... read more...

More Details On Creating Tables In Power BI/Power Query M Code Using #table()
About two years ago I wrote a blog post describing how the #table M function can be used to generate tables, but in that post I only covered the functionality I used regularly – namely using #table with a list of column names or a table type in the first ... read more...