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


DatabaseWeekly - Newsletter
NULLs in SQL are a mixed blessing.The Three-Valued Logic of SQL has its uses but can cause difficulties to anyone who assumes that NULL has a 'value'. ...
12:47 01-Jul-2015
SQLServerCentral - Questions
Hi Friends, We are using SQL Server 2014 on Windows server 2008 Web edition (64 bit). Total RAM of OS is 8 GB .When we check high ...
12:21 01-Jul-2015
SQLServerCentral - Editorials
What's the best way to enter this business? Steve Jones has a few thoughts on the traditional CS degree.
23:00 30-Jun-2015
SQLServerCentral - Main Articles
In Level 7 of this stairway, we look at combining Availability Groups with FCIs for both HA and DR protection.
23:00 30-Jun-2015
SQLServerCentral - Main Articles
Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this ...
23:00 30-Jun-2015
SQLServerCentral - Main Articles
Unless development happens directly on the production database, every organization will manage one or more development and test instances. Redgate is ...
23:00 30-Jun-2015
SQLServerCentral - Blogs
It is a constant source of frustration for some people that it is hard to download SSDT or SSDT-BI or you download the wrong thing. This is an example ...
18:00 30-Jun-2015
SQLServerCentral - Questions
SQL Newbie here. I've inherited some older SQL Servers at my new job. I've been checking out their current maintenance plans and came across the following: ...
16:23 30-Jun-2015
SQLServerCentral - Blogs
I know a few people in the SQL Server community who have been involved in Scouting. A couple of them have taken or helped lead Scoutings leadership training ...
12:38 30-Jun-2015
DatabaseWeekly - Newsletter
You want to implement Continuous Integration for Databases and you know why, but you need to get buy-in from your managers and colleagues. How do you ...
11:46 30-Jun-2015
SQLServerCentral - Questions
I am trying to build a table detailing historical price changes from a system extract that has generated an audit line every time a change has been made ...
11:35 30-Jun-2015
SQLServerCentral - Blogs
By Steve Bolton ....It may be called Minitab, but SQL Server users can derive maximum benefits from ...
11:02 30-Jun-2015
SQLServerCentral - Blogs
I'm excited to see the future of Sql server management studio with release of SQL Management Studio 2015 Preview. http://bit.ly/1LSu0Ek Two of the points ...
11:00 30-Jun-2015
Simple-Talk - Blogs
Microsoft have now publicly announced that they will release Visual Studio 2015 (along with .NET 4.6 and TFS 2015) on July 20th. Redgate is a SimShip ...
10:33 30-Jun-2015
SQLServerCentral - Questions
Is it possible to connect together SQL query 45 MDF LDF DETABESE to get report in excel one short in 45 sheets.
10:02 30-Jun-2015
SQLServerCentral - Questions
We have implemented our software in SQL server 2008 r2 Standard DB. Client has bought Sql server 2014 standard. I believe r2 will work on 2014. But I ...
03:17 30-Jun-2015
SQLServerCentral - Editorials
Work is important, and it's a large part of our lives, but Steve Jones notes we need to keep things in perspective.
23:00 29-Jun-2015
SQLServerCentral - Main Articles
One of the benefits of a version control system (VCS) is that you can look at the history of code changes. Ed Elliot shows us a situation where that helps ...
23:00 29-Jun-2015
SQLServerCentral - Main Articles
Consider a situation when you have a large number of databases on your SQL Server, and you are requested to grant user access to all SQL Server databases. ...
23:00 29-Jun-2015
SQLServerCentral - Blogs
It's this time of the year again, when PASS announces the speakers in the biggest SQL Server event in the world - PASS Summit. Like many others, I submitted ...
20:45 29-Jun-2015
SQLServerCentral - Questions
Respected Sirs, I wanted to know which is the best book now in markt for SQL 2012 writing queries. I am Low to medium in SQL Queries But wanted to become ...
17:31 29-Jun-2015
DatabaseWeekly - Newsletter
A new course from Code School. ?Learn the most important parts of the SQL language so you can create tables with constraints, use relationships, and write ...
15:46 29-Jun-2015
Simple-Talk - Blogs
If you share a database with other developers, chances are you've encountered a situation like this: 1. Alice starts editing an object. 2. Meanwhile, ...
15:10 29-Jun-2015
SQLServerCentral - Blogs
I recently recorded a podcast with the SQL Server Radio group and discussed virtualization, high availability, and independent consulting topics. I had ...
14:20 29-Jun-2015
SQLServerCentral - Blogs
Reading Time: 1 minutes Let’s Play A Game! So, just to tickle your fancy, here is... The post Sneak Preview – Podcast 010 appeared first on ...
12:30 29-Jun-2015
SQLServerCentral - Blogs
Microsoft is all about rapid release cycles nowadays. We already experienced this with Power BI, where monthly new features and improvements have been ...
11:59 29-Jun-2015
SQLServerCentral - Blogs
A few weeks ago, while at SQL Saturday Philadelphia, Chris Bell, SQL Server MVP and co-leader of PASS DC user group graciously sat me down and talked. ...
11:10 29-Jun-2015
SQLServerCentral - Blogs
A few months ago I wrote a post about the fact that I had actually submitted a session to PASS Summit. Well as I’m sure you are aware the selected ...
11:00 29-Jun-2015
SQLServerCentral - Blogs
A little while back SQL Server 2016 CTP2 was announced and I have spent some time playing with it (read: spent hours creating a VM because there were ...
10:40 29-Jun-2015
SQLServerCentral - Questions
id date diffdays 1 1/1/2015 0 1 1/2/2015 1 1 1/4/2015 2 2 1/1/2015 0 2 1/10/2015 9![alt text][1] 2 2/4/2015 25 ...
10:19 29-Jun-2015
SQLServerCentral - Questions
any one tell me plz
07:40 29-Jun-2015
SQLServerCentral - Blogs
Hi All, Major expectation raised by user for SharePoint other then Search ,is to have Good User Experience ...
04:50 29-Jun-2015
Simple-Talk - Opinion and Geeks
DevOps isn't a particular technology, nor a job role. It is more of a software development method, initiating originally from system administrators, that ...
by Adam Bertram
00:00 29-Jun-2015
Simple-Talk - Opinion and Geeks
We all use software, and we all find it alarmingly easy to find bugs in it. Does that mean that we have a natural talent for testing software? Devyani ...
by Devyani Borade
00:00 29-Jun-2015
SQLServerCentral - Editorials
Steve Jones has a new take on what it means to be a DBA.
23:00 28-Jun-2015
SQLServerCentral - Main Articles
Foreign Keys are one of the fundamental characteristics of relational databases and enforce the referential integrity. Is it a good idea to index a FK ...
23:00 28-Jun-2015
SQLServerCentral - Main Articles
References and links to help you learn how to create multiple tempdb files. FREE eBook - "45 Database Performance Tips for Developers"Improve ...
23:00 28-Jun-2015
SQLServerCentral - Main Articles
Automation - done right - frees you to add real value to your team, but you've got to be careful not to shoot yourself in the foot. Join Brian A. Randell, ...
23:00 28-Jun-2015
SQLServerCentral - Blogs
Continuation from the previous 56 parts, the whole series can be found at http://www.nikoport.com/columnstore/ In this post I want to focus on a very ...
19:03 28-Jun-2015