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
Hi All, I have a small problem with implicit schema creation. I have several members in my dev team that are member of a group (domain\devgroup). The ...
12:56 10-Jul-2017
SQLServerCentral - Blogs
In the previous post in this series, I addressed how to use an on-premises instance of SSIS to move data to and from Azure databases. If you're running ...
10:01 10-Jul-2017
SQLServerCentral - Blogs
If you keep your head up and look around you’ll see the choices people make all the time. I saw a recent example online in this story about two ...
09:59 10-Jul-2017
SQLServerCentral - Questions
Hello I have one Project number 0110 in one table but in other table its 0110A-B so when i do a join between these 2 tables with proj number the above ...
08:32 10-Jul-2017
SQLServerCentral - Blogs
I’ve always been particularly cautious when it comes to deploying code to databases, some would say overly cautious. Because of this I’ve ...
07:40 10-Jul-2017
SQLServerCentral - Blogs
Suppose, you have Transactional Replication configured in your production environment. There is a business ...
23:00 09-Jul-2017
SQLServerCentral - Editorials
What makes SQL Server professionals stick together? Can we draw any conclusions from this?
23:00 09-Jul-2017
SQLServerCentral - Main Articles
In this article, we will show how to create a WPF application ans show how to insert data to ASDW. How to fix SQL Server disk I/O ...
23:00 09-Jul-2017
SQLServerCentral - Main Articles
Practice makes perfect. That's true of everything, including disaster recovery. If you aren't already testing your DR plan, you should be - here's what ...
23:00 09-Jul-2017
SQLServerCentral - Main Articles
The majority of Azure SQL Database related features reach their General Availability (GA) stage relatively quickly. There are however, some exceptions. ...
23:00 09-Jul-2017
SQLServerCentral - Questions
Can Anyone discuss how to exactly incorporate DDL Schema changes with Always On Availability Groups, step by step? We have a Primary Replica in one state, ...
21:27 09-Jul-2017
SQLServerCentral - Questions
hi friends, i want to migrate from sql2012 to sql2016 using distributed AG and then remove sql 2012. Does anyone has any experience, documents or video ...
10:40 09-Jul-2017
SQLServerCentral - Questions
i use a query like: select CUSTOMER_ID INTO #mc FROM USR_Customer_VW select TOP 3500 v.CUSTOMER_ID,x.* from #mc v CROSS APPLY [dbo].[udf_GetMaxDate](v.customer_id) ...
02:35 08-Jul-2017
SQLServerCentral - Questions
We are seeing frequent error messages like this: "[WARNING] === At least 16 extensions for file {FFC2D582-1684-4B50-AC03-5964A39885E1} (d:\b\s1\sources\sql\ntdbms\hekaton\engine\hadr\mtlog.cpp ...
22:15 07-Jul-2017
SQLServerCentral - Questions
Hi, In case of two companies, code 1 and code 2. Both have a customer with the same code. How to query only sales of customers in company 1? Company ...
20:49 07-Jul-2017
SQLServerCentral - Blogs
With SQL Server coming on Linux, some people will want to learn a bit of Linux. Or perhaps they need to get re-acquainted with the OS, which is my situation. ...
18:41 07-Jul-2017
DatabaseWeekly - Newsletter
In this episode of the Azure Government video series, Zach Kramer talks with Matt Rathbun (CISO, Azure Government) about compliance in Azure Government. ...
15:47 07-Jul-2017
DatabaseWeekly - Newsletter
I show you the general tasks of Azure Cosmos DB Gremlin (graph) for your first use, and a little bit dive into the practical usage of graph query. This ...
15:47 07-Jul-2017
DatabaseWeekly - Newsletter
Applying a patch in SQL Server is a planned process which is followed across various companies. Most ...
15:47 07-Jul-2017
DatabaseWeekly - Newsletter
Azure SQL Data Sync is a service of Azure SQL Database that enables you to synchronize relational data you select across multiple cloud databases and ...
15:47 07-Jul-2017
DatabaseWeekly - Newsletter
Final testing, a lesson in barometric pressure, and learning to accept potential failure. Here's the second HASSP testing diary.
15:47 07-Jul-2017
DatabaseWeekly - Newsletter
Building stuff I sometimes really hate coming up with ideas, and much prefer someone to just say "I want this" so I can go out into the world and figure ...
15:47 07-Jul-2017
DatabaseWeekly - Newsletter
I've started to look at the excellent dbatools.io to automate some of the checks that I routinely perform on my SQL instances. But before I go into this ...
15:47 07-Jul-2017
DatabaseWeekly - Newsletter
Microsoft Most Valuable Professionals are passionate technology experts who share their knowledge with the community. They are always on the "bleeding ...
15:47 07-Jul-2017
DatabaseWeekly - Newsletter
A little over a month ago, I gave an update on our progress of moving the Windows team to Git in the largest Git repo on the planet.  At the time, I described ...
15:47 07-Jul-2017
DatabaseWeekly - Newsletter
The feature was introduced in New Release Definition Editor in Team Services. It's therefore not really ...
15:47 07-Jul-2017
SQLServerCentral - Questions
Hi All, Sorry to bother but I have quite a strange situation. I have a member of our dev group (domain\devgroup) who is not mapped as a login on server ...
15:38 07-Jul-2017
SQLServerCentral - Blogs
Microsoft has introduced two new disk sizes for Azure IaaS VMs in P40 (2TB) and P50 (4TB) for both managed and unmanaged Premium Disks and S40 (2TB) and ...
14:00 07-Jul-2017
SQLServerCentral - Questions
**BY mistake somebody has updated tables approx 10000000 records can i know who & when it was updated**
13:49 07-Jul-2017
SQLServerCentral - Questions
Hello, I am creating a server report for sql 2000. I need to get sql port number and sql replication information along with other info like services ...
11:58 07-Jul-2017
SQLServerCentral - Questions
I have a data of order per costumer and per date that I achieved to present in the following way: ID Date Record ColNumber RowNumber ...
11:45 07-Jul-2017
SQLServerCentral - Questions
Anytime I try to backup database from my computer, it will tell me "The server principal is not able to access the database " UFC" under the current security ...
09:58 07-Jul-2017
SQLServerCentral - Blogs
I’ve started to look at the excellent dbatools.io to automate some of the checks that I routinely perform on my SQL instances. But before I go into ...
08:30 07-Jul-2017
SQLServerCentral - Blogs
Final Lions Test tomorrow! The win last week sets up a thrilling series decider, if they win they’ll be the first Lions Team to win a series against ...
08:00 07-Jul-2017
SQLServerCentral - Questions
Hi All, I'm trying to import a ANSI format file which contains a name **Portomeñe**. But when I import it using the DAta flow task, it is importing ...
07:49 07-Jul-2017
SQLServerCentral - Questions
I have a table with repeating Name column already in a specific order that I need to pull out only the DISTINCT values from Name column but they must ...
07:49 07-Jul-2017
SQLServerCentral - Editorials
Today Steve Jones is looking for database design resources.
23:00 06-Jul-2017
SQLServerCentral - Main Articles
Start learning Powershell (PoSh) for SQL Server and improve your ability to write utilities that will make your job easier.
23:00 06-Jul-2017
SQLServerCentral - Main Articles
Jonathan Kehayias discusses SQL Server on VMware, and how to monitor CPU performance - with or without access to vCenter. How to fix ...
23:00 06-Jul-2017