[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 […]
Archives du mois : mai 2024
PostgreSQL UNION, INTERCEPT & EXCEPT Operator
Overview In this tutorial, you will learn how to use the PostgreSQL Union, Intercept and Except operators to […]
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 […]
This Is It! The Last 3 Days of My Anniversary ...
Every year in May, I look back at when I first registered BrentOzar.com way back in May 2001. […]
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 […]
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 […]
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 […]
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 […]
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 […]
Takeaways from Data Grillen 2024
Before anyone tries to order something online from DataGrillen.com and thinks it will be delivered by them by […]
Okay, About That SmartPostgres.com Thing.
In some of the Query Exercises posts here, you might have noticed links over to similar query exercises […]
ライセンス関連のお問い合わせ窓口について (Azure 仮想マシン : SQL Server)
こんにちは、 SQL Server サポートです。 本記事では、Azure 仮想マシン上でご利用の SQL Server のライセンスに関するお問い合わせ窓口を紹介します。 Azure 仮想マシン上の SQL Server のライセンスやご契約に関するお問い合わせを 私ども技術サポート窓口 にお問い合わせをいただくことがありますが、恐れ入りますが専門外となるため、基本的にご案内はできないものとなります。 […]
[Video] Office Hours: I Feel Like an Amateur Edition
I started with audio problems, then had video problems halfway in. It’s amusing because we also discuss feeling […]
Troubleshoot SQL Server Always On Availability Groups with SQL LogScout
The post Troubleshoot SQL Server Always On Availability Groups with SQL LogScout appeared first on SQLServerCentral.
Empowering Lakehouse Users – Data Engineering with Fabric
Microsoft Fabric allows the developers to create delta tables in the Lakehouse. However, the automation of copying, updating, […]
The Future of DBAs: History Rhymes
Eitan Blumin recently wrote a post about the future of the DBA career in which he talked about […]
The CHECK() Constraint
One of the many ways a relational table differs from the file structures used by pre-relational storage […]
Détecter les blocages dans MS SQL Server
Un blocage est un phénomène normal dans tous SGBD Relationnels pour éviter les conflits d’accès en écriture qui, […]
Exploring MVCC and InnoDB’s Multi-Versioning Technique
In the realm of relational databases, MySQL stands out as one of the most popular choices. Maximizing […]
How Big Data Supports Gen AI
Big data processing plays a pivotal role in the development and efficiency of Generative Artificial Intelligence (AI) systems. […]
Unlock power of data in Azure- With SQL Server on ...
In a world awash with data, the challenge lies in our ability to comprehend and engage with it […]
Optimizing MySQL: Deleting Data
In the previous parts of these MySQL optimization series, we told you how query optimization works on […]
SQL Replication Error – the row was not found at ...
The post SQL Replication Error – the row was not found at the Subscriber when applying the replicated […]
Managing SQL Agent in Azure Data Studio
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I’ve written a few articles […]
Cumulative Update #13 for SQL Server 2022 RTM
The 13th cumulative update release for SQL Server 2022 RTM is now available for download at the Microsoft […]
[Video] Office Hours: Answers for Your Database Questions
Y’all post questions and upvote the best ones at https://pollgab.com/room/brento, and I discuss ’em in my home office […]
Windows 11/Windows Server 2022 への SQL Server のインストールが失敗する場合の対処策について
こんにちは。SQL Server サポート チームです。 今回は、Windows 11 に SQL Server をインストールする際に、インストール先のディスクのセクター サイズが 4KB よりも大きいために、インストールに失敗した場合の対処策をご案内します。 SQL Server では 4KB […]
Snake draft sorting in SQL Server, part 3
In part 2 of this series, I showed an example implementation of distributing a long-running workload in […]
Getting Data Out of an Audit Table: Answers & Discussion
In last week’s post, I gave you a trigger that populated a history table with all changes to […]
SQL Server Always On Availability group on AKS with DH2i’s ...
Did you know you can do a quickfire deployment of SQL Server Always On Availability Groups on Azure […]
Combining Silver Tables into a Model – Data Engineering with ...
Data Presentation Layer Microsoft Fabric allows the developer to create delta tables in the lake house. The bronze […]
Why Generative AI Scares the Hell Out of DBAs
I was chatting with a client’s DBA about this thought-provoking blog post about data governance in the age […]
T-SQL Tuesday #174: Your Favorite Job Interview Question?
T-SQL Tuesday is something I don’t participate in nearly enough. When I saw Kevin Feasel’s invitation for […]
PowerBI premium capacity administration: dataset monitoring and tuning
Over the years Power BI has evolved into a complex and varied ecosystem of tools and solutions, […]
Read Data Stored in a Lake Database using Azure Synapse ...
The post Read Data Stored in a Lake Database using Azure Synapse Analytics appeared first on SQLServerCentral.
Using Machine Learning Pipeline Execution Activity in Azure Data Factory
Introduction The Azure Machine Learning (AML) Python SDK v2 is an updated Python SDK package. It helps to […]
Identifying Customer Buying Pattern in Power BI – Part 2
In our previous article, Identifying Customer Buying Patterns in Power BI—Part 1, we described the customer purchase product […]
SQL Server Networking troubleshooting documentation expanded
The SQL Server CSS (technical support) and Content teams have been publishing documentation on troubleshooting SQL Server networking […]
I’m Getting Antsy for SQL Server vNext.
Historically, Microsoft publicly announces the next version of SQL Server about a year before it ships. For example: […]
Who’s Changing the Table? Answers and Discussion
Your challenge for this week was to find out who keeps mangling the contents of the AboutMe column […]
SQL Server Filtered Index Essentials Guide
The post SQL Server Filtered Index Essentials Guide appeared first on SQLServerCentral.
SQL ConstantCare® Population Report: Spring 2024
The short story: SQL Server 2019 appears poised to swallow the SQL Server market altogether, hahaha. The long […]
How to Build Metadata Driven Pipelines in Microsoft Fabric
Over the past years, “traditional” ETL development has morphed into data engineering, which has a more disciplined […]
[Video] Office Hours: Ask Me Anything About Azure and Microsoft ...
Back at home in the office, time to settle in with a nice caffeine-free Diet Coke and go […]
Ingest and Retrieve data from an ADX Cluster Using Python
Introduction Azure Data Explorer (ADX) helps to analyze high volumes of data in near real-time. The Azure Machine […]
The Curious Case of… missing log information
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post […]
All about SQL drivers and access tokens
We often get support escalations related to failures around expired access tokens when using Microsoft Entra ID (formerly […]
Who’s Hiring in the Microsoft Data Platform Community? May 2024 ...
Is your company hiring for a database position as of May 2024? Do you wanna work with the […]