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 - Questions
So, I noticed this recently when I was doing a full database backup on one of our test servers. As the backup is executing, the filesize on disk shows ...
03:36 29-May-2017
SQLServerCentral - Blogs
For the first time in my career, I'm a certified Microsoft Certified Trainer (MCT). This title came as a result of my two-year working as a trainer at ...
19:11 28-May-2017
SQLServerCentral - Blogs
Continuation from the previous 104 parts, the whole series can be found at http://www.nikoport.com/columnstore/. For a very long time I was intending ...
15:24 27-May-2017
SQLServerCentral - Blogs
As a continuation of "SQL Azure Databases - Active Secondary" series started earlier, this post will cover how to connect to a azure SQL Database primary ...
08:30 27-May-2017
Simple-Talk - SQL Articles
SQL Server 2016 has a new configuration to control the auto-growth of multiple files in the same filegroup. When we create several files in the same filegroup ...
06:20 27-May-2017
Simple-Talk - Blogs
SQL Server 2016 has a new configuration to control the auto-growth of multiple files in the same filegroup. When we create several files in the same filegroup ...
06:20 27-May-2017
SQLServerCentral - Blogs
Web API FAQs: 1.       What are the return types of Action methods in Web API?a.       Void:If ...
03:45 27-May-2017
SQLServerCentral - Questions
Dear Expert, i need help to update a table. it looks like this. CREATE TABLE #test (id INT IDENTITY(1,1), score int, goal int) INSERT INTO #test(score) ...
18:13 26-May-2017
SQLServerCentral - Questions
I am attempting to connect to an availability group read-only replica through SSMS (version 2016 and 2017). I connect using the listener and add "ApplicationIntent=ReadOnly" ...
18:13 26-May-2017
SQLServerCentral - Questions
I am new to coding with sql and trying to add an extra column with ON HAND for 410 locatoin only for each of the lines. Currently it shows all the columns ...
18:13 26-May-2017
SQLServerCentral - Blogs
Parallelism and MAXDOP There's no doubt that parallelism in SQL is a great thing. It enables large queries to share the load across multiple processes ...
13:18 26-May-2017
SQLServerCentral - Blogs
I’ve currently been participating in the Microsoft Professional Program in Data Science. It’s an online curriculum of MOOCs (Massive Open ...
12:12 26-May-2017
SQLServerCentral - Blogs
I'm proud to announce that I will be speaking at SQL Saturday Pensacola on June 3rd 2017! Check out the amazing schedule! If you don't know what SQLSaturday ...
11:12 26-May-2017
SQLServerCentral - Questions
Hey Guys, i really need help, i'm creating a report using xml data connection, issue is when i query two array elements at same time it only returns ...
09:59 26-May-2017
DatabaseWeekly - Newsletter
You've got some troubling wait stats in SQL Server. How can you tell which queries are causing those waits? Learn the pros and cons of different techniques ...
09:45 26-May-2017
DatabaseWeekly - Newsletter
This post introduces PowerShell Remoting in Multi-Platform Environments, specifically using OpenSSH.
09:45 26-May-2017
SQLServerCentral - Blogs
The weather in Dublin is absolutely gorgeous at the moment so I’m not planning on spending much time inside this weekend! Hope the weather is the ...
07:39 26-May-2017
SQLServerCentral - Questions
I have a SQL script that works exactly as I want it to when I step through it line by line. At first, this was a viable option, but the script has gotten ...
06:13 26-May-2017
SQLServerCentral - Editorials
The SQL Server platform is growing, but Steve Jones notes that this might not really affect our jobs.
23:00 25-May-2017
SQLServerCentral - Main Articles
This article from Tony Davis describes how to the use the Redgate SQL Compare and SQL Data Compare GUIs ...
23:00 25-May-2017
SQLServerCentral - Main Articles
Read a short comparison of datetime and datetime2 types. Learn about their structure, as well as the advantages and disadvantages of each.
23:00 25-May-2017
SQLServerCentral - Main Articles
Monica Rathburn talks about a few of the more common elements she always checks for when troubleshooting I/O problems.
23:00 25-May-2017
SQLServerCentral - Blogs
So in my last post I told you about how I started my journey on learning PowerShell, let's keep going down that path together. In this post I'm going ...
19:24 25-May-2017
SQLServerCentral - Blogs
For the first time in many years, I won't be at IT/DevConnections this fall.  I'm disappointed to miss the event, but I had other commitments around ...
18:22 25-May-2017
DatabaseWeekly - Newsletter
Visual Studio 2017, SSDT and SQL Server 2016/SQL Database (on Azure) can be used in both migration and state based database development approaches.
16:45 25-May-2017
DatabaseWeekly - Newsletter
Have you ever needed to look at what data in a table used to look like? If you have, it probably took a knuckle-cracking filled session of writing group-by ...
16:45 25-May-2017
DatabaseWeekly - Newsletter
Data privacy and data security have become one of the most prominent topics in organizations in almost ...
16:45 25-May-2017
DatabaseWeekly - Newsletter
One of the changes that's been brought into the database engine in SQL Server 2017 is the ability to disable the cache that SQL keeps on identity values ...
16:45 25-May-2017
SQLServerCentral - Blogs
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is also a part of a basic ...
16:16 25-May-2017
DatabaseWeekly - Newsletter
At BUILD 2017, Microsoft announced the preview of Azure Cloud Shell supporting the Bash shell, and are now adding PowerShell support to Azure Cloud Shell, ...
15:45 25-May-2017
DatabaseWeekly - Newsletter
A major cause of poor performance is a simple failure to use an indexed or persisted computed column value as expected.
15:45 25-May-2017
DatabaseWeekly - Newsletter
Reports indicate that Microsoft has agreed to buy Israeli cybersecurity company Hexadite for around $100 million. Hexadite uses artificial intelligence ...
15:45 25-May-2017
DatabaseWeekly - Newsletter
Microsoft R Open (MRO), Microsoft's enhanced distribution of open source R, has been upgraded to version 3.4.0 and is now available for download for Windows, ...
15:45 25-May-2017
DatabaseWeekly - Newsletter
Artificial intelligence will not only change how and where compute happens but also the underlying structure of the technology that we use every day.
15:45 25-May-2017
DatabaseWeekly - Newsletter
By using low-priority VMs, Microsoft is enabling a way to use Azure Batch with price reductions of up to 80%.
15:45 25-May-2017
SQLServerCentral - Blogs
I am so excited and honored to have been selected to speak at SQL Saturday Atlanta (#652) this year.  This is huge event where I've been a volunteer ...
15:22 25-May-2017
DatabaseWeekly - Newsletter
Companies looking to grow and extract value from their data are increasingly turning to Chief Data Officers ...
14:45 25-May-2017
DatabaseWeekly - Newsletter
Microsoft have announced the last service pack for SQL Server 2012.
14:45 25-May-2017
DatabaseWeekly - Newsletter
SSRS provides the capability to review the scheduled reports (subscriptions) in a highly-detailed fashion. This article will dive into the source of this ...
14:45 25-May-2017