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
Hi, I have SQL Server 2016 SP1 with a linked server Oracle 12c Linked Server. Most queries work fine, but there is an issue with Image data. In some ...
13:07 28-Feb-2017
SQLServerCentral - Blogs
A couple of weeks back I installed SQL Server 2016 on my personal machine, including SSAS Tabular. Yesterday I created a new Tabular model project in ...
13:00 28-Feb-2017
Simple-Talk - SQL Articles
We all know how easy it is to run R, together with dependent packages, from SQL Server on order to ...
09:16 28-Feb-2017
SQLServerCentral - Editorials
Steve Jones comments on containers and their suitability for databases.
00:00 28-Feb-2017
SQLServerCentral - Main Articles
To upgrade or migrate, that is the question. And I have an answer.
00:00 28-Feb-2017
SQLServerCentral - Main Articles
In an effort to make leading wildcard searches sargable, Aaron Bertrand plays around with a trigram-type implementation in SQL Server.
00:00 28-Feb-2017
SQLServerCentral - Questions
we are upgrading to sql server 2016 sp1. i wanted to ask, would log shipping work if primary server is sql 2016 sp1 enterprise edition and secondary ...
19:30 27-Feb-2017
SQLServerCentral - Blogs
In case you didn't know this already, dbatools is an awesome collection of Powershell functions that will help you immensely in your work as a DBA. Just ...
18:26 27-Feb-2017
Simple-Talk - SQL Articles
When there are several SSIS projects with packages in a SQL Server Database or Data Warehouse development, automated deployments as part of Continuous ...
17:32 27-Feb-2017
SQLServerCentral - Blogs
In the next few months I will be speaking at some awesome events around Europe.   SQLBits – April 5-8  SQLBits is THE SQL Server event in ...
17:24 27-Feb-2017
SQLServerCentral - Blogs
I'll be speaking at Visual Studio Live - Austin in May 2017. I was fortunate to be selected to speak again, after my first two VS Lives last year in DC ...
17:12 27-Feb-2017
SQLServerCentral - Questions
I have a table T with four dimensions and one measure like this: Dim1, Dim2, Dim3, Dim4, Msr 1A, 2A, 3A, 4A, 100 1A, 2A, 3A, 4B, 50 1A, ...
16:58 27-Feb-2017
Simple-Talk - SQL Articles
Managed Disks have simplified way that Azure storage interacts with the users' virtual machines, thanks to the way that it eliminates the need to deal ...
15:36 27-Feb-2017
Simple-Talk - Cloud Articles
Managed Disks have simplified way that Azure storage interacts with the users' virtual machines, thanks to the way that it eliminates the need to deal ...
15:36 27-Feb-2017
SQLServerCentral - Questions
In Oracle there is a way to find the sensitive data columns (Application Data Modelling). Is there any way to find the sensitive data columns in sql server ...
15:34 27-Feb-2017
SQLServerCentral - Blogs
These are those queries where you are pulling for, let’s say, a first name, a last name, a state, and/or a city. Simple enough, until you notice ...
14:00 27-Feb-2017
SQLServerCentral - Blogs
This weekend I set up some SQL vNext virtual machines, two on Windows and one on Linux so that I could test some scenarios and build an availability group. IMPORTANT ...
13:39 27-Feb-2017
SQLServerCentral - Blogs
I am resuming technical blogging after a gap of nearly a month. I will continue to blog my re learning of statistics and basic concepts, and illustrate ...
13:21 27-Feb-2017
SQLServerCentral - Blogs
Today is the launch of SQL Clone, a great new tool that helps you quickly and easily provision SQL Server databases for development and testing. Oh god, ...
12:04 27-Feb-2017
SQLServerCentral - Questions
Hi All, I read some article about SQL 2016 In memory OLTP . As suggested by MS Foreign Key and triggers are supported in SQL 2016 in Memory OLTP. But ...
11:58 27-Feb-2017
SQLServerCentral - Blogs
Ergh, not a fun weekend rugby wise. But anyway… Last week Microsoft released an image for SQL Server 2016 SP1 Developer Edition in containers. Previously ...
09:00 27-Feb-2017
SQLServerCentral - Questions
In management studio 2008 R2 on Windows XP suddenly every view that I create and filter by Date is running very slow. For example on table of 10 rows, ...
08:52 27-Feb-2017
SQLServerCentral - Blogs
Hey guys! So here's my adventure in deploying Windows Server 2016 Nano on a physical server. It was a hard fought battle, but I finally won. Note: ...
06:52 27-Feb-2017
SQLServerCentral - Blogs
Note this was during earlier beta usage, so some of the UI and other features will have been updated more. I plan on writing more on this promising tool ...
05:00 27-Feb-2017
SQLServerCentral - Blogs
End users generally face a situation where the SQL server application gets hangs. What users generally do is restart the machine for fixing the problem ...
02:21 27-Feb-2017
SQLServerCentral - Editorials
Machine learning and AI are becoming more and more prevalent, which Steve Jones thinks is good.
00:00 27-Feb-2017
SQLServerCentral - Main Articles
In this article, you will learn how to troubleshoot error when you try to launch the main Dashboard Report.
00:00 27-Feb-2017
SQLServerCentral - Main Articles
This is the last week for a discounted registration to SQL Bits 2017. The price goes up after Mar 4, so register today.
00:00 27-Feb-2017
SQLServerCentral - Main Articles
SQL Server Encryption is an essential part of what is required for protecting data. Column-level encryption ...
00:00 27-Feb-2017
SQLServerCentral - Blogs
Continuation from the previous 98 parts, the whole series can be found at http://www.nikoport.com/columnstore/. This blog post is focused on the MERGE ...
00:55 26-Feb-2017
SQLServerCentral - Questions
we have Barracuda setup for backing all the server, for the other windows server its good , Great interface. but when we do SQL server backup when I try ...
17:11 24-Feb-2017
Simple-Talk - Cloud Articles
Azure provides an idea platform for hosting microservices because it offers a number of managed services that allow developers to create microservices ...
16:36 24-Feb-2017
SQLServerCentral - Blogs
I suspect this may make a few people angry, but I felt the need to share. I was recently asked to go through my contacts and put together calls with some ...
15:04 24-Feb-2017
SQLServerCentral - Questions
Can you please suggest few of the techniques/procedures that we should do on database to run the system ...
13:14 24-Feb-2017
SQLServerCentral - Blogs
The cloud has evolved. Just a few years ago, cloud-based applications were the exception rather than the rule, and on-premises apps were the clear standard ...
12:47 24-Feb-2017
SQLServerCentral - Blogs
Does this title seem strange?  Of course we know this is the true answer:https://cdn.meme.am/cache/instances/folder633/58097633.jpgBut here is a ...
12:44 24-Feb-2017
Simple-Talk - .NET Articles
When Google announced the 'Go' language in 2009 we were all underexcited. After all, a compiled, statically typed language in the tradition of Algol ...
12:20 24-Feb-2017
SQLServerCentral - Questions
Hi, I am trying to write a statement in which my test step finds a parent node and node name but then I want it to start with only those two items or ...
10:18 24-Feb-2017
SQLServerCentral - Questions
I have 2 tables, both have date columns & customer code is common in both tables. I need to extract details of all the customer from both table on the ...
10:12 24-Feb-2017