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 have a SQL Server 2012 and the logs state "The SQL Server Network Interface library successfully registered the Service Principal Name (SPN) [ MSSQLSvc/SHSTNFDBV1.testaapdomain.local:1433 ...
19:25 28-Apr-2016
DatabaseWeekly - Newsletter
Microsoft's cofounder vows to change the "supply side" for breakthrough energy technologies by investing billions of his and his friends' dollars.
17:44 28-Apr-2016
DatabaseWeekly - Newsletter
We're excited to announce that the latest preview of the Mobile Report Publisher was released last week and is now available for SQL Server 2016. This ...
17:44 28-Apr-2016
DatabaseWeekly - Newsletter
The AlwaysOn log transport uses a SQL Broker based design to send and receive messages between the primary ...
17:44 28-Apr-2016
DatabaseWeekly - Newsletter
Every time I look at my ForEach NodeList Enumerator post, I struggle to remember how to do half of it. Plus, as I discovered today, I am inconsistent ...
17:44 28-Apr-2016
DatabaseWeekly - Newsletter
Earlier this week, I posted a follow-up to my my recent post about STRING_SPLIT() in SQL Server 2016, addressing several comments left on the post and/or ...
17:44 28-Apr-2016
DatabaseWeekly - Newsletter
This is a very exciting time for Chocolatey! Over the past 5 years, there have been some amazing points in Chocolatey's history. Now we are less than ...
17:44 28-Apr-2016
DatabaseWeekly - Newsletter
I've been a working IT pro since 1997, and in that time, I've seen lots of changes. A new era has recently started, and many of the clues suggest that ...
17:44 28-Apr-2016
DatabaseWeekly - Newsletter
Microsoft recently updated their policies and recommendations for installing cumulative updates. Now, ...
17:44 28-Apr-2016
DatabaseWeekly - Newsletter
This blog post is not what I was intending to write, at least not so early in my list of blog postings. Mainly due to the fact that it's main issue is ...
17:44 28-Apr-2016
DatabaseWeekly - Newsletter
SQL Server 2016 and Azure SQL Database have increased the maximum size for index keys with nonclustered indexes. The new maximum key size for nonclustered ...
17:44 28-Apr-2016
DatabaseWeekly - Newsletter
As I have been watching what has been going on recently in the Windows and SQL Server world, I have come to the conclusion that it is a particularly exciting ...
17:44 28-Apr-2016
DatabaseWeekly - Newsletter
In SQL Server 2014 we introduced a revamped Cardinality Estimator (CE), which we further improved in SQL Server 2016 and Azure SQL Database. With the ...
17:44 28-Apr-2016
DatabaseWeekly - Newsletter
azon Unlimited is a all-you-can-read service. You pay one price and can read anything that's in the program. Amazon pays authors out of a fixed pool, ...
17:44 28-Apr-2016
DatabaseWeekly - Newsletter
The auto-update statistics configuration updates statistics when the amount of row changes in the table achieves 20% of total rows.
17:44 28-Apr-2016
DatabaseWeekly - Newsletter
I pity the fool who needs to shrink his database!
17:44 28-Apr-2016
DatabaseWeekly - Newsletter
I certainly didn't expect it would go this far when I built Have I been pwned (HIBP) a few years ago, ...
17:44 28-Apr-2016
DatabaseWeekly - Newsletter
This is the fourth post in a series of twelve in Tim Fords Entry-Level Content Challenge. In this blog post, I will explain how SQL Server deals with ...
17:44 28-Apr-2016
DatabaseWeekly - Newsletter
Years ago I wrote about how SQL Server stores VARCHAR columns in the Navigation Structure of an index.
17:44 28-Apr-2016
DatabaseWeekly - Newsletter
SQL Server 2016 enhanced the bulk insert activities (BULK INSERT), leveraging the CPUs vector instructions. ...
17:44 28-Apr-2016
DatabaseWeekly - Newsletter
This is a tip that should help installing SQL Server 2016 (tested on CTP33, RC2 and RC3) Master Data Services. The documentation is pretty old and incomplete ...
17:44 28-Apr-2016
SQLServerCentral - Questions
I have a table that lists file-names that have been created on an App server. Goal: I want to keep the list of files in the SQL server table and the list ...
15:19 28-Apr-2016
SQLServerCentral - Blogs
The April MVP nomination is Chris Yates (B|T). Chris is one of those individuals that always have a positive outlook on life which infectious.  He hails ...
13:00 28-Apr-2016
SQLServerCentral - Blogs
In case you haven’t noticed, Power BI added a new feature in preview mode: row level security (RLS). This blog post describes how you  can use this ...
11:18 28-Apr-2016
SQLServerCentral - Questions
I want to install the sql server programmatically. 1. Is there any open program to install it? 2. In which language is it possible to install, if ...
10:34 28-Apr-2016
SQLServerCentral - Blogs
My new course "Understanding and Using Essential Tools in Enterprise Linux 7" in now available on Pluralsight ...
10:09 28-Apr-2016
SQLServerCentral - Questions
Is there any way to set audible(sound) alert in sql server job activity monitor if any jobs has been failed, there is already email notification is available ...
10:03 28-Apr-2016
SQLServerCentral - Questions
Hi I need to filter 80 % of matrix data. I used runningvalue/dataset_total to find this. But unable to filter since runningvalue cant be used in filters.. How ...
09:08 28-Apr-2016
SQLServerCentral - Questions
Good Day, I have issue with my sql server 2012, frequent recveive file group running out of space. Can you please help me out
08:47 28-Apr-2016
SQLServerCentral - Questions
I am looking to update the list of selected defaults for parameter in SSRS. I have created the first parameter, and the second parameter gets it's default ...
08:18 28-Apr-2016
SQLServerCentral - Questions
I have been created a SQL Server authentication login in the system which i install SQL Server, So now can i connect to database engine via SQL authentication ...
05:17 28-Apr-2016
SQLServerCentral - Editorials
Could someone remove data from all systems and backups?
23:00 27-Apr-2016
SQLServerCentral - Main Articles
Learn how to use Biml to create a SSIS-package with a Script component that can read from Twitter.
23:00 27-Apr-2016
SQLServerCentral - Main Articles
In this article, Marcin Policht describes the basic functionality and implementation steps for Azure SQL Database's Elastic Database jobs.
23:00 27-Apr-2016
SQLServerCentral - Questions
We want to take a group out of sysadmin but grant them a role so they can do following 1. add, change, remove database access on prod servers for users, ...
22:08 27-Apr-2016
SQLServerCentral - Questions
I have a trigger on a master table for a specific field that when I update that field I want to populate four (4) other fields on another master table. ...
21:17 27-Apr-2016
SQLServerCentral - Questions
Hi All, Myself recruiter looking for Female Sql server DBA in Braselton, GA. It is Full time position. ...
21:10 27-Apr-2016
SQLServerCentral - Blogs
data structures are art If anyone thinks that working with complex data structures is boring... I don't know what world they live in. The problem is ...
17:09 27-Apr-2016
SQLServerCentral - Blogs
  This post is a requirement from one of my blog reader. There are plenty of scripts available to get the backup status of the databases across multiple ...
15:02 27-Apr-2016