Testing Databases: What’s Required?
The post Testing Databases: What’s Required? appeared first on SQLServerCentral.
Extend your Power BI Reports with Analysis Services 2022 Data
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
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
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
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
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
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
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
Office Hours, ChatGPT Edition: AI Answers 4 of Your Questions
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
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
The post Dealing with Mutually Dependent Databases in Flyway appeared first on SQLServerCentral.
Encrypt SQL Server Stored Procedures to Protect Source Code
The post Encrypt SQL Server Stored Procedures to Protect Source Code appeared first on SQLServerCentral.
Publishing a Public Power BI Report from Google Sheets
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
The post Dealing with Cross-Server Database Dependencies in Flyway Projects appeared first on SQLServerCentral.