Sites anglophones


Building a Kimball Data Warehouse

Publié le 14 juin 2023 sur sqlservercentral.com
 

Introduction I sat through a YouTube webinar on Data Lakes, and I’ll have to admit that it was pretty cool. With the advent of ‘Big Data’, the various cloud offerings, Big Table, Hadoop, python, Atlas/Atlas SQL, etc., the question arises: is the tradit …

The SQL Server Advice You Don’t Wanna Hear

Publié le 13 juin 2023 sur brentozar.com
 

One of the big principles of our SQL ConstantCare® monitoring product – which happens to be free this month – is that we only wanna tell you things you’re actually gonna take action on. Anytime we email you advice, there a few “ …

Poll Results: Are You Going Back to In-Person Events?

Publié le 12 juin 2023 sur brentozar.com
 

Last week, I asked if y’all had been to in-person regional events before, and whether you were going back. I wanted to know because Data Saturdays and SQL Saturdays are starting to happen again, but … attendance seems way down from pre-COVI …

 

Manipulating Data In PostgreSQL: Learning PostgreSQL with Grant

Publié le 12 juin 2023 sur simple-talk.com
 

So far in the series I’ve shown how to create databases, tables, constraints, indexes and schema. Now, it’s time to put some of that information to work and begin the process of manipulating data within the database. After all, a database i …

 

Flyway for SQL Server Data Tools Users

Publié le 12 juin 2023 sur sqlservercentral.com
 

The post Flyway for SQL Server Data Tools Users appeared first on SQLServerCentral.

T-SQL Scripts to generate the HTML-formatted database storage report

Publié le 12 juin 2023 sur sqlservercentral.com
 

This article explains the T-SQL scripts that can be used to manage and monitor the disk space on the database server. The T-SQL script contains queries to populate the following details. List of drives, size of disk, and percentage available space Data …

Multiple Relationships on the same Table in a Power BI Data Model

Publié le 12 juin 2023 sur sqlservercentral.com
 

The post Multiple Relationships on the same Table in a Power BI Data Model appeared first on SQLServerCentral.

 

A Guide to INSERT, UPDATE, and DELETE Statements in Oracle

Publié le 9 juin 2023 sur simple-talk.com
 

In this article, we’ll be focusing on three of the most used SQL commands in Oracle: INSERT, UPDATE, and DELETE. These commands are used to insert new data into tables, update existing data, and delete data from tables, respectively. In this arti …

 

Overcoming Organization Challenges in Cloud Migration: A Webinar for Senior IT Leaders

Publié le 9 juin 2023 sur sqlservercentral.com
 

The post Overcoming Organization Challenges in Cloud Migration: A Webinar for Senior IT Leaders appeared first on SQLServerCentral.

PostgreSQL Copy

Publié le 9 juin 2023 sur sqlservercentral.com
 

Article Overview In this article, we will discuss the ‘COPY’ functionality of PostgreSQL database which is one of the most important and often used features in practical world. There are two variants of ‘COPY’ statement, copy a database and copy a tabl …

Data Transfer from Snowflake to Azure Blob using Synapse Analytics

Publié le 9 juin 2023 sur sqlservercentral.com
 

The post Data Transfer from Snowflake to Azure Blob using Synapse Analytics appeared first on SQLServerCentral.

30%-off health checks and self-service via credit card – no waiting!

Publié le 8 juin 2023 sur sqlskills.com - paul randall
 

We’ve added the ability to purchase a self-service health check using a credit card – no more waiting for a scoping call and then budget approval, just click and go! Once you purchase the health check, you get access to our health check pac …

[Video] Office Hours at Sea: Leaving Juneau

Publié le 8 juin 2023 sur brentozar.com
 

I stopped piloting the ship long enough to answer your top-voted database questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:42 Dirty_Pages: You mentioned recently how much you swear, what is your favorite swea …

 

Unmasking SQL Server Dynamic Data Masking – Part 2 – Setting up Masking

Publié le 7 juin 2023 sur simple-talk.com
 

This is the second part of a series on SQL Server Dynamic Data masking. The first part in the series was a brief introduction to dynamic data masking, including use cases. The focus of this blog will is setting up masking and some base examples. Config …

 

[Video] Office Hours in Glacier Bay, Alaska

Publié le 7 juin 2023 sur brentozar.com
 

Thankfully, we didn’t hit any icebergs or glacier droppings, so I put my comfiest coat on to answer your top-voted questions from https://pollgab.com/room/brento. Here’s what we discussed: 00:00 Start 01:29 gb DBA: Hi Brent, I have over 200 …


Pages :