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

Join me next week at my first GroupBy session

By

2021 has been the year people want to learn about Temporal Tables, it seems....

Daily Coping 20 Oct 2021

By

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

Updated Pluralsight Course – Configuring and Managing Kubernetes Networking, Services, and Ingress

By

My updated course “Configuring and Managing Kubernetes Networking, Services, and Ingress” is now available...

Read the latest Blogs

Forums

Please help with grouping totals and details

By eluchianic

I am trying to get the same layout going in ssrs as in the...

Replace apostrophe in user input field

By JP789

I have an Access front end with SQL backend.  The user input field is...

DATEDIFF with GETWEEK worth of data

By JeremyU

I have such an issue. I have units, on sale date and also how...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers