Create an HTML Report on the Status of SQL Server Agent Jobs
SQL Server jobs are an integral part of any SQL Server environment. These jobs run a predefined set of tasks and commands at specified intervals, ensuring the database is up-to-date and performing optimally. As a database administrator, it is essential …
Happy 21st Anniversary, BrentOzar.com. What’s Coming Next?
It’s pretty cool to look at a blog post and see, “Last updated: 21 years ago.” It’s pretty fun to see old pictures of me in the media library, too. When I first started blogging over two decades ago, it wasn’t a business. …
PostgreSQL Basics: Essential psql Tips and Tricks
Having access to the psql command-line tool is essential for any developers or DBAs that are actively working with and connecting to PostgreSQL databases. In our first article, we discussed the brief history of psql and demonstrated how to install it o …
ChatGPT in Visual Studio tutorial
Introduction In this article, we will learn how to work with ChatGPT in Visual Studio. We will install and use an extension in a SQL Server Database Project. Requirements First, we need to have SQL Server installed. Secondly, we need to have Adventurew …
How to Slice Data by Week in a Calendar Table using DAX
The post How to Slice Data by Week in a Calendar Table using DAX appeared first on SQLServerCentral.
Working with Flyway And Entity Framework Code First: An Overview
The post Working with Flyway And Entity Framework Code First: An Overview appeared first on SQLServerCentral.
How to Automate Cross-Platform Database Development
The post How to Automate Cross-Platform Database Development appeared first on SQLServerCentral.
Using the New Open Source SQLCMD to Create Containers
In my previous article, I looked at the basics of the new, open-source SQLCMD, which is a new version of sqlcmd written in GO with modern features. This article will cover the features in this utility to help you set up and query containers, which is a …
Updated First Responder Kit and Consultant Toolkit for April 2023
This month’s big changes are performance tuning in sp_BlitzFirst & sp_BlitzLock. Part of the benefits of using the open source FRK is that when any of us work with *really* big/fast/ugly servers, we tune the FRK procs to work better in those …
How to Go Live on SQL Server 2022
You’re planning to migrate to SQL Server 2022, and you want your databases to be faster after the migration. This is NOT a blog post about how to migrate – that’s the same as it’s been for a long time. Go build the new 2022 serv …
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.