Database Weekly

What is Azure SQL Database Serverless?

  • Editorial

I remember when the first SQL databases were available on Azure. The size limits and missing features made them impractical for most uses at the time. Fast forward 10 years and you can you create a terabyte database and take advantage of configurations like Hyperscale, Elastic Pool, and Managed Instances. You get automatic high-availability and […]

2020-06-13

108 reads

The Social Impact of Data

  • Editorial

Let the data drive your decisions. This has been something of a mantra for many technical people, and even many business people, across the last twenty or so years. The allure of business intelligence is harnessing lots of data to make decisions that are rooted in some rational analysis of what has happened. Many companies […]

2020-06-06

42 reads

The Build Book of News

  • Editorial

Every year Microsoft has held the Build conference for developers. I've been lucky enough to go a few times, and I was hoping to get the chance to attend again. With the pandemic, the entire event went virtual, and was held across 48 continuous hours. I was slightly disappointed as a few sessions I wanted […]

2020-05-23

61 reads

Bad Managers

  • Editorial

I’m constantly hearing stories about terrible managers, and, of course, I’ve experienced quite a few myself. In fact, I can’t come up with many nice things to say about most managers when I look back over my career. (Luckily, my manager at Redgate is wonderful!) Early in my tech career, I was working at a […]

5 (1)

2020-05-16

162 reads

The SQL Community Steps up in Time of Need

  • Editorial

Healthcare workers are some of the many heroes working bravely in the face of the Covid-19 pandemic. To protect themselves and their patients, they must wear face masks during their entire shifts. This causes a great deal of ear irritation, so a strap was designed to make wearing the masks easier and alleviate pressure on […]

2020-04-18

118 reads

Now Is a Good Time for Choices

  • Editorial

The whole world is going through some interesting times. Chances are pretty high that you’re working from home and your principal interaction with others is through virtual means. I know I’m that way as is my company, Redgate Software. It can be challenging or rewarding, depending on how you go about it. What’s even more […]

5 (1)

2020-03-28

121 reads

Blogs

ASF 032: Jennifer Stirrup interview

By

Introduction Jennifer Stirrup is a data strategist and technologist, Microsoft Data Platform Most Valuable...

SQL Server Express Size Limit

By

My Pluralsight course for new SQL Server DBAs   (Needs to upgrade to a...

Daily Coping 2 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Adding NOT NULL to column with existing rows causes page bloat

By timoq

Hi, I'd like to know why the page count is almost exactly doubled for...

Stretch database

By mtz676

Is there anything similar to a stretch database in mysql where an on-premise mysql...

Partitioning Heaps

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Partitioning Heaps

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers