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
SQL Server Plan Cache Bloat Performance ImpactsThe post SQL Server Plan Cache Bloat Performance Impacts appeared first on SQLServerCentral. 10 avril 2024 dans Sites anglophones étiqueté Performance and Tuning / Plan Cache par sqlservercentral.com
Security Update for SQL Server 2022 RTM CU12The Security Update for SQL Server 2022 RTM CU12 is now available for download at the Microsoft Download […] 9 avril 2024 dans Sites Microsoft par MS Tech Community
Security Update for SQL Server 2019 RTM CU25The Security Update for SQL Server 2019 RTM CU25 is now available for download at the Microsoft Download […] 9 avril 2024 dans Sites Microsoft par MS Tech Community
Security Update for SQL Server 2019 RTMThe Security Update for SQL Server 2019 RTM GDR is now available for download at the Microsoft Download […] 9 avril 2024 dans Sites Microsoft par MS Tech Community
Update: Security hotfixes released for ODBC and OLE DB drivers ...We’ve released hotfix packages for the following drivers to address important security issues: Microsoft ODBC Driver 17.10.6 […] 9 avril 2024 dans Sites Microsoft par MS Tech Community
Using ChatGPT for T-SQL Code ReviewsFor this month’s T-SQL Tuesday, Pinal Dave asked us if AI has helped us with our SQL Server […] 9 avril 2024 dans Sites anglophones étiqueté t-sql par brentozar.com
Using Common Table Expressions: Transforming and Analyzing Data in PostgreSQL, ...In the first article in this transforming data series, I discussed how powerful PostgreSQL can be in […] 8 avril 2024 dans Sites anglophones étiqueté Homepage / PlanetPostgresqlRyanBooz / PostGreSQL par simple-talk.com
Giving Feedback on Microsoft Data Platform ToolsAs a data professional, there is a set of tools that you use on pretty much a […] 8 avril 2024 dans Sites anglophones étiqueté Editorials / Homepage / SQL Server par simple-talk.com
Joining Queries in Azure Data Factory on Cosmos DB SourcesThis article illustrates how to join two queries using ADF (Azure data factory). Prerequisites First, prepare your data […] 8 avril 2024 dans Sites anglophones étiqueté Azure Cosmos DB / Azure Data Factory / ETL/SSIS/Azure Data Factory par sqlservercentral.com
SQL Server Patching Using PowerShell DSCIntroduction In the previous article we have seen how to install SQL Server Management Studio (SSMS) using PowerShell […] 5 avril 2024 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com
Introduction to Python including Installation, Jupyter Notebooks and Visual Studio ...The post Introduction to Python including Installation, Jupyter Notebooks and Visual Studio Code appeared first on SQLServerCentral. 5 avril 2024 dans Sites anglophones étiqueté Python / VS Code par sqlservercentral.com
[Video] Office Hours: Just Three QuestionsSometimes y’all post questions at https://pollgab.com/room/brento that require extended answers. Today, I’m hitting just 3 questions: Here’s what […] 4 avril 2024 dans Sites anglophones étiqueté Videos par brentozar.com
Released: SCOM Management Pack for Azure SQL Managed Instance (7.4.0.0)An update to Azure SQL Managed Instance Management Pack is available (7.4.0.0). You can download the MP from […] 3 avril 2024 dans Sites Microsoft par MS Tech Community
Dynamic Partitioning and a Simple Incremental LoadLet’s consider a simple statement for partitioning and save a table in a lakehouse: df.write.mode(« overwrite »).format(« delta »).partitionBy(« Year », »Month », »Day »).save(« Tables/ » + table_name) […] 3 avril 2024 dans Sites anglophones étiqueté Blogs / lakehouse / Microsoft Fabric par simple-talk.com