Storing Credentials Securely on a Windows-based Flyway Installation
The post Storing Credentials Securely on a Windows-based Flyway Installation appeared first on SQLServerCentral.
Starter Metadata T-SQL Query Examples for Databases and Tables
The post Starter Metadata T-SQL Query Examples for Databases and Tables appeared first on SQLServerCentral.
When Parameter Tuning is not the Answer
So much about parameters tuning, but does it always help? Welcome to the third and final blog of the “magic of parameters” series. In two previous blogs, we discussed how tuning PostgreSQL parameters could help improve overall system perfor …
[Video] Office Hours: DBA & Developer Relationships
Y’all posted & upvoted questions at https://pollgab.com/room/brento, and we finished up the session talking about the relationships between developers and database administrators. Here’s what we covered: 00:00 Start 02:35 Nortzi: Hi Bre …
[Video] Office Hours: Lots of Good SQL Server Questions
At https://pollgab.com/room/brento, post the questions you’d like to get my opinion on, and I’ll take a break every now and then at the office and go through ’em. Here’s what we covered in this episode: 00:00 Start 01:08 #ARRRRR …
The difference between libraries and frameworks
The post The difference between libraries and frameworks appeared first on SQLServerCentral.
Supervise the use of Microsoft Fabric
Already one month since the official announcement of Microsoft Fabric and his public Preview: https://azure.microsoft.com/en-us/blog/introducing-microsoft-fabric-data-analytics-for-the-era-of-ai/ Since then, I have been supporting customers in their Pr …
Bard, Google’s ChatGPT Competitor
After ChatGPT, Google announced that they had Bard. Which is a nice AI chatbot that can also help us as ChatGPT. Is this AI model better? Is it worse? In this SQL Server Central article, we will find out these questions. Bard AI To start Bard, press th …
SQL Server Database Backup and Restore Failure Notifications
The post SQL Server Database Backup and Restore Failure Notifications appeared first on SQLServerCentral.
Six Things to Monitor with PostgreSQL
The post Six Things to Monitor with PostgreSQL appeared first on SQLServerCentral.
Searching Flyway Migration Files using Grep and Regex
The post Searching Flyway Migration Files using Grep and Regex appeared first on SQLServerCentral.
Unpivot Data Using Python
Problem Statement In one of the Business Analytics Dashboards Projects, Sales data is received from different countries (100 +) around the globe. This data is consolidated and depicts trend analysis KPIs, such as MTD, YTD, and ITD. The data received is …
[Video] How to Use ChatGPT to Write WordPress Blog Posts
Today’s live stream was a little different: I demonstrated using the Aiomatic WordPress plugin, ChatGPT, and Azure Open AI to write blog posts. I showed the kinds of content it writes, the kinds of blog post content it doesn’t include, and …
[Video] Office Hours: As They Pour My Patio Concrete Edition
I can finally see the finish line in my backyard renovation, now that the concrete’s going in. I took a break from watching the construction folks to go through your highly upvoted questions at https://pollgab.com/room/brento: Here’s what w …
How to Reduce the Need for Bookmarks Using Parameters in Power BI
Introduction to the Problem When developing Power BI reports, it’s often necessary to slice and interpret datasets in different ways. Using a combination of multiple pages, overlaying visuals and toggling their visibility, setting navigation and action …