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


Short-term vs long-term perspective in software development
In this post, Vladimir Khorikov talks about one of the most damaging attitudes a company or a person can have in the field of software development: short-sighted perspective. read more...

What GDPR means to Office 365
From May 25, 2018, companies with business operations inside the European Union must follow the General Data Protection Regulations (GDPR) to safeguard how they process personal data. read more...

WannaCry Hero Pleads Not Guilty to Banking Malware Charges
A British cybersecurity researcher credited with helping curb a recent worldwide ransomware attack pleaded not guilty Monday to federal charges accusing him of creating malicious software to steal banking information three years ago. read more...

Always Encrypted with Azure Key Vault
Bradley Schacht explores using SQL Server’s Always Encrypted functionality with Azure Key Vault. read more...

A TSQL Developer Contemplates R
Dave Mason talks about his experience with learning more about R language, data science, and big data. read more...

Using Time Zones in SQL Server
The usage of time zones in applications becomes inevitable, especially with the globalization of the applications. The programming on database level also requires usage of the time zones. In this post there are some examples that will demonstrate usage of time zones. read more...

Managing Azure Resources with Cloud Shell
Russell Smith looks at the different ways Azure can be managed from the command line, including Cloud Shell, which is currently in preview. read more...

Bad parameter sniffing decision flow chart
PASS President Grant Fritchey is asking for input on a new flowchart he's creating. See what his first draft looks like and give your feedback. read more...

Increased Database Security: Another Reason to Adopt DevOps
Don't bury the lead! Databases are critical. If you bring down a database server you might stop a company in its tracks. It is much easier to recover if an application server crashes than if a database server crashes. This is something which people can easily agree on. And with databases being so critical, securing them is vital to the health of the company. read more...

Killing the "SQL Server is a memory hog" myth
Thomas LaRock explains that if SQL Server is consuming too much memory, the issue might actually be you rather than the program. read more...

Creating better disaster recovery plans
Five questions for Tanya Reilly: How service interdependencies make recovery harder and why it’s a good idea to deliberately and preemptively manage dependencies. read more...

You Can Now Put Values On Rows In Power BI
Back in January 2016, Meagan Longoria wrote a blog post explaining a DAX workaround that allows you to put measures on rows in a matrix in a Power BI report. In this post she updates that the workaround is no longer needed, because you can now natively put measures on rows in a matrix in both Power BI Desktop and PowerBI.com. read more...

Working with Regular Expressions in PowerShell
Matching strings is a common occurrence when writing PowerShell scripts. No matter how many things in PowerShell are objects with lots of useful properties, there always comes a time when you've got a string that isn't quite right. Whether you need to check to see if a string contains certain characters or you need to pull out some information, a regular expression (regex) is a powerful way to make that happen. read more...

Row Level Security and Indexed Views
Louis Davidson explains how row level security works with indexed views - generally speaking, the answer is fairly obvious. read more...

SQL Server vs Oracle: Convert string to date
Daniel Janik discusses how each platform can create a date from a string. This sounds easy but it’s not as simple as it sounds, well at least not for SQL Server. read more...

Using Antivirus with SQL Server
In a perfect world, your SQL Server would be so secure that you would not need antivirus software, you would have behind layers of firewalls, nobody would ever connect with remote desktop to install anything, and it would always have all of the latest security patches… but that is not the real world. read more...

T-SQL to Powershell: Substring
Shane O’Neill contrasts the SUBSTRING function in T-SQL with Powershell’s Substring method. read more...

Randomness in Security Configuration
Brian Kelley shares the method he and his team used when they needed to choose a non-standard port for a new web service they were deploying. read more...

What Do You Mean My Windows Container isn’t Running?
The Windows Containers tooling is great! It simplifies the process of containerizing your applications, generating Docker and Compose files and giving you the full Docker CLI (command line interface) with the same API that you would use for Linux containers. That said, you may come across a problem where Visual Studio cannot connect to underlying Windows container. Error messages can manifest themselves in a couple of ways. read more...

Using Merge
I was playing with some data, loading it into staging tables and then moving it to a real table. I typically have done this with T-SQL, writing efficient upsert code that works well. However, I haven’t used Merge in a long time and thought I should practice a bit with the structure. read more...