SQL

SQLServerCentral Article

Installing PostgreSQL 11 on Windows with Step-by-step Instructions

  • Article

PostgreSQL is a free database management system (DBMS). PostgreSQL 11 is the new version of this DBMS. We will take a look at how to install PostgreSQL 11 on Windows. This article covers where to download PostgreSQL 11, how the installation process looks like, and how to connect to the PostgreSQL server. Step-by-Step Installation on Windows […]

2.67 (3)

You rated this post out of 5. Change rating

2020-09-03

17,640 reads

SQLServerCentral Article

Database Modeling - Relationships

  • Article

A proper relationship between two people, places or things improves the communication between them. In every real-world based application, this logic holds and a database is no different. This article discusses the different relationship types possible between database objects. The designing of these relationships between them is called modeling, and the three types of relationships […]

5 (3)

You rated this post out of 5. Change rating

2020-08-31

7,311 reads

External Article

Gathering SQL Server Performance Counters for Multiple Servers

  • Article

SQL Multi Script can easily be persuaded to run queries at the server level rather than the database level. It is also able to combine results from many databases even if the results aren't identical but have some different columns. Phil Factor demonstrates how this works, when collecting a set of performance counters from all databases on a distribution list of servers.

2020-08-07

External Article

6 New Courses Published on the Redgate University

  • Article

Master the fundamentals of Redgate products with easy to follow video courses on Redgate University. This month 6 new courses have been published to help you advance your skills including courses on SQL Prompt, SQL Monitor, SQL Change Automation, SQL Compare, and Database DevOps for Oracle. All brought to you by some amazing presenters like Kendra Little, Grant Fritchey, Kathi Kellenberger and the Redgate team of experts. Start learning now!

2020-07-17

External Article

Hands-On with Columnstore Indexes: Part 1 Architecture

  • Article

Microsoft introduced Columnstore with SQL Server 2012 and have improved the feature in every version since then. You may be wondering why they are different than traditional indexes and how they work. In this series, Edward Pollack explains the architecture of Columnstore indexes. In future articles in the series, he will describe best practices for Columnstore.

2020-06-18

Blogs

Plan Time for Self-Development

By

As you begin the new year, if you don't already have time set aside...

BK’s Bookshelf: Never Split the Difference

By

I picked up Never Split the Difference: Negotiating As If Your Life Depended On...

Replacing Images in PBIR Format Reports

By

With the PBIR format of Power BI reports, it’s much easier to make report...

Read the latest Blogs

Forums

psyarabiashop.com

By psycharabian

About Us - PsyArabiaShop.com - Where Desert Dreams Meet Psychedelic Streams Welcome to PsyArabiaShop.com,...

The Learning Plan for 2025

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Learning Plan for 2025

Leveraging the “STUFF” Function for Enhanced Data Representation and String Manipulation 

By Ganesh Gopal Masti Jayaram

Comments posted to this topic are about the item Leveraging the “STUFF” Function for...

Visit the forum

Question of the Day

Quiesce

What does it mean to quiesce a system?

See possible answers