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
This story began as they almost always do - with a page at 4am local time...Alert: SQL Failed Jobs on ...
09:48 01-Aug-2014
DatabaseWeekly - Newsletter
Most of us learned long ago not to run executable files from sketchy USB sticks. But old-fashioned USB hygiene can't stop this newer flavor of infection: ...
09:48 01-Aug-2014
SQLServerCentral - Questions
Hi all I have to do a task in daily basis. I got some excel files in a folder. Let me explain you. Suppose in a particular folder i have 30 excel files ...
by rajiv1mehrau
07:19 01-Aug-2014
SQLServerCentral - Questions
Dear Sir, In my database one table have approx 200 Million records and its size is approx 100 GB, Now User will access this table for reporting purpose. ...
by Mukesh_Kumar
06:18 01-Aug-2014
SQLServerCentral - Questions
. This is the Issue that we are facing , Followed Postgreql query is the existing one . We need an equivalent of this in SQLServer . SELECT ...
by asif.sha11
05:27 01-Aug-2014
SQLServerCentral - Questions
Hi Guys, Im new here and in need of your help. this is the scenario i have in hand. we have our Main App DB and Add-On App DB currently sitting on same ...
by MadhavanR
04:39 01-Aug-2014
SQLServerCentral - Editorials
Views can be a great way to abstract away details for clients, but they can also make development much more flexible.
23:00 31-Jul-2014
SQLServerCentral - Main Articles
Writing a resume that rocks is not an art. Follow these simple guidelines to help secure your next interview.
23:00 31-Jul-2014
SQLServerCentral - Main Articles
Mubin M. Shaikh outlines how to create SSRS Report on SSAS OLAP Cube. If you don't have much prior knowledge of SSRS, just follow the steps and to have ...
23:00 31-Jul-2014
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
Simple-Talk - .NET Articles
Test-Driven Development (TDD) relies on the repetition of a very short development cycle Starting from ...
by Michael Sorens
00:00 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