How to ask for programming help
Over the past 25 years, I have answered a lot of programming questions in online forums, from […]
Sites anglophones
[Video] Office Hours: Quiet Sunday Edition
While waiting for the dry cleaner to open, I went live to stream a quiet session going through […]
Firebase and Supabase: Key differences you need to know
The tools classified as “Realtime Backend / API“, or tools that can rapidly process an API call […]
Free Training Coming Up! March is PowerShell Month.
You’re a production database administrator responsible for the health, security, and uptime of many database servers. You’ve been […]
A Version Control Strategy for Branch-based Database Development
Our existing database development and release process was holding back team productivity and causing frequent deployment delays. It […]
A Simple Example of Flyway Development using GitHub Branching
The post A Simple Example of Flyway Development using GitHub Branching appeared first on SQLServerCentral.
[Video] Office Hours: Snowy Michigan Edition
We went up to Michigan to see my dad’s side of the family, and the snow came down […]
Using TOP clause in a SELECT statement
This article is part of Greg Larsen’s continuing series on Learning T-SQL. To see all 9 items […]
Schedule Jobs on a Clustered SQL Server
High availability or Always On is achieved in SQL Server using Cluster. Clustering is a logical collection of […]
The Database DevOps Transformation
The post The Database DevOps Transformation appeared first on SQLServerCentral.
Privileges and Roles in SQL Server, Oracle and PostgreSQL – ...
The post Privileges and Roles in SQL Server, Oracle and PostgreSQL – Part 1 appeared first on SQLServerCentral.
Power BI Dataset Scale-Out
Power BI has evolved into the leading platform for both self-service and IT-managed enterprise business intelligence. The […]
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 this article, we are going to talk about nullable and non-nullable columns specifically related to Postgres databases. […]
PostgreSQL Constraints: Learning PostgreSQL with Grant
PostgreSQL supports constraints much like any other database management system. When you need to ensure certain behaviors […]
[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 […]
[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 […]
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 […]
Ingesting Data from Google Drive to Azure Data Lake Gen2 ...
The post Ingesting Data from Google Drive to Azure Data Lake Gen2 using Azure Data Factory appeared first […]
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 […]
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 […]
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 […]
Dealing with Cross-Server Database Dependencies in Flyway Projects
The post Dealing with Cross-Server Database Dependencies in Flyway Projects appeared first on SQLServerCentral.
Configure Contained Availability Groups for High Availability in SQL Server ...
The post Configure Contained Availability Groups for High Availability in SQL Server 2022 appeared first on SQLServerCentral.
[Video] Office Hours: Ten Minutes of SQL Server Answers
ChatGPT, Resource Governor, manually created stats, Always Encrypted, and as always, fragmentation: let’s answer your questions from https://pollgab.com/room/brento. […]
Bite-Sized Office Hours: Q&A on TikTok
Wanna learn about SQL Server and the Microsoft data platform, but you don’t wanna sit through long videos? […]
Dynamic ELT with Azure Data Factory – Part 3 of ...
In Part 1 of this series, we talked about the art of data ingestion where we discussed the […]
DevOps Process Improvement Course
The post DevOps Process Improvement Course appeared first on SQLServerCentral.
Azure Functions and Managed Identity: More Secrets
I wrote about Managed Identity Secrets a few weeks ago, but since that article was published I […]
How to Import Data in Power BI Using R
Introduction In this article, we will learn how to import data in Power BI using R. R and Python […]
A Version Control Strategy for Database DevOps
The post A Version Control Strategy for Database DevOps appeared first on SQLServerCentral.
SQL Server Function Examples with JSON Files
The post SQL Server Function Examples with JSON Files appeared first on SQLServerCentral.
SQL Server point in time recovery
The post SQL Server point in time recovery appeared first on SQLServerCentral.
Verifying Trees
Introduction Employee lists in organizations are often maintained in spreadsheets or database tables which record each employee’s number, […]
PostgreSQL Basics: Roles and Privileges
Authentication Authorization Verify that the user is who they claim to be. This can be through password, […]
The 20th Anniversary of the SQL Slammer Worm
Twenty years ago this month (next Wednesday to be exact), sysadmins and database administrators started noticing extremely high […]
Technical Considerations for Data Ingestion – Part 2
In part one of this series, we discussed how to prepare for the ingestion of data. In this […]
Understanding Windows Server Cluster Quorum Options
The post Understanding Windows Server Cluster Quorum Options appeared first on SQLServerCentral.
Manage Data Over Time with SQL Server MERGE Statement
This article is part of Greg Larsen’s continuing series on Learning T-SQL. To see all 8 items […]
[Video] Office Hours: Back Live on Twitch Again
After I stopped selling live classes, I took some time off all live broadcasting period. It was a […]
Synapse Serverless: CETAS requires DFS to work
CETAS is the acronym for Create External Table As Select. This allow us to export the result […]
How to Install SQL Server and the Stack Overflow Database ...
To follow along, you’ll need: An Apple Mac with an Apple Silicon processor (M1, M2, etc – not an […]
How to work with web information, maps, and images in ...
Introduction Sometimes, we need to work with images in Power BI. This tip will be about the FIFA […]
Bucket Sort Algorithm in Python to Sort a List of ...
The post Bucket Sort Algorithm in Python to Sort a List of Array Values appeared first on SQLServerCentral.
Database Sharding to help Improve Performance and Maintenance Tasks
The post Database Sharding to help Improve Performance and Maintenance Tasks appeared first on SQLServerCentral.
Using pre-commit to prevent simple mistakes
There is no level of experience or intelligence where we cease to make mistakes. The simpler the mistake […]