Database Weekly

SQL Server 2019 CTP 3.2 Available

  • Editorial

Microsoft announced CTP 3.2 for SQL Server 2019 just a few days ago, but many people working with SQL Server don’t care about this. I run into people at user group meetings and SQL Saturdays who are stuck supporting versions as old as SQL Server 2000, and SQL Server 2008 R2 is still prevalent. I’m […]

2019-07-27

501 reads

Building or Buying Analytics

  • Editorial

One of the decisions that I've been involved with at the beginning of every software project is whether to buy software to solve the problem or build our own. This might be a quick "is there software anyone knows about to do this?" query, or an in-depth review of the marketplace or something in between. […]

2019-06-08

183 reads

Why Tools Can Help You Do Your Job

  • Editorial

Back in my days as a SQL server DBA, I didn't have many third-party tools at my disposal. I remember having a monitoring tool with licenses for only three or four SQL server instances. Whenever there was a problem with one instance that wasn’t currently being monitored, I would have to stop monitoring another instance […]

2019-05-18

200 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