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
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 - 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
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
SQLServerCentral - Blogs
SirSQL made a rather stirring post recently. He talked about a speaker buddy system to help out new speakers in our community that are trying to make ...
06:29 21-Jul-2014
SQLServerCentral - Questions
Please find the below attached image. I have one point(in blue color) and polyline(in black color). Using the below sql server 2012 comment i got the ...
by RamRamesh
05:33 21-Jul-2014
SQLServerCentral - Questions
I have a stored procedure which is executing very slowly in client production environment.ON further ...
by sudipta_banerjee_2014
05:32 21-Jul-2014
SQLServerCentral - Blogs
Please come join the Data Architecture VC this Wednesday to get info from MVP Grant about Database Deployment ...
05:28 21-Jul-2014
SQLServerCentral - Questions
I need to use in a bank payment file (flat file); Notes 1: - Each line has 50 characters, I need to convert in 4 columns totaling 200 characters. ...
by raimundo.couras
01:52 21-Jul-2014
SQLServerCentral - Editorials
After six weeks away, Steve Jones is back.
23:00 20-Jul-2014
SQLServerCentral - Main Articles
In this lesson we will learn the basics of DMX and create some samples. Free eBook - Performance Tuning with DMVsThis free eBook provides ...
23:00 20-Jul-2014
SQLServerCentral - Main Articles
Although SQL Data Types seem to cause a lot of grief for database developers and can be tricky in their use, we seem to be expected to know all about ...
23:00 20-Jul-2014
SQLServerCentral - Main Articles
SQL in the City is coming back to London and Seattle in 2014. The London event will take place on October 24 (before Tech Ed Europe) and in Seattle on ...
23:00 20-Jul-2014
SQLServerCentral - Questions
The picture attached is the result of my class study Lab. At the moment, I am trying to get the Name ...
by Enigma6082
23:11 19-Jul-2014
SQLServerCentral - Questions
My problem here is how to identify and select a patients service date. A service date could be admission date(hospital), discharge date(hospital), CBC ...
by jtagab
00:18 19-Jul-2014
SQLServerCentral - Questions
Hello all, I need some help with a trigger to prevent overlapping dates. I feel so close but I'm not sure what I'm missing. The details; Rates table ...
by reamades
21:38 18-Jul-2014
SQLServerCentral - Blogs
If you want a quick way to determine which format, or style, to specify when converting a datetime value in SQL to a character data type, you can use ...
19:30 18-Jul-2014
SQLServerCentral - Blogs
I was doing some work on the marketing for SQLSaturday Orlando and looked back at the messages we sent last year, and in one those messages I found this ...
17:55 18-Jul-2014
SQLServerCentral - Blogs
I wrote What Is the Hardest Feature to Learn About SQL Server? not really knowing what answer to expect. So far no one topic has risen to the top of the ...
16:20 18-Jul-2014
SQLServerCentral - Questions
My company looks after a server which is running SQL Server 2014 Standard Edition. The main application database on the server is replicated out to about ...
by philipallen
15:44 18-Jul-2014
SQLServerCentral - Questions
The pkg runs fine on my local machine. It fails with the error message below when executed from SQL ...
by lacorrigan
15:27 18-Jul-2014
SQLServerCentral - Blogs
Photo credit – Mike Lynch A good cure to a creepy doll is a good old post that is still useful. In this post, I’m going back over some of ...
15:00 18-Jul-2014
SQLServerCentral - Questions
I am stuck with this NT AUTHORITY\ANONYMOUS login, can't figure out how to get around it. Also how do I create a local login and connect it to a linked ...
by nopolla
14:56 18-Jul-2014