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
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
SQLServerCentral - Main Articles
Ahmad Yaseen explains what SQL Server 2016 SP1's new CREATE OR ALTER statement does, and how to use it.
00:00 20-Feb-2017
SQLServerCentral - Main Articles
In this free webinar, Steve Jones and Arneh Eskandari show how Redgate's Database DevOps solution works with Visual Studio Team Services to improve your ...
00:00 20-Feb-2017
SQLServerCentral - Blogs
As some readers may know, I am a regular attendee on SQL Cruise s for 8 years now. SQLCruise is a training(&-vacation for some) event organized by ...
21:57 19-Feb-2017
SQLServerCentral - Questions
Hi All, We are trying to load a table from SQL Server Parallel DW APS to In-Memory OLTP SQL Server 2014 Enterprise edition. As we are aware that we have ...
10:40 19-Feb-2017
SQLServerCentral - Questions
please kindly tell me the answer for the attached picture. ![![alt text][1]][1] [1]: /storage/temp/3978-pic1.jpg
09:11 19-Feb-2017
SQLServerCentral - Questions
Hi, I have a database with 100 tables. I have a main customer table (Primary Key CutomerID) and need to archive all customer records where status = ...
19:24 18-Feb-2017
SQLServerCentral - Questions
I given a task for auditing any DDL changes in one particular server instance. There are a few databases on the server and I cannot create any objects ...
10:43 18-Feb-2017
SQLServerCentral - Questions
can someone help me prevent this deadlock I have 2 Tables, Say table A and Table B, Table B has foreign key relation with Table A and while inserting ...
21:22 17-Feb-2017
SQLServerCentral - Questions
Hello All, Good afternoon,I am trying to compare the clustered and nonclustered count and their definitions ...
18:32 17-Feb-2017
SQLServerCentral - Blogs
One of my client vCenter Server fails to start as below shown error in event logs.Could not allocate space for object 'dbo.VPX_EVENT'.'VPXI_EVENT_USERNAME' ...
18:30 17-Feb-2017
DatabaseWeekly - Newsletter
SQL Server 2016 SP1 opens up a lot of new possibilities for Standard, Web, and Express editions of SQL Server, including new options for in-memory technologies ...
17:42 17-Feb-2017