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've recently started implementing columnstore indexes on my company's SQL 2012 OLAP database. When performance tuning I have noticed that queries ...
by tommyfly
07:40 23-Apr-2014
SQLServerCentral - Blogs
By David Postlethwaite At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some articles on Gethyn's blog ...
07:00 23-Apr-2014
SQLServerCentral - Blogs
This is a followup to a previous post where I likened SQL Server float datatype to Muhammad Ali. Specifically, I wanted to address the phrase "negligible ...
04:00 23-Apr-2014
SQLServerCentral - Editorials
The MCM certification program has been abandoned by Microsoft. Steve Jones thinks the material can still be useful for the community.
23:00 22-Apr-2014
SQLServerCentral - Main Articles
The first level of this stairway introduces the basics of source control, some common technologies and ...
23:00 22-Apr-2014
SQLServerCentral - Main Articles
Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, ...
23:00 22-Apr-2014
SQLServerCentral - Main Articles
The task of Database Normalization doesn't have to be painful, especially if you follow Old Mother Celko's Normalization Heuristics.
23:00 22-Apr-2014
SQLServerCentral - Blogs
!function(d,i){if(!d.getElementById(i)){var j=d.createElement("script");j.id=i;j.src="https://widgets.getpocket.com/v1/j/btn.js?v=1";var w=d.getElementById(i);d.body.appendChild(j);}}(document,"pocket-btn-js");Have ...
19:03 22-Apr-2014
SQLServerCentral - Blogs
I’ve fallen down on my challenge over the last month. It’s been a content time, with me working more towards presentations and writing most ...
19:03 22-Apr-2014
SQLServerCentral - Blogs
2014 is the latest edition of SQL Server available[/caption] SQL Server 2014 was officially released in April 4th, 2014. You can download the 120 day ...
18:30 22-Apr-2014
SQLServerCentral - Questions
**i am using mysql and php** table : ID: auto inc NO: int name: varchare date: ...
by rafiq
15:41 22-Apr-2014
SQLServerCentral - Questions
I am new to SSIS so am practising. I have a worksheet in excel (2013) called Pensions which I update everyday. It has formular in it. I have created a ...
by chrismic999
15:04 22-Apr-2014
SQLServerCentral - Questions
I am dealing with the following set of tables: tbl_contact_history which has contactid and historyid as columns tbl_contact_note which has contactid ...
by Larry_Krone
15:00 22-Apr-2014
SQLServerCentral - Blogs
!function(d,i){if(!d.getElementById(i)){var j=d.createElement("script");j.id=i;j.src="https://widgets.getpocket.com/v1/j/btn.js?v=1";var w=d.getElementById(i);d.body.appendChild(j);}}(document,"pocket-btn-js");It ...
14:51 22-Apr-2014
SQLServerCentral - Blogs
It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow me on twitter (@StrateSQL). ...
14:00 22-Apr-2014
SQLServerCentral - Blogs
Do you know what the “Three A’s of Security” are and how they apply to Microsoft SQL Server? Let’s look at them as they are important ...
13:45 22-Apr-2014
Simple-Talk - Blogs
During the course of upgrading a search application database from SharePoint 2010 to SharePoint 2013 ...
13:29 22-Apr-2014
SQLServerCentral - Blogs
Blogging isn't easy. You have to come up with a topic, write about it, and then release it for the world to see. That's three kinds of pressure. Now most ...
13:15 22-Apr-2014
SQLServerCentral - Blogs
That is a patently false statement and total BS. It sure does crawl up your spine though doesn’t it? Why then do we need to do this? I read an article, ...
12:12 22-Apr-2014
SQLServerCentral - Blogs
I’ll be doing double time over the next two weeks with Two Presentations on SQL Server Internals. It is essentially just a repeat of the same presentation ...
12:02 22-Apr-2014
SQLServerCentral - Blogs
Steps to install SQL Server Failover Cluster from SQL Server 2008 onwards :- 1) Open SQL Server Installation ...
11:46 22-Apr-2014
SQLServerCentral - Questions
I have 3 tables T1,T2,T3. Each of them has a relation to another. T1_Serno T1 -------------- 1 T1 Table 2 T2_Serno T1_Serno ...
by fashraf
10:47 22-Apr-2014
DatabaseWeekly - Newsletter
This paper aims to help readers understand some of the common architectural patterns where In-Memory OLTP has provided significant benefits and discusses ...
10:44 22-Apr-2014
SQLServerCentral - Blogs
I have just returned from a trip to Washington DC where I was delivering course 2105 - SQL Server 2012 DBA skills upgrade class in an onsite class to ...
09:00 22-Apr-2014
SQLServerCentral - Questions
table name : purchase or_name ord_yr ord_numer sal 2011 0004 after insert the table the value is table name: purchase_order order sal-2011-0004 and ...
by sekar
07:50 22-Apr-2014
Simple-Talk - SQL Articles
Sometimes, XML seems a bewildering convention that offers solutions to problems that the average database user doesn't have. To make things worse, XML ...
by Robert Sheldon
00:00 22-Apr-2014
SQLServerCentral - Editorials
How can you perform due diligence on new employees? There are a variety of ways, but Steve Jones has an idea that might help you nudge a potential employer ...
23:00 21-Apr-2014
SQLServerCentral - Main Articles
Part two of our series looks at the partitioning strategy to separate customers' data, providing security and performance.
23:00 21-Apr-2014
SQLServerCentral - Main Articles
Steve Jones is putting out an open call for guest editorial pieces in the spring of 2014. If you're interested, read on.
23:00 21-Apr-2014
SQLServerCentral - Main Articles
Marcin Policht reviews security related challenges of Microsoft Azure Software as a Service-based SQL Database, focusing in particular on the SQL Server ...
23:00 21-Apr-2014
SQLServerCentral - Questions
Hello everyone, The PEACE of the Lord Jesus be with you all. I have five tables, and would like some help to create a query that returns all the information ...
by Marcos Cruz
22:27 21-Apr-2014
SQLServerCentral - Blogs
On Thursday, May 1st, I will be presenting a new webcast with Tegile Systems entitled “Easy SQL Server Benchmarking”. Abstract: Do you have ...
18:07 21-Apr-2014
SQLServerCentral - Questions
I've setup a new instance for TFS and Reporting. I'm able to connect to TFS and manage the code fine but the reports are not working and return the below ...
by Flathead_SQL
16:15 21-Apr-2014
SQLServerCentral - Blogs
Same room but different seating arrangement. Instead of separate table pushed some together, used the space better and more a feeling of being in a meeting ...
13:05 21-Apr-2014
SQLServerCentral - Questions
Hello All, Consider Applying patches in sql server clustering Nodes, First i have tried to apply the patches in Passive Node(Node B), It got updated ...
by Mohamed4053
12:13 21-Apr-2014
SQLServerCentral - Questions
i need to create a batch which will modify the child table if any record is updated in its parent table.suppose ...
by Chitra_Maithani
11:32 21-Apr-2014
SQLServerCentral - Blogs
I had a recent run in with collation problems and it got me started reading about them. As I read I started to realize that for a seemingly simple subject ...
11:00 21-Apr-2014
SQLServerCentral - Blogs
Creating a directory in a Filetable share is easy. It looks like this: It's hard to see, but this was a right click, New, Folder in the share from Windows ...
10:31 21-Apr-2014
SQLServerCentral - Blogs
By David Postlethwaite At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some articles on Gethyn's blog ...
07:00 21-Apr-2014