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 - Blogs
I've used Windows Live Writer for almost as long as I've been blogging (mid 2007 or so). It's worked well enough and I've liked having an offline editor. ...
01:56 11-Feb-2016
SQLServerCentral - Editorials
Steve Jones talks about the timeframes for updating and fixing security problems in applications.
00:00 11-Feb-2016
SQLServerCentral - Main Articles
Because SSIS is case sensitive, random VS_NEEDSNEWMETADATA errors on case-insensitive databases may indicate issues in your database change management ...
00:00 11-Feb-2016
SQLServerCentral - Main Articles
Rajendra Gupta takes a look at the additional enhancements made to Row Level Security in SQL Server 2016 CTP 3.1 and explores the new features with examples. ...
00:00 11-Feb-2016
SQLServerCentral - Main Articles
Are you thinking about the cloud yet? Redgate is conducting some research into cloud adoption to better understand both the drivers and the blockers. ...
00:00 11-Feb-2016
SQLServerCentral - Questions
I have been asked to enhance a listing for a report. The request is to provide prior values for Operation_code, operation_sequencer, and Labor_clockindate. ...
23:21 10-Feb-2016
SQLServerCentral - Questions
Hello I have couple of tables Table one Customer InitialProgramDate 24145 1/5/2011 24593 5/6/2011 Table Two Customer ...
23:21 10-Feb-2016
SQLServerCentral - Questions
I have been asked to enhance a listing for a report. The request is to provide prior values for Operation_code, operation_sequencer, and Labor_clockindate. ...
20:18 10-Feb-2016
SQLServerCentral - Blogs
Thanks for attending tonight's joint meeting of the Baton Rouge .NET/SQL/PowerBI User Groups, which was sponsored by Idera!I presented a lightning round ...
19:22 10-Feb-2016
Simple-Talk - Blogs
There are a few reasons you can get the "The node to be inserted is from a different document context." ...
17:16 10-Feb-2016
SQLServerCentral - Blogs
Even though an Azure SQL Database stores all data on the Azure cloud, it does not mean that your options for managing and monitoring the databases are ...
16:00 10-Feb-2016
SQLServerCentral - Blogs
While working on the Advent of Code problems in SQL, I ran across something interesting. Day 4 involves hashing, which is done with the HASHBYTES function ...
15:54 10-Feb-2016
SQLServerCentral - Blogs
In my last post "Copying SSIS packages With DTUTIL" I described a "gotcha" where the dynamic management views (DMVs) had different columns in SQL Server ...
15:21 10-Feb-2016
SQLServerCentral - Blogs
  Many traits make up data professionals and the many who find themselves in leadership roles. The traits being shared in this blog post are ones ...
14:30 10-Feb-2016
SQLServerCentral - Blogs
Clearing out a full transaction log is a common problem. A quick search will find you dozens of forum entries and blog posts. Because of that I’m ...
14:00 10-Feb-2016
SQLServerCentral - Questions
As per my understanding "Always ON" configuration internally have two nodes and active node will always serve the request. But suppose I have SQL Jobs ...
08:27 10-Feb-2016
SQLServerCentral - Editorials
00:00 10-Feb-2016
SQLServerCentral - Main Articles
Understand what FK's do and how they use indexes. Then use my script to see if they're using good indexes.
00:00 10-Feb-2016
SQLServerCentral - Main Articles
Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that ...
00:00 10-Feb-2016
SQLServerCentral - Main Articles
Are you thinking about the cloud yet? Redgate is conducting some research into cloud adoption to better understand both the drivers and the blockers. ...
00:00 10-Feb-2016
SQLServerCentral - Blogs
Earlier today I had the pleasure of speaking with the PASS Business Intelligence Virtual Chapter on ...
21:20 09-Feb-2016
DatabaseWeekly - Newsletter
This book aims to get the newcomer started in SQL Server development, how does it fare?
19:42 09-Feb-2016
SQLServerCentral - Questions
I'm trying to install sql server 2012 in windows 8.1. After accepting terms & conditions,its going to ...
19:06 09-Feb-2016
SQLServerCentral - Questions
I need to examine a user database with a corrupted logfile ("the logscan number ... is not valid"). This database is in full recovery mode. Due to this ...
17:18 09-Feb-2016
SQLServerCentral - Blogs
What an amazing week! VMware has announced the full list of VMware vExperts for the first half of the 2016 cycle, and I'm honored to say that I have been ...
15:02 09-Feb-2016
SQLServerCentral - Blogs
In a similar vein to last week's blog post. I heard an interesting comment recently. "Change that Column != 2 to a Column > 2 or Column < 2 combination, ...
14:30 09-Feb-2016
SQLServerCentral - Blogs
How much hospitals charge for the same type of cases compared with the average across the US and other cities around the world (limited data)? The data ...
14:29 09-Feb-2016
SQLServerCentral - Questions
I have a publication which is intended to push data to a subscriber over the internet from a remote server to our onsite local subscriber but it ends ...
13:55 09-Feb-2016
SQLServerCentral - Blogs
Just a short post for a Tuesday to let you that I will delivering Learning Tree's 534 Developing SQL Queries for SQL Server course in Learning Tree's ...
13:00 09-Feb-2016
SQLServerCentral - Blogs
Until now we have seen the windows memory addressing concepts.http://sqlandmorewithkruti.blogspot.in/2016/01/memory-fundamentals-for-sql-server.htmlhttp://sqlandmorewithkruti.blogspot.in/2016/02/memory-fundamentals-for-sql-server-awe.htmlSo ...
12:22 09-Feb-2016
SQLServerCentral - Questions
I have two tables. Users and UserInformation UserID is a primary key in Users and a foreign key in UserInformation There is only one user in the User ...
10:42 09-Feb-2016
SQLServerCentral - Questions
Help We've recently upgraded to SQL Server 2014 and I need to convert all of the datetime columns to datetime2 in a specific database. Thanks Tim
10:33 09-Feb-2016
DatabaseWeekly - Newsletter
Many software teams are already integrating their application code but haven't yet brought the continuous integration discipline to their database development. ...
08:42 09-Feb-2016
DatabaseWeekly - Newsletter
New version includes a first of its kind Pipeline Builder, for a significantly easier automated database deployment pipeline, enabling users to visually ...
08:42 09-Feb-2016
SQLServerCentral - Questions
Hello, May anyone please help me on this. database: SQL SERVER 2008 18 Million records i have two table and i need to check missing rows between two ...
08:23 09-Feb-2016
SQLServerCentral - Blogs
Hi friends, in this blog we will discussed another limitation of In-Memory OLTP that seed and increment ...
03:01 09-Feb-2016
Simple-Talk - SQL Articles
You can still do Database Lifecycle Management (DLM) workflows in the hosted version of Team foundation Server (TFS) in Visual Studio Team Services (VSTS) ...
by Jason Crease
00:00 09-Feb-2016
SQLServerCentral - Editorials
Public records have been open in the past, but today's digital access might mean problems.
00:00 09-Feb-2016
SQLServerCentral - Main Articles
Enabling Transparent Data Encryption on Databases in Always On Scenario
00:00 09-Feb-2016