Who’s Changing the Table? Answers and DiscussionYour challenge for this week was to find out who keeps mangling the contents of the AboutMe column […] 8 mai 2024 dans Sites anglophones étiqueté Query Exercise Answers par brentozar.com
SQL Server Filtered Index Essentials GuideThe post SQL Server Filtered Index Essentials Guide appeared first on SQLServerCentral. 8 mai 2024 dans Sites anglophones étiqueté Filtered Indexes / indexing par sqlservercentral.com
SQL ConstantCare® Population Report: Spring 2024The short story: SQL Server 2019 appears poised to swallow the SQL Server market altogether, hahaha. The long […] 7 mai 2024 dans Sites anglophones étiqueté SQL Server Population Report par brentozar.com
How to Build Metadata Driven Pipelines in Microsoft FabricOver the past years, “traditional” ETL development has morphed into data engineering, which has a more disciplined […] 6 mai 2024 dans Sites anglophones étiqueté BI / Homepage / Microsoft Fabric par simple-talk.com
[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 […] 6 mai 2024 dans Sites anglophones étiqueté Videos par brentozar.com
Ingest and Retrieve data from an ADX Cluster Using PythonIntroduction Azure Data Explorer (ADX) helps to analyze high volumes of data in near real-time. The Azure Machine […] 6 mai 2024 dans Sites anglophones étiqueté Azure Data Explorer (ADX) / Python par sqlservercentral.com
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 […] 6 mai 2024 dans Sites anglophones étiqueté availability groups / Failover Clusters / The Curious Case of... par sqlskills.com - paul randall
All about SQL drivers and access tokensWe often get support escalations related to failures around expired access tokens when using Microsoft Entra ID (formerly […] 3 mai 2024 dans Sites Microsoft par MS Tech Community
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 […] 3 mai 2024 dans Sites anglophones étiqueté Who's Hiring par brentozar.com
Database Dashboards in Azure Data StudioAzure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I’ve written a few articles […] 3 mai 2024 dans Sites anglophones étiqueté Azure Data Studio (ADS) / Tools for development par sqlservercentral.com
Managing Failed Pipeline Runs in Azure Data FactoryThe post Managing Failed Pipeline Runs in Azure Data Factory appeared first on SQLServerCentral. 3 mai 2024 dans Sites anglophones étiqueté ETL/SSIS/Azure Data Factory par sqlservercentral.com
Query Exercise: Who’s Changing the Table?For this week’s Query Exercise, your challenge is to find out who keeps messing up the rows in […] 2 mai 2024 dans Sites anglophones étiqueté Query Exercises par brentozar.com
It’s Time For Our Annual Anniversary Sale!I first registered BrentOzar.com way back in May 2001. Over the years, some things in databases have changed […] 1 mai 2024 dans Sites anglophones étiqueté Company News par brentozar.com
Metadata Driven Pipelines – Data Engineering with FabricWhat is a metadata driven pipeline? Wikipedia defines metadata as “data that provides information about other data.” As […] 1 mai 2024 dans Sites anglophones étiqueté Apache Spark / Bronze / CSV files / data engineering / Data Factory / Full Load Code / John F. Miner III / Learn / Meta Data Driven Design / Microsoft Fabric / Microsoft Fabric (Azure Synapse, Data Engineering, etc.) / Quality Zones / Raw / Silver par sqlservercentral.com
PySpark Secrets to use with FabricPySpark is a powerful language for data manipulation and it’s full of tricks. Let’s discover some of […] 30 avril 2024 dans Sites anglophones étiqueté Blogs / Microsoft Fabric par simple-talk.com
Join Me at the PASS Data Community Summit in November!On November 4 in Seattle, I’m presenting a new pre-conference workshop! Tuning T-SQL for SQL Server 2019 and […] 30 avril 2024 dans Sites anglophones étiqueté #SQLPass par brentozar.com
Updating Documents in MongoDBThis article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […] 29 avril 2024 dans Sites anglophones étiqueté Homepage / MongoDB / MySQL par simple-talk.com
Learning Spark SQL String Functions with Explanations and Code ExamplesThe post Learning Spark SQL String Functions with Explanations and Code Examples appeared first on SQLServerCentral. 29 avril 2024 dans Sites anglophones étiqueté Apache Spark par sqlservercentral.com
Exporting and Importing Registered Servers in SSMSMany SQL Server Management Studio (SSMS) users connect to the same SQL Server instances over and over. In […] 29 avril 2024 dans Sites anglophones étiqueté Management Studio (SSMS) / Registered Servers / Tools for development par sqlservercentral.com
Database technology learning resourcesBefore I started as the editor of Simple Talk, I worked on SQL Server. Only. (Ok, I […] 27 avril 2024 dans Sites anglophones étiqueté Free Stuff / Homepage / Resources par simple-talk.com
Building RESTful APIs in Rust With Actix and DieselThere are many packages and tools that you can use to facilitate your API development with Rust. […] 26 avril 2024 dans Sites anglophones étiqueté Homepage / Rust / Web par simple-talk.com
What happens when we drop a column on a SQL ...Short answer: The column is marked as ‘deleted’ and will stop being visible/usable. But, most importantly – The […] 26 avril 2024 dans Sites anglophones étiqueté @SQLServer / Administration / Database Administration / DBA / DBCC IND / DBCC PAGE / internals / SQL Server internal storage / Table Structure / TSQL par sqlservercentral.com
Why migrate Windows Server and SQL Server to Azure: ROI, ...Hey everyone! We’ve been on the road the last couple of weeks at MVP Summit, SQLBits and Fabric […] 25 avril 2024 dans Sites Microsoft par SQL Server Blog
[Video] Database Answers in Hong KongAs my time in Hong Kong came to an end, I sat inside on a foggy morning and […] 25 avril 2024 dans Sites anglophones étiqueté Videos par brentozar.com
Working with IAsyncEnumerable in C#IAsyncEnumerable is a powerful interface introduced in C# 8.0 that allows you to work with sequences of […] 24 avril 2024 dans Sites anglophones étiqueté .NET / Homepage par simple-talk.com
Troubleshooting Mysterious Blocking Caused By sp_getapplockI’m kinda weird. I get excited when I’m troubleshooting a SQL Server problem, and I keep hitting walls. […] 24 avril 2024 dans Sites anglophones étiqueté Locking, Blocking, and Isolation Levels par brentozar.com
It’s almost time for Fundamentals Week! Have you signed up ...The Monday after next, I’ll be getting together with dozens of smart people who are a lot like […] 23 avril 2024 dans Sites anglophones étiqueté Conferences and Classes par brentozar.com
Recursive CTEs: Transforming and Analyzing Data in PostgreSQL, Part 3The first two articles in this series demonstrated how PostgreSQL is a capable tool for ELT – […] 22 avril 2024 dans Sites anglophones étiqueté Homepage / PlanetPostgresqlRyanBooz / PostGreSQL par simple-talk.com
Unlocking Power with Updatable Views in SQL ServerRelational database management systems (RDBMS) rely on Structured Query Language (SQL) as their foundation for data management and […] 22 avril 2024 dans Sites anglophones étiqueté sql server views / updatable views / Views par sqlservercentral.com
Kubernetes For Complete BeginnersThe post Kubernetes For Complete Beginners appeared first on SQLServerCentral. 22 avril 2024 dans Sites anglophones étiqueté Virtualization, containers, and k8s par sqlservercentral.com
Building a Culture of Data: The Technical AspectsIn the first part of this two-part series, I covered the mostly non-technical aspects of building a […] 19 avril 2024 dans Sites anglophones étiqueté Blogs / Culture / Data culture / Homepage par simple-talk.com
Identifying Customer Buying Pattern in Power BI – Part 1This article is part 1 of a retail analytics market-based analysis in Power BI. In part 1, we […] 19 avril 2024 dans Sites anglophones étiqueté business intelligence / Data Analytics / Market Based Analysis / Power BI / Retail analytics par sqlservercentral.com
[Video] Office Hours: Hong Kong HarborI recently went to Shanghai & Hong Kong, and stopped to take your questions from https://pollgab.com/room/brento while sitting […] 18 avril 2024 dans Sites anglophones étiqueté Videos par brentozar.com
Database Subsetting and Data ExtractionLet’s start by defining a subset and why you would require a data subset? When dealing with […] 17 avril 2024 dans Sites anglophones étiqueté Database Administration / Homepage / Theory and design par simple-talk.com
Exploration Experience: Saving and Creating DatasetsI have been talking about Data Exploration in Power BI on many of my sessions, specially the […] 17 avril 2024 dans Sites anglophones étiqueté Blogs / Data Exploration / Microsoft Fabric / Power BI par simple-talk.com
How to Have a Conversation About Software LicensingAs a consultant, I sometimes see SQL Servers with high CPU core counts relative to their workload. For […] 17 avril 2024 dans Sites anglophones étiqueté Licensing par brentozar.com
Full vs. Incremental Loads – Data Engineering with FabricThe loading of data from a source system to target system has been well documented over the years. […] 17 avril 2024 dans Sites anglophones étiqueté Apache Spark / Bronze / data engineering / Erase Hive Tables / Full Load Code / Incremental Load Code / John F. Miner III / Learn / Microsoft Fabric / Microsoft Fabric (Azure Synapse, Data Engineering, etc.) / Quality Zones / Raw / Silver par sqlservercentral.com
Announcing Offline Access to Your BrentOzar.com CoursesSo you’ve got an iPhone or iPad or Vision Pro, and you bought one of my training classes […] 16 avril 2024 dans Sites anglophones étiqueté Company News par brentozar.com
Announcing GA of enhanced patching for SQL Server on Azure ...We are pleased to announce the GA release of enhanced patching capabilities for SQL Server on Azure VMs […] 16 avril 2024 dans Sites Microsoft par MS Tech Community
Snake draft sorting in SQL Server, part 2In my previous post, I showed how to borrow a snake draft concept from fantasy football, or […] 15 avril 2024 dans Sites anglophones étiqueté Database Administration / Homepage / SQL Server / T-SQL Programming par simple-talk.com
Finding Sister Locations to Help Each Other: Answers & DiscussionThe post Finding Sister Locations to Help Each Other: Answers & Discussion appeared first on SQLServerCentral. 15 avril 2024 dans Sites anglophones étiqueté t-sql par sqlservercentral.com
Disaster Recovery and High Availability Solutions in SQL ServerWhen managing a database, ensuring data availability and integrity is paramount, especially in the face of hardware failures, […] 15 avril 2024 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com
Snake draft sorting in SQL Server, part 1I recently had a restore job where I needed to split the work up into multiple parallel […] 12 avril 2024 dans Sites anglophones étiqueté Database Administration / Homepage / SQL Server / T-SQL Programming par simple-talk.com
Fabric and Azure SQL in a few clicks: Mirroring a ...Finally, mirroring is available for Fabric! You can mirror an Azure SQL to Fabric. It works for […] 12 avril 2024 dans Sites anglophones étiqueté BI / Homepage / Microsoft Fabric par simple-talk.com
Breaking Down DENSE_RANK(): A Step-by-Step Guide for SQL EnthusiastsIntroduction to SQL Window Functions In today’s data-driven world, SQL (Structured Query Language) stands as a cornerstone for […] 12 avril 2024 dans Sites anglophones étiqueté #sql interview questions / Advanced SQL / Azure SQL / BI / Data / Database / SQL Script / Uncategorized par sqlservercentral.com
Cumulative Update #26 for SQL Server 2019 RTMThe 26th cumulative update release for SQL Server 2019 RTM is now available for download at the Microsoft […] 12 avril 2024 dans Sites Microsoft par MS Tech Community
[Video] Office Hours: Career & Data Q&AA few career and security questions found their way into the queue at https://pollgab.com/room/brento for this episode: Here’s […] 11 avril 2024 dans Sites anglophones étiqueté Videos par brentozar.com
How to Use Any SQL Database With RustRust is emerging as a frontrunner for ensuring memory safety without sacrificing performance. Its growing popularity isn’t […] 11 avril 2024 dans Sites anglophones étiqueté Homepage / Rust / Web par simple-talk.com
Azure OpenAI and RAG SecurityThe most watched videos on my youtube channel are related to security. Azure SQL Networking Secrets and […] 10 avril 2024 dans Sites anglophones étiqueté Azure / Blogs / openai / Security par simple-talk.com
Your Teammates Need the Fundamentals.You’ve been reading my site for a while, watching videos, keeping up with the best SQL Server techniques. […] 10 avril 2024 dans Sites anglophones étiqueté Conferences and Classes par brentozar.com