Tag: sql server

Using Kafka to Replicate Data from Postgres to MS SQL Server: Part 1


    The Challenge You’ve probably heard the expression, “Data is the new oil”.  That’s because data is at the heart of any business decision system of any organization. However, the data you need  isn’t always located in only one…

Read More >

FIX: SQL Server Installer Hangs on Existing Clustered Instance “Running Discovery on Remote Machine”

SQL Server

Problem You’re trying to install a service pack, cumulative updates, or run the installer to add a shared feature on a SQL Server clustered instance. The installer just hangs and doesn’t progress without any indication on the GUI as to…

Read More >

Fix: SSIS Catalog Creation Error – “SQL Server Denali is Required to Install Integration Services”

ssis catalog error

  Problem You’re trying to create an SSIS Integration Catalog using SQL Server Management Studio for a SQL Server Instances dated 2016 or later. Upon right-clicking and choosing “Create Catalog, you see this error:   Cause You get this error…

Read More >

Datascape Episode 49: SQL Server, Snowflake, IT Industry Advice and More

Episode 49 Shownotes SQL Server, Snowflake, IT Industry Advice and More     Welcome to the latest episode of the Datascape Podcast. Our guest for today’s episode is writer and SQL authority Pinal Dave. Pinal talks about his work with…

Read More >

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 >

Five ways to migrate your on-premises SQL database to Azure

There are currently three deployment options for SQL Server Database on the cloud. Well, four, if you count Azure SQL Databases in elastic pool. But Azure SQL DB in elastic pool is essentially just Azure SQL Databases grouped into an…

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