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


Azure Machine Learning Algorithm Flowchart
When you are working with Machine Learning there are many things you need to keep an eye on. You need to prepare the data, deal with any missing values and you need to select an algorithm you will be using for you model. Choosing an algorithm can be a difficult one though. Azure Machine Learning alone has around 25 different algorithms, each one with its own pros and cons. To help out beginning Advanced Analytics and Azure Machine Learning users Dataheroes designed a flowchart to help you select an algorithm quick and easily! read more...

Monospaced Programming Fonts with Ligatures
Typographic ligatures are when multiple characters appear to combine into a single character. In this post Scott Hanselman looks at what's available for ligatures in programming fonts. read more...

SUM() vs SUMX()
Matt Allington takes a fresh look at the topic of when to use SUM(), and when to use SUMX(). read more...

Compressing files from the SSIS Script Task
Mark Broadbent shows how to compress files within Integration Services using a script task. read more...

Regexp with PowerShell, more than a match
In this article Klaas Vandenberghe shows where regular expressions can appear in PowerShell. You probably know you can use a regexp in -match, but there are some other interesting uses. read more...

Downgrading SQL Server Editions
At some point in your career working with SQL Server, you will run into a situation where the wrong edition of SQL Server has been installed on a server and will need to change the edition for licensing reasons. read more...

Representing a simple hierarchical list in SQL Server with JSON, YAML, XML and HTML
How difficult can it be to produce a simple hierarchical list in JSON, YAML, XML and HTML from a SQL Server table that represents a simple hierarchy within an organisation. Well once you know, it is easy and William Brewer is on a mission to tell you how. read more...

Do people write insane code with multiple overlapping side effects with a straight face?
Who writes code like that with a straight face? It's one thing to write it because you're trying to win the IOCCC or you're writing a puzzle, but in both cases, you know that you're doing something bizarre. Are there people who write a -= a *= a and p[x++] = ++x; and think, "Gosh, I'm writing really good code?" read more...

SQL Server Agent and Daylight Savings time
Matthew Mcgiffen looks at how daylight savings time affects SQL Server Agent jobs. read more...

SQLskills SQL101: Creating SQL Server Databases
Whether it is done with the SQL Server Management Studio (SSMS) GUI, or with a T-SQL CREATE DATABASE command, many people and organizations are creating new SQL Server databases without really thinking about what they are doing, and without taking advantage of a number of beneficial options and properties. read more...

PowerShell for Assigning and Querying Tags in Azure
Melissa Coates explains why tags in Azure are useful pieces of metadata for annotation, and shows how to assign and query them using PowerShell. read more...

Microsoft Delivers First SQL Server 2017 Release Candidate
SQL Server 2017 took a major step closer to its official release date this week. After a steady trickle of community technology previews, on July 17 Microsoft announced the general availability of the AI-enabled database software's first release candidate (RC1). read more...

Segway Hoverboard Hacking Demonstrates IoT Security Risks
Riding a hoverboard requires a certain amount of balance, but no amount of physical dexterity will help a rider whose hoverboard has been taken over by hackers. read more...

Adopting AI in the Enterprise: Ford Motor Company
Driverless cars aren’t the only application for deep learning on the road: neural networks have begun to make their way into every corner of the automotive industry, from supply-chain management to engine controllers. read more...

Announcing the Cognitive Services White Glove Program for All Azure Government Customers
Microsoft Program Manager, Julie Glixon, explains what the Azure Cognitive Services White Glove Program program is, and how you can get involved. read more...

The Fundamentals Of Processing A SQL Server Workload In A Scale-able Manner
In this blog post Chris Adkin distills down the most fundamental points to consider when attempting to process a SQL Server workload in a scale-able manner. However, many of the principles outlined can be applied to any kind of data processing platform. read more...

Office Hours 2017/07/05
This week, Brent and Tara discuss separating data and logs on separate drives, statistics time, scalar UDFs, licensing, encryption, gathering SQL error logs and agent job history, replication, upcoming training courses from Brent Ozar Unlimited, and what DBA topics they struggle with the most. read more...

What I Love About the Stack Overflow Database
Brent Ozar writes a love letter to his favorite replacement for AdventureWorks. read more...

SQL 2016 SP1 Shows You Wait Stats in Execution Plans - or does it?
SQL 2016 SP1 Shows You Wait Stats in Execution Plans. Or Does It? Brent Ozar demos why you shouldn't trust this new feature just yet. read more...

Extending DevOps practices to SQL Server databases – Branching & Merging with VSTS
Join Microsoft Data Platform MVP Steve Jones for the next Database DevOps demo webinar. He’ll be plugging Redgate’s tools into Visual Studio Team Services and showing how you can branch and merge your database changes. read more...