Sites anglophones


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.

Nullable vs Non-Nullable Columns and Adding Not Null Without Downtime in PostgreSQL

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

In this article, we are going to talk about nullable and non-nullable columns specifically related to Postgres databases. While the reasons to use nullable or non-nullable columns may seem obvious at first, there are pitfalls associated with each decis …

 

PostgreSQL Constraints: Learning PostgreSQL with Grant

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

PostgreSQL supports constraints much like any other database management system. When you need to ensure certain behaviors of the data, you can put these constraints to work. I’ve already used several of these in creating my sample database (avail …

 

[Video] Office Hours: 22 Good Questions and a Stinker

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

Lots of good questions on today’s broadcast! If you’d like to submit one, go to https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. Here’s what we covered today: 00:00 Start 01:05 Testing123: When ins …

[Video] Office Hours: Quickie Before Dinner

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

Before heading out to dinner, I went through your highly-upvoted questions from https://pollgab.com/room/brento. Here’s what we covered in this episode: 00:00 Start 00:20 Mert: Hi Brent, what is the relation between AlwaysOn and Windows Failover …

The Data Fabric – Future of Data Management

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

Data is the new gold and is truly an asset to any enterprise. As predicted by IDC, the size of the world’s data – the Datasphere – will grow from an estimated 85 zettabytes (ZB) by the end of 2022 to 175 ZB by 2025. With the increased volume, velocity, …

Ingesting Data from Google Drive to Azure Data Lake Gen2 using Azure Data Factory

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

The post Ingesting Data from Google Drive to Azure Data Lake Gen2 using Azure Data Factory appeared first on SQLServerCentral.

 

Optimizing Queries in MySQL: Optimizing Reads

Publié le 31 janvier 2023 sur simple-talk.com
 

 

Office Hours, ChatGPT Edition: AI Answers 4 of Your Questions

Publié le 31 janvier 2023 sur brentozar.com
 

In a recent Office Hours post, David Reabow suggested letting ChatGPT answer a few of the questions y’all posted at http://pollgab.com/room/brento/. Brilliant! Let’s see how it does. I purposely cherry-picked the questions that I thought Ch …

Backup Directly to a GCS Bucket in SQL Server 2022

Publié le 30 janvier 2023 sur sqlservercentral.com
 

SQL 2022 is here!  Lets back up our databases directly to GCS! This new release of SQL Server has added functionality to allow you to back up databases directly to S3-compatible object storage.  You can read more details about it by following this link …

Dealing with Mutually Dependent Databases in Flyway

Publié le 30 janvier 2023 sur sqlservercentral.com
 

The post Dealing with Mutually Dependent Databases in Flyway appeared first on SQLServerCentral.

Encrypt SQL Server Stored Procedures to Protect Source Code

Publié le 30 janvier 2023 sur sqlservercentral.com
 

The post Encrypt SQL Server Stored Procedures to Protect Source Code appeared first on SQLServerCentral.

Publishing a Public Power BI Report from Google Sheets

Publié le 27 janvier 2023 sur sqlservercentral.com
 

I find Power BI to be a neat way to visualize data, one that allows interactivity to help analyze the results in a report. I decided to use Power BI last year to share some data with the kids I coach and worked on a way to help them understand some sta …

Dealing with Cross-Server Database Dependencies in Flyway Projects

Publié le 27 janvier 2023 sur sqlservercentral.com
 

The post Dealing with Cross-Server Database Dependencies in Flyway Projects appeared first on SQLServerCentral.


Pages :