SQLServerCentral Editorial

Creating Test Data

This editorial was originally published on Jan 9, 2020. It is being re-run as Steve is out of town. Test data is hard to come by, and I agree with Brent Ozar: " I get so frustrated when I hear trainers/presenters/bloggers/idealists talk about how developers should be using purpose-built-from-scratch data sets with no real customer […]

PostgreSQL 101: Getting started with PostgreSQL for SQL Server Developers (AEST and SGT Time Zones)

In the first two webinars, we've discussed why PostgreSQL has become such a force in recent years and some of the main differences for SQL Server users to know.
In this follow-up webinar, find out how to take your first steps using PostgreSQL.

Join Ryan Booz, PostgreSQL Advocate at Redgate, and discover:
-The freely available options to help you get started
-The essential tools you will need when using PostgreSQL
-Some learning resources to help you take the next steps

External Article

PostgreSQL 101: Getting started with PostgreSQL for SQL Server Developers (CT and BST Time Zones)

In the first two webinars, we've discussed why PostgreSQL has become such a force in recent years and some of the main differences for SQL Server users to know.
In this follow-up webinar, find out how to take your first steps using PostgreSQL.

Join Ryan Booz, PostgreSQL Advocate at Redgate, and discover:
-The freely available options to help you get started
-The essential tools you will need when using PostgreSQL
-Some learning resources to help you take the next steps

SQLServerCentral Editorial

Trust!

The difference between a low trust society (few individuals within a trust circle outside your family and/or tribe) and a high trust society (general trust of individuals beyond immediate family/tribe associations) generally speaking can be measured as the difference between a low tech (low trust) and high tech (high trust) society. Yes, exceptions abound, but […]

Blogs

SQL, MDX, DAX – the languages of data

By

Ramblings of a retired data architect Let me start by saying that I have...

Setting PK Names in Redgate Data Modeler

By

A customer was testing Redgate Data Modeler and complained that it auto-generated PK names....

Flyway Tips: AI Deployment Script Descriptions

By

With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...

Read the latest Blogs

Forums

Connecting Power BI to SSAS and effective user not working

By Paul Hernández

Hi everyone, Below is a consolidated summary of what we validated Architecture & data...

High Availability setup - has anyone seen this method?

By Paul Lancaster

Hi all, I recently moved to a new employer who have their HA setup...

Semantic Search in SQL Server 2025

By Deepam Ghosh

Comments posted to this topic are about the item Semantic Search in SQL Server...

Visit the forum

Question of the Day

Encoding URLs

I have this data in a SQL Server 2025 table:

CREATE TABLE Response
( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY
, ResponseVal VARBINARY(5000)
)
GO
If I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use?

See possible answers