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
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
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
DatabaseWeekly - Newsletter
Last week I received an email from a reader asking how to handle missing members in MDX used in the Excel CubeSet() function. My first thought was that ...
09:42 22-Feb-2017
DatabaseWeekly - Newsletter
Welcome to the last part of this series, you can find the previous post here (http://www.sqlservercentral.com/blogs/denniss-sql-blog-1/2017/02/01/improve-performance-by-replacing-temp-tables-with-memory-optimized-tables-part-1/) ...
09:42 22-Feb-2017
DatabaseWeekly - Newsletter
Last week, I have had one mystery challenge while creating Availability Group listener in Azure. We followed Configure one or more Always On Availability ...
09:42 22-Feb-2017
DatabaseWeekly - Newsletter
My last article demonstrated that you can use SQL Clone to make a copy of a live database, even when that database is protected with Transparent Data ...
09:42 22-Feb-2017
DatabaseWeekly - Newsletter
In my last post, I explained how to alter an existing job step across many servers. I also had cause to add a T-SQL Job step to a large number of jobs ...
09:42 22-Feb-2017
DatabaseWeekly - Newsletter
Microsoft is excited to announce a new preview for the next version of SQL Server (SQL Server v.Next). Community Technology Preview (CTP) 1.3 is available ...
09:42 22-Feb-2017
DatabaseWeekly - Newsletter
Probably one of the most common challenges I see when I do ETL and business intelligence work is analyzing a table (or a file) for possible primary keys. ...
09:42 22-Feb-2017
DatabaseWeekly - Newsletter
Here's an article that explains how to make Azure Data Lake Store the default file system for Hadoop. Making Azure Data Lake Store the default file system ...
09:42 22-Feb-2017
DatabaseWeekly - Newsletter
MSPoweruser There's a second major Windows 10 update coming later in 2017, Microsoft has confirmed. The second update, code-named Redstone 3, will follow ...
09:42 22-Feb-2017
DatabaseWeekly - Newsletter
One question constantly comes up; What should the Cost Threshold for Parallelism be? The default value of 5 is pretty universally denigrated (well, not ...
09:42 22-Feb-2017
DatabaseWeekly - Newsletter
The public CTP 1.3 of SQL Server vNext on Windows is available here! The corresponding versions of SQL Server Data Tools (SSDT) and SQL Server Management ...
09:42 22-Feb-2017
DatabaseWeekly - Newsletter
It's no secret today that all our applications and devices are generating tons of data; thus making data analytics a very hot topic these days and Microsoft ...
09:42 22-Feb-2017
DatabaseWeekly - Newsletter
It took me quite a while to figure out how to sign a SQL Server CLR Assembly (like a CLR stored procedure / function / trigger etc) in VS 2015. If you ...
09:42 22-Feb-2017
DatabaseWeekly - Newsletter
There is a command that as far as I can tell has been in the product since SQL2008 but I was woefully unaware of. Actually I find many others are unaware ...
09:42 22-Feb-2017
DatabaseWeekly - Newsletter
When you're tuning queries It's sort of a relief when the first time you get your hands on it, you get the plan and there's a missing index request. Even ...
09:42 22-Feb-2017
DatabaseWeekly - Newsletter
I was asked if there was an easy way to export all the plans from cache to a .SQLPLAN file. My immediate answer was, "I'm sure there's a PowerShell script ...
09:42 22-Feb-2017
DatabaseWeekly - Newsletter
After we announced the ability for U-SQL to massively distributed Python code in the Azure Data Lake Analytics service, a lot of developers have been asking ...
09:42 22-Feb-2017
DatabaseWeekly - Newsletter
Some five months after Yahoo disclosed a security breach that exposed sensitive data for 500 million ...
09:42 22-Feb-2017
DatabaseWeekly - Newsletter
This article describes how to create a virtual relationship in DAX using the TREATAS function, which is more efficient than approaches based on INTERSECT ...
09:42 22-Feb-2017
DatabaseWeekly - Newsletter
Hold my beer. CREATE DATABASE [50Ways]; GO ALTER DATABASE [50Ways] SET PAGE_VERIFY NONE; /* Normally ...
09:42 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
SQLServerCentral - Main Articles
In this level, I'll introduce Extended Properties. As with the previous levels, I want to illustrate as much as possible with practical and immediately ...
00:00 22-Feb-2017
SQLServerCentral - Main Articles
Let's forget the actual PowerShell code for a moment: Why is PowerShell important? Why should I use it? Where did it come from? Why did it take so long ...
00:00 22-Feb-2017
SQLServerCentral - Questions
Hi, Complicated query to do and ask/explain, at least for me, so here goes... Table= 'Page ' with an index named 'LibSort' build on field 'library_sort'. ...
21:19 21-Feb-2017
SQLServerCentral - Questions
Hello, I have been reading about fragmentation levels on indexes, but want to check with you lot first as I don't fully understand it. I have a clustered ...
17:16 21-Feb-2017
SQLServerCentral - Blogs
The response to our most recent job position was incredible, and I’d like to thank all of the folks who responded and submitted their CVs to us ...
15:42 21-Feb-2017
SQLServerCentral - Blogs
I'm honored to be selected to speak at SQL Bits 2017 this April in Telford. This is my favorite SQL Server conference, and it's always a joy to attend. ...
14:32 21-Feb-2017