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
Hi all, I'm learning SSIS, so sorry if this question is too primitive. I added a For Loop container to control flow and then added script task inside ...
by HarveyAx
21:28 30-Jul-2014
SQLServerCentral - Questions
Hello, I have two servers server 'A' and server 'B'. server A has logins which are dbo i.e, the logins are just the database name so when some one login, ...
by sqlrookie
21:16 30-Jul-2014
SQLServerCentral - Blogs
I am taking a slight deviation from the usual type of posts that I share.  This time, I just want to share a quick and easy fix that I ran across due ...
21:00 30-Jul-2014
DatabaseWeekly - Newsletter
Let's say you've got a vendor application that creates tables, loads them, queries them, and drops them all the time. You can't change the code. The tables ...
16:47 30-Jul-2014
DatabaseWeekly - Newsletter
Creating a non-clustered Columnstore index will make the index as well as the base table read-only, which means you can't insert, update, or delete any ...
16:47 30-Jul-2014
DatabaseWeekly - Newsletter
Oracle 12.1.0.2 was recently released with some fanfare. One of the most talked about features is Oracle Database In-Memory, but there's more to this ...
16:47 30-Jul-2014
DatabaseWeekly - Newsletter
Klaus Aschenbrenner on Update Locks in SQL Server, and why they are needed to avoid deadlock situations and decreased concurrency.
16:47 30-Jul-2014
DatabaseWeekly - Newsletter
Argenis Fernandez demonstrates that you can, indeed, script out contained database users and recreate them on another database, as either contained users ...
16:47 30-Jul-2014
DatabaseWeekly - Newsletter
How can you calculate the value of your overdue invoices on any given date? Not just invoices that are ...
16:47 30-Jul-2014
DatabaseWeekly - Newsletter
Per CPU partitioned output works to reduce the impact of tracing the production server. However, the divide and conquer activity for capture means you ...
15:47 30-Jul-2014
DatabaseWeekly - Newsletter
This blog describes locking behavior when data is inserted through Bulk Load command, when using a clustered column store index
15:47 30-Jul-2014
DatabaseWeekly - Newsletter
In the first in a series on the practicalities of using the Microsoft Azure Platform for the SQL Server ...
15:47 30-Jul-2014
DatabaseWeekly - Newsletter
One of the fixes included in Cumulative Update 11 for SQL Server 2008 R2 Service Pack 2 addresses an "incorrect deadlock" that can occur in a specific ...
15:47 30-Jul-2014
DatabaseWeekly - Newsletter
For small applications with small databases, migrating applications to the cloud can be pretty straight forward. However as the complexity and volume ...
15:47 30-Jul-2014
DatabaseWeekly - Newsletter
SSAS security roles are additive - that is, a user gets permission to access data allowed in any role to which the user belongs, even if another role ...
15:47 30-Jul-2014
DatabaseWeekly - Newsletter
It is awkward to do 'Graph databases' in SQL to explore the sort of relationships and memberships in social networks because equivalence relations are ...
15:47 30-Jul-2014
DatabaseWeekly - Newsletter
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. ...
15:47 30-Jul-2014
DatabaseWeekly - Newsletter
A robust detailed documentation library creates an environment that is less complex, less error-prone, reduces the amount of time DBAs spend learning ...
15:47 30-Jul-2014
SQLServerCentral - Blogs
If you’re in Seattle the week of November 2 – say, for example, you’re attending the ...
15:08 30-Jul-2014
SQLServerCentral - Questions
We are on sqlserver 2008r2 and my guess is during the upgrade from sql 2005 to 20008r2, some of the databases has the Compatibility level SQL Server 2000(80) ...
by chitrarekha.saha
14:39 30-Jul-2014
SQLServerCentral - Blogs
Notes: Email with the schedule went out this week, nice bump in registrations - we're at 229 today Mailed the list twice (bad) because the bulk loaded ...
14:39 30-Jul-2014
SQLServerCentral - Questions
I have executed `sp_spaceused` and get the following data: database_name database_size unallocated space test 482767.63 MB 166888.50 ...
by gotqn
13:13 30-Jul-2014
SQLServerCentral - Questions
I have a table containing a column of data type xml. I have to create index on this column, since I have to join and also has queries with search criteria. If ...
by rudrapbiswas
12:56 30-Jul-2014
SQLServerCentral - Blogs
Did you know that whatever columns you pick as your clustered index will be included in any non clustered indexes on the same table? But don’t ...
11:00 30-Jul-2014
SQLServerCentral - Questions
Hi, Hope someone can help with this. I've created an SSRS report with a parameter for product. Say a user wants to run a report filtered on a specific ...
by query
10:13 30-Jul-2014
SQLServerCentral - Questions
![alt text][1] [1]: /storage/temp/1612-test2.png the following are procedure that display Thresher ...
by omprakashsah
10:02 30-Jul-2014
SQLServerCentral - Editorials
The elevation of privileges is a large security problem and Steve Jones discusses his fears. Would you know if someone successfully attacked your instance? ...
23:00 29-Jul-2014
SQLServerCentral - Main Articles
Set a security standard across environments that developers can see and run, but not change. "A real time saver" Andy Doyle, Head of ...
23:00 29-Jul-2014
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 29-Jul-2014
SQLServerCentral - Main Articles
One option to get notified when TempDB grows is to create a SQL Alert to fire a SQL Agent Job that will automatically send an email alerting the DBA when ...
23:00 29-Jul-2014
SQLServerCentral - Questions
I have a table with two different versions. The latest release contains one extra column. However, I need to do an insert statement like the following ...
by chung
20:30 29-Jul-2014
SQLServerCentral - Blogs
So the title says it all, right?  Well, only really partially. Recently an article was published listing the top 10 most recommended books for SQL Server. ...
15:49 29-Jul-2014
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