Tag: sql server

Archive Read-Only Data from RDS SQL Server to Partitioned S3 Buckets

Overview Here’s a scenario we’ve seen in many businesses; your SQL Server database has grown to the point that performance has degraded significantly, and your business no longer meets the intended RTO (recovery time objective). In this case, your database…

Read More >

Top 10 New Features of SQL Server 2019

Editor’s Note: Because our bloggers have lots of useful tips, every now and then we bring forward a popular post from the past. We originally published today’s post on October 29, 2019. It’s no secret to anyone that software release…

Read More >

How to Overcome the Top 10 SQL Server Performance Challenges

Working with consulting clients is rewarding, interesting, and challenging. In discussion with some of my colleagues, I’ve noticed the same performance challenges come up over and over again across clients with completely different hardware, industry verticals, levels of staff seniority,…

Read More >

SQL Encryption 101

Over the past month, I organized #DataSessions for the Singapore SQLPASS group. Singapore SQLPASS is the data platform user group community in Singapore. In June, we held free live webinars every Tuesday and live-streamed it on Facebook and YouTube. I…

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 >

Getting started with Cloud SQL for SQL Server

Finally Cloud SQL for SQL Server is now available in beta. Announced at Google Next ‘19, Cloud SQL Server is a managed database service that makes it easy to set up, maintain, manage, and administer your SQL Server databases on…

Read More >

How to Fix: The Selected Subscriber does not satisfy the minimum version compatibility

Problem: You are trying to add a new subscriber to a SQL Server Publication using the SQL Server Management Studio and you receive an error similar to the one below: “The selected Subscriber does not satisfy the minimum version compatibility…

Read More >

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 >

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 >
Page 1 of 1012345...10...Last Page »