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 could teach my cat this in respect to, Endovex. I gather I'm following a similar strategy with Endovex. You want to avoid Endovex at all costs. As always, ...
08:36 24-Apr-2017
SQLServerCentral - Questions
Hi Gems, I have created a composite primary key on 2 columns, one of the column is encrypted. but when I am fetching two column data with decrypt, I ...
08:21 24-Apr-2017
SQLServerCentral - Blogs
Back after a couple of busy weeks, kinda looking forward to getting back into the old work routine (ah, well maybe ) Last week was a big week, I had ...
06:54 24-Apr-2017
SQLServerCentral - Blogs
I hope you take backups or have a recovery plan in place before a SQL Server service pack upgrade,  if not you might want to reconsider. Initially I wasn't ...
04:55 24-Apr-2017
SQLServerCentral - Editorials
Have you ever given up on your brainchild? If yes, how did you deal with it? How to fix SQL Server disk I/O bottlenecks (without a ...
23:00 23-Apr-2017
SQLServerCentral - Main Articles
In my project I see that people writes different things with EXISTS logical operator (EXISTS (SELECT StarOrOne FROM...)). They are "*", "1" ...
23:00 23-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 23-Apr-2017
SQLServerCentral - Main Articles
This article demonstrates using React and the CData API Server to build dynamic Web pages using SQL Server data.
23:00 23-Apr-2017
SQLServerCentral - Main Articles
The Redgate Foundry team have been researching data masking, and have found that generally speaking there's six common approaches. In this blog post, ...
23:00 23-Apr-2017
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 remember writing an article about Query specific wait statistics being available inside execution plans in SQL Server 2016 SP1. The way that works is ...
17:56 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