Bridging Snowflake and Azure Data Stack: A Step-by-Step Guide
In today’s era of hybrid data ecosystems, organizations often find themselves straddling multiple data platforms for optimal performance and functionality. If your organization utilizes both Snowflake and Microsoft data stack, you might encounter the n …
Powershell and SQL on the River
We are having a conference in Chattanooga, TN on Aug 16 and 17, the primary topics of which are clearly in the name of the conference! We have 3 tracks, and one of the tracks is for ANY topic (technical/professional is probably better, but I am excited …
[Video] Office Hours: 16 Questions
Like Sixteen Candles, but different: I go through your top-voted questions from https://pollgab.com/room/brento. Strangely, my video and audio is ever so slightly out of sync in this episode. 00:00 Start 01:26 GuaroSql: Hey Brent! How are you? It is ne …
PostgreSQL UNION, INTERCEPT & EXCEPT Operator
Overview In this tutorial, you will learn how to use the PostgreSQL Union, Intercept and Except operators to combine result sets of two or more queries. These operators helps to combine result sets of two select statements into a single result . UNION …
SQL Bulk Insert Command Examples
The post SQL Bulk Insert Command Examples appeared first on SQLServerCentral.
Coming in Entity Framework 9: Better Query Parameterization
Hallelujah. With current versions of Entity Framework, when developers add a mix of parameters and specific values to their query like this:async Task<List<Post>> GetPosts(int id) => await context.Posts .Where( e => e.Title == « .NET B …
This Is It! The Last 3 Days of My Anniversary Sale.
Every year in May, I look back at when I first registered BrentOzar.com way back in May 2001. Things were so different back then. I struggled trying to find fun, interesting ways to learn about Microsoft SQL Server. My learning options were really dry …
Enhancing Web Application Performance through Database Optimization: A Comprehensive Study
Introduction In today’s digital age, web applications serve as the backbone of online services, catering to a myriad of user needs ranging from e-commerce transactions to social networking interactions. However, the success and usability of these appli …
Updated First Responder Kit and Consultant Toolkit for May 2024
If you’ve hard-coded installer file names, there’s a big change in this release. There are now just 2 installer scripts: Install-All-Scripts.sql, and a new Install-Azure.sql, which only installs the scripts that are compatible with Azure SQ …
Snake draft sorting in SQL Server, part 4
In the previous posts in this series (part 1, part 2, part 3), I described how I have optimized a long-running set of routines by processing databases, tables, and even subsets of tables in parallel. This leads to many separate jobs that all kick off a …
SQL Server Temporary Stored Procedures
The post SQL Server Temporary Stored Procedures appeared first on SQLServerCentral.
What is new in Copilot, the new features available
Introduction to copilot In Bing, you can now see a Copilot option. In the past, we had Bing Chat. Now, it was changed to Copilot. In this article, we will see what is new in Copilot. When was Copilot introduced in Bing? The rebranding of Bing Chat to C …
Manage Elastic jobs in Azure using Azure Elastic Jobs Manager
Microsoft Azure offers the Azure Elastic Job agent as a managed service, enabling efficient scheduling of T-SQL workloads on Azure SQL Databases. Similar to the SQL Server Agent job Wizard in SQL Server Management Studio, Azure Elastic Jobs Manager str …
Takeaways from Data Grillen 2024
Before anyone tries to order something online from DataGrillen.com and thinks it will be delivered by them by TakeAway.com: STOP. The content of this article is, of course, about the annual, legendary and unique event called Data Grillen, helt in Linge …
Okay, About That SmartPostgres.com Thing.
In some of the Query Exercises posts here, you might have noticed links over to similar query exercises at SmartPostgres.com, and the free read-only version of the Stack Overflow database I’m hosting there. I’ve held off the questions for l …