SQLServerCentral Article

Connect to PostgreSQL as an External Data Source using PolyBase

PolyBase is a new feature of SQL Server that allows you to connect to relational and non-relational data. You can run queries on any external data sources you might have, such as Oracle, PostgreSQL, Salesforce, MongoDB, Hadoop, etc. When paired with the CData ODBC Driver for PostgreSQL, you get access to your PostgreSQL data directly […]

SQLServerCentral Editorial

Learning Is Challenging, So, Forgive Yourself

In addition to trying to get better at SQL Server, Redgate Software, and all the various aspects of my job, I'm also trying to get better at this whole human interaction thing AND I'm working on trying to learn PostgreSQL much more deeply. Whew! Yeah, may not seem like a whole lot, but I assure […]

SQLServerCentral Article

How to Delete Large Amounts of Data

As a DBA, we are often tasked with maintenance work on the database. Often this includes making sure that old data is purged from the tables.  This is especially true with logging tables.  Sometimes multiple applications write to the same logging tables, and they can grow very quickly. Let’s say we have a logging table […]

Blogs

A New Form of Address: Mx

By

When I was presenting at the dataMinds Connect conference, I called on someone in...

Group By Starting Characters

By

I was chatting with Jeff (b|t) on my team yesterday and the context escapes...

Daily Coping 22 Oct 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Remove database from Distributed Availability Group replica AG ONLY!

By calmkza

Hi, all! I have an existing always on availability group on-prem and last week...

How to redesign a query

By kuopaz

Hi Result is determined by the calculated Usage, With the below query, the result...

How do I join two temporary tables using MySQL?

By miquiztli

Hi all, I'm still pretty new to SQL and could use some help getting...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers