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
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 - 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. FREE eBook - "45 Database Performance Tips for Developers"Improve your database performance with 45 tips from ...
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 - Questions
![alt text][1] [1]: /storage/temp/1581-untitled.jpg
by yuvaaraj
04:33 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
SQLServerCentral - Blogs
Packages can be scheduled to run at a time when you expect data to be in a database. Instead of guessing the time when the data will be in the database ...
19:51 21-Jul-2014
SQLServerCentral - Questions
I am wonder what the process would be to recover from a lost data file in MSSQL. Up front this is a hypothetical situation but lets say that there is ...
by JCAirey1
19:00 21-Jul-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"); If ...
18:50 21-Jul-2014
SQLServerCentral - Blogs
SharePoint uses a series of SQL Server databases to save configuration information, security setups and all the user data that has been created. The Central ...
18:49 21-Jul-2014
SQLServerCentral - Blogs
Looking for help is a pain in Powershell. I type something like help get-process execute this and I'm scrolling up and down. Things scroll off the screen ...
16:10 21-Jul-2014