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
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 - 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
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
SQLServerCentral - Blogs
On Thursday, February 23rd at 3 PM EST I’m giving a webinar on designing a successful database security model with SQL Server. Register Here for ...
14:15 21-Feb-2017
SQLServerCentral - Questions
i'm try to update table in linked server using procedure and trigger create trigger ksunil on ...
13:42 21-Feb-2017
SQLServerCentral - Blogs
In this module you will learn how to use the Waffle Chart Power BI Custom Visual.  The Waffle Chart visual is most useful for presenting a percentage ...
13:18 21-Feb-2017
SQLServerCentral - Blogs
In my latest learning tree newsletter, I discussed analysing some of the salary survey data that the good folks over at BrentOzar.com collected and made ...
12:30 21-Feb-2017
SQLServerCentral - Blogs
Issue: I am trying to load data from Excel 97 – 2003 sheet into a database table. I have written a simple SSIS package to do that, but unfortunately, ...
09:44 21-Feb-2017
SQLServerCentral - Blogs
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 ...
06:35 21-Feb-2017
SQLServerCentral - Blogs
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/) ...
05:55 21-Feb-2017
SQLServerCentral - Questions
Hi, I need a query that lists the parents with missing child (records). I have two tables, parent and child. There are 1000 parent records and 980 ...
03:25 21-Feb-2017
SQLServerCentral - Blogs
Since installing SQL Server vNext CTP 1.3 I found out that there is a new way to return statistics histogram for a specific stat which actually is also ...
01:30 21-Feb-2017
SQLServerCentral - Blogs
[2017-Feb-21] I'm creating this particular blog post more for myself to remember and use it as a reference to related discussions in future.One of ...
00:57 21-Feb-2017
SQLServerCentral - Editorials
For many years now we always seem to have been on the verge of the revolution in object databases, without it ever quite transpiring. Why is this?
00:00 21-Feb-2017
SQLServerCentral - Main Articles
An Evaluation of the Azure SQL Database Ecosystem.
00:00 21-Feb-2017
SQLServerCentral - Main Articles
As the demand for data analytics grows so does the need for a technology or platform to process large amounts of different types of data in timely manner. ...
00:00 21-Feb-2017
SQLServerCentral - Questions
i spend quite some time reg. licensing but have still one question. I have server A where i install sql server including ssrs, i have a core based license ...
15:23 20-Feb-2017
SQLServerCentral - Blogs
One question constantly comes up; What should the Cost Threshold for Parallelism be? The default value of 5 is pretty universally denigrated (well, not ...
15:05 20-Feb-2017
SQLServerCentral - Blogs
Growing up my mother used this phrase quite a bit. Penny wise, pound stupid. (In case you didn’t know the pound is the British equivalent of the ...
14:00 20-Feb-2017
SQLServerCentral - Questions
All, recentlty i installed SQLSERVER 2016 for loading JSON format files. Actually our JSON file contains many JSON tags separeted by newline character. ...
13:46 20-Feb-2017
SQLServerCentral - Blogs
I had a need to setup transactional replication from my SQL Server to SQL Database (Azure) where I only needed a selection of tables that I wanted to ...
12:01 20-Feb-2017
SQLServerCentral - Blogs
An availability group supports a failover environment for a discrete set of user databases, known as availability databases, that fail over together. ...
11:15 20-Feb-2017
SQLServerCentral - Blogs
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 ...
10:03 20-Feb-2017
SQLServerCentral - Blogs
A quick reminder that tomorrow, Feb 21 at 12pm EST, I'll be hosting another DevOps, Database Lifecycle Management (DLM) webinar. Together with Arneh Eskandari, ...
09:48 20-Feb-2017
SQLServerCentral - Blogs
No rugby on last weekend so I didn’t have anything to distract me from working. On another note, my flat has never been cleaner! So last week Microsoft ...
09:00 20-Feb-2017
SQLServerCentral - Questions
Hello, I have "History" folder which consist 3000+ text files and so I would like to automate the process ...
07:04 20-Feb-2017
SQLServerCentral - Editorials
Steve Jones is getting excited about learning at SQL Bits 2017.
00:00 20-Feb-2017
SQLServerCentral - Main Articles
If you have not been capturing baselines on your production servers, then today is the day you can start. This article provides scripts, valid for SQL ...
00:00 20-Feb-2017