Articles

Free eBook: SQL Server Internals: In-Memory OLTP

In this free eBook, Kalen Delaney explains how Microsoft's 2016 In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton.

2020-03-25 (first published: )

55,467 reads

Using SQL Monitor Groups in PowerShell

Not only are SQL Monitor Groups probably the neatest and most maintainable way of ensuring that all your SQL Servers have the best possible configuration of alerts, but they represent a powerful way of categorizing your SQL Server estate. In this article, I'll show how to use the SQL Monitor PowerShell API to export these groups, save their settings onto a configuration management system, or compare groups of settings to see the differences between them.

2020-03-25

607 reads

Blogs

ASF 030: Benni De Jagere interview

By

Introduction Benni De Jagere is a Senior Data Insights Consultant with a strong focus...

Going Dark in SSMS

By

I haven’t been a big fan of dark mode in many tools, but I’ve...

Figuring Out How To Hide Production Data

By

There’s a really simple conundrum that we go through all the time. The best...

Read the latest Blogs

Forums

How to make join to teams display without join all teams ?

By ahmed_elbarbary.2010

problem How to make left join to only teams displayed  dynamically depend on fields...

sql server memory buffer cache building up question

By sqlguy80

question for DB Gurus when sql server is restarted, it will be slow at...

Query Optimization Level

By Grant Fritchey

Comments posted to this topic are about the item Query Optimization Level

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

SQLCMD Output

See possible answers