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
ssis flat file destination connection manager has invalid usage type folder exists. I am using a variable with source location. I have a flat file connection ...
by artistlover
20:26 18-Apr-2014
SQLServerCentral - Blogs
Photo credit – Travis Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time to dig out ...
15:00 18-Apr-2014
SQLServerCentral - Blogs
I hope you were able to attend my free webinar on Creating Power Map Reporting Solutions on April 17 2014.  If you weren’t you can ...
14:40 18-Apr-2014
SQLServerCentral - Blogs
I made some small improvements to a few of the queries this month. I plan to add several more SQL Server 2014 specific queries over the next couple of ...
12:46 18-Apr-2014
SQLServerCentral - Blogs
I’m heading back to SQL Bits for the third time and I’m excited to be going again. I think that this is my favorite conference, hands down. ...
12:33 18-Apr-2014
SQLServerCentral - Blogs
Next month, I'll be making a couple of stops at SQL Saturday events in the south.  On May 3, I'll be attending SQL Saturday #285 in Atlanta and presenting ...
11:58 18-Apr-2014
SQLServerCentral - Blogs
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real ...
11:00 18-Apr-2014
SQLServerCentral - Blogs
I recently came across the following error message when I tried to look at the batches in the Integration Management section of MDS: 515: A database error ...
08:20 18-Apr-2014
SQLServerCentral - Questions
The requirement is that the data in certain columns need to be encrypted after data is loaded and later ...
by sumitava20
05:29 18-Apr-2014
SQLServerCentral - Editorials
If you could look back on your career, is there some advice you wish you had? Is there something you'd tell people considering your job as a career? Let ...
23:00 17-Apr-2014
SQLServerCentral - Main Articles
Views that use implicit conversion to return result sets may use a different query plan than the statement executed in query analyzer. ...
23:00 17-Apr-2014
SQLServerCentral - Main Articles
This beginner's guide to Wait Stats by Jonathan Kehayias and Erin Stellato is a free PDF download brought ...
23:00 17-Apr-2014
SQLServerCentral - Main Articles
Please join us on Saturday, May 3rd, 2014, as both business analysts and IT professionals come to learn and network with experts for the first SQLSaturday ...
23:00 17-Apr-2014
SQLServerCentral - Questions
Hello, I want an xml like this using SQL server 2005. price Amount xmlns="uri">121ABC
by Anshu
20:41 17-Apr-2014
SQLServerCentral - Questions
Hello I am working with SSRS 2008. I am wondering if there is a way to do HEX2DEC. I have tried a few things but they get error out. I have tried using ...
by fozzy767
19:34 17-Apr-2014
SQLServerCentral - Blogs
I hope you were able to attend my free webinar on Bringing Power BI Q&A to your Organization on April 15 2014.  If you weren’t you ...
17:49 17-Apr-2014
DatabaseWeekly - Newsletter
In this episode of the Notes from the Field series database expert John Sterrett (Group Principal at ...
16:44 17-Apr-2014
SQLServerCentral - Blogs
Analytics Platform System (APS) is simply a renaming of the Parallel Data Warehouse (PDW).  It is not really a new product, but rather a name change due ...
16:36 17-Apr-2014
SQLServerCentral - Questions
Hello! I have a query that does exactly what I need it to but I know there has to a better way to write this because it runs for 17 minutes. The problem ...
by muk
16:19 17-Apr-2014
DatabaseWeekly - Newsletter
Microservices is just a Service Oriented Delivery approach for a well architected SOA solution. SOA provides the contextual framework, provides most ...
14:44 17-Apr-2014
DatabaseWeekly - Newsletter
Hot off the presses is this new MSDN white paper: Optimizing Your Query Plans with the SQL Server 2014 ...
14:44 17-Apr-2014
DatabaseWeekly - Newsletter
Our sister site Simple-Talk have gathered together all of their articles on database delivery in a single place, along with some other resources. The ...
14:44 17-Apr-2014
DatabaseWeekly - Newsletter
Sometimes, you just want to do a search in a SQL Server database as if you were using a search engine like Google. Besides the obvious Full-Text search, ...
14:44 17-Apr-2014
SQLServerCentral - Blogs
v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} A few months ...
13:03 17-Apr-2014
SQLServerCentral - Questions
I have old flat file from 2009 that are on my drive for long years. i want to create SSIS package to delete all of them except the last three months. ...
by fantumahi2
13:01 17-Apr-2014
SQLServerCentral - Blogs
I'm presenting tonight at oPASS, two presentations worth! If you’re in Orlando I hope you’ll attend, details at http://orlando.sqlpass.org/. ...
12:15 17-Apr-2014
DatabaseWeekly - Newsletter
From the moment a query request is made until the query response is delivered, what really happens to your query in SQL Server? Let's find out, and talk ...
09:44 17-Apr-2014
DatabaseWeekly - Newsletter
The Red Gate Database Delivery team is looking for people willing to participate in UX sessions for a brand new product, with $50 Amazon vouchers for ...
09:44 17-Apr-2014
DatabaseWeekly - Newsletter
Backing up SQL Server to the cloud makes a lot of sense, particularly for small businesses. Managing the physical media takes up too much time and effort ...
09:44 17-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 17-Apr-2014
SQLServerCentral - Questions
Hi, How to resolve the below issue? I have done RebuildIndex but the problem not solved.I think page ...
by rajasekharbollareddy
06:03 17-Apr-2014
SQLServerCentral - Editorials
Twitter is working on a new database that can handle unstructured as well as structured data well. Is this a competitor for SQL Server?
23:00 16-Apr-2014
SQLServerCentral - Main Articles
An introduction to the XML Schema Collection and XML validation.
23:00 16-Apr-2014
SQLServerCentral - Main Articles
The output from the Association Rules data mining model in SSAS 2012 can be difficult to understand, ...
23:00 16-Apr-2014
SQLServerCentral - Main Articles
The Red Gate Database Delivery team is looking for people willing to participate in UX sessions for an exciting, brand new product, with $50 Amazon vouchers ...
23:00 16-Apr-2014
SQLServerCentral - Blogs
SQL Server 2014 is deeply integrated with Windows Microsoft Azure and moving an On-prem database to ...
21:20 16-Apr-2014
SQLServerCentral - Questions
I have two tables, and I want to update values in the first one based on a inner join with values from the second table (seems pretty simple right?). ...
by nickmorse
20:39 16-Apr-2014
Simple-Talk - Blogs
The Red Gate Database Delivery team is looking for people willing to participate in UX sessions for an exciting, brand new product, with $50 Amazon vouchers ...
16:39 16-Apr-2014
SQLServerCentral - Blogs
At my Filestream/Filetable talk yesterday at SQL Intersection, someone asked me about programmatically adding a file to a Filetable. Easy enough, I thought, ...
16:33 16-Apr-2014