PowerShell Commands to Administer Virtual Machines on Amazon AWS – Part 2
The post PowerShell Commands to Administer Virtual Machines on Amazon AWS – Part 2 appeared first on SQLServerCentral.
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 these questions. And sometimes, I wonder that myself – I wonder why people don’t put their questions into ChatGPT, especially GPT 4, becaus …
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 to use them in practical world. If you are not at all familiar with Cassandra, recommend you to read the article, Cassandra Springboot I …
Microsoft Fabric: Extended Source Control Features
The source control features in Microsoft Fabric are evolving every day. The PBIP feature included in Power BI allowed us to include source control on a SDLC process for Power BI, supporting reports and datasets linked directly from the portal to a repo …
[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. Here’s what we covered: 00:00 Start 00:41 MatthewsSQLServer: How AlwaysON AG failovers cause can be analyze …
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 on how the tool works, and I’ve got a few more coming. I covered a basic orientation and a more in-depth one on some of the code writing features. In …
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 what we covered: 00:00 Start 01:41 Pete: 1 NUMA, 2 NUMA, 3 NUMA, 4 NUMA, or More? 176 cores, 1.5 TB RAM, currently all in a single NUMA configurat …
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 chance to talk to the boss and get the SQL Server and Azure SQL DB training that will help your company solve real problems in the year 2024 and …
When an update doesn’t update
Tell me if you’ve heard this one before: I changed data from my application, but when I checked the database, I couldn’t see the change! I’ve seen this. Loads. It can be quite perplexing for folks because they expect to see an error m …
Time Series Data Mining Example with T-SQL when Adding New Data
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 data designer, data modeler, data programmer, data whatever. Whether you are setting up a data warehouse or an operational database, it happens often that you need to s …
Warehouse Load Patterns – Part 1 – Requirements and General Patterns
No matter the ETL tool used, there are some basic patterns to follow when transferring data between systems. There are many data tools and platforms, but the basic patterns remain the same. This focuses on SQL Server, but most of these methods work in …
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 interesting advance, but it was disappointing because it was only available in half. Updating the Fabric Data Warehouse was not possible yet. The November …