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
What is the scope of SQl Server, since now no sql DBs are emerging high in markets? Is it better to stick with SQl or go ahead and learn NOSQL DBS. which ...
by madhanmohan
09:14 24-Jul-2014
SQLServerCentral - Questions
Hi all, I have a table of Parent/Child relationships. Some parents have exactly the same group of children. I need to find which ones. For example I ...
by mjharper
08:23 24-Jul-2014
SQLServerCentral - Questions
We have file coming from FTP site and this file is zipped. Inside the zip file there is .bak file holding backup files . The name of the backups are constants ...
by fantumahi2
03:24 24-Jul-2014
SQLServerCentral - Questions
I have 3 tables >Category CategorySerno | CategoryName 1 One 2 Two 3 Three ...
by fashraf
00:06 24-Jul-2014
SQLServerCentral - Editorials
Should decisions be made on instinct or with data?
23:00 23-Jul-2014
SQLServerCentral - Main Articles
SQL Server 2012 introduced columnstore indexes, which can immensely improve the performance of OLAP queries. How were they updated and improved in SQL ...
23:00 23-Jul-2014
SQLServerCentral - Main Articles
Many DBAs back up their user databases, but not their system databases. Whatever the reason for the lack of a backup, John Grover explains how to save ...
23:00 23-Jul-2014
SQLServerCentral - Main Articles
Red Gate's running a half-day training workshop at their UK head office in Cambridge on Aug 8. It'll show you how to link your database source control ...
23:00 23-Jul-2014
SQLServerCentral - Questions
1. Assume that the fields "ID" and "Manager" exist as Integers for each entry in the "Persons" table. Write a SQL Function that accepts an "ID" and returns ...
by mbgreen2
21:38 23-Jul-2014
SQLServerCentral - Blogs
Just the chart today. We're considerably ahead of previous year registrations for the same number of weeks out. I'm looking at that number every day now!   ...
19:36 23-Jul-2014
SQLServerCentral - Questions
I have a table tablex that contains rows of data like field1, field2, field3. If I use this: select field1, field2, field3 from tablex I get: field1 ...
by donw5288
17:28 23-Jul-2014
SQLServerCentral - Questions
I'm trying to look at currently running queries by using the sys.dm_exec_requests DMV but I don't have the permission. I also tried to look at the query ...
by liton
16:58 23-Jul-2014
SQLServerCentral - Questions
the error is SQLSTATE: 08001 code: 53 message: [Microsoft][SQL Server Native Client 11.0]Named Pipes ...
by pbalendra
15:38 23-Jul-2014
SQLServerCentral - Blogs
I was working on a small piece of code the other day that was calculating the seconds for an event. I had a function that returned me the seconds as an ...
14:42 23-Jul-2014
SQLServerCentral - Blogs
There seemed to be some question whether my comfort level with my own masculinity would prevent me from wearing these: Oh please! Couldn’t we be ...
13:09 23-Jul-2014
SQLServerCentral - Questions
Please help me to get this. Input Part_Number Part_Type Description_1 Value1 Description_2 Value2 Description_3 Value3 EDG38305 ...
by AlexKlap
12:21 23-Jul-2014
SQLServerCentral - Blogs
Have you ever wanted to find out if someone is logged into a computer or maybe who is logged into a computer without having to remote in to check? Recently ...
12:00 23-Jul-2014
SQLServerCentral - Blogs
This may seem like a question with a simple answer but there is a bit more to it than you might think. In fact I know of 3 possible reasons (and there ...
11:00 23-Jul-2014
SQLServerCentral - Blogs
Microsoft fixed SQL Server 2012 with SP2 Slipstream ISO images do not install SP2 issue. The new ISOs have been posted on their respective release channels ...
08:33 23-Jul-2014
SQLServerCentral - Blogs
The 11th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download ...
08:30 23-Jul-2014
SQLServerCentral - Editorials
At least it's not Sage.
23:00 22-Jul-2014
SQLServerCentral - Main Articles
There times when you need to write T-SQL code that creates specific T-SQL Code and executes it. When you do this you are creating dynamic T-SQL code. ...
23:00 22-Jul-2014
SQLServerCentral - Main Articles
Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting ...
23:00 22-Jul-2014
SQLServerCentral - Main Articles
A lot of numbers that we use everyday such as Bank Card numbers, Identification numbers, and ISBN codes, have check digits. As part of the routine data ...
23:00 22-Jul-2014
SQLServerCentral - Questions
Is there a wild card that covers all SQL versions for AV exclusions?
by llong
21:01 22-Jul-2014
SQLServerCentral - Blogs
We're at 180 registered so far and we haven't published the schedule yet! So far so good. We're on track to have the schedule live at 60 days out, maybe ...
19:58 22-Jul-2014
SQLServerCentral - Questions
I was recently upgraded from XP and SSMS 2008 to Windows 7 and SSMS 2012. I hate it that when I open an SQL file, the Windows taskbar says "Miscellaneous...". ...
by virtualjosh
16:43 22-Jul-2014
SQLServerCentral - Questions
I am note familiar with SQL Server administration and I am looking for a tool that is showing the current IO/RAM/CPU activity for a particular SQL Server ...
by gotqn
14:35 22-Jul-2014
SQLServerCentral - Blogs
When doing ETL, you have the choice of using T-SQL or SSIS (see When to use T-SQL or SSIS for ETL).  If you decide T-SQL is the way to go and you just ...
14:00 22-Jul-2014
SQLServerCentral - Questions
Dear All, i have subscribe a couple of SSRS report. but customer ask me that they just want an email need to be deliver when report has Data on it. Can ...
by AlexKlap
13:22 22-Jul-2014
SQLServerCentral - Blogs
Twice a week I am asked "why don't you add new cool feature to ExpressProfiler?"The answer is as simple as ExpressProfiler itself - you should always ...
12:42 22-Jul-2014
SQLServerCentral - Questions
This code creates check file. what i put in bold. It used to curamount > 0 ...i had some negative values and that would not work so i took code out ...
by artistlover
12:35 22-Jul-2014
SQLServerCentral - Blogs
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need ...
10:29 22-Jul-2014
SQLServerCentral - Questions
Hello together :) I'm coming up with the next replication problem and hope you guys can help me. So, i will try to explain as best as I can what our ...
by david.hoffmann
07:52 22-Jul-2014
SQLServerCentral - Blogs
My previous two posts about SSRS reports being deployed to a SharePoint site along with their subscription didn't stop me from exploring the whole things ...
05:25 22-Jul-2014
SQLServerCentral - Editorials
The DevOps movement has Steve Jones excited.
23:00 21-Jul-2014
SQLServerCentral - Main Articles
This article demonstrates a method of importing a data file directly into a temporary table and selectively inserting data from the temporary table into ...
23:00 21-Jul-2014
SQLServerCentral - Main Articles
The SSC team has put together a little quiz on database source control to go with Rob Richardson, Robert Sheldon, and Tony Davis' new book, SQL Server ...
23:00 21-Jul-2014
SQLServerCentral - Main Articles
A good DBA needs to have good technical skills but he also has to have good personal skills. In this article, Greg Larsen discusses the personal skills ...
23:00 21-Jul-2014