Kathi Kellenberger

The New Year: A Chance to Start Over

January 1st is the beginning of a new year thanks to Julius Caesar and Pope Gregory XIII. This date is somewhat arbitrary, and many religions and cultures celebrate their own beginning of a new year at different times. Even though these celebrations don’t fall at the same time, I think the sentiment is similar. The […]

5 (1)

2019-12-28

79 reads

A Faster tempdb

I like to call tempdb the “workhorse” of SQL Server. I’ve heard some other people call it other terms that were not so flattering, but since I like to keep things positive, I’ll stick with workhorse. SQL Server uses tempdb for many things. The obvious uses are temp tables and table variables, but tempdb is […]

5 (3)

2019-11-02

509 reads

Which Service in Azure Should You Use for SQL?

I remember when Azure SQL Database was first released in 2010. Microsoft has tweaked the name a couple of times over the years, and back then it was called SQL Azure. The largest database you could create was just 50 GB, and there were quite a few restrictions, such as heaps not being supported. Since […]

2019-10-05

189 reads

Blogs

Azure Storage tips

By

As a followup to my blog post Azure Data Lake Store Gen2 is GA,...

Managing Agent Jobs on Availability Group Servers

By

As always, the scripts in this post can also be found on our Git...

Permissions required for row counts to show up on Object Explorer Details

By

I ran into a rather obscure permissions problem the other day. Since I wasn’t...

Read the latest Blogs

Forums

First DW design - advice appreciated

By as1981

All, Up to this point I've only worked with relational databases. I'm trying to...

Backup Strategy For distributed availability groups

By juniorDBA13

What is the recommendations for backups in distributed availability groups? I have AG setup...

What happens when I drop a huge table with LOBs? will the space be reused?

By NJ-DBA

Thanks in advance for your help. I have a 5TB database with mutliple filegroups. ...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers