ebook

sql-server-in-memory-oltp book cover

Free eBook: SQL Server Internals: In-Memory OLTP

  • Article

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-12-30 (first published: )

55,467 reads

External Article

Free eBook: SQL Server Backup and Restore

  • Article

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Redgate's SQL Backup tool.

2020-12-02 (first published: )

80,501 reads

Blogs

Regression Testing: DAX User Defined Functions

By

User Defined Functions is a new feature in PowerBI currently in public preview. There...

The fundamental requirements of a reporting system

By

There are some fundamental boxes that your reporting system must tick. ✅ The figures...

Seeing the Bigger Picture: How A Monitoring Tool Changed My Approach to Estate Management

By

When it comes to managing complex database environments, having the right monitoring solution is...

Read the latest Blogs

Forums

SQL MI Next-gen general purpose tier

By SqlAdmin001

Has anyone used Azure SQL MI on the next-gen general purpose tier, Microsoft documentation...

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

The Last Good DBCC Run

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Last Good DBCC Run

Visit the forum

Question of the Day

The Last Good DBCC Run

I want to check when DBCC CHECKDB was last run on my Baseball database. What code should I use?

See possible answers