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
to create xml file i use the follow script bcp "SELECT xml_data from Xmltable" queryout C:\Test\1.xml -S '+@@servername+' -T -t -w; checking the created ...
08:41 30-Apr-2016
DatabaseWeekly - Newsletter
The website belonging to Maisto International, a popular maker of remote-controlled toy vehicles, has ...
17:44 29-Apr-2016
DatabaseWeekly - Newsletter
I've just been reading Kingpin by Kevin Poulsen which sheds some really interesting light on criminal credit card fraud in the mid 2000's. Towards the ...
17:44 29-Apr-2016
DatabaseWeekly - Newsletter
It's not an overstatement to say that, at least for me personally, Edward Tufte's book The Visual Display of Quantitative Information was transformative. ...
17:44 29-Apr-2016
DatabaseWeekly - Newsletter
With the most recent announcement of Power BI's inclusion in the Azure Trust Center, it is a good time to review where we are today with Power BI security ...
17:44 29-Apr-2016
DatabaseWeekly - Newsletter
The StackOverflow XML Data Dump was recently updated with 2016-03 data, so I've updated our torrent of the SQL Server database version of the Stack Overflow ...
17:44 29-Apr-2016
DatabaseWeekly - Newsletter
SQL Server event alerts that respond by notifying operators can lead to too much noise in your email inbox. There is a built-in option to specify a number ...
17:44 29-Apr-2016
DatabaseWeekly - Newsletter
If you were given the chance to build the ultimate server, what would you draft first?
17:44 29-Apr-2016
DatabaseWeekly - Newsletter
Since I have started my consulting engagements with customers around the world, I have been asked interesting queries from time to time. In a recent customer ...
17:44 29-Apr-2016
DatabaseWeekly - Newsletter
When you undertake some performance improvement task, you think it is frustrating however at the same time you tend to learn more. So the other day we ...
17:44 29-Apr-2016
DatabaseWeekly - Newsletter
Seagate has started volume shipments of its first helium-filled hard drives. They were announced earlier ...
17:44 29-Apr-2016
SQLServerCentral - Questions
I have a very simple Concat query, it works on Standard Edition , but when I am migrating to Web Edition, this query does not work. (it does not concatenate) ...
14:39 29-Apr-2016
SQLServerCentral - Questions
i have more data with many columns in excel,how to store all data into sql server database. thanks in advance
14:20 29-Apr-2016
SQLServerCentral - Blogs
Over the last few years I have been involved in reviewing the architectures of various companies that are building or have built big data solutions.  When ...
14:00 29-Apr-2016
SQLServerCentral - Questions
Can you suggest best options/tools to do the SQL Server data encryption after sending data(encrypt format) from database to application(decrypt data),it ...
07:37 29-Apr-2016
SQLServerCentral - Questions
checking thee xml file i exported arise the following error: "Element type "P" must be followed by either attribute specifications, ">" or "/>"(checked ...
07:33 29-Apr-2016
SQLServerCentral - Questions
Hello, When i login to report server then error thrown An error occurred within the report server database. This may be due to a connection failure, ...
05:20 29-Apr-2016
SQLServerCentral - Blogs
When you undertake some performance improvement task, you think it is frustrating however at the same time you tend to learn more. So the other day we ...
02:16 29-Apr-2016
SQLServerCentral - Editorials
It seems that one area many DBAs don't have much knowledge in is testing hardware.
23:00 28-Apr-2016
SQLServerCentral - Main Articles
Learn about Microsoft's latest end-user BI reporting tool, Power View, and create animated graphs that impress your boss!
23:00 28-Apr-2016
SQLServerCentral - Main Articles
We're always looking for articles, but here are a few ones that I'd like to see written up.
23:00 28-Apr-2016
SQLServerCentral - Main Articles
Developers who are already familiar with application languages will be baffled by different aspects of PowerShell to the beginner to programming. Laerte ...
23:00 28-Apr-2016
SQLServerCentral - Questions
I have a SQL Server 2012 and the logs state "The SQL Server Network Interface library successfully registered the Service Principal Name (SPN) [ MSSQLSvc/SHSTNFDBV1.testaapdomain.local:1433 ...
19:25 28-Apr-2016
DatabaseWeekly - Newsletter
Microsoft's cofounder vows to change the "supply side" for breakthrough energy technologies by investing billions of his and his friends' dollars.
17:44 28-Apr-2016
DatabaseWeekly - Newsletter
Every time I look at my ForEach NodeList Enumerator post, I struggle to remember how to do half of it. Plus, as I discovered today, I am inconsistent ...
17:44 28-Apr-2016
DatabaseWeekly - Newsletter
Earlier this week, I posted a follow-up to my my recent post about STRING_SPLIT() in SQL Server 2016, addressing several comments left on the post and/or ...
17:44 28-Apr-2016
DatabaseWeekly - Newsletter
Microsoft recently updated their policies and recommendations for installing cumulative updates. Now, ...
17:44 28-Apr-2016
DatabaseWeekly - Newsletter
This blog post is not what I was intending to write, at least not so early in my list of blog postings. Mainly due to the fact that it's main issue is ...
17:44 28-Apr-2016
DatabaseWeekly - Newsletter
As I have been watching what has been going on recently in the Windows and SQL Server world, I have come to the conclusion that it is a particularly exciting ...
17:44 28-Apr-2016
DatabaseWeekly - Newsletter
I pity the fool who needs to shrink his database!
17:44 28-Apr-2016
DatabaseWeekly - Newsletter
I certainly didn't expect it would go this far when I built Have I been pwned (HIBP) a few years ago, ...
17:44 28-Apr-2016
DatabaseWeekly - Newsletter
This is the fourth post in a series of twelve in Tim Fords Entry-Level Content Challenge. In this blog post, I will explain how SQL Server deals with ...
17:44 28-Apr-2016
DatabaseWeekly - Newsletter
This is a tip that should help installing SQL Server 2016 (tested on CTP33, RC2 and RC3) Master Data Services. The documentation is pretty old and incomplete ...
17:44 28-Apr-2016
SQLServerCentral - Blogs
You have brains in your head. You have feet in your shoes. You can steer yourself in any direction you choose. You're on your own, and you know what you ...
16:50 28-Apr-2016
SQLServerCentral - Blogs
With the most recent announcement of Power BI’s inclusion in the Azure Trust Center, it is a good time to review where we are today with Power BI ...
15:54 28-Apr-2016
SQLServerCentral - Questions
I have a table that lists file-names that have been created on an App server. Goal: I want to keep the list of files in the SQL server table and the list ...
15:19 28-Apr-2016
SQLServerCentral - Blogs
The April MVP nomination is Chris Yates (B|T). Chris is one of those individuals that always have a positive outlook on life which infectious.  He hails ...
13:00 28-Apr-2016
SQLServerCentral - Blogs
In case you haven’t noticed, Power BI added a new feature in preview mode: row level security (RLS). This blog post describes how you  can use this ...
11:18 28-Apr-2016
SQLServerCentral - Questions
I want to install the sql server programmatically. 1. Is there any open program to install it? 2. In which language is it possible to install, if ...
10:34 28-Apr-2016