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
Please help me to get this. Input Part_Number,Part_Type,Description_1,Value1, Description_2,Value2,Description_3 Value3 EDG38305,Gauge, Compatibility,CTS, ...
by AlexKlap
12:21 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. 12 must-have SQL Server toolsThe award-winning SQL Developer Bundle contains 12 tools for faster, simpler SQL ...
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
SQLServerCentral - Blogs
image source It’s been a few months since I’ve updated my SQL Server monthly maintenance checklist.  Even though it hasn’t been updated, ...
16:00 21-Jul-2014
SQLServerCentral - Blogs
Walk & Talk #001 – Unknown or Null Values Ride with us in this video as we head to Richmond, Virginia to present to their user group. This ...
14:17 21-Jul-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 21-Jul-2014
SQLServerCentral - Questions
I have try to check the performances improvement that Hekaton engine brings converting a regular table to OLTP one. The regular table is 9 GB, but the ...
by gotqn
13:47 21-Jul-2014
SQLServerCentral - Blogs
I took part in the PASS Summit 2014 selection committee this year because I was really curious about seeing how the sausage gets made. I’ve seen ...
12:52 21-Jul-2014
SQLServerCentral - Blogs
Steps to install Service Pack for SQL Server 2005 on multiple instances in one go :- Step 1 : First page of Service pack setup. Informatory details only. Step ...
12:34 21-Jul-2014
SQLServerCentral - Questions
I have a table with clustered index and non clustered index. Generally, when the a query is executed the non clustered index is used only, because it ...
by gotqn
12:23 21-Jul-2014
SQLServerCentral - Blogs
I seem to get a lot of permissions questions these days and one of the more frequent ones goes along these lines “I still don’t have the right ...
11:00 21-Jul-2014
Simple-Talk - Blogs
If you’ve got an environment which is at the end of an unreliable or slow network connection, or isn’t connected to your network at all, and ...
10:03 21-Jul-2014
SQLServerCentral - Questions
I have to inline functions - the first returns about 28 000 rows and the second returns about 16 000 rows. The functions are executed for 0 seconds both. ...
by gotqn
09:14 21-Jul-2014