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


Creating a Simple AI with Unity and C#
The characters in many games today seem lifelike. Under the covers, an application controls the behavior. In this article, Lance Talbert walks you through setting up a game with some simple artificial intelligence built in using Unity and C# read more...

Office Development in Visual Studio
Microsoft Office is heavily used in most organizations, and Microsoft has provided several ways to extend and customize Office applications. In this article, Darko Martinovic demonstrates how to use C# to create several automation solutions, including custom add-ins. read more...

Go Unit Tests: Tips from the Trenches
In this article, Michael Sorens describes unit testing for applications written in Go. While focused on Go, many of his recommendations and techniques can be applied to other languages as well. read more...

Azure Databricks: Simplifying Big Data and AI
The big data and AI world can be a complex one for companies to navigate alone. This has led to the perception of a high entry barrier among many organizations. Some of the early comments and questions we hear from companies we partner with include: ... read more...

Simple Linear Regression in Power BI
Combining Power BI with statistics yields some very powerful results. In this post we’ll show how easy it is to do Linear Regression with the Power BI tool. Linear Regression is a very useful statistical tool that helps us understand the relationship ... read more...

CheckDB Error Msg 824 level 24
One of the common CheckDB errors that I see is the Message 824, level 24. This is something that I regularly work to repair for customers with great success.   DBCC results for ‘YourDatabaseName’. CHECKDB found 0 allocation errors and 0 consistency errors ... read more...

SQL SERVER – Useful Queries – Why Huge Transaction Log (LDF) File? Fix Low Disk Free Space on the Drive Used by LDF Files
During my Comprehensive Database Performance Health Check engagement with the client, one of the most common issue found was the huge size of the transaction log file. In this blog, we would learn about useful queries which I use to help my client in ... read more...

8 practices for business data security
These days, everything from buying clothes to banking is done online, and this is all thanks to technology. The shift of transactional and record-keeping systems from physical to virtual has led to an unprecedented amount of problems, the most troublesome ... read more...

Database ownership chaining in Azure SQL Managed Instance
Azure SQL Managed Instance enables you to run cross-database queries the same way you do it in SQL Server. It also supports cross-database ownership chaining that will be explained in this post. Cross database ownership chaining enables logins to access ... read more...

Dates differences between Excel and DAX
DAX supports dates starting in 1900 and while teaching DAX I always explain that DAX manages dates like Excel, which is the reason why these limitations exist. Actually, this is true – but answering to a comment today I realized I could explain this ... read more...

Announcing new Guatemala SQL Server user group
I am very happy to announce that after a long time struggling and filling all the requirements, we were able to create the SQL Server local user group for Guatemala.The purpose of creating this group was to empower the local database administrators and ... read more...

What’s the Difference Between a Data Warehouse and Data Lake?
Click to learn more about video blogger Andrew Brust. The Big Data & Brews video blog series continues with host Andrew Brust, Senior Director of Market Strategy and Intelligence at Datameer. The series touches on hot topics within the business of Big ... read more...

Mining Plans : Not just for the plan cache
When looking at query performance there are a lot of great sources of information within SQL Server, and one of my favorites is the query plan itself. In the last several releases, notably starting with SQL Server 2012, each new version has included ... read more...

SQL SERVER – Error: 17300 – The Error is Printed in Terse Mode Because There was Error During Formatting
One of my clients contacted me in a situation where their business was down! Their production SQL Server instance used by their Human Resource team was unable to start in a clustered environment. In this blog, we would learn about how to fix the error: ... read more...

What SOX means to the DBA
The responsibilities of a database administrator can seem endless, so why should that already heavy workload be burdened with legislation compliance? Surely, legal stuff can be dealt with by lawyers? Unfortunately, this is no longer the case. With legislation ... read more...

SQL Server Failover cluster instance upgrade failure issue from 2008 R2 to 2012
Today, one of my clients' production environment was facing an issue with the failed upgrade of a SQL Failover Cluster Instance from SQL 2008 R2 to SQL 2012. They were trying the upgrade since a couple of days and it was failing with the below error TITLE: ... read more...

Creating Sparklines And Small Multiples In Power BI Using The Google Image Charts API
The excellent work that David Eldersveld has been doing recently on using SVG images in Power BI has generated a lot of interest; now that the August 2018 release of Power BI Desktop allows you to set data categories on measures – and specifically the ... read more...

What are my permissions?
Permissions are a common concern. One of the most frequent requests I get is I need X, Y and Z permissions. And all too often the conversation goes like this: Dev: I need write permission to this database. Me: Ok. Me: Checks their current permissions. Me: ... read more...

Async Network IO SQL Wait
Over the last few days we have been tracking down the cause of some really high async network IO waits.  In order to fix this problem we have to understand the wait and what it is telling us, so that is where we begin. Async Network IO in my experience ... read more...

Take the SQLChallenge: Tuning a Stored Procedure
I’ve just published a new SQLChallenge course for subscribers, and I think it’s one of the best ones yet. Your mission is to: Identify which statement is slowing down our stored procedure the mostTune the code to speed it up. You can change the query ... read more...