Sites anglophones


PostgreSQL Temporary Table

Publié le 10 février 2023 sur sqlservercentral.com
 

Overview In this tutorial, we will learn about a PostgreSQL temporary table and its usage. We will study the basic syntax and some examples to understand its functionality. Definition A PostgreSQL temporary table, as its name implies, is a table that e …

 

How to ask for programming help

Publié le 9 février 2023 sur simple-talk.com
 

Over the past 25 years, I have answered a lot of programming questions in online forums, from co-workers, and from friends. It has been a while since I had been around forums, but I recently decided it was time to get back to what started me in the SQL …

 

[Video] Office Hours: Quiet Sunday Edition

Publié le 9 février 2023 sur brentozar.com
 

While waiting for the dry cleaner to open, I went live to stream a quiet session going through a bunch of y’all’s questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 01:45 Rollback is single threaded: H …

 

Firebase and Supabase: Key differences you need to know

Publié le 9 février 2023 sur simple-talk.com
 

The tools classified as “Realtime Backend / API“, or tools that can rapidly process an API call and in this case, store data, include Firebase and Supabase. Firebase is a NoSQL database, while Supabase is a relational database. The Firestor …

 

Free Training Coming Up! March is PowerShell Month.

Publié le 8 février 2023 sur brentozar.com
 

You’re a production database administrator responsible for the health, security, and uptime of many database servers. You’ve been pointing and clicking your way through SSMS for years, scripting out T-SQL to files, but… when you need …

A Version Control Strategy for Branch-based Database Development

Publié le 8 février 2023 sur sqlservercentral.com
 

Our existing database development and release process was holding back team productivity and causing frequent deployment delays. It was manual and error prone. Developers worked on a shared development database, with all changes committed to a ‘monolit …

A Simple Example of Flyway Development using GitHub Branching

Publié le 8 février 2023 sur sqlservercentral.com
 

The post A Simple Example of Flyway Development using GitHub Branching appeared first on SQLServerCentral.

[Video] Office Hours: Snowy Michigan Edition

Publié le 7 février 2023 sur brentozar.com
 

We went up to Michigan to see my dad’s side of the family, and the snow came down just in time for our arrival. Always love the fresh snow look. So I stood outside and took your top-voted questions from https://pollgab.com/room/brento. Let’ …

 

Using TOP clause in a SELECT statement

Publié le 6 février 2023 sur simple-talk.com
 

This article is part of Greg Larsen’s continuing series on Learning T-SQL. To see all 9 items in the series, click here. TOP Clause Syntax The syntax for the top clause is simple and is shown in Figure 1. TOP (<expression>) [PERCENT] [ WITH TIES …

 

Schedule Jobs on a Clustered SQL Server

Publié le 6 février 2023 sur sqlservercentral.com
 

High availability or Always On is achieved in SQL Server using Cluster. Clustering is a logical collection of 2 or more physical servers (nodes) that individually host SQL instances and access the common shared storage. The applications will connect to …

The Database DevOps Transformation

Publié le 6 février 2023 sur sqlservercentral.com
 

The post The Database DevOps Transformation appeared first on SQLServerCentral.

Privileges and Roles in SQL Server, Oracle and PostgreSQL – Part 1

Publié le 6 février 2023 sur sqlservercentral.com
 

The post Privileges and Roles in SQL Server, Oracle and PostgreSQL – Part 1 appeared first on SQLServerCentral.

 

Power BI Dataset Scale-Out

Publié le 3 février 2023 sur www.pulsweb.fr
 

Power BI has evolved into the leading platform for both self-service and IT-managed enterprise business intelligence. The decision to migrate to Power BI Premium depends on the requirements of each customer. Customers should carefully evaluate addition …

 

Testing Databases: What’s Required?

Publié le 3 février 2023 sur sqlservercentral.com
 

The post Testing Databases: What’s Required? appeared first on SQLServerCentral.

Extend your Power BI Reports with Analysis Services 2022 Data

Publié le 3 février 2023 sur sqlservercentral.com
 

The post Extend your Power BI Reports with Analysis Services 2022 Data appeared first on SQLServerCentral.


Pages :