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 - Blogs
Hi friends, I recently found an issue while inserting data into table during transactions that transaction will not completely rollback …Continue ...
00:51 26-May-2016
SQLServerCentral - Editorials
Today we have a guest editorial from Andy Warren that looks at the decision to leave a job. Or not.
23:00 25-May-2016
SQLServerCentral - Main Articles
Diagnosing and resolving parallelism-related latching and blocking in SQL Server using DMV's, the activity monitor, procedure execution plans, and index ...
23:00 25-May-2016
SQLServerCentral - Main Articles
Ayo Olubeko talks through the improvements being made to SQL Server tooling in 2016.
23:00 25-May-2016
SQLServerCentral - Blogs
“The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)” error may occurs when executing PowerShell scripts using WMI query. There ...
20:29 25-May-2016
DatabaseWeekly - Newsletter
Microsoft Regional Director and MVP, Troy Hunt, shares his thoughts on the LinkedIn data breach, talks about HIBP, and discusses the broader issues related ...
17:45 25-May-2016
DatabaseWeekly - Newsletter
Gjorgji Gjeorgjievski summarizes the Query Optimizer improvements coming to SQL Server 2016, and explains how you can leverage the benefits of these new ...
17:45 25-May-2016
DatabaseWeekly - Newsletter
Have you ever tried to restore over an existing database only to receive an Msg 3154 error message? You could easily avoid this error by using the WITH ...
17:45 25-May-2016
DatabaseWeekly - Newsletter
Unlike most other statistical software packages, R doesn't have a native data file format. The goal of the Feather project is to create a standard data ...
17:45 25-May-2016
DatabaseWeekly - Newsletter
Kendra Little provides a solution to a user-submitted question regarding locking and blocking.
16:45 25-May-2016
DatabaseWeekly - Newsletter
At first glance, PowerShell may appear overwhelming, but the language and syntax is actually quite simple. In this post, Jeff Hicks gives a quick rundown ...
16:45 25-May-2016
DatabaseWeekly - Newsletter
In the sixth part of her series on SQL Server Service Broker, the native messaging and queueing technology built into the SQL Server Database Engine, ...
16:45 25-May-2016
DatabaseWeekly - Newsletter
Few companies design and build data centers at Facebook's scale, and the social network's three-year-old computing facility in Luleå, Sweden, is one of ...
15:45 25-May-2016
DatabaseWeekly - Newsletter
Raul Gonzalez talks about some of the misconceptions around how TRUNCATE TABLE in SQL Server actually works, and clears up the confusion with some easily ...
15:45 25-May-2016
DatabaseWeekly - Newsletter
Very few databases are properly designed. Many SQL databases are denormalized inadvertently, or intentionally for performance. They require special constraints ...
14:45 25-May-2016
DatabaseWeekly - Newsletter
When you're driving a car, you spend most of your time looking out the windscreen, only glancing at the dashboard now and again. Hjalmar Gislason asks ...
14:45 25-May-2016
SQLServerCentral - Blogs
Azure storage is a great, inexpensive solution for storing your data in the cloud.  There are many types of Azure storage options, but I wanted to list ...
14:00 25-May-2016
SQLServerCentral - Blogs
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. When I was a six or seven ...
13:55 25-May-2016
DatabaseWeekly - Newsletter
It is easy for someone who is developing a database to shrug and say 'if only my budget would extend to buying fancy tools, then I could start using version ...
13:45 25-May-2016
DatabaseWeekly - Newsletter
Have you ever run a DELETE or an UPDATE without a WHERE clause by accident? Was it on Production data, ...
13:45 25-May-2016
DatabaseWeekly - Newsletter
The requirements for the management of passwords have become far more complex over the past few years in response to the increasing sophistication of ...
13:45 25-May-2016
DatabaseWeekly - Newsletter
If you're using Azure SQL DB or SQL Server 2016 in your project, now you'll find it even easier to diagnose database-related performance bottlenecks in ...
13:45 25-May-2016
DatabaseWeekly - Newsletter
Statistics holds out the promise of teasing out significant relationships and to determine cause and effect. Now that so much data is easily available, ...
13:45 25-May-2016
SQLServerCentral - Blogs
Recently I created my first Azure SQL Database. But now I need to connect to it. You can connect using any number of tools. We can actually see several ...
12:00 25-May-2016
SQLServerCentral - Questions
Hi! I'm using script component in SSIS to generate insert statements. I'm selecting list of columns from database, then create string covering these ...
05:57 25-May-2016
SQLServerCentral - Blogs
While this is a personal blog, I try to keep it focused on either technical topics or personal development and leadership related to technical topics. ...
05:35 25-May-2016
SQLServerCentral - Editorials
23:00 24-May-2016
SQLServerCentral - Main Articles
In the next installment of our stairway to Extended Events, we delve into the Live Data and Target Data ...
23:00 24-May-2016
SQLServerCentral - Main Articles
Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting ...
23:00 24-May-2016
SQLServerCentral - Main Articles
Sometimes it's good to re-think how to write a query; set operations can provide performance benefits over 'straight SQL'. In this article, David Fitzjarrell ...
23:00 24-May-2016
SQLServerCentral - Blogs
I got an email today from PASS, noting that credentials were changing from username to email. That's fine. I don't really care, but I know I got multiple ...
19:22 24-May-2016
SQLServerCentral - Blogs
When I was at PowerShell Conference EU in Hannover last month (The videos are available now – click here and the slides and code here) I found out ...
19:14 24-May-2016
SQLServerCentral - Blogs
Convert the XML document to JSON document example <person> <name>John</name> <age>25</age> <address> <city>New ...
19:07 24-May-2016
SQLServerCentral - Questions
I get a lot of text files from clients. We have to import the files, export the files with minimal fields for another department processing and then load ...
15:24 24-May-2016
SQLServerCentral - Questions
We are looking for SQL Server monitoring tools for Performance/Capacity, Is there any good 3rd party ...
14:55 24-May-2016
SQLServerCentral - Blogs
In just a few weeks I’ll be doing the Buckeye Blitz. That is, a tour of user groups in Ohio (aka, the Buckeye state, after a tree, not a sports ...
14:41 24-May-2016
SQLServerCentral - Blogs
One of the more interesting features in SQL 2016 is the integration of the R language. For those who haven't seen it before, R is a statistical and data ...
13:30 24-May-2016
SQLServerCentral - Blogs
This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging and queueing technology built into the SQL ...
13:00 24-May-2016
SQLServerCentral - Questions
Hello all, Hope all are doing good..!!! Can anyone say, " Are there any priorities within ddl and dml commands? " Because, I came across a scenario ...
12:57 24-May-2016