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
Last week in Part One I went through how to mount directories from the host server into a docker container in order to persist data. However, you don’t ...
08:00 28-Jun-2017
SQLServerCentral - Editorials
The SQL:2016 standard is out in draft and SQL Server lags a bit. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this ...
23:00 27-Jun-2017
SQLServerCentral - Main Articles
Learn how to clean bad characters from lots of data in this article.
23:00 27-Jun-2017
SQLServerCentral - Main Articles
This free eBook from Redgate Software will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and ...
23:00 27-Jun-2017
SQLServerCentral - Main Articles
You can produce HTML from SQL because SQL Server has built-in support for outputting XML, and HTML is best understood as a slightly odd dialect of XML ...
23:00 27-Jun-2017
Simple-Talk - SQL Articles
If you’ve been around SQL Server for a while, you know that writing T-SQL code is nothing to treat ...
16:52 27-Jun-2017
Simple-Talk - SQL Articles
Although Azure is the obvious Cloud service to host SQL Server, Amazon Relational Database Service (RDS) ...
16:49 27-Jun-2017
Simple-Talk - Cloud Articles
Although Azure is the obvious Cloud service to host SQL Server, Amazon Relational Database Service (RDS) ...
16:49 27-Jun-2017
SQLServerCentral - Blogs
Having covered authentication yesterday, let’s move on the second A, authorization. Authentication was about proving identity. Now that we know ...
14:00 27-Jun-2017
SQLServerCentral - Questions
I am researching a new encryption option introduce in `SQL Server 2016 CP1`, called always-encrypted. Basically, I need to create a certificate which ...
12:14 27-Jun-2017
SQLServerCentral - Blogs
Having the right tools for the job makes the work much more efficient. However, for those just starting out in SQL Server land, it may not be clear which ...
10:59 27-Jun-2017
SQLServerCentral - Blogs
I was VERY excited when I read the following tweet (below) from Bob Ward regarding SQL Server Diagnostics capability. What is it you are asking? It is ...
09:55 27-Jun-2017
SQLServerCentral - Questions
Hello all, I need to create a process in SSIS that will do the following things per each csv file separately. Each file has a different number of columns ...
06:12 27-Jun-2017
SQLServerCentral - Questions
i want to insert a table with value like that print right('000000' + cast(next value for SequenceExample as nvarchar ), 6) but i get error Msg 11738, ...
02:22 27-Jun-2017
SQLServerCentral - Editorials
The ability to protect, and perhaps handle, sensitive data separately from other data is becoming more important. Steve Jones discusses the process and ...
23:00 26-Jun-2017
SQLServerCentral - Main Articles
In this article, we'll explore a less used feature of SQL Server: filegroup restoring, feature that has an interesting consequence because database can ...
23:00 26-Jun-2017
SQLServerCentral - Main Articles
Have you ever wanted to be able to see the actual transactions that are contained in the transaction log file? Greg Larsen shows you how to browse the ...
23:00 26-Jun-2017
SQLServerCentral - Questions
I apologize for asking frequent question. I have tried multiple solutions suggested. I am getting the message very clear but why does the processing ...
20:05 26-Jun-2017
SQLServerCentral - Questions
I have this solution to find Functions or stored procedures but what would I add to the When clause to get Views? I know it's along the lines of: WHEN ...
19:48 26-Jun-2017
SQLServerCentral - Questions
Hi , I have to divide a table that Financial Department gave to me , it is table with three columns: DEPT MONTH BUDGET A 1 ...
17:38 26-Jun-2017
SQLServerCentral - Blogs
Managing indexes is a critical component of database maintenance but we often don't think about the indicators behind the index maintenance operations. ...
16:59 26-Jun-2017
SQLServerCentral - Blogs
I had a strange situation the other day, where a number of things went wrong with my instance. First, I lost permissions to detached databases. The SID ...
14:27 26-Jun-2017
SQLServerCentral - Blogs
SQL Server provides multiple ways to perform most functions. In order to maximize your understanding of how SQL Server works and have as many different ...
13:03 26-Jun-2017
SQLServerCentral - Blogs
Brent Ozar (b/t) posted a pop quiz on twitter earlier today. Go ahead and give it a shot .. I’ll wait. So? What do you think? Did you get it ...
12:00 26-Jun-2017
SQLServerCentral - Blogs
VM snapshots are one of the best virtualization features ever. But.have you ever had a VMware vSphere or Hyper-V snapshot grow out of control and fill ...
11:43 26-Jun-2017
SQLServerCentral - Blogs
Join me Friday, July 21, 2017 for a day of Real-life SQL Server Performance Troubleshooting ...
11:02 26-Jun-2017
SQLServerCentral - Blogs
When I start talking with folks about security, one of the areas of confusion I often find has to do with the three A’s of security. Specifically, ...
11:00 26-Jun-2017
SQLServerCentral - Questions
the single record that i used is table shipment_assignment or table a on this scheme then i add alias ...
09:56 26-Jun-2017
SQLServerCentral - Blogs
Last week I asked the following question on Twitter: – I was interested to see the responses as I wanted to know how more experienced presenters ...
07:18 26-Jun-2017
SQLServerCentral - Blogs
Previous Related Post: Split personality text editing in SSMS with Sublime Text 3 In this prior post I wrote about how to call Sublime Text 3 from SSMS ...
04:00 26-Jun-2017
SQLServerCentral - Blogs
One of the real-world I/O troubleshooting problems is - If you have your databases spread across multiple LUNs and you want to find out which database ...
00:32 26-Jun-2017
SQLServerCentral - Questions
Hello group. I just recently completed my MCSE Data Management and Analytics, but did it using the MCSA 2012/14 path with exam 461,462,and 463. I am ...
23:43 25-Jun-2017
SQLServerCentral - Editorials
If you have ideas for how to improve replication, Steve Jones is asking for them.
23:00 25-Jun-2017
SQLServerCentral - Main Articles
How we overcame the A to Z Windows Drive-Letter limitation using Volume Mount Points
23:00 25-Jun-2017
SQLServerCentral - Main Articles
Database Lifecycle Management aims to make the development and modification of databases more predictable. Bugs are the source of more unpredictability ...
23:00 25-Jun-2017
SQLServerCentral - Blogs
[2017-June-25] There are several custom solutions that make Twitter messages analysis possible in Power BI. And with a recent addition of the Campaign/Brand ...
22:39 25-Jun-2017
SQLServerCentral - Blogs
Continuation from the previous 106 parts, the whole series can be found at http://www.nikoport.com/columnstore/. I would like to thank Sunil Agarwal (Program ...
12:26 25-Jun-2017
SQLServerCentral - Questions
I'm having trouble understanding how the DATE data type storage is 3 bytes in SQL Server. The DATE data type stores only date values with a range of ...
19:48 24-Jun-2017
SQLServerCentral - Blogs
This past year has certainly been interesting in the world of Linux. Microsoft has taken a new strategy and is embracing the open source model. It's releasing ...
10:50 24-Jun-2017