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


What’s the Size of that Index?
Which indexes are the big space consumers within the specified table for the given database? read more...

SQL Server 2016 Community Technology Preview 2.2 is available
The SQL Server 2016 CTP 2.2 incremental release includes new capabilities for query store, stretch database, core engine, temporal, MDS, reporting services and engine scalability improvements. read more...

The pain of Forced Parameterization in SQL Server
Klaus Aschenbrenner explains why Forced Parameterization is not always a good choice. read more...

SQL Style Guide
You can use this set of guidelines, fork them or make your own - the key here is that you pick a style and stick to it. read more...

In data science, the R language is swallowing Python
According to a new survey, Python’s data science training wheels increasingly lead to the R language read more...

Grant’s Fly-by-night Leadership Course – The Plan
Grant Fritchey sketches out some of his goals for a proposed Leadership Training Course. read more...

Getting Started with Windows 10
Scott Hanselman shows how to upgrade the Start menu after upgrading to Windows 10. read more...

Encrypting Existing Data with Always Encrypted
With Always Encrypted sensitive data is transparently encrypted and decrypted within a client application by a client driver. SQL Server does not have access to plaintext encryption keys and cannot encrypt or decrypt encrypted data. An important implication of the above is that encrypting existing data requires downloading the data to a trusted client machine, encrypting it and uploading it back to the database. read more...

Indexes on GUIDs – Not Only Fragmentation
An ETL process that inserted a few thousand rows every few minutes was taking 300 milliseconds, and suddenly the duration spiked to about 3 seconds. What was that tipping point? read more...

SQL Server 2016 Video Pills
This Curah is a collection of videos on the most important features of SQL Server 2016. Speakers are Engineers and Program Manager of the SQL Server Team! read more...

Proactive SQL Server Health Checks, Part 4 : ERRORLOG
When a performance issue exists in SQL Server, it’s ideal to troubleshoot the issue live, but in some cases, historical information can provide a smoking gun, or at least a starting point. A great source of historical information in SQL Server is the ERRORLOG. read more...

Improving the Row Numbering Median Solution
The fastest way to compute a median uses the SQL Server 2012 OFFSET extension to the ORDER BY clause. Running a close second, the next fastest solution uses a (possibly nested) dynamic cursor that works on all versions. This article looks at a common pre-2012 ROW_NUMBER solution to the median calculation problem to see why it performs less well, and what can be done to make it go faster. read more...

Review: Goodbye, Windows 8; hello, Windows 10
Mary Jo Foley's review of Windows 10 after using it for a week. read more...

How to ETL Data into and out of Amazon Redshift
A key question about any data warehouse, often overlooked in the purchasing process, is how the data gets in and out. While performance is obviously critical, you will be loading data in and dumping data out all day long. A simple, scalable process is critical. read more...

Microsoft and Database Lifecycle Management (DLM): The DacPac
The Data-Tier Application Package (DacPac), together with the Data-Tier Application Framework (DacFx), provides an alternative way to automate the process of scripting out, or deploying a SQL Server database, reporting on changes, or checking version-drift. read more...

The key to avoiding source control problems
It’s a familiar story. Two developers are working on a database, they’re using source control, and there’s a problem. The bigger problem is, they don’t even know they have a problem. As far as they’re, concerned, they’re doing everything right. They’ve ... read more...

Announcing SQL Server Management Studio - July 2015 Release
Today, we announce the latest preview of SQL Server Management Studio (SSMS). It is the second release in our fast-train preview program. This release includes all updates included in the June release and features Database diagramming support for Azure...(read ... read more...

SQL SERVER – What are T-SQL Window Functions? – Notes from the Field #090
[Note from Pinal]: In this episode of the Notes from the Field series database expert Kathi Kellenberger explains about T-SQL Median. Kathi is an amazing instructor, she was the SQL author I have read in my early career. The reason, I love SQL Server ... read more...

Show Me the Tuition
College in the United States is expensive. read more...

Azure Data Services for (near) Real Time Scenarios
Light takes about 8 and half minutes to get from the surface sun to the earth and it can actually take a photon 20,000 years to get form the core of the sun to the surface.  On earth that means that if the sun stops shining we wont know about it until ... read more...