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
There are plenty of examples on how to retrieve a single sibling value. For example given the following XML fragment: 800000 80000 ...
00:09 23-Feb-2017
SQLServerCentral - Editorials
Today Steve Jones argues the cloud is just another tool for us to use. Not required, not ignored, but considered.
00:00 23-Feb-2017
SQLServerCentral - Main Articles
Article in markdown format: https://github.com/ktaranov/sqlserver-kit/blob/master/SQL%20Server%20Trace%20Flag.md
00:00 23-Feb-2017
SQLServerCentral - Main Articles
Aaron Bertrand acknowledges that DISTINCT and GROUP BY are usually interchangeable, but shows there are cases where one performs better than the other. ...
00:00 23-Feb-2017
SQLServerCentral - Blogs
Just last week we had the fantastic opportunity to present at Microsoft Ignite 2017 in the Gold Coast on Azure Cognitive Services – and we had an ...
23:30 22-Feb-2017
SQLServerCentral - Blogs
Nothing special - just signed with renewed code sign certificate, small fixes, etcHave fun!Wait a minute! Almost forgot.More great news coming soon, stay ...
22:50 22-Feb-2017
SQLServerCentral - Blogs
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. If you've worked with SQL ...
20:31 22-Feb-2017
SQLServerCentral - Questions
We have a database called work and distributor database. we had setup replication on work database and devices in field. How do we migrate the work database ...
17:10 22-Feb-2017
SQLServerCentral - Blogs
I just wanted to remind everyone that the SQL Saturday in Chicago is coming up, and that both Adam Machanic and I are holding precons the Friday before ...
16:28 22-Feb-2017
SQLServerCentral - Questions
Hi Experts , I run below scripts for Backup job .after backup job complete (xp_delete) delete the old copy of full backup .last 2 days backup job was ...
16:01 22-Feb-2017
SQLServerCentral - Questions
I'm a C# developer with limited experience in SSIS, but I've been asked to learn how to build custom components for the system. I've had some success ...
15:03 22-Feb-2017
SQLServerCentral - Questions
Hi, I have a column (Full Name) which needs to split into First Name, Middle Name and Last Name. So can any one of you provide me function to do that. ...
15:03 22-Feb-2017
SQLServerCentral - Questions
How to whitelist ipaddress to give access to a given client ?
15:01 22-Feb-2017
SQLServerCentral - Blogs
Restoring a backup file is pretty easy right? RESTORE DATABASE [Test] FROM DISK = 'C:\backups\backup.bak'; Ok, but what if more than one database backup ...
14:00 22-Feb-2017
SQLServerCentral - Questions
I have a database of 750GB, i want to upgrade from sql server 2008R2 to sql server 2016 web edition. We create a brand new server and afterwards close ...
13:56 22-Feb-2017
SQLServerCentral - Questions
Hi, We have developed the cube and it is been refreshing daily through sql jobs this cube has been hosted in .net page to view the result to the users. ...
12:49 22-Feb-2017
DatabaseWeekly - Newsletter
I was working with a customer to troubleshoot memory optimized table issues.  In this scenario, our ...
10:42 22-Feb-2017
DatabaseWeekly - Newsletter
Last summer, after SP2 for SQL Server 2014 was released, I wrote about using DBCC CLONEDATABASE for more than simply investigating a query performance ...
10:42 22-Feb-2017
DatabaseWeekly - Newsletter
In blog "Importance of choosing correct bucket count of hash indexes on a memory optimized table",  ...
10:42 22-Feb-2017
DatabaseWeekly - Newsletter
Jeff Pries shows how to use the Natural Earth data set in SQL Server: But what about when you need more flexibility in your geographic display?  Some ...
10:42 22-Feb-2017
DatabaseWeekly - Newsletter
Always Encrypted is a new feature included in SQL Server 2016 for encrypting column data at rest and in motion. This represents an important difference ...
10:42 22-Feb-2017
DatabaseWeekly - Newsletter
I was consulting a client for migration from SQL 2014 to SQL 2016. They were using methodology discussed ...
10:42 22-Feb-2017
DatabaseWeekly - Newsletter
Sander Stad has made changes to his Export-DMVInformation Powershell module: Last Friday I had the chance to show the Export-DMVInformation module to ...
10:42 22-Feb-2017
DatabaseWeekly - Newsletter
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to ...
10:42 22-Feb-2017
DatabaseWeekly - Newsletter
This material was originally posted on the Linchpin People blog . In this post, I demonstrate how to use the SQL Server 2012 Import and Export Wizard ...
10:42 22-Feb-2017
DatabaseWeekly - Newsletter
We are getting ready to update the SQL Server Management Packs. Please install and use this public preview ...
10:42 22-Feb-2017
DatabaseWeekly - Newsletter
Temporal, or system-versioned, tables were introduced as a database feature in SQL Server 2016. This gives us a type of table that can provide information ...
10:42 22-Feb-2017
DatabaseWeekly - Newsletter
The 4th cumulative update release for SQL Server 2014 SP2 is now available for download at the Microsoft Downloads site. Please note that registration ...
10:42 22-Feb-2017
DatabaseWeekly - Newsletter
The folks at Sharp Sight Labs show how to create high-quality map visuals in R: Maps are great for practicing data visualization. First of all, there's ...
10:42 22-Feb-2017
DatabaseWeekly - Newsletter
One year ago I wrote an article describing how the time intelligence DAX functions work in Power BI (I just updated the article including the example ...
10:42 22-Feb-2017
DatabaseWeekly - Newsletter
June 3, 2014 For more information and to register, please go to https://ssig201406.eventbrite.com Presentation ...
10:42 22-Feb-2017
DatabaseWeekly - Newsletter
The 11th cumulative update release for SQL Server 2014 SP1 is now available for download at the Microsoft Downloads site. Please note that registration ...
10:42 22-Feb-2017
DatabaseWeekly - Newsletter
We are excited to announce the public availability of SQL Server 2016 SP1 Developer Edition in Windows Containers! The image is now available on Docker ...
10:42 22-Feb-2017
DatabaseWeekly - Newsletter
Jovan Popvic has created a 4.35 GB JSON array: SQL Server 2016 and Azure SQL Database enable you to parse JSON text and transform it into tabular format. ...
10:42 22-Feb-2017
DatabaseWeekly - Newsletter
Sometimes going back-to-the-basics is the best thing to do to fully understand something. Some of us have been doing things in a certain way for so long ...
10:42 22-Feb-2017
DatabaseWeekly - Newsletter
I've got a program here that finds SQL in procedures with missing column specifications. Table Columns Are Ordered Even though they shouldn't be. Unlike ...
10:42 22-Feb-2017
SQLServerCentral - Questions
In my database I maintain Hierarchy in below order. Main_market->market->Market_Sub->Brand MM1 M1 SM1 B1 I have Hierarchy ...
10:23 22-Feb-2017
SQLServerCentral - Blogs
SQL Server Management Studio (SSMS) release candidate 17.0 RC2 works side-by-side with generally available releases (16.x), but it is not recommended ...
09:45 22-Feb-2017
SQLServerCentral - Blogs
Continuing on my series in working with Docker on Windows, I noticed that I always open up a remote powershell window when working with Docker on servers. ...
09:00 22-Feb-2017