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
Is it possible to validate a connection is using ApplicationIntent=ReadOnly? The application code shows that ApplicationIntent=ReadOnly is added to the ...
18:56 07-Jul-2015
DatabaseWeekly - Newsletter
Amazon's newest warehouse is testing the limits of automation and human-machine collaboration.Trenton, New Jersey, isn't the industrial powerhouse it ...
18:47 07-Jul-2015
DatabaseWeekly - Newsletter
Sessions of the event 24 Hours of PASS: Growing Our Community (which was held on last June 24-25) were recorded and now they are available for online ...
18:47 07-Jul-2015
DatabaseWeekly - Newsletter
In the previous articles on Always Encrypted, we used two sample applications (a console app and an ASP .NET web app) to demonstrate how to use Always ...
18:47 07-Jul-2015
SQLServerCentral - Blogs
This is part of a series on how to take the Adventureworks database and bring it in line with modern standards. How do we put a legacy SQL Server database ...
17:53 07-Jul-2015
DatabaseWeekly - Newsletter
Continuing on with my Partitioning post series, this is part 5. The partitioning includes several major components of work (and can be linked below); partitioning ...
17:47 07-Jul-2015
DatabaseWeekly - Newsletter
by Angela Guess Kenneth Cukier of The Economist recently wrote in the MIT Technology Review, "The basis of commercial enterprise is information. That ...
17:47 07-Jul-2015
DatabaseWeekly - Newsletter
A few years ago on road trips I'd happily grab whatever I can find to eat at service stations. That usually includes either McDonald's, KFC, or Burger ...
17:47 07-Jul-2015
DatabaseWeekly - Newsletter
by Angela Guess Lindsey Patterson recently wrote for Business 2 Community, "Hadoop is a software system developed by Apache that allows a company's data ...
17:47 07-Jul-2015
DatabaseWeekly - Newsletter
As we begin to get a grasp of all that is available with SQL Server 2016 and all of the new features, it is a great idea to see what else has been made ...
17:47 07-Jul-2015
DatabaseWeekly - Newsletter
Your enterprise doesn't have to be as big or complex as Lenovo to benefit from SAS-based analytics initiatives.
17:47 07-Jul-2015
DatabaseWeekly - Newsletter
There are a number of blog posts that have been written on this very topic. This can be from basics to almost advanced in many ways. I am outlining some ...
17:47 07-Jul-2015
DatabaseWeekly - Newsletter
by Jennifer Zaino Are you able to get a really good look at what the data in your graph database can tell you? A graph database such as Aurelius' Titan, ...
17:47 07-Jul-2015
DatabaseWeekly - Newsletter
The SSIS Project Deployment Model is great! It really is the best thing since sliced bread! I specifically appreciate the package execution logging and ...
17:47 07-Jul-2015
DatabaseWeekly - Newsletter
We always take NULL very lightly. Like if we are designing database then whether it is necessary or not we allow the data field to accept null.We think ...
17:47 07-Jul-2015
DatabaseWeekly - Newsletter
Editor's note: Full disclosure - the author is a developer and software architect at ArangoDB GmbH, which leads the development of the open source multi-model ...
17:47 07-Jul-2015
DatabaseWeekly - Newsletter
Recently, I ran into a critical error while I was helping a customer troubleshoot an issue in SQL Server. That may not sound like a big deal, but we were ...
17:47 07-Jul-2015
DatabaseWeekly - Newsletter
I've been doing SQL Critical Care® work with clients for over a year now. It's absolutely true that every client's situation is different and needs special ...
17:47 07-Jul-2015
DatabaseWeekly - Newsletter
Today brings good news for those of you with one drive bay and a hankering for lots of fast local storage: Samsung has just added 2TB solid-state drives ...
17:47 07-Jul-2015
DatabaseWeekly - Newsletter
Redgate, the SQL Server and .NET software company, returns to London and Seattle in October with its ...
16:47 07-Jul-2015
SQLServerCentral - Blogs
Constraints are sometimes annoying in real life, but no society can exist without rules and regulations. The same concept is found in Database Design: ...
16:06 07-Jul-2015
SQLServerCentral - Blogs
A few years ago on road trips I’d happily grab whatever I can find to eat at service stations. That usually includes either McDonald’s, KFC, ...
10:35 07-Jul-2015
SQLServerCentral - Blogs
Recently, I ran into a critical error while I was helping a customer troubleshoot an issue in SQL Server. That may not sound like a big deal, but we were ...
10:10 07-Jul-2015
SQLServerCentral - Questions
Hello, I am trying create a report for daily repayments confirmed in our banking database based on SQL 2014. I am creating the report by Report builder. ...
09:58 07-Jul-2015
SQLServerCentral - Blogs
Tweet G’Day, Well it seems like TSQL Tuesday #68 is providing me with a real good reason to get back into my blogging again. It been a while – ...
08:18 07-Jul-2015
SQLServerCentral - Questions
This issue was brought to my attention today. When returning a value from an Oracle database via a ...
23:20 06-Jul-2015
SQLServerCentral - Editorials
Today Steve Jones talks about the ways in which we interview new developers. Are they working or do we need a new way? Should we be considering those ...
23:00 06-Jul-2015
SQLServerCentral - Main Articles
Translating reports with Analysis Services 2012 and MS-Excel 2013 in a multilingual environment
23:00 06-Jul-2015
SQLServerCentral - Main Articles
I want to temporarily use a Log Shipped secondary database for Read Only operations, but Log Shipping was not configured for read only operations. I ...
23:00 06-Jul-2015
SQLServerCentral - Main Articles
Anthony Nocentino, experienced Enterprise Architect and Friend of Redgate, explains the challenges presented by monitoring Availability Groups and shows ...
23:00 06-Jul-2015
SQLServerCentral - Questions
I tried using this syntax alter table [Person].[Phonenumber] add column_name BusinessEntityID INT NOT NULL and got the error Msg 102, Level ...
20:56 06-Jul-2015
SQLServerCentral - Blogs
Continuing on with my Partitioning post series, this is part 5. The partitioning includes several major components of work (and can be linked below); partitioning ...
20:30 06-Jul-2015
SQLServerCentral - Blogs
  We always take NULL very lightly. Like if we are designing database then whether it is necessary or not we allow the data field to accept null.We ...
19:37 06-Jul-2015
SQLServerCentral - Questions
What is the difference between Build, Deploy and Process commands for an SSAS cube? Is there a specific order to these commands?
18:08 06-Jul-2015
DatabaseWeekly - Newsletter
As we begin to get a grasp of all that is available with SQL Server 2016 and all of the new features, it is a great idea to see what else has been made ...
16:47 06-Jul-2015
DatabaseWeekly - Newsletter
You can download the latest version of ClearTrace from my consulting site: scaleSQL Consulting.  I've decided to stop using the year as part of the version.  ...
16:47 06-Jul-2015
SQLServerCentral - Blogs
The SSIS Project Deployment Model is great! It really is the best thing since sliced bread! I specifically appreciate the package execution logging and ...
15:34 06-Jul-2015
SQLServerCentral - Questions
Hi, I've been using several role playing dimensions for my cube. One for "Sales Turnover", "Sales date", "Inventory turnover", etc. There is a fact table ...
14:10 06-Jul-2015
SQLServerCentral - Blogs
I frequently see statements on forums along the lines of “I don’t have a test server, so I’m going to do something I’ve never ...
11:49 06-Jul-2015