Database Weekly is the seven-day roundup from SQLServerCentral. 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.

Sign up to our newsletter now, to keep up to date with all the latest news.

Latest Database Weekly Newsletter Articles


SQL101: Import/Export wizard
Do you need to quickly Import or Export data to/from SQL Server?  Do you want to avoid the hassle of creating and deploying an SSIS pacakge? The SQL Server Import/Export wizard might be perfect for you! The wizard steps you through the necessary pieces ... read more...

Steps for SQL DB Geo Replication
Unless you are living under a rock, you have most likely heard of the hurricane that is bearing down on the east coast of the United States.  Some areas have mandatory evacuation and I have seen reports of 80’ plus foot waves so this hurricane is not ... read more...

Google Outlines Incident Response Process for Cloud Customers
The four-phased approach is designed to quickly identify incidents, mitigate damage and restore services, the company says. read more...

Intel Fixes Yet Another Flaw In Management Engine
Positive Technologies discovered a new vulnerability in Intel's Management Engine that could allow hackers to compromise sensitive information. read more...

Microsoft Dynamics CRM – Max Degree of Parallelism Settings and Slow Performance
My primary source of income for me is the Comprehensive Database Performance Health Check for any application using SQL Server. Recently, I was hired by a large organization which was struggling with the poor performance of their Microsoft Dynamics CRM. read more...

MN SQLSaturday #796 Pre-Cons
We are just a few weeks out from #sqlsatmn and over 250 have registered! Don’t miss out on securing your spot, register today!  http://www.sqlsaturday.com/796/eventhome.aspx Checkout pre-con events and the earl-bird pricing while it lasts:)  Early-bird ... read more...

Should Index Changes Require Change Control?
We got a phenomenal series of questions from a client, and I wanted to encapsulate the answers into a blog post to help more folks out: Should all index changes require testing in a staging environment, no matter how big or small? What would be a reasonable ... read more...

ADATA Unveils IUSP33F BGA SSDs: Up to 1.2 GB/s Throughput
ADATA has announced its first SSDs in a BGA form-factor. The IUSP33F drives are designed for devices that require a storage solution with a minimal footprint, such as thin-and-light laptops, convertible notebooks, or tablets. Meanwhile, the performance ... read more...

Toshiba’s Portégé X30T: An Uncanny Mix of Clamshell and Tablet
Back at the IFA event in Germany, I noticed that Toshiba had announced a new laptop. However the headline didn’t quite grab my eye. It was only by chance that while walking through the show floor, I stumbled into the Toshiba booth where the device, called ... read more...

The Hidden Danger of Readable Secondaries in SQL Server AlwaysOn Availability Groups
A long time ago in a galaxy far, far away, I had to troubleshoot interesting performance issue in SQL Server. Suddenly, the CPU load on the server started to climb up. Nothing changed in terms of workload. The system still processed the same amount of ... read more...

Connect to SQL Managed instance
SQL Managed instance is located inside a Vnet. The options to connect to it are : read more...

SQL Audit logs in Azure Log Analytics and Azure Event Hubs
We are pleased to announce that Azure SQL Database Audit logs can now be written directly to Azure Log Analytics or Azure Event Hubs. This ability, now available in public preview, provides SQL Database Auditing customers with an easy way to centrally ... read more...

Lesson 12 - Data Frames
Those of you with a strong background in databases will see some familiar concepts in this post. For lesson 12, we will consider datasets and structures in R that can accommodate them. Thinking back on what's been covered so far, we know vectors and ... read more...

Performance Problems With MDX Calculated Measures That Return Constants In Analysis Services Multidimensional
Recently I was working on an MDX calculation that calculated a value at a low granularity and aggregated the result – basically what I described in my blog post here. Here’s a simplified version of the calculation written on a cube built from Adventure ... read more...

Customer Roadblocks to Azure
When I speak with customers, I often find they share common roadblocks to using Azure. I recently sat down with our Consulting Sales Manager in Texas, to ask what he hears from customers, to see if together, we can shed some light to clear up some of ... read more...

Them Con+cat+enatin’ Blues
We ran into a funny problem not long ago, revolving around a stored procedure that was building up a dynamic SQL string. The code had worked without a hitch in our development and test environments but blew up when it was moved to production due to the ... read more...

A Quick Intro to DevOps in Azure
Today, I’d like to discuss DevOps in Azure and tell you why you should consider using DevOps when you start moving to Azure. What DevOps is, can be hard to define. Everyone seems to know what it is, but no one can seem to define it in a simple way. Microsoft’s ... read more...

Finding Table Defaults, Primary and Unique Keys and Foreign Keys with sp_helpconstraint
A little while back I wrote a post going over sp_help in a beginning effort to find table dependency information.  https://www.sqlrx.com/using-sp_help-to-find-object-dependencies/.  That expanded to reviewing sys.dm_sql_referenced_entities & sys.dm_sql_referenced_entities  ... read more...

A Day in the Life of Brent Ozar: July 23, 2018 #SQLCareer
Steve Jones asked data professionals to cover four days in our lives, so I blogged about a normal non-client-facing day, and then an unproductive day. Today is different: I’m client-facing. We specialize in a 3-day SQL Critical Care: Day 1 – we meet ... read more...

How AI is leading to Autonomous Enterprise Integrations
Click to learn more about author Prasanna Kumar Illa. We all are aware that AI (Artificial Intelligence) plays an increasingly significant role in automating highly repetitive tasks, at scale. By repeatedly analyzing the data, AI adapts progressive learning ... read more...