Tag: sql server

How to deploy highly available SQL Server 2017 on Linux on GKE

Kubernetes is an open-source container orchestration system for automating deployment, scaling and management of containerized applications. Running a SQL Server database on Kubernetes is a topic of discussion nowadays as Kubernetes provides ways to provision stateful containers using persistent volumes,…

Read More >

How to restore SSISDB to another server and migrate the SSIS catalog

It is easy to get this one wrong. SSISDB is just a database, after all, and I’ve seen a number of instances where it was restored to another server and a number of errors/issues crop up. After all, SSISDB is…

Read More >

Migrating to Microsoft SQL Server or Azure SQL Database

Migrating to Microsoft SQL Server or Azure SQL Database – a webinar by Warner Chaves Register today Are you considering a migration to Microsoft SQL Server or Azure SQL Database? Before you go any further, join Warner Chaves, Pythian’s Microsoft…

Read More >

Introduction to Azure SQL Managed Instance – SQL on the edge episode 17

SQL Server is one of the most adopted and widely-used database engines in the world. Almost every company either builds on it or uses some enterprise third-party software that uses it as the back end. For this reason, it makes…

Read More >

How to restore encrypted backups

SQL Server started having encrypted backups since SQL Server 2014. You can see the technical details here. This is a very good feature that allows you to encrypt the backups upon creation with different algorithms that will meet your security…

Read More >

Sharding a SQL Server database

This blog post covers sharding a SQL Server database using Azure tools and PowerShell script snippets. Sharding, at its core, is breaking up a single, large database into multiple smaller, self-contained ones. This is usually done by companies that need…

Read More >

Using Kerberos configuration manager to resolve Microsoft SQL server SPN issues

It’s not uncommon to have authentication issues with Microsoft SQL Server. Not only with users trying to access the server, but problems related to the connection between instances, like AlwaysOn Availability Groups. The traditional way to solve it is well…

Read More >

Log Buffer #522: a carnival of the vanities for DBAs

This edition of Log Buffer covers Cloud, Oracle, SQL Server and MySQL and much more.

Read More >

How to analyze SQL server stack dumps

As a SQL Server production DBA, at some point in time you will have to deal with a stack dump. A stack dump is a file that is written to disk with an “.mdmp” extension when SQL Server encounters a…

Read More >

Log Buffer #515: A Carnival of the Vanities for DBAs

This Log Buffer Edition covers Oracle, SQL Server and MySQL.

Read More >
Page 1 of 912345...Last Page »