Blog Posts

In Memory Table Indexes

Now that I have written about In-Memory Tables and Migrating to In-Memory tables, let’s look at indexes and how they are created and how they work within those tables....

2020-01-27 (first published: )

474 reads

Azure Storage tips

As a followup to my blog post Azure Data Lake Store Gen2 is GA, I wanted to give some pointers when using ADLS Gen2 as well as blob storage,...

2020-01-24 (first published: )

278 reads

Memory Optimizer Advisor

Previously I wrote about In-Memory Optimized Tables, in this blog I am going to discuss how to determine which tables could benefit from being In-Memory by using a tool...

2020-01-23 (first published: )

333 reads

Blogs

Trace Query in Extended Events

By

The ability to quickly and easily trace a query is important to database professionals....

Using Erik Darling’s sp_pressure_detector to resolve CPU issues

By

Last Friday I spent my lunch break going through some links I had marked...

How to Resolve Remove-AzKeyVaultKey : Operation returned an invalid status code ‘Forbidden’ Error

By

I’ve come across another error message in my seemingly never-ending battle with Azure Key...

Read the latest Blogs

Forums

Read Only Files

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Read Only Files

Why A Query May be Faster the Second Time it Runs

By Kendra Little

Comments posted to this topic are about the item Why A Query May be...

OLE DB 0x80004005 connection error trying to run SQL HA Maintenance Plans

By sg_twinmaple

Hi, I'm getting a connection error when I try to run even the most...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers