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
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 take my ...
17:47 31-Jul-2014
DatabaseWeekly - Newsletter
PASS VP of Marketing Denise McInerney - a SQL Server MVP and Data Engineer at Intuit - began her career ...
17:47 31-Jul-2014
DatabaseWeekly - Newsletter
Microsoft issues a warning on a Windows Server conflict that's a model of clarity and insight. Yes, ...
17:47 31-Jul-2014
DatabaseWeekly - Newsletter
In addition to the usual questions challenging the candidate's knowledge of such things as b-trees, object permissions, database recovery models, and ...
17:47 31-Jul-2014
DatabaseWeekly - Newsletter
Current SSD recommendations, split into different categories by form factor and performance.
17:47 31-Jul-2014
DatabaseWeekly - Newsletter
Chris Skorlinski explain how to use SQL Server Replication technologies to move data between local on premises SQL Server to SQL Server running in Windows ...
16:47 31-Jul-2014
DatabaseWeekly - Newsletter
A technique that involves auditing successful logins for a certain period, so that they are written to the error log,and then importing the data to a ...
16:47 31-Jul-2014
DatabaseWeekly - Newsletter
I recently discovered an undesirable behavior of SQL Server on a brand new SQL 2008R2SP2 cluster. If the cluster failed over once it was fine. If it ...
16:47 31-Jul-2014
DatabaseWeekly - Newsletter
Let's assume a great deal of memory is being taken by single use plans - say, 10% of total committed memory. What can we do about it?
16:47 31-Jul-2014
DatabaseWeekly - Newsletter
Starting August 1st, a team of my friends and colleagues from the community and I are going to begin sharing with you concepts, tips, tricks and examples ...
15:47 31-Jul-2014
DatabaseWeekly - Newsletter
Emma is the Database Administrator at Adventure Works Cycles, a bicycle manufacturing company. At Adventure Works, Emma and her team are using traditional ...
15:47 31-Jul-2014
SQLServerCentral - Blogs
Short blog post this time as Website Pulse contacted me a few weeks ago with a few questions about working as a DBA. They’ve now published the article, ...
15:19 31-Jul-2014
Simple-Talk - Blogs
All developers will be familiar with the basic format of a technical interview. After a bout of CV-trawling to gauge basic experience, strengths and weaknesses, ...
15:16 31-Jul-2014
SQLServerCentral - Blogs
Recently an incident came across my desk where an end user was receiving an error trying to retrieve ...
14:39 31-Jul-2014
SQLServerCentral - Blogs
This story began as they almost always do - with a page at 4am local time...--'Alert: SQL Failed Jobs ...
13:34 31-Jul-2014
SQLServerCentral - Questions
I have used `sp_spaceused` to check why one of the database is so big. The results are as follow: ![alt text][1] Then following an article about `sp_spaceused` ...
by gotqn
13:24 31-Jul-2014
DatabaseWeekly - Newsletter
This metric creates an alert that will be raised when something is added to the schema, or the existing schema is modified.
09:47 31-Jul-2014
SQLServerCentral - Editorials
Many DBAs monitor for those events they expect to happen, either successfully or failed. However many DBAs wouldn't be aware of an event never occurring. ...
23:00 30-Jul-2014
SQLServerCentral - Main Articles
The DAC is an important tool and several things can go wrong when trying to connect to it.
23:00 30-Jul-2014
SQLServerCentral - Main Articles
Test-Driven Development (TDD) has a misleading name, because the objective is to design and specify that the system you are developing behaves in the ...
23:00 30-Jul-2014
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
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
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
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