[Video] Office Hours: 25 Pretty Good Questions
You post questions at https://pollgab.com/room/brento and upvote the ones you’d like to see, and my job is to come up with accurate answers on the fly. Let’s see how I did. Here’s what we discussed: 00:00 Start 03:25 SickOf: Brent is …
Classing Up SSMS is as Easy as 1, 2, 3.
Step 1: go into Tools, Options and set this: Step 2, set this: Step 3, check this box: And presto, no one will ever again question whether or not you know what you’re doing.
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.