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 - Editorials
We always want to follow the best, or at least good, practices for software development. However do you know what those are? Steve Jones notes there's ...
23:00 23-Apr-2014
SQLServerCentral - Main Articles
Have you received an XML file that must be migrated into a production database? Today's workshop dives into an ad hoc method of processing relational ...
23:00 23-Apr-2014
SQLServerCentral - Main Articles
There is a stored procedure that must be run by only one user at a time. In this tip, learn how to prevent ...
23:00 23-Apr-2014
SQLServerCentral - Questions
Hi all, I am doing this for the very first time ever so please bare with me. I am creating an SSRS report that displays all of the students in a given ...
by muk
18:50 23-Apr-2014
SQLServerCentral - Questions
I use SSDT 2012 to generate the reports. now I like to know if I deploy the reports to report server 2008, does it will cause any problem? Do I still ...
by SSGC
16:11 23-Apr-2014
SQLServerCentral - Questions
I am trying to write a procedure that will get the server status for each database server that is listed in a table. But the return code i am getting ...
by hankado
15:58 23-Apr-2014
SQLServerCentral - Blogs
I have run into this before, but not in this same way, so I decided it would be worth writing about.On a client server they are running 32-bit SQL Server ...
14:45 23-Apr-2014
SQLServerCentral - Questions
Our SQL 2005 database is supposed to be 300mb. we were being told the database is full I queried: use "MY_DB" exec sp_spaceused and got: database_name ...
by OCMC
13:48 23-Apr-2014
SQLServerCentral - Questions
Dear All, We need some clarification in Logshipping & Hardware Configuration. Could you please help me in this regard. We are using SQL Server 2008 ...
by kpsenthilkumar86
13:42 23-Apr-2014
SQLServerCentral - Blogs
If you are near Pittsburgh, PA on May 22, 2014 catch the following all-day training session from 8:30 ...
12:50 23-Apr-2014
SQLServerCentral - Blogs
I introduced Azure Automation in a previous post. I’ve spent some more time exploring it. There’s a set of documentation available as I noted ...
12:48 23-Apr-2014
SQLServerCentral - Blogs
I started reading about collations after I had a recent run in with them. As I read I started to realize that for a seemingly simple subject there was ...
11:00 23-Apr-2014
SQLServerCentral - Blogs
Practical Data Migration Strategies As organizations mature their IT infrastructure must change to keep up with new applications and technologies. Many ...
10:23 23-Apr-2014
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
I am excited about being selected to speak and attend the May 3rd SQLSaturday BA Edition in Dallas, TX. There are a number of sessions I want to attend ...
06:18 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 1st, 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