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


DLM Automation Suite add-ons
Many software teams are already integrating their application code but haven’t yet brought the continuous integration discipline to their database development. The DLM Automation Suite helps you extend that process by plugging into third party tools commonly used for application development. It’s now even easier to find the add-on you need for your build or release system. read more...

DBmaestro Unveils TeamWork Version 5.0
New version includes a first of its kind Pipeline Builder, for a significantly easier automated database deployment pipeline, enabling users to visually describe the database environment and the deployment flow. read more...

Introducing SQL Server
This book aims to get the newcomer started in SQL Server development, how does it fare? read more...

Sparse Columns in SQL Server : Impact on Time & Space
SQL Server 2008 introduced sparse columns as a method to reduce storage for null values and provide more extensible schemas. The trade-off is that there is additional overhead when you store and retrieve non-NULL values. I was interested in understanding the cost for storing non-NULL values, after talking to a customer who was using this data type in a staging environment. read more...

Using Custom File Delimiters in SSIS
Tim Mitchell demos how to use custom file delimiters in SSIS flat file connections, which can be used to read or write files with a nonstandard field delimiter. read more...

Why Learn PowerShell?
Microsoft has bet big time on PowerShell for a number of years and has made it very plain that if you intend to have a career managing Windows-based platforms and infrastructure you really need to know PowerShell. read more...

PowerShell Pester Testing for Parameter Validation
Rob Sewell on using Pester to run unit tests within PowerShell. read more...

Running code on the startup of SQL Server
Every now and again you need to run code when your instance starts up. For example you might want to check if the SQL Agent is running. read more...

Nested grouping using GROUPBY vs SUMMARIZE
DAX introduced a GROUPBY function that should replace SUMMARIZE in some scenarios. This article describes how to use GROUPBY in nested grouping scenarios and other improvements. read more...

Thank you Waitrose, now fix your insecure site
Troy Hunt investigates concern about the security of the Waitrose login form. read more...

Announcing SQL Server Management Studio – January 2016 Release
The latest preview of SSMS includes all updates included in last year’s December release, and features numerous bug fixes in Always Encrypted dialogs, Extended Events sessions, and many more. read more...

SQL Server Diagnostic Information Queries Detailed–Recap
Throughout January Glenn Berry described each of the 70 queries in the January 2016 version of his SQL Server 2016 Diagnostic Information Queries, with documentation of the various views and functions behind each query. Here's a recap of all of them. read more...

Introducing: SQL Server 2016 Community Technology Preview 3.3
The SQL Server 2016 Community Technology Preview (CTP) 3.3 is now available for download! In SQL Server 2016 CTP 3.3, part of our new rapid preview model, we made enhancements to several features which you can try in your development and test environments. read more...

New Ways To Concatenate Text In Excel 2016 With CONCAT() And TEXTJOIN()
Anyone who has ever done any serious work in Excel has found how difficult it is to concatenate more than two text values. Well, not any more – Microsoft have finally got around to addressing this problem with two new Excel functions, TEXTJOIN() and CONCAT(). read more...

Analysing Power BI DMV Queries In Power BI Desktop
Running DMV queries against a Power BI Desktop model and more importantly doing something useful with the information they return, isn’t straightforward. read more...

Data as Defense Against Disruption
Recent disruptions have not all been based first on price, but rather data. For instance, Uber actually started in the high-end luxury car business that was highly fragmented. It was their data-driven platform that allowed them to get into cheaper car markets and disrupt the taxi industry. read more...

Docker's Unikernel acquisition: The Microsoft angle
It's no secret that Docker and Microsoft have been working increasingly closer over the past couple of years. And unikernel operating systems are important in the Internet of Things (IoT) space, which is a market of keen interest to Microsoft. read more...

Getting started with R scripts and R visuals in Power BI Desktop
The Power BI team announced its support to create R visuals in its recent update and in this tip we'll help you get started by walking through what R is, how you can configure Power BI Desktop to run R scripts and create R visuals in Power BI desktop. read more...

Entity Framework Pitfalls: Cascade Deletes
The problem with cascade deletes configuration in EF is, sometimes it cannot be done with attributes, which is a mapping mechanism that most people like and use, and the different associations need different approaches. read more...

Microsoft Survey on Backup and Security
Microsoft is looking for some people to talk to for ~20 minutes, via phone/Skype, about Backups or data security. read more...