PowerShell Commands to Administer Virtual Machines on Amazon AWS – ...
The post PowerShell Commands to Administer Virtual Machines on Amazon AWS – Part 2 appeared first on SQLServerCentral.
Archives de l’année : 2023
ChatDBA: ChatGPT 4 Answers 5 Office Hours Questions
Every now and then, someone asks a question on PollGab about why I don’t use ChatGPT to answer […]
Getting Started with DDL statements of Cassandra Query Language
Article Overview In this tutorial, we’ll learn the essential DDL concepts of Cassandra query language (CQL) and how […]
SQL Server Cumulative Updates (CU) through the end of calendar ...
Re-posting a message from the SQL Server Release service team on Cumulative Updates till end of year: […]
SQL Server Cumulative Updates (CU) through the end of calendar ...
SQL Server 2022 RTM has completed one year after SQL Server GA release last November. Per the Modern […]
Microsoft Fabric: Extended Source Control Features
The source control features in Microsoft Fabric are evolving every day. The PBIP feature included in Power […]
[Video] Office Hours: Live on Black Friday Edition
On Black Friday, I took a break from answering support emails to hit your top-voted questions from https://pollgab.com/room/brento. […]
TABLOCK Hint can Negatively Impact SQL Server Concurrency
The post TABLOCK Hint can Negatively Impact SQL Server Concurrency appeared first on SQLServerCentral.
Using the Import Extension in Azure Data Studio
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I’ve written a few articles […]
Working with Azure DocumentDB: SQL & NoSQL Together
The post Working with Azure DocumentDB: SQL & NoSQL Together appeared first on SQLServerCentral.
[Video] Office Hours: Black Friday Promo Edition
In this episode, a lot of the questions triggered mentions of our Black Friday Sale, on now! Here’s […]
BrentOzar.com Cyber Monday Week Sale
Every November, we run a huge sale here on my training courses, apps, and online services. Now’s your […]
When an update doesn’t update
Tell me if you’ve heard this one before: I changed data from my application, but when I […]
Time Series Data Mining Example with T-SQL when Adding New ...
The post Time Series Data Mining Example with T-SQL when Adding New Data appeared first on SQLServerCentral.
Ensuring a Single Row Table
Single row tables in data modeling Single row tables are a fact of our life as as a […]
Warehouse Load Patterns – Part 1 – Requirements and General ...
No matter the ETL tool used, there are some basic patterns to follow when transferring data between […]
Updates about Database Projects for Microsoft Fabric
comp A few weeks ago, I wrote a blog about Database Projects for Microsoft Fabric. It’s an […]
It’s Black Friday! Time to save big on SQL Server ...
My Annual Black Friday Sale is On! I’m running a giant Black Friday sale on my training courses! […]
Black Friday returns to SQLServerFast
The post Black Friday returns to SQLServerFast appeared first on SQLServerCentral.
Unpivoting Multiple Sets of Columns in SQL Server using CROSS ...
The post Unpivoting Multiple Sets of Columns in SQL Server using CROSS APPLY appeared first on SQLServerCentral.
[Video] Office Hours: Brent’s Cursed Technology Edition
I first answered these while standing at a harbor in Maine, but upon arriving home, I realized my […]
SQL Server 2022 for RHEL 9 and Ubuntu 22.04 is ...
We are happy to announce that Starting CU 10 release for SQL Server 2022 , SQL Server 2022 on RHEL […]
Source Control with GIT, Power BI and Microsoft Fabric
Source control is fundamental when dealing with projects and sharing code between multiple developers. Power BI present […]
What is Microsoft Fabric all about?
In this article, we will introduce Microsoft Fabric and how it relates to Power BI Premium Capacity […]
[Video] Office Hours in Camden Harbor
On an overcast morning in scenic Camden, Maine, I stood on the docks and took your top-voted questions […]
Advanced SQL Server installation using Powershell DSC
Introduction In the previous article, we learned how to install a SQL Server instance with basic parameters like […]
Azure DocumentDB: Working with Microsoft's NoSQL Database in the Cloud
The post Azure DocumentDB: Working with Microsoft's NoSQL Database in the Cloud appeared first on SQLServerCentral.
Back home from the PASS Data Community Summit
What a week it was. While it wasn’t my first in person conference this year, it felt […]
Why Haven’t You Disabled SA? Wrong Answers Only.
On social media, I asked folks, “Why haven’t you disabled the SA account in your SQL Servers? Wrong […]
Rapports Custom pour SSMS : SSMSInfoReports
Dans cette vidéo, je montre comment installer et utiliser mes "Custom Reports" pour SQL Server Management Studio. Les […]
SSMS and Visual Studio Issue Displaying EUDC (End-User-Defined Characters)
Issue: —————————————- A customer opened an interesting case stating SQL Server Management Studio (SSMS) would not display EUDC […]
Strategies for queries against bit columns
Recently someone posted a question where they couldn’t quite figure out how to construct a predicate based […]
Embracing SQL Server 2022 with SSDT 17.8: Unveiling Key Updates
In the dynamic landscape of database development, SQL Server Data Tools (SSDT) is a powerful tool for database […]
Azure Monitor SCOM MI: New SQL Server monitoring solution in ...
It has just been announced that Azure Monitor SCOM Managed Instance is generally available. This is a new […]
“How do my peers do this?” The latest best practices ...
The post “How do my peers do this?” The latest best practices for IT architects implementing a major […]
What are Warehouses in Microsoft Fabric?
The post What are Warehouses in Microsoft Fabric? appeared first on SQLServerCentral.
PASS Summit 2023 – Community Keynote – AIOps and ChatGPT ...
Last but not least, the Community Keynote. Hang on to your hats, this is going to be […]
Cumulative Update #10 for SQL Server 2022 RTM
The 10th cumulative update release for SQL Server 2022 RTM is now available for download at the Microsoft […]
Is your organization using MongoDB? Help the Redgate Flyway team ...
The post Is your organization using MongoDB? Help the Redgate Flyway team understand your pain points. appeared first […]
How to get your security team on board with your ...
The post How to get your security team on board with your cloud migration appeared first on SQLServerCentral.
Scheduling SQL Agent Jobs on Alternating Weeks
Bi-week… semi-week… fortnight… « every two weeks » Recently on the SQL Community Slack group, someone asked if there was […]
PASS Summit 2023 – Redgate Keynote – The New Database ...
Day 2 is here! Sitting here at the bloggers table waiting for the keynote to commence! <image […]
[Video] Office Hours at Megunticook Falls in Camden, Maine
While in historic and beautiful Camden to hang out with friends, I went to Megunticook Falls and answered […]
PASS Summit 2023 – Microsoft Keynote – Limitless growth, limitless ...
CEO of Redgate: Jakub Lemik: This year’s theme is Connect, Share, and Learn. Tomorrow will be People […]
Power what’s next with limitless relational databases from Azure
At Microsoft, we’re seeing firsthand how data is powering incredible innovation and accelerating more than just a platform […]
The Bridge – How Azure Arc brings cloud innovation to ...
By Debbi Lyons, Director of Azure Relational Databases Product Marketing The ability to effectively manage data is […]
Office Hours, Silent Film Edition
Hey, remember in yesterday’s video how I said I was having a really bad day? Well, here’s how […]
SQL Server Table Design Guidelines – Data Types, Designing for ...
The post SQL Server Table Design Guidelines – Data Types, Designing for Deletes and Primary Keys appeared first […]
How to join the free PASS Data Community Summit Livestream ...
There’s nothing quite like attending PASS Data Community Summit in person to reconnect with friends and make new professional connections […]
SQL Window Functions Series: RANK() and DENSE_RANK()
Welcome to the fascinating world of SQL Window functions! As we journey through the intricate labyrinths of databases […]