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
Hi friends, in this post we will discussed another limitation of In-Memory OLTP that in-memory tables ...
03:06 12-Feb-2016
SQLServerCentral - Questions
Hi, Please be so kind as to point me in the right direction with regards to my SQL case select query: My case statement currently reads as follow: ...
18:11 11-Feb-2016
Simple-Talk - Blogs
“Does anyone actually do this stuff?” This question came from a member of the audience at one of Brent Ozar’s training classes on SQL ...
18:00 11-Feb-2016
SQLServerCentral - Questions
HI. I have a requirement to change the dbid of the database and increase the priority of the start up of the database.
16:49 11-Feb-2016
SQLServerCentral - Blogs
I was talking with some of our support people recently about permissions on DLM Dashboard. A client was having issues, and we weren't sure what was wrong. ...
16:43 11-Feb-2016
SQLServerCentral - Blogs
Text Mining with RapidMiner for Loch Ness Monster Sightings Text mining involves pulling root words from text in a system.  In this example, I pulled ...
12:33 11-Feb-2016
SQLServerCentral - Blogs
Join Eitan Blumin in the next video of his DocumentDB Tutorials. This time learn how to work with the documents themselves. If you still haven't, be sure ...
09:25 11-Feb-2016
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
Simple-Talk - SQL Articles
Have you ever longed for a way of making the delivery of databases more visible, predictable and measurable? Do you ever wish that they would be of ...
by Grant Fritchey
00:00 10-Feb-2016
Simple-Talk - SysAdmin Articles
'Desired State Configuration (DSC) is an essential part of the configuration, management and maintenance of Windows-based servers. It allows a PowerShell ...
by Nicolas Prigent
00:00 10-Feb-2016
SQLServerCentral - Editorials
8 must-have SQL Server toolsThe SQL Developer Suite contains 8 tools for faster, simpler SQL Server development. Download a free ...
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