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 some databases with compatible level sql Server 2005 with Page Verify Torn_Page_Detection, can I change that to checksum? However if the database ...
by chitrarekha.saha
14:26 29-Jul-2014
SQLServerCentral - Blogs
As I've discussed in some of my previous posts, creating a non-clustered Columnstore index will make the index as well as the base table read-only. Which ...
09:13 29-Jul-2014
SQLServerCentral - Blogs
Today, We will go through with the steps of renaming or changing SQL Server Standalone Named Instance. Renaming or Changing SQL Server Standalone Named ...
08:22 29-Jul-2014
SQLServerCentral - Questions
Hi, I came across a requirement to insert result of stored procedure into a global temp table. Stored procedure name will be passed as a paramter. 1) I ...
by Swapnil
06:38 29-Jul-2014
Simple-Talk - Cloud Articles
Although the Cloud gives us the freedom of using, and paying for, computing resources only when we need them, the public cloud isn't a universal panacea. ...
by Robert Sheldon
00:00 29-Jul-2014
SQLServerCentral - Editorials
SQL Saturday continues to set records, and Steve Jones is amazed at the latest data.
23:00 28-Jul-2014
SQLServerCentral - Main Articles
CONNECT ANY DATABASE is one of three new permissions in SQL Server 2014 that can be granted to server logins. What is this new permission good for and ...
23:00 28-Jul-2014
SQLServerCentral - Main Articles
Here are seven practical tips for any 'accidental DBA' or developer, faced with having to deploy an upgrade to a database live to production, in a development ...
23:00 28-Jul-2014
SQLServerCentral - Questions
I have a sql cluster and nothing has changed on it but when I came in today I am seeing errors in the cluster log, saying it cant bring the SQL Network ...
by butterfly
20:00 28-Jul-2014
SQLServerCentral - Questions
The hard drive is encrypted using TrueCrypt (entire drive) and it would not allow me to copy anything ...
by cgastler
19:06 28-Jul-2014
SQLServerCentral - Questions
I was working with several programs open - You Tube, Visual Studio, SQL Server, Demo9 (movie maker), when my Windows 8.1 operating system gave a me a ...
by haughtchick
18:23 28-Jul-2014
SQLServerCentral - Blogs
A recent Connector showed the following stats for SQLSaturday for the fiscal year ending June 30, 2014 and mentioned 86 events completed:   Impressive ...
16:20 28-Jul-2014
SQLServerCentral - Blogs
More notes: In hindsight it's easy to see we should have worked on the email template first, then the flyers. Email is our #1 way of communicating and ...
15:53 28-Jul-2014
SQLServerCentral - Questions
.on 10.50.2500.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 10:30:00 AM Progress: 2014-07-28 10:30:02.62 ...
by chitrarekha.saha
15:34 28-Jul-2014
SQLServerCentral - Blogs
Recently I wrote about what it means that a value is NULL. Right at the beginning I mentioned ANSI_NULLS and said I would discuss it later. Well it’s ...
11:00 28-Jul-2014
SQLServerCentral - Blogs
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need ...
09:46 28-Jul-2014
SQLServerCentral - Blogs
I am very happy to announce that my first book “SQL Server 2014 Development Essentials” has now been published by Packt Publishing. SQL Server ...
09:21 28-Jul-2014
Simple-Talk - SQL Articles
It is awkward to do 'Graph databases' in SQL to explore the sort of relationships and memberships in social networks because equivalence relations are ...
by Joe Celko
00:00 28-Jul-2014
Simple-Talk - .NET Articles
The .NET 4.5 async/await commands provide an opportunity for improving the scalability and performance of applications, particularly where tasks are more ...
by Jon Smith
00:00 28-Jul-2014
Simple-Talk - Cloud Articles
In the first in a series on the practicalities of using the Microsoft Azure Platform for the SQL Server ...
by Buck Woody
00:00 28-Jul-2014
SQLServerCentral - Editorials
It can be frustrating to deal with poorly implemented systems, but Steve Jones notes that you can't take things into your own hands.
23:00 27-Jul-2014
SQLServerCentral - Main Articles
This article describes an easy way to handle calculation based on fiscal year and quarter
23:00 27-Jul-2014
SQLServerCentral - Main Articles
In this article, we'll be focusing on the different ways you can build with a Cloud Service, and what exactly happens in terms of virtual machines when ...
23:00 27-Jul-2014
SQLServerCentral - Blogs
There are many blog posts talking about, how to recover "SysAdmin" password in case if it's lost OR the server is new to you and no idea that has own ...
06:25 27-Jul-2014
SQLServerCentral - Blogs
The 1st cumulative update release for SQL Server 2012 Service Pack 2 is now available for download at ...
04:39 27-Jul-2014
SQLServerCentral - Questions
`enter code here`enter code heremy question is ,, how to build a diagram, I don't understand that many to many , or one to many and about primary key ...
by andybr
22:58 26-Jul-2014
SQLServerCentral - Questions
My laptop accidentally tripped on the stairs and this was out. When I turned on the laptop normally and wanted to connect to a database sql server 2008, ...
by mizquierdo
22:09 25-Jul-2014
SQLServerCentral - Questions
Problem with Formatting please find attachment Basically i have three Tables Request ID Parent ID Account Name Addresss 1452 ...
by chethanmalur
19:15 25-Jul-2014
SQLServerCentral - Blogs
Yesterday I presented about Change Data Capture for the Pragmatic Works Free Training on the T’s. I covered the basics of what Change Data Capture ...
16:29 25-Jul-2014
SQLServerCentral - Blogs
I will be giving a presentation on ETL (Extract, Transform, Load) security at two user groups in the coming weeks. Securing the ETL Pipeline We’re ...
15:36 25-Jul-2014
SQLServerCentral - Blogs
Photo credit – Husso I’ve always been a fan of the feeling when I find an old blog post that’s got just the information that I need ...
15:00 25-Jul-2014
DatabaseWeekly - Newsletter
Even if you aren't running SQL Server, but want to understand best how to build high performance Azure IaaS applications, this article has a wealth of ...
14:47 25-Jul-2014
DatabaseWeekly - Newsletter
Raw numbers are easy to report and analyze, but without the proper context, they can be misleading. Is the effect you're seeing real, or a simple result ...
14:47 25-Jul-2014
SQLServerCentral - Questions
Hello: Although recall seeing the following option in SQL 2005 in the past, but unable to see it on an installation now. Any idea where this is hidden? ...
by Mansour Shoari
14:40 25-Jul-2014
SQLServerCentral - Questions
In C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log there are log files created not everyday but may be two or 3 per day. I am ...
by chitrarekha.saha
14:15 25-Jul-2014
SQLServerCentral - Questions
Hi, We are Currently using SQL Server 2008. We have SQL Server 2000 (80) Compatibility----6 Databases We have SQL Server 2005 (90) Compatibility----5 ...
by sqlqa
13:54 25-Jul-2014
DatabaseWeekly - Newsletter
In a series of articles will look at how to use Node.js with some of the most popular products and platforms like SQL Server, MongoDB, Microsoft Azure, ...
13:47 25-Jul-2014
DatabaseWeekly - Newsletter
The 2014 HIMSS Analytics Cloud Survey documents the use and concerns of healthcare organizations use ...
13:47 25-Jul-2014
DatabaseWeekly - Newsletter
Backup should never be treated as a "one-size fits all" thing. Your backup and recovery mechanisms need to be matched to your particular technological ...
13:47 25-Jul-2014