Connecting to PostgreSQL: Learning PostgreSQL with Grant
Database professionals often work with more than one database platform. Grant Fritchey explains setting up and connecting to PostgreSQL database.
2021-12-17
Additional Articles
Did you know SQL Monitor supports Azure databases, too?
SQL Monitor allows you to bring your whole estate into a single monitoring landscape that has a consistent interface, whether you have an all-Azure environment, or, more likely, a mixed database environment. Find out more, here!
2021-12-17
BETWEEN the two of us
BETWEEN can be used in a SQL WHERE clause to filter on a range. Joe Celko explains the history of BETWEEN and also could be implemented.
2021-12-15
DBAs at work #2: The airline DBA
How different is it working as a DBA at an airline? Find out how your peers work in this series: DBAs at work. This episode features Deborah Thompson, Database Administrator at WestJet, Canada’s second largest airline.
2021-12-15
A Flyway Teams Callback Script for Auditing SQL Migrations
Demonstrates a cross-database PowerShell callback script for reporting on and auditing Flyway migrations, telling you which scripts were used to create each version, when they were run, who ran them and more.
2021-12-13
Raw Data Ingestion into Delta Lake Bronze tables using Azure Synapse Mapping Data Flow
In this article we look at how ingestion will read data from the landing zone and push data into the Bronze layer of the Delta Lake tables for Azure Synapse Analytics.
2021-12-13
Flyway Teams and the Problem of Database Variants
The 'ShouldExecute' script configuration option in Flyway Teams simplifies 'conditional execution' of SQL migration files. This makes it easier to support multiple application versions from the same Flyway project, to deal with different cultural or legislative requirements. It also helps developers handle environmental differences between development, test and staging, such as the need to support multiple versions or releases of the RDBMS.
2021-12-10
Introduction to DAX for paginated reports
SSRS reports can be built using DAX. In this article, Adam Aspin explains how to get started using DAX to build the reports.
2021-12-10
Create a SQL Server PolyBase Scale-out Group Using Amazon Web Services
In this article we look at how to create a scale-out SQL Server PolyBase solution on AWS
2021-12-08
How a monitoring tool benefits the entire organization
Redgate estimate that the savings realized with a monitoring tool could be well over $85,000 / year*. Does your organization understand how a monitoring tool can impact almost every department?
2021-12-08
Blogs
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
From DBA or Data Engineer to AI Engineer: A Realistic Path
If you spend your days tuning queries, managing pipelines, or keeping a production database...
Forums
BIT_COUNT() V
Comments posted to this topic are about the item BIT_COUNT() V
How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager
Comments posted to this topic are about the item How We Reduced SQL Server...
An Eventual Consistency Scam
Comments posted to this topic are about the item An Eventual Consistency Scam
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers