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


SQL in the City Streamed: Standardizing Database Change Management across your Organization
Date and time: Wednesday April 3, 09:00-14:00 Eastern / 14:00 - 19:00 BST Microsoft MVPs Kendra Little, Grant Fritchey, Steve Jones, and Kathi Kellenberger lead the speaker line-up for this free virtual event. Join online for sessions designed to broaden your skillset, support your ongoing learning, and keep you up-to-date with the industry. read more...

Webinar: Don’t just think DevOps. Think Compliant Database DevOps!
Wednesday March 20, 15.00-16.00 GMT / 10.00-11.00 CDT How can the promise of releasing changes to the database faster and easier be balanced with the need to keep data safe and remain compliant with legislation? Join this webinar to discover how the answer lies in in going one step further than database DevOps and thinking about Compliant Database DevOps. read more...

Webinar: The Importance of Monitoring your Azure SQL Database
Wednesday March 6, 15.00-16.00 GMT / 9.00-10.00 CST Monitoring Azure SQL Database is still a necessary part of understanding how your system is behaving and ensures that you have the information needed to make necessary decisions about your databases in a timely and accurate manner. read more...

Regression Testing Overview
In a previous post, I touched on the point of testing and briefly touched on regression testing. In this post, I will be going into more detail about what regression testing is and why it’s important to do it. read more...

DBA Myths: Can a differential backup get bigger than the full backup?
The thing about DBA Myths is that they are generally widespread and widely believed. At least I believed this one until I posted What’s a differential Backup? and Randolph West (b/t) pointed out that my belief that differential backups can’t get larger than full backups was incorrect. read more...

Using the Wait Statistics Report in Azure Data Studio
Azure Data Studio, which used to be called SQL Operations Studio, has a bunch of extensions available, including one called Server Reports from Microsoft. Last year they took my wait stats query (from here) and made it into a report as part of Server Reports extension. In this quick post I’ll show you how to install that extension and look at the report. read more...

Does sp_executesql WITH RECOMPILE Actually Recompile Anything?
No, No It Doesn’t. But it’s fun to prove this stuff out. Let’s take this index, and these queries. read more...

Error converting data type varchar to numeric where ISNUMERIC finds only numbers
I am writing some SQL to form the basis of views to pull data from a Microsoft SQL Server source into Azure SQL Database, and then the data would go to Power BI. The data was all presented in string format initially (not my data, not my monkeys, not my circus), and I wanted to correct the data types before the data got into Power BI. read more...

Proposed SQL Server defaults: disable lightweight pooling
A few months ago I suggested that the following settings should be the default for most SQL Server instances. Set cost threshold for parallelism to 50 Disable lightweight pooling if it is enabled Disable priority boost if it is enabled Set optimize for ... read more...

PolyBase Revealed: CDH Quickstart And PolyBase
All of my experience with Hadoop has been with the Hortonworks Data Platform. But to make sure that the stuff I’m advising in PolyBase Revealed works for Cloudera too, I grabbed the Cloudera QuickStart VM and took it for a spin. The two products are ... read more...

Gartner Identifies Top 10 Data and Analytics Technology Trends for 2019
According to a recent press release, “Augmented analytics, continuous intelligence and explainable artificial intelligence (AI) are among the top trends in data and analytics technology that have significant disruptive potential over the next three to ... read more...

Three Key Requirements for Continuous Integration in Cloud Environments
In my previous blog post I discussed hybrid cloud computing. The phrase Hybrid Cloud Computing is used to describe the coexistence of multiple environments, at least one of which is a cloud environment. Hybrid ... read more...

Re-imagining the Business with Artificial Intelligence
Artificial Intelligence (AI) will be a strategic capability and competitive advantage, no doubt. Statistics speak to that point. According to AI startup advisor Steve Ardire during his presentation (co-presented with Mico Yuk) at the DATAVERSITY® Enterprise ... read more...

How to get Live Execution Plan using Extended Events
Have you ever found yourself in a situation where you were supposed to troubleshoot a long running expensive query that was hammering your SQL Server? I bet you wanted to get and analyse the actual runtime execution plan of this query. In ... read more...

What is the Best Training for Business Analysts?
The rate of change in the tools available to a Business Analyst has never been faster than it is today.  The market is changing so quickly ... read more...

Protecting Data During Development
In the years before joining Redgate, I was a SQL Server database consultant. I spent a lot of time doing SQL Server health checks, query tuning, and ETL (extract, transform, and load) development. Every customer was different and getting to the resources I needed to do the job at each shop varied as well... read more...

Why and how you should speak at a conference
You may think that speaking at usergroups and conferences is reserved for a select group of elite professionals. Let me tell you right away that this is not the case, and that you should seriously consider a rewarding side career as a speaker at usergroups ... read more...

Thoughts On The New Power Query Source In SSIS
Yet more evidence that Power Query is taking over the world: there’s a new Power Query data source for SQL Server Integration Services in the latest version of SSDT. Here’s the blog post announcing it (the actual announcement is halfway through): https://blogs.msdn.microsoft.com/ssis/2019/02/15/deeper-integration-and-new-connector-for-ssis-in-adf/ And ... read more...

Microsoft’s Developer Blogs are Getting an Update
In the coming days, we’ll be moving our developer blogs to a new platform with a modern, clean design and powerful features that will make it easy for you to discover and share great content. This week, you’ll see the Visual Studio, IoTDev, and Premier ... read more...

Migrating your existing on-prem SQL Server database to Azure SQL DB
If you are in the process of moving an existing .NET application to Azure, it’s likely you’ll have to migrate an existing, on-prem SQL database as well. There are a few different ways you can go about this, so let’s go through them. Data Migration Assistant ... read more...