Archives du mois : novembre 2022

FCI failed to do failover because of ReAclDirectory : Failed ...

Customer was trying to apply SQL2014 SP3 in Failover cluster instance. They applied patch to passive node, then […]

30 novembre 2022 dans Sites Microsoft par SQL Server Support Blog

Basic Checks on a New AWS RDS SQL Server
Introduction In this article, we shall imagine that we were just recruited by a new company and handed […]

30 novembre 2022 dans Sites anglophones étiqueté amazon / Amazon RDS / amazon rds instance / AWS / AWS RDS SQL Server / Cloud Computing / RDS par sqlservercentral.com

Webinar | Test Data Management

The post Webinar | Test Data Management appeared first on SQLServerCentral.

30 novembre 2022 dans Sites anglophones étiqueté Conferences, Classes, Events, and Webinars par sqlservercentral.com

Slow “Having” Query? Try Pre-Filtering.
I was helping a client with a query, and I’m going to rework the example to use the […]

29 novembre 2022 dans Sites anglophones étiqueté t-sql par brentozar.com

New In SQL Server 2022 and Azure SQL: XEvent Performance ...
Running Extended Event (XEvent) sessions on SQL Server has a cost. Since XEvents was designed for high-performance, this […]

28 novembre 2022 dans Sites Microsoft par MS Tech Community

Azure KeyVault を用いて AG 環境の暗号化を実施する

こんにちは、 SQL Server サポートです。今回は、 Always On 可用性グループを構成するデータベースを Azure Key Vault を利用し TDE 暗号化する手順についてご紹介します。手順の大まかな流れとしては以下の公開情報の手順を、プライマリ、セカンダリ両方で実施し、同じ非対称キーを用いてTDE暗号化する流れとなります。 Azure […]

28 novembre 2022 dans Sites Microsoft par SQL Server Support Blog

A week in Seattle in 8 Slides at the PASS ...
Being from home for over a week, having a good travel companion is crucial. And with rising data […]

28 novembre 2022 dans Sites anglophones étiqueté Conferences, Classes, Events, and Webinars par sqlservercentral.com

Being Agile – A Success Story
Introduction What is Agile? The definition of Agile varies depending on the perspective of a person. For example, […]

28 novembre 2022 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com

SQL Server at Scale – Using an Archive Table – ...

The post SQL Server at Scale – Using an Archive Table – Part 2 appeared first on SQLServerCentral.

28 novembre 2022 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com

The Curious Case of… community

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post […]

27 novembre 2022 dans Sites anglophones étiqueté General / The Curious Case of... par sqlskills.com - paul randall

Backing Up MySQL Part 5: Backing Up Big Data

According to research made by Statista in 2022, the amount of data that is being worked with […]

26 novembre 2022 dans Sites anglophones étiqueté backups / Blogs / Database / MySQL par simple-talk.com

[Video] Office Hours: Black Friday Edition

My Black Friday sale is in its last days, so most of my time at the moment is spent […]

25 novembre 2022 dans Sites anglophones étiqueté Videos par brentozar.com

Express.js or Next.js for your Backend Project

Backend projects create projects to execute code on a centralized server and then communicate results with a […]

25 novembre 2022 dans Sites anglophones étiqueté Homepage / Javascript par simple-talk.com

Is Azure SQL Database a Good Choice for your Database ...

The post Is Azure SQL Database a Good Choice for your Database Applications? appeared first on SQLServerCentral.

25 novembre 2022 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com

Why bother automating?

The post Why bother automating? appeared first on SQLServerCentral.

25 novembre 2022 dans Sites anglophones étiqueté Conferences, Classes, Events, and Webinars par sqlservercentral.com

Troubleshooting external data and access policies in Azure SQL and ...
The article is published here on the Azure SQL Blog: Troubleshooting external data and access policies in Azure SQL […]

23 novembre 2022 dans Sites Microsoft par MS Tech Community

Contest: Guess the Next SQL Server Release Date

When will Microsoft officially release SQL Server 2023 (or 2024, or whatever it’ll be) for download? The dust […]

23 novembre 2022 dans Sites anglophones étiqueté SQL Server 2023 par brentozar.com

Migrate Azure Analysis Services to Power BI Premium
Power BI has evolved into the leading platform for both self-service and IT-managed enterprise business intelligence. The […]

