Autonomous Databases?I was talking to some people today about the concept of Autonomous Databases. The idea is that […] 15 novembre 2023 dans Sites anglophones étiqueté Blogs / Editorials par simple-talk.com
The Curious Case of… missing 832 errors during memory corruption(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post […] 14 novembre 2023 dans Sites anglophones étiqueté Corruption / The Curious Case of... par sqlskills.com - paul randall
The Black Friday Sale is Here: Save Big on Training ...My Annual Black Friday Sale is On! I’m running a giant Black Friday sale on my training courses! […] 14 novembre 2023 dans Sites anglophones étiqueté Company News par brentozar.com
The Real Problem with SQL Server’s Licensing CostsAt least once a month, a client has The Postgres Conversation™ with me. It happens at the end […] 13 novembre 2023 dans Sites anglophones étiqueté SQL Server par brentozar.com
Getting Started with MongoDBMongoDB is a scalable database management system that stores data as documents in a collection, rather than […] 13 novembre 2023 dans Sites anglophones étiqueté Homepage / NoSQL par simple-talk.com
It’s Probably Time to Upgrade Your Cloud VMsThe post It’s Probably Time to Upgrade Your Cloud VMs appeared first on SQLServerCentral. 13 novembre 2023 dans Sites anglophones étiqueté Cloud Computing / IaaS par sqlservercentral.com
Azure Data Studio – A First LookIntroduction Azure Data Studio is the next iteration in Microsoft’s development of a cross-platform client tool for developing […] 13 novembre 2023 dans Sites anglophones étiqueté Azure / Azure Data Studio / data studio / DevOps / SQL Tools par sqlservercentral.com
Security in the cloud: Whose responsibility is it?The post Security in the cloud: Whose responsibility is it? appeared first on SQLServerCentral. 13 novembre 2023 dans Sites anglophones étiqueté Cloud Computing / Security par sqlservercentral.com
An editor’s biggest headache: PlagiarismAs an editor working with other people’s technical writing for many years, you might guess that either […] 10 novembre 2023 dans Sites anglophones étiqueté Blogs par simple-talk.com
Office Hours: “Read This” EditionSometimes when people post questions at https://pollgab.com/room/brento, the answer is just a link, nothing more, nothing less. It […] 10 novembre 2023 dans Sites anglophones étiqueté SQL Server par brentozar.com
Microsoft at PASS Data Community Summit 2023!t’s gearing up to be an exciting week November 14th – 17th as we prepare for this […] 10 novembre 2023 dans Sites Microsoft par MS Tech Community
Is your organization using MongoDB? Help the Redgate Flyway team ...The post Is your organization using MongoDB? Help the Redgate Flyway team understand your pain points appeared first […] 10 novembre 2023 dans Sites anglophones étiqueté flyway / PostGreSQL / RedGate / Redgate Software par sqlservercentral.com
The PASS Data Community Summit First Timer GuideEdwin Sarmiento has been producing a first-timer’s guide for the PASS Data Community Summit since 2016. He has […] 10 novembre 2023 dans Sites anglophones étiqueté PASS Summit par sqlservercentral.com
Time-Series Data Analysis with Apache DruidIn the era of data-driven decision-making, the ability to efficiently analyze and derive insights from time-series data is […] 10 novembre 2023 dans Sites anglophones étiqueté Apache Druid / Big Data / Data Warehouse / ETL (Extract Transform and Load) / Management Data Warehouse / Time Series Data Warehouse par sqlservercentral.com
[Video] Office Hours: Having a Bad Day EditionThe first day back after a long vacation is always rough, and today’s no exception. I took your […] 9 novembre 2023 dans Sites anglophones étiqueté Videos par brentozar.com
The NTILE FunctionThe SQL NTILE() is a window function that allows you to break a table into a specified […] 9 novembre 2023 dans Sites anglophones étiqueté Homepage / Theory and design par simple-talk.com
Fabric Data Warehouse News you need to knowMicrosoft Fabric, including the Data Warehouse, evolves faster than we can analyze and write about it. Here […] 8 novembre 2023 dans Sites anglophones étiqueté Blogs / data platform / Data Warehouse / Microsoft Fabric / Power BI par simple-talk.com
Azure Data Studio 1.47 is now availableJust in time for Microsoft Ignite and the PASS Data Community Summit, version 1.47.0 of Azure Data Studio […] 8 novembre 2023 dans Sites Microsoft par MS Tech Community
[Video] Office Hours: Yes, I’m In the Same ShirtWhy yes, I’m wearing the same shirt as the video from “yesterday”. Why do you ask? Stop paying […] 8 novembre 2023 dans Sites anglophones étiqueté Videos par brentozar.com
Timescale Launches Dynamic PostgreSQL, the Cost-Effective Alternative to Serverless and ...NEW YORK – November 6, 2023 – Timescale, the cloud database company, has announced the launch of their […] 8 novembre 2023 dans Sites anglophones étiqueté PostGreSQL par sqlservercentral.com
Free Webcast: How to Think Like the Engine, LiveYou’re comfortable writing queries to get the data you need. But you’re uncomfortable if someone asks you how it […] 7 novembre 2023 dans Sites anglophones étiqueté Conferences and Classes par brentozar.com
Who’s Hiring in the Microsoft Data Platform Community? November 2023 ...Is your company hiring for a database position as of November 2023? Do you wanna work with the […] 6 novembre 2023 dans Sites anglophones étiqueté Who's Hiring par brentozar.com
Storm Ciaran Analysis with Microsoft FabricAlways looking for Open Source data to highlight the capabilities of Microsoft Analytics solutions, I have: In […] 6 novembre 2023 dans Business Intelligence / Sites anglophones étiqueté Microsoft Fabric / microsoftfabric par www.pulsweb.fr
Analyse de la tempête Ciaran avec Microsoft FabricToujours à la recherche de données Open Source afin de mettre en exergue les capacités des solutions […] 6 novembre 2023 dans Business Intelligence / Sites anglophones étiqueté Microsoft Fabric par www.pulsweb.fr
Moving SQL Server To The Cloud: Modernizing Stack Overflow for ...Earlier this year, we migrated the entire Stack Overflow for Teams platform to Azure. This was a […] 6 novembre 2023 dans Sites anglophones étiqueté Database Administration / Homepage / migration / Upgrades par simple-talk.com
SQL Server and Python TutorialIntroduction In this article, we will see how to connect SQL Server with Python using the pyodbc library. […] 6 novembre 2023 dans Sites anglophones étiqueté Microsoft SQL Server / Python / SQL Server par sqlservercentral.com
Five database DevOps practices for boosting team productivityThe post Five database DevOps practices for boosting team productivity appeared first on SQLServerCentral. 6 novembre 2023 dans Sites anglophones étiqueté DevOps and Continuous Delivery (CI/CD) / Software Development par sqlservercentral.com
Creating an Azure PostgreSQL cluster and connecting to itOne of the technologies that my new job brought with it was learning about all the various […] 4 novembre 2023 dans Sites anglophones étiqueté Azure / Blogs / PostGreSQL par simple-talk.com
Deploying availability groups for SQL Server with HPE Serviceguard for ...It’s time for a new blog on how Ansible can simplify SQL Server deployment, configuration, and availability. If […] 3 novembre 2023 dans Sites Microsoft par MS Tech Community
Getting connected to PostgreSQL for the first timePostgreSQL continues to be all the rage in 2023, whether in “vanilla” form of the fully open-source […] 3 novembre 2023 dans Sites anglophones étiqueté Homepage / PlanetPostgresqlRyanBooz / PostGreSQL par simple-talk.com
Efficient Table Migration to a New Schema in T-SQLIntroduction Efficiently migrating tables to a new schema in T-SQL is a common task for database administrators and […] 3 novembre 2023 dans Sites anglophones étiqueté Database Administration / schema / Schemas / t-sql / Table Migration par sqlservercentral.com
SQL Server Fragmentation Impact with Modern HardwareThe post SQL Server Fragmentation Impact with Modern Hardware appeared first on SQLServerCentral. 3 novembre 2023 dans Sites anglophones étiqueté Administration / Database Administration / Fragmentation par sqlservercentral.com
Microsoft at the PASS Data Community Summit 2023It’s gearing up to be an exciting week November 14th – 17th as we prepare for this year’s […] 3 novembre 2023 dans Sites anglophones étiqueté Microsoft / PASS Summit par sqlservercentral.com
Entra Authentication for Replication in Arc-enabled SQL Server 2022 CU ...As of SQL Server 2022 Cumulative Update (CU) 6, configuring replication using authentication with Microsoft Entra ID (formerly […] 2 novembre 2023 dans Sites Microsoft par MS Tech Community
The Black Friday Sale is Live!You’ve used sp_Blitz and the First Responder Kit to learn a lot about your databases. You read the […] 1 novembre 2023 dans Sites anglophones étiqueté Company News par brentozar.com
Why Database Discussions Have Moved From the Backroom to the ...The post Why Database Discussions Have Moved From the Backroom to the Boardroom appeared first on SQLServerCentral. 1 novembre 2023 dans Sites anglophones étiqueté DevOps and Continuous Delivery (CI/CD) par sqlservercentral.com
SQL Server Central Is Upgrading Our ServersThe Short Story We will be upgrading our systems on Thur, Nov 2, from around 930a GMT to […] 1 novembre 2023 dans Sites anglophones étiqueté SQLServerCentral par sqlservercentral.com
Using Pipeline Return Value in Azure Data Factory and Azure ...Introduction In this article, we will talk about Azure Data Factory’s newly introduced Pipeline return value features. We […] 1 novembre 2023 dans Sites anglophones étiqueté Azure Data Factory / ETL/SSIS/Azure Data Factory / Microsoft Fabric (Azure Synapse, Data Engineering, etc.) par sqlservercentral.com
SSMSInfoReports : nouvelle release v9Une nouvelle release de mes rapports custom pour SQL Server Management Studio, la v9 ! Enormément d’améliorations partout […] 31 octobre 2023 dans Sites francophones par blog.datafly.pro
SQL Endpoints and Lakehouse UI Differences and Access SecretsThere are some differences and secrets between the UI of a SQL Endpoint and the UI of […] 30 octobre 2023 dans Sites anglophones étiqueté BI / Data Lake / Homepage / lakehouse / Microsoft Fabric / Power BI par simple-talk.com
[Video] Halloween Office Hours in Salem, MAI visited friends in Salem, Massachusetts, home of the 1692 witch trials, and it turns out Salem is […] 30 octobre 2023 dans Sites anglophones étiqueté Videos par brentozar.com
Utiliser les indicateurs de requête, la présentationTéléchargez la présentation de la conférence Datafrogs « utiliser les indicateurs de requête (Query hints) ». https://blog.datafly.pro/public/Documents/Datafrogs_-_Query_Hints.pdf La vidéo de […] 30 octobre 2023 dans Sites francophones par blog.datafly.pro
Mastering a cloud migration: 10 video tipsThe post Mastering a cloud migration: 10 video tips appeared first on SQLServerCentral. 30 octobre 2023 dans Sites anglophones étiqueté Cloud Computing par sqlservercentral.com
Improve Query Performance when SQL Server Ignores Nonclustered IndexThe post Improve Query Performance when SQL Server Ignores Nonclustered Index appeared first on SQLServerCentral. 30 octobre 2023 dans Sites anglophones étiqueté Database Performance / Performance and Tuning par sqlservercentral.com
Batch Execution Mode on a Rowstore in SQL Server 2022Batch execution mode is a new optimization feature in SQL Server. In this article, we’ll explore how batch […] 30 octobre 2023 dans Sites anglophones étiqueté #sql server interview questions / Azure SQL / azure sql server / Batch Execution Mode on Rowstore in SQL Server 2022 / Database Performance / Microsoft SQL Server / Microsoft SQL Server 2022 / performance enhancement / Performance Tuning / SQL Server / SQL Server 2019 / SQL Server 2022 par sqlservercentral.com
Trigger the Execution of an ADF Pipeline from an EmailIntroduction The problem statement is to execute a Data Factory Pipeline automatically every time an email is received […] 27 octobre 2023 dans Sites anglophones étiqueté Azure Data Factory / ETL/SSIS/Azure Data Factory par sqlservercentral.com
Power Query Editor in Power BI for Formatting Text ColumnsThe post Power Query Editor in Power BI for Formatting Text Columns appeared first on SQLServerCentral. 27 octobre 2023 dans Sites anglophones étiqueté Power BI / Power Query par sqlservercentral.com
Pike’s Market to Pikes Peak: The PASS Summit is Worth ...Recently I spoke at SQL Saturday Denver. The day after the conference we went to visit Pikes […] 26 octobre 2023 dans Sites anglophones étiqueté Editorials / Homepage par simple-talk.com
Packed/Batched Transact-SQL (TSQL) RPC InvocationThe SQL Server TDS protocol provides two main paths for query execution (Language and RPC events.) You can […] 26 octobre 2023 dans Sites Microsoft par MS Tech Community
Announcing Buy-Now-Pay-Later, Just in Time for the Black Friday Sale!It’s almost time for my annual Black Friday sale, and some of you are staring longingly at the […] 26 octobre 2023 dans Sites anglophones étiqueté Company News par brentozar.com