Here at Database Weekly, 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. Here, we have an assortment of the latest articles from selected sources.

At DatabaseWeekly.com you can sign up for the newsletter and browse the latest news.

Latest Articles


SQLServerCentral - Blogs
In this module you will learn how to use the Drill-Down Donut Chart. The Drill-Down Donut Chart allows you to visualize categorical data in an interactive ...
00:24 19-Apr-2018
SQLServerCentral - Blogs
In the previous blog, we discussed the Foreign Keys Constraints and how the CHECK Constraints are useful to verify the data that goes into your tables. But, ...
23:00 18-Apr-2018
SQLServerCentral - Main Articles
Backups. Are you confident you can restore? Do you have a process that ensures you can recover your systems? Learn how one system works in the cloud.
23:00 18-Apr-2018
SQLServerCentral - Main Articles
Along with Graph Databases, Microsoft has introduced the new MATCH function for querying them. Robert Sheldon explains how to use the new function.
23:00 18-Apr-2018
SQLServerCentral - Main Articles
Many large enterprises launch small DevOps initiatives within certain departments, but subsequently find that scaling DevOps across the organization faces ...
23:00 18-Apr-2018
SQLServerCentral - Blogs
There's a new feature in Azure, and I stumbled on it when someone posted a link on Twitter. Apologies, I can't remember who, but I did click on the Azure ...
16:02 18-Apr-2018
SQLServerCentral - Blogs
The client reported that the log file on their main database was growing unusually large, and when they checked the backup target the database didn't ...
15:14 18-Apr-2018
SQLServerCentral - Blogs
Last time, we began an in-depth look at how time is measured. This post continues our journey. If any of you are students of Albert Einstein and his theory ...
15:00 18-Apr-2018
Simple-Talk - .NET Articles
The next step in learning how to create games in C# using Unity is to add extensions to get custom functionality. Lance Talbert shows you how to create ...
14:55 18-Apr-2018
SQLServerCentral - Blogs
SSMS (and other SQL Server utilities) utilize a batch separator to, well, separate batches of T-SQL statements. Before we go jump into batch separators, ...
14:45 18-Apr-2018
SQLServerCentral - Blogs
This script is from my library and I use it to review what is going on with my transactional replications, try to remove statements that didn't get purged ...
14:20 18-Apr-2018
SQLServerCentral - Blogs
Dear Mr. Martin and the PASS Organization, In the spirit of advocating for change in a public way, I'm writing this letter to ask you to revisit your ...
13:49 18-Apr-2018
SQLServerCentral - Questions
HI I used this query to get all the invoices which is billed and getting incorrect invoice number select a.Projectid,a.workorderid,CustomerName,d.InvoiceNumber,d.ContractorID,d.invoiceDate ...
12:53 18-Apr-2018
SQLServerCentral - Blogs
I wanted to spend a few minutes highlighting a couple of important tools for figuring out what information you have available to you within SQL Server. ...
12:00 18-Apr-2018
SQLServerCentral - Blogs
In my sessions, I always talk about how to build your skill set when you don't have a budget for training. Well next week April 25-26 is one of those ...
11:40 18-Apr-2018
DatabaseWeekly - Newsletter
Well, it is that time of the year, again. PASS puts on a 24 Hours of PASS where 1 hours session go on once an hour for 24 hours. This is free training ...
09:44 18-Apr-2018
DatabaseWeekly - Newsletter
If you are aware of Betteridge's law of headlines, you already know the answer, but let me explain. There are a lot of odd myths that surround SQL Server. ...
09:44 18-Apr-2018
DatabaseWeekly - Newsletter
Watch this week's episode on YouTube. When In-Memory OLTP was first released in SQL Server 2014, I was excited to start using it.  All I could think was ...
09:44 18-Apr-2018
DatabaseWeekly - Newsletter
There's a new feature in Azure, and I stumbled on it when someone posted a link on Twitter. Apologies, I can't remember who, but I did click on the Azure ...
09:44 18-Apr-2018
DatabaseWeekly - Newsletter
This week, I had a problem where I needed to find and eliminate from the results of my query, data with overlapping ranges. I have written about this ...
09:44 18-Apr-2018
DatabaseWeekly - Newsletter
Designing implementation of interface is as critical as designing interface itself. In this post we will discuss some advice on how to choose the right ...
09:44 18-Apr-2018
DatabaseWeekly - Newsletter
One of the most impactful ways data teams can communicate is by turning ideas into visuals to share with internal stakeholders. With Python and R, chart ...
09:44 18-Apr-2018
DatabaseWeekly - Newsletter
Sponsored by The General Data Protection Regulation (GDPR) went into effect in May 2016, giving all organizations two years to put the right people, processes, ...
09:44 18-Apr-2018
DatabaseWeekly - Newsletter
With SQL Server 2017, Microsoft announced the exciting news that SQL Server would now run in Docker containers. Laerte Junior provides a guide to get ...
09:44 18-Apr-2018
DatabaseWeekly - Newsletter
I wanted to spend a few minutes highlighting a couple of important tools for figuring out what information you have available to you within SQL Server. ...
09:44 18-Apr-2018
DatabaseWeekly - Newsletter
I just spent ages trying to work out why I couldn't connect to Power BI Report Server using the Reporting ...
09:44 18-Apr-2018
DatabaseWeekly - Newsletter
The ANDs, ORs, and NOTs in a T-SQL query's WHERE clause can get confusing, especially if you're thinking of it like plain-Jane algebra. Here I show you ...
09:44 18-Apr-2018
DatabaseWeekly - Newsletter
Note: This the first of three re-writes of older posts to bring them in line with McGoveran's formalization ...
09:44 18-Apr-2018
DatabaseWeekly - Newsletter
According to recent research from IoT security company Zingbox, health care organizations are wrestling with an array of IoT security issues.
09:44 18-Apr-2018
DatabaseWeekly - Newsletter
Using events reported as cyber-breaches in the nonprofit Privacy Rights Clearinghouse, a team of economists from Singapore, Cyprus, Hong Kong and the ...
09:44 18-Apr-2018
DatabaseWeekly - Newsletter
On April 24, I'll be hosting a webinar that talks about the GDPR and how you can help ensure compliance in your development environments. I'll talk about ...
09:44 18-Apr-2018
DatabaseWeekly - Newsletter
Forgetfulness can lead to learning something new. This is a bit of a nightmare when it happens in production, but a treat when it happens in an isolated ...
09:44 18-Apr-2018
DatabaseWeekly - Newsletter
Being a great analyst is more than SQL, Python or reporting-great analytics is a human exercise, a communications skill and way to grow a data-driven ...
09:44 18-Apr-2018
DatabaseWeekly - Newsletter
Microsoft Corp., Facebook Inc. and dozens of other technology companies from around the world have come together to help protect people from malicious ...
09:44 18-Apr-2018
DatabaseWeekly - Newsletter
Here's what you need to know about the hidden costs, risks and other considerations that must be taken ...
09:44 18-Apr-2018
SQLServerCentral - Blogs
Well, it is that time of the year, again. PASS puts on a 24 Hours of PASS where 1 hours session go on once an hour for 24 hours. This is free training ...
05:36 18-Apr-2018
Simple-Talk - Blogs
This week, I had a problem where I needed to find and eliminate from the results of my query, data with overlapping ranges. I have written about this ...
03:59 18-Apr-2018
SQLServerCentral - Editorials
A good security system needs layers since our applications and platforms don't exist in a vacuum. How to fix SQL Server disk I/O bottlenecks ...
23:00 17-Apr-2018
SQLServerCentral - Main Articles
Earlier levels have shown how Columnstore Indexes work effectively with static data. In most tables ...
23:00 17-Apr-2018