23 novembre 2022 dans Business Intelligence / Sites anglophones étiqueté AAS / AsAzureRedirection / Azure / Azure - Cloud / AzureAnalysisServices / Excel / finops / LogAnalytics / Power BI / PowerBI / PPU / XMLA par www.pulsweb.fr

Using SQL Backup in Development Work

The post Using SQL Backup in Development Work appeared first on SQLServerCentral.

23 novembre 2022 dans Sites anglophones étiqueté Vendors/3rd-party Products par sqlservercentral.com

Are You Underpaid? Let’s Find Out: The 7th Annual Data ...
Whew. This is a crazy time, isn’t it? The aftermath of the pandemic is kicking in, and there […]

22 novembre 2022 dans Sites anglophones étiqueté Salary par brentozar.com

Backing up MySQL Part 4: mydumper

There are many tools we can use to back up our MySQL databases. Some are well-known and […]

22 novembre 2022 dans Sites anglophones étiqueté backups / Blogs / Database / MySQL / Software Tools par simple-talk.com

Converting Data Across Time Zones: An In-Depth Primer

If only the entire world used UTC, wouldn’t life be so much easier? We can dream, can’t […]

21 novembre 2022 dans Sites anglophones étiqueté Homepage / T-SQL Programming par simple-talk.com

SQL Server 2022: Azure AD Authentication

SQL Server 2022 is finally GA and one of the features I was most expecting is finally […]

21 novembre 2022 dans Sites anglophones étiqueté Azure / Azure Active Directory / Blogs / SQL Server 2022 par simple-talk.com

Microsoft lance officiellement SQL Server 2022

La déclinaison 2022 du SGBD de Microsoft, SQL Server, passe en mode GA (disponibilité générale). La firme de […]

21 novembre 2022 dans Sites francophones par lemondeinformatique.fr

Looking Back at the 2022 #PASSDataCommunitySummit in Seattle
I’m back home in Vegas, back down to Inbox Zero, and I’ve had some time to think about […]

21 novembre 2022 dans Sites anglophones étiqueté #SQLPass par brentozar.com

SQL Server 2022 se convertit au cloud hybride

21 novembre 2022 dans Sites francophones par lemagit.fr

New Flyway Course on Redgate University

The post New Flyway Course on Redgate University appeared first on SQLServerCentral.

21 novembre 2022 dans Sites anglophones étiqueté Conferences, Classes, Events, and Webinars par sqlservercentral.com

Amazon RDS – Configuring a Connection to a SQL Server ...
Introduction In a previous article, we explored the factors worth considering when deploying a database in the public […]

21 novembre 2022 dans Sites anglophones étiqueté Amazon RDS / amazon rds instance / AWS / cloud / Cloud Computing / cloud database / Data / Database / RDS SQL Server / relational database service par sqlservercentral.com

An Introduction to SQL Triggers

The post An Introduction to SQL Triggers appeared first on SQLServerCentral.

21 novembre 2022 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com

Installations rapides

Si comme moi vous déployez fréquemment des instances SQL Server pour des tests divers et que vous êtes […]

20 novembre 2022 dans Sites francophones par blog.datafly.pro

Backing up MySQL Part 3: mysqlpump

In the MySQL world, there are a couple of ways to take backups of your data. Backups […]

19 novembre 2022 dans Sites anglophones étiqueté backups / Blogs / Database / MySQL / Software Tools par simple-talk.com

#PASSdataCommunitySummit Keynote Day 3 Live Blog
Today at the PASS Data Community Summit in Seattle, Kimberly Tripp is doing the first-ever in-person community keynote. […]

18 novembre 2022 dans Sites anglophones étiqueté SQL Server par brentozar.com

Retrouvez la version d'origine

Savez-vous que les fichiers de données ou de sauvegarde de SQL Server embarquent l’information sur la version d’origine […]

18 novembre 2022 dans Sites francophones par blog.datafly.pro

Try Before You Commit in Flyway

The post Try Before You Commit in Flyway appeared first on SQLServerCentral.

18 novembre 2022 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com

How to get IO statistics of SQL Server database files
SQL Server is a resource-intensive database system that requires adequate CPU and memory capacity to run transactions with […]

18 novembre 2022 dans Sites anglophones étiqueté DMV / t-sql / Transact SQL par sqlservercentral.com

Microsoft publie SQL Server 2022 avec de nouvelles fonctionnalités pour ...

Microsoft publie SQL Server 2022 avec de nouvelles fonctionnalités pour Azure et des améliorations de performances l’entreprise […]

17 novembre 2022 dans Sites francophones par sgbd.developpez.com

