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, Lately I identified a strange behaviour. Where a GO statement executed without error. And the same statement failed on another machine. Below is ...
19:18 23-Apr-2017
SQLServerCentral - Blogs
I have been fascinated with another new feature of the upcoming SQL Server release and so I decided to blog about it. The new version of SQL Server (2017) ...
14:49 23-Apr-2017
SQLServerCentral - Blogs
Availability Groups are a fantastic way to provide high availability and disaster recovery for your databases, but it isn't exactly the easiest thing ...
18:28 22-Apr-2017
SQLServerCentral - Blogs
  Thu, Apr 27 2017 20:00 GMT Daylight Time Power BI Dashboard within an hour for Excel users ...
16:33 22-Apr-2017
SQLServerCentral - Blogs
Continuation from the previous 103 parts, the whole series can be found at http://www.nikoport.com/columnstore/. This blog post is a logical continuation ...
00:23 22-Apr-2017
Simple-Talk - SQL Articles
Can you produce HTML from SQL? Yes, very easily. Would you ever want to? I certainly have had to. The principle is very simple. HTML is really just a ...
17:32 21-Apr-2017
Simple-Talk - Blogs
Can you produce HTML from SQL? Yes, very easily. Would you ever want to? I certainly have had to. The principle is very simple. HTML is really just a ...
17:32 21-Apr-2017
SQLServerCentral - Questions
Hello, We have setup Ola Hallengren Backup solution, the daily differential backup job is failing attached the job history, can some one help me with ...
16:14 21-Apr-2017
DatabaseWeekly - Newsletter
Microsoft is recommending enabling "CLR Strict Security" in SQL Server 2017, which means users cannot create any CLR assemblies unless they have elevated ...
15:44 21-Apr-2017
DatabaseWeekly - Newsletter
We've identified the tables with similar structure, but what about if we want to know which column names match exactly?
15:44 21-Apr-2017
DatabaseWeekly - Newsletter
Kenneth Fisher offers his general rules of thumb for when and when not to add indexes.
15:44 21-Apr-2017
DatabaseWeekly - Newsletter
Erik Darling uncovers some new stuff in SQL Server that they don't mention in the release notes.
15:44 21-Apr-2017
DatabaseWeekly - Newsletter
Erik Darling discovers that regular ol' join simplification can help the optimizer 'optimize away' a table variable operator.
15:44 21-Apr-2017
DatabaseWeekly - Newsletter
The Active Directory module from RSAT is the way to go but sometimes you may want a bit more control. You also may have a need to roll your own tools. ...
14:44 21-Apr-2017
DatabaseWeekly - Newsletter
Joseph Sirosh announces the close integration of AI functions into databases, data lakes, and the cloud ...
13:44 21-Apr-2017
DatabaseWeekly - Newsletter
SQL Server 2017 and Azure SQL Database introduce a new set of adaptive query processing improvements, such as batch mode memory grant feedback, batch ...
13:44 21-Apr-2017
DatabaseWeekly - Newsletter
The 5th cumulative update release for SQL Server 2014 SP2 is now available for download at the Microsoft Downloads site.
13:44 21-Apr-2017
DatabaseWeekly - Newsletter
Graph extensions are fully integrated in the SQL Server 2017 engine. This article introduces two new types of tables in SQL Server 2017 databases, Node ...
13:44 21-Apr-2017
DatabaseWeekly - Newsletter
The PASS Summit is the biggest SQL Server community event, and a lot of us speakers have "present at PASS" on their bucket list. it means getting in is ...
13:44 21-Apr-2017
DatabaseWeekly - Newsletter
Marco Russo explains the right and wrong reasons to use DirectQuery.
13:44 21-Apr-2017
DatabaseWeekly - Newsletter
SQL Server 2017 CTP 2.0 adds a number of new capabilities, including the ability to run advanced analytics using Python in a parallelized and highly scalable ...
13:44 21-Apr-2017
DatabaseWeekly - Newsletter
Well, good one Australia, UK and whoever else has embarked on this hare-brained scheme, you've just made things a whole lot worse.
13:44 21-Apr-2017
DatabaseWeekly - Newsletter
Row level security is the ability to filter content based on a users role. There are two primary ways to implement row level security in Power BI - through ...
13:44 21-Apr-2017
DatabaseWeekly - Newsletter
Brent Ozar brings to our attention the Chat rooms at SQLcommunity.Slack.com.
13:44 21-Apr-2017
DatabaseWeekly - Newsletter
If you have a query where ISNULL() is used in the WHERE clause to replace NULL values with a canary ...
13:44 21-Apr-2017
DatabaseWeekly - Newsletter
While auditing features were available before in Azure, Blob auditing is a huge leap forward, especially in having more granular control over what audit ...
12:44 21-Apr-2017
DatabaseWeekly - Newsletter
Microsoft has released SQL Server 2014 Service Pack 2 Cumulative Update 5, which is Build 12.0.5546.0. There are 24 hotfixes in the public fix list.
12:44 21-Apr-2017
DatabaseWeekly - Newsletter
Glenn Berry explains why he thinks it a shame that many people actually use Data Definition Language (DDL) triggers on their systems.
12:44 21-Apr-2017
SQLServerCentral - Blogs
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This continues my series on ...
11:44 21-Apr-2017
SQLServerCentral - Blogs
I received  the email from Learning Tree on Wednesday with their weekly offer of courses running in the London Education Center this May. There ...
08:00 21-Apr-2017
SQLServerCentral - Blogs
I’m participating in the #vizBookClub, a great idea by the data visualization community. In short, we read a book about data visualization and we ...
07:59 21-Apr-2017
SQLServerCentral - Editorials
It takes a creative mind to come up with new ideas. So how do you do it?
23:00 20-Apr-2017
SQLServerCentral - Main Articles
To fully appreciate just how different columnstore indexes are, and why work so well in reporting and online analytical processing (OLAP) workloads, but ...
23:00 20-Apr-2017
SQLServerCentral - Main Articles
To celebrate the recent launch of their new database provision tool, Redgate are giving you the chance to win a $10 Amazon or Starbucks gift card every ...
23:00 20-Apr-2017
SQLServerCentral - Main Articles
In this free demo webinar, Grant Fritchey and Arneh Eskandari will show how Redgate tools enable you to push and pull database changes in Git, then set ...
23:00 20-Apr-2017
SQLServerCentral - Questions
DECLARE v_Batch_Cd VARCHAR2(15); v_Run_Status VARCHAR2(20); vv_Run_status VARCHAR2(20); v_Batch_Nbr VARCHAR2(20); ...
14:16 20-Apr-2017
SQLServerCentral - Blogs
Yesterday was the Microsoft Data Amp event where a bunch of very exciting announcements were made: SQL Server vNext CTP 2.0 is now available and the ...
14:00 20-Apr-2017
SQLServerCentral - Questions
I have received the following error when attempting to set up a condition in policy based management using the Executesql function any help would be greatly ...
10:57 20-Apr-2017
SQLServerCentral - Questions
I have been asked to provide a solution for failover using just 2 servers (Primary and a Standby), 1 sql licence and san for storage. Just want to know ...
08:27 20-Apr-2017