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


Learn T-SQL with the StackOverflow Database
You work for a company that’s got a lot of data in Microsoft SQL Server, and you want to work with it – but you’re not sure how to start. You’re also afraid that your queries might be “bad,” and you don’t want to cause problems on someone else’s server – even when you need to work with a lot of data read more...

When Algorithms Go Astray
The tale of Marc Elliott's algorithm raises a specter about which we all have to be concerned in this era when companies are generating models and algorithms by the truckload. read more...

Database Changes - Build Once, Deploy Anywhere
A core concept of continuous delivery is build once, deploy anywhere. The idea behind it is simple, code is built once and deployed to all the servers throughout the various environments. For example, if you had a development, testing, staging and production server, you would build once before deploying to development. Once verified, that same package would then be deployed to testing and the process would repeat itself. read more...

Design Pattern Haikus
Jeff Foster explains the some design pattern basics through the ancient poetic arts. read more...

Why is Uninstalling SQL Server Such a Pain?
Tony Davis discovers that the SQL Server uninstall button is hard to find... read more...

Events By Feature
Within the world of SQL Server there are a few things one can be certain of – things will change. This is true of the features in SQL Server. Additionally, Extended Events is constantly evolving which underscores this constant change. read more...

Why We Still Don’t Have Better Batteries
Despite very promising results from the 75-odd energy-storage research projects that ARPA-E funds, however, the grail of compact, low-cost energy storage remains elusive. read more...

The Dropbox hack is real
Motherboard reported on what had been rumoured for some time, namely that Dropbox had been hacked. Not just a little bit hacked and not in that "someone has cobbled together a list of credentials that work on Dropbox" hacked either, but proper hacked to the tune of 68 million records. read more...

What is Serverless Computing? Exploring Azure Functions
"Serverless Computing" doesn't really mean there's no server. Serverless means there's no server you need to worry about. That might sound like PaaS, but it's higher level that than. read more...

Files and File Groups in SQL Server
Klaus Aschenbrenner goes into depth on how SQL Server handles files and file groups, and looks at how to optimize for performance using multiple file groups. read more...

Azure SQL Data Warehouse Execution Plans
Azure SQL Data Warehouse can sometimes feel like it’s completely different from SQL Server, but under the covers, it is still (mostly) SQL Server and it does have execution plans. read more...

Building a Desktop Workstation for SQL Server Development and Testing
With the current selection of high-performance and very affordable desktop computer components, it is not very difficult to assemble an extremely high performance workstation for SQL Server development and testing at a very reasonable cost. Depending on how much performance you want and what your available budget is, you can take several different routes to get this accomplished. read more...

What’s New in SQL Server 2016 Analysis Services?
SQL Server 2016 Analysis Services (SSAS) includes many new enhancements providing improved performance, easier solution authoring, automated database management, enhanced relationships with bi-directional cross filtering, parallel partition processing, and much more. At the heart of most enhancements for this release is the new 1200 compatibility level for tabular model databases. read more...

Data-Driven Power BI Desktop Parameters Using List Queries
The July 2016 update for Power BI Desktop included the ability to make parameters data-driven, by giving the option to bind the Suggested Values property of a parameter to the output of a query that returns a list. if you’re wondering what a list is and how to get query to return one so you can use it in a parameter, then read on. read more...

SQL Server Default Port
This article explores the default port number of SQL Server required for getting connected to different applications. read more...

Do Clustered Index Columns Count Against Max Nonclustered Key Size?
SQL Server 2016 and Azure SQL Database have a lot of little perks. One little thing that changed is that the maximum key size allowed for nonclustered indexes was raised from 900 bytes to 1700 bytes. Whoa! That’s room for a lot more key columns in there. Bring on the SSDs! Load up the memory! read more...

In Defense Of Linked Servers
Conventional wisdom flags up a raft of issues with linked servers for SQL. Dave Mason challenges that wisdom and addresses some of the known issues. read more...

Data, Information, Knowledge Discovery, and Knowledge Representation
The use of SQL databases (confused with relational databases) is often questioned for certain analytical purposes. For example, scientific research experiments that “requires assignment of data to tables, which is difficult when the scientists do not know ahead of time what analysis to run on the data, a lack of knowledge that severely limits the usefulness of relational databases. read more...

Networking Doesn't Scale. Coding and Blogging Do.
Networking is a time suck that doesn’t scale. Whenever you want to make new connections, you have to go to a location, be mentally present, and you can’t be doing anything else. It’s an active task, not a passive task. read more...

What is domain logic?
Domain logic (aka business logic, business rules, and domain knowledge) is the logic that makes business-critical decisions. read more...