PASS Data Community Summit registration is open!
The post PASS Data Community Summit registration is open! appeared first on SQLServerCentral.
Revolutionizing Real-Time Data Management with SQL Server, Kafka, and Informatica
The field of data engineering involves handling vast amounts of data through processing, transformation, and storage to enable businesses to make informed decisions based on analytics. In recent years, the ability to process data in real-time has becom …
[Video] Office Hours: Live Q&A
This one’s broken up into two parts because I took a bio break mid-stream: 00:00 Start 03:04 Clippy: Hey Brent, you are the best!!! Can you share us more about your roots? What’s the origin of your family name and where does it comes from? 04:15 …
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.