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


DatabaseWeekly - Newsletter
Anthony Nocentino introduces the basics of CPU scheduling in Windows and SQL Server so that when you see things slow down in either of one of these technologies ...
17:45 26-May-2016
DatabaseWeekly - Newsletter
Karthik provides a simple solution to querying a table that has comma separated values.
17:45 26-May-2016
DatabaseWeekly - Newsletter
Ahmad Yaseen takes a look at how to deal with an endpoint encryption compatibility error when using SQL Server's AlwaysOn Availability Group Wizard.
17:45 26-May-2016
DatabaseWeekly - Newsletter
Microsoft's Steve Lasker briefly explains the benefits of using containers compared to VMs
17:45 26-May-2016
DatabaseWeekly - Newsletter
Kong Yang talks through how to deal with security and compliance concerns, support for legacy systems, and budget limitations when implementing cloud ...
17:45 26-May-2016
DatabaseWeekly - Newsletter
In SQL Server Master Data Services all the entities are organized in a model. Once a model is ready to be released to subscribers, it should be frozen ...
17:45 26-May-2016
DatabaseWeekly - Newsletter
The former head of engineering at Rent the Runaway, Camille Fournier, looks at how to measure the success of an engineering team.
17:45 26-May-2016
DatabaseWeekly - Newsletter
Kendra answers a question about early adoption of SQL Server, discusses why testing in production isn't necessarily crazy, and recommends how to handle ...
17:45 26-May-2016
DatabaseWeekly - Newsletter
Arshad Ali discusses SQL Server 2016 Query Store and how it greatly simplifies the performance troubleshooting ...
16:45 26-May-2016
DatabaseWeekly - Newsletter
Julie Rodriguez and Piotr Kaczmarek talk about how visualizations that show comparisons, connections, and conclusions offer analytical clarity.
16:45 26-May-2016
DatabaseWeekly - Newsletter
Vitor Fava looks at how AutoClose property works, and why it's recommended you disable it.
16:45 26-May-2016
DatabaseWeekly - Newsletter
Oracle's lawyers have made their final pitch to paint Google as a copyright outlaw, and the decision is now up to a 10-person jury. Joe Mullin gives some ...
16:45 26-May-2016
DatabaseWeekly - Newsletter
Bradley Ball shares his own Random Workload Generator, and talks through how and why he tweaked the original created by Jonathan Kehayias a few years ...
16:45 26-May-2016
DatabaseWeekly - Newsletter
Though most DBAs don't have the permissions to change the settings in Active Directory (AD) that affect Kerberos, it's still a good idea to understand ...
15:45 26-May-2016
DatabaseWeekly - Newsletter
Moty Fania, principle engineer for big data analytics at Intel IT, talks through the company's internal IoT platform
15:45 26-May-2016
DatabaseWeekly - Newsletter
Oracle is introducing a major new release of its NoSQL database - version of 4.0. Joyce Wells runs through the five key talking points of the new release. ...
15:45 26-May-2016
DatabaseWeekly - Newsletter
Dr. Athanasios Gentimis' field of expertise is Algebraic Topology, with a special interest in Geometric ...
15:45 26-May-2016
SQLServerCentral - Questions
I'm making a website for a private tuition classes. Here, the concept is that a teacher goes to teach to the student's house. There are many teachers ...
10:53 26-May-2016
SQLServerCentral - Blogs
In this post we're going to introduce the basics of CPU scheduling. In a computer system, only one thing can happen at a time. More specifically, only ...
10:23 26-May-2016
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
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
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