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 …
Unmasking SQL Server Dynamic Data Masking, Part 4, Unmasking Formatted and Unformatted Text
This is part of a series on Dynamic Data Masking by Ben Johnson. For the rest of the series, click here Continuing from the previous entry in this series on security concerns with using Dynamic Data Masking, in this blog I want to close out that discus …
On the Road Again, Next Up Columbus
January 18, 2020, was the last time I stood in front of a live group of people and spoke about anything. It was at the location where I did my first SQL Saturday presentation, back at the first SQL Saturday in Nashville. Speaking at the time was a norm …
How to Make Database Changes Without Breaking Everything
You’ve got an existing application with a database back end. You’re thinking about changing the database, and you don’t wanna break stuff. The most important thing to understand is difference between constructive and destructive chang …
Using a Subquery in a SELECT statement
This article is part of Greg Larsen’s continuing series on Learning T-SQL. To see all 10 items in the series, click here. Did you know you can include a SELECT statement within another SELECT statement? When a SELECT statement is embedded within anothe …
[Video] Office Hours: Professional Development & Training Questions
The post [Video] Office Hours: Professional Development & Training Questions appeared first on SQLServerCentral.
SQL Server Resumable Index Operations
As the DBA, have you ever had to cancel an online rebuild or create index process on a very large table? Perhaps it didn’t finish during your maintenance window or consumed valuable resources, causing other queries to run slowly? It is a headache for a …
Cheat Sheet for SQL Server DBAs – Monitoring Current Activity, Blocking and Performance
The post Cheat Sheet for SQL Server DBAs – Monitoring Current Activity, Blocking and Performance appeared first on SQLServerCentral.