PostgreSQL Basics: Getting started with psql
PostgreSQL has a separate command-line tool that’s been available for decades and is included with any installation of PostgreSQL. Many long-term PostgreSQL users, developers, and administrators rely on psql to help them quickly connect to databa …
Creating a Standalone Executable Python Application
The post Creating a Standalone Executable Python Application appeared first on SQLServerCentral.
A Brief Introduction to PowerShellAI, an Intelligent Command-line
The rising popularity of ChatGPT has led to the development of a PowerShell module called PowerShellAI, which allows users to access ChatGPT via API using scripts rather than a graphical user interface. Developed by Doug Finke, this module simplifies t …
Automatically Tracking and Deploying Static Data in Flyway Enterprise
The post Automatically Tracking and Deploying Static Data in Flyway Enterprise appeared first on SQLServerCentral.
Experimenting with Go-SQLCMD
At a few different conferences in early 2023, I’ve heard Microsoft employees talking about the version of sqlcmd, called go-sqlcmd. I’m not sure why the language it’s written in matters, and I suspect that Microsoft developers are proud of their work, …
SQL Prompt Safety Net Features for SSMS: Tab Coloring
The post SQL Prompt Safety Net Features for SSMS: Tab Coloring appeared first on SQLServerCentral.
Extract SharePoint List Data and save to SharePoint Folder as CSV using Power Automate
The post Extract SharePoint List Data and save to SharePoint Folder as CSV using Power Automate appeared first on SQLServerCentral.
One use case for NOT using schema prefixes
I’ve long been a huge advocate for always referencing objects with a schema prefix in SQL Server. In spite of what may be a controversial title to many of my regular blog readers, I don’t really want you to stop that practice in most of you …
What Does Setting the SQL Server Compatibility Level Do?
If you right-click on a database in SQL Server Management Studio, you get an option to set Compatibility Level at the database level: When you upgrade SQL Server or you want to improve performance, which option should you choose? Should you always go w …
[Video] Office Hours Speed Round: 21 Answers in 15 Minutes
HONK HONK! It’s time for a fast round of answers to concise questions y’all posted and upvoted at https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:19 TheyBlameMe: Hi Brent. What is your view on using Dacpac diff …
Office Hours Speed Round, Easy Text Answers Edition
Some of the questions y’all post at https://pollgab.com/room/brento have easy one-line answers. Let’s knock ’em out: George: Hi Brent, what recently has been the most challenging/surprising/new-to-you performance issue you have encoun …
SQL Prompt Safety Net Features for SSMS: SQL History
The post SQL Prompt Safety Net Features for SSMS: SQL History appeared first on SQLServerCentral.
Create an Empty Database Using SQL Server Integration Services
Recently, we were working on a small project. The requirement was to create an empty copy of an existing database, meaning the new database could contain only database objects without data. The database was smaller and less complicated, so we completed …
Use DDL Triggers to Automatically Keep SQL Server Views in Sync
The post Use DDL Triggers to Automatically Keep SQL Server Views in Sync appeared first on SQLServerCentral.
Finding and Tuning Expensive Stored Procedures using SQL Monitor
The post Finding and Tuning Expensive Stored Procedures using SQL Monitor appeared first on SQLServerCentral.