Home Tags SQL server

Tag: SQL server

4 Encryption options for your SQL Server

In today’s tutorial, we will learn about cryptographic elements like T-SQL functions, service master key, and more. SQL Server cryptographic elements Encryption is the process of...

Understanding SQL Server recovery models to effectively backup and restore your...

Before you even think about your backups, you need to understand the SQL Server recovery model that is internally used while the database is...

Get SQL Server user management right

The question who are you sounds pretty simple, right? Well, possibly not where philosophy is concerned, and neither is it where databases are concerned...

Troubleshooting in SQL Server

This article is an excerpt from a book SQL Server 2017 Administrator's Guide written by Marek Chmel and Vladimír Mužný. This book will help...

How SQL Server handles data under the hood

This article is an excerpt from a book written by Marek Chmel and Vladimír Mužný titled SQL Server 2017 Administrator's Guide. In this book,...

Getting to know SQL Server options for disaster recovery

This article is an excerpt from a book written by Marek Chmel and Vladimír Mužný titled SQL Server 2017 Administrator's Guide. This book will...

How to implement In-Memory OLTP on SQL Server in Linux

Below given article is an excerpt from the book SQL Server on Linux, authored by Jasmin Azemović. This book is a handy guide to...

How to integrate SharePoint with SQL Server Reporting Services

This article is an excerpt from a book written by Dinesh Priyankara and Robert C. Cain, titled SQL Server 2016 Reporting Services Cookbook.This book...

Basics of Spark SQL and its components

Below given is an excerpt from the book Learning Spark SQL by Aurobindo Sarkar. Spark SQL APIs provide an optimized interface that helps developers...

Getting Started with Microsoft SQL Server 2008 R2

  Microsoft SQL Server 2008 R2 Administration Cookbook Over 70 practical recipes for administering a high-performance SQL Server 2008 R2 system Introduction Microsoft SQL Server 2008 has opened...