Books

In-Memory OLTP eBook Download

SQL Server Internals: In-Memory OLTP

In this book, Kalen Delaney explains how the 2016 In-Memory OLTP engine works, how it stores and manipulates data, and how, even with all data stored in memory and no locking or latching, it can still guarantee the ACID properties of all transactions.

5 (1)

You rated this post out of 5. Change rating

2023-04-28 (first published: )

962 reads

Pro Encryption in SQL Server 2022

Pro Encryption in SQL Server 2022: Provide the Highest Level of Protection for Your Data

This in-depth look at the encryption tools available in SQL Server shows you how to protect data by encrypting it at rest with Transparent Data Encryption (TDE) and in transit with Transport Level Security (TLS). You will know how to add the highest levels of protection for sensitive data using Always Encrypted to encrypt data also in memory and be protected even from users with the highest levels of access to the database. The book demonstrates actions you can take today to start protecting your data without changing any code in your applications, and the steps you can subsequently take to modify your applications to support implementing a gold standard in data protection.

You rated this post out of 5. Change rating

2023-04-24 (first published: )

2,400 reads

Tribal SQL eBook Download

TribalSQL: 15 New Voices in SQL Server

MidnightDBA and Red Gate have joined together to produce a new book on SQL Server, written by 15 first-time authors. The resulting book, TribalSQL, includes everything you should know about SQL Server that isn’t taught in traditional training, they call it Tribal knowledge.

You rated this post out of 5. Change rating

2019-03-26 (first published: )

402 reads

SQL Server Execution Plans Second Edition eBook Download

SQL Server Execution Plans, Second Edition by Grant Fritchey

Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how to read and interpret execution plans. This book leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or XML, and then how to use the information you find there to diagnose the most common causes of poor query performance, and so optimize your SQL queries, and improve your indexing strategy.

You rated this post out of 5. Change rating

2012-11-12

17,026 reads

SQL Server Transaction Log Management eBook Download

SQL Server Transaction Log Management by Tony Davis and Gail Shaw

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works. An effective response to a crisis requires rapid decisions based on understanding its role in ensuring data integrity.

You rated this post out of 5. Change rating

2012-11-12

4,409 reads

The Art of SQL Server Filesteam eBook cover

The Art of SQL Server FILESTREAM by Jacob Sebastian and Sven Aelterman

FILESTREAM is implemented as an extension to the VARBINARY(MAX) data type and allows large object data to be stored in a special folder on the NTFS file system, while bringing that data under the transactional control of SQL Server. This book describes both the way it works and the implementation, administration and troubleshooting of it.

You rated this post out of 5. Change rating

2012-11-12

564 reads

Blogs

Using Git Prune–#SQLNewBlogger

By

As I’ve been working with SQL Saturday and managing changes to events, I’ve accumulated...

Microsoft Purview new data governance features

By

Starting last week is a rollout of the public preview of a new and...

SQL Database Administration: Not For Everyone (But Maybe It’s for You)

By

Let's get one thing straight: database administration isn't the most glamorous tech job out...

Read the latest Blogs

Forums

Create Copy of DB in same server.

By terry999

Hi I want to create a copy of a DB on the same server....

SSRS Expression IIF Zero then ... Got #Error

By danyeungw

Hello, Need some help for SSRS. The column % expression is =iif(sum(Fields!ColumnA.Value) = 0...

Insert using table unput

By Bruin

I have a table that I need to run off a different server\db and...

Visit the forum

Question of the Day

Restoring the Resource Database

How can I restore a version of the Resource Database in SQL Server 2022?

See possible answers