#PASSdataCommunitySummit Keynote Day 2 Live Blog
I’m in Seattle for the PASS Data Community Summit, and the day 2 keynote is about to start. […]

17 novembre 2022 dans Sites anglophones étiqueté #SQLPass par brentozar.com

Manage, govern, and secure all your SQL Servers with new ...
Part of the SQL Server 2022 blog series. In the face of changing market conditions and pressure to accelerate […]

17 novembre 2022 dans Sites Microsoft étiqueté SQL Server 2022 / SQL Server 2022 Blogging Series par SQL Server Blog

SQL Server 2022 Paid Editions Require a Licensing Key.
For the final release of SQL Server 2022, Microsoft popped a surprise that wasn’t in the release candidates: […]

17 novembre 2022 dans Sites anglophones étiqueté SQL Server 2022 par brentozar.com

SQL Server がインストール済みのAzure VM をデプロイする際、サーバーの照合順序を変更すると、デプロイに失敗する場合があります
こんにちは。日本マイクロソフト SQL Server サポートチームです。 SQL Server がインストール済みのAzure VM をデプロイする際、サーバーの照合順序を変更することができます。しかし、サーバーの照合順序を変更してデプロイした場合、デプロイに失敗することがあります。今回は、デプロイに失敗する原因と対処について説明します。また、デプロイする際にサーバーの照合順序を変更する必要がない場合があるため、デプロイする前にご確認いただきたいこととして、まとめました。なお、このブログの内容は2022 年 11 月時点の情報となります。本件については、既知の問題として認識しており対応を検討しておりますため、対応に進捗がある場合には、こちらも更新します。 ●対象の画面　SQL Server […]

17 novembre 2022 dans Sites Microsoft par SQL Server Support Blog

SQL Server 2022 est disponible

Le 16 novembre 2022 au matin (Pacific Time), et donc ce soir ici : c’est la sortie officielle […]

16 novembre 2022 dans Sites francophones par blog.datafly.pro

Backing Up MySQL Part 2: Percona XtraBackup

There’s no doubt about it – if you’ve ever heard of Percona, you’ve heard of XtraBackup as […]

16 novembre 2022 dans Sites anglophones étiqueté backups / Blogs / Database / MySQL / Percona / XtraBackup par simple-talk.com

Azure Data Studio November release
In this release of Azure Data Studio, we have exciting news to share across several of our core […]

16 novembre 2022 dans Sites Microsoft étiqueté Uncategorized par SQL Server Blog

New SQL Server on Azure Virtual Machines and Azure SQL ...
Customers who are running their SQL Server workloads using SQL Server on Azure Virtual Machines and Azure SQL […]

16 novembre 2022 dans Sites Microsoft étiqueté SQL Server on Azure Virtual Machines / Uncategorized par SQL Server Blog

SQL Server 2022 Release Date: November 16, 2022

Microsoft released SQL Server 2022 today, November 16, 2022. The footnotes indicate: SQL Server 2022 free editions (Developer […]

16 novembre 2022 dans Sites anglophones étiqueté SQL Server 2022 par brentozar.com

Manage, secure, and govern your SQL Server estate from Azure
Overview Our learnings from talking to several enterprise customers is that businesses are leveraging hybrid and multi-cloud approaches […]

16 novembre 2022 dans Sites Microsoft par MS Tech Community

SQL Server 2022 is now generally available
Part of theSQL Server 2022 blog series. Today, we announced the general availability of SQL Server 2022, the […]

16 novembre 2022 dans Sites Microsoft étiqueté Announcements / Customer Stories / Events / Featured / SQL Server 2022 / SQL Server 2022 Blogging Series par SQL Server Blog

Link feature for Azure SQL Managed Instance: Connecting SQL Server ...
Part of theSQL Server 2022 blog series. We are excited to announce general availability (GA) of the link […]

16 novembre 2022 dans Sites Microsoft étiqueté SQL Server 2022 Blogging Series / Uncategorized par SQL Server Blog

Azure SQL Database External REST Endpoints Integration Public Preview
The ability to call a REST endpoint natively from Azure SQL Database, which was made available via […]

16 novembre 2022 dans Sites Microsoft par devblogs.microsoft.com

Join #TeamHugo and Help Fight Leukemia.
If you’ve been reading this blog for a while or subscribed to my email newsletters, you’ve learned something […]

16 novembre 2022 dans Sites anglophones étiqueté #SQLPass par brentozar.com