Get the Most Current Row From a Detail Table
Task: Update a table with the most current value of a detail table. In this article I’m using the sys.tables / sys.columns tables because they are available everywhere. In reality it would be, e.g. a customer table, where you are setting the last_order …
Simple-Talk RSS Feeds
Recently, we have made a few changes to the simple-talk.com website’s RSS feeds that I am pretty excited about. If you don’t know what RSS feeds are, they are links that let you pull down content from a website not the formatted view you ty …
Creating an Azure SQL Database Using Azure Cloud Shell
Introduction Azure Cloud Shell is a browser-based tool that allows the creation, configuration, and management of Azure resources using a shell. Azure Cloud Shell supports Azure PowerShell and Bash Command Line Interfaces. This tool is comparable to ot …
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 …