Try Before You Commit in Flyway
The post Try Before You Commit in Flyway appeared first on SQLServerCentral.
Archives de l’année : 2022
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 […]
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 […]
#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. […]
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 […]
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: […]
SQL Server がインストール済みのAzure VM をデプロイする際、サーバーの照合順序を変更すると、デプロイに失敗する場合があります
こんにちは。日本マイクロソフト SQL Server サポートチームです。 SQL Server がインストール済みのAzure VM をデプロイする際、サーバーの照合順序を変更することができます。しかし、サーバーの照合順序を変更してデプロイした場合、デプロイに失敗することがあります。 今回は、デプロイに失敗する原因と対処について説明します。また、デプロイする際にサーバーの照合順序を変更する必要がない場合があるため、デプロイする前にご確認いただきたいこととして、まとめました。なお、このブログの内容は2022 年 11 月時点の情報となります。本件については、既知の問題として認識しており対応を検討しておりますため、対応に進捗がある場合には、こちらも更新します。 ●対象の画面 SQL Server […]
SQL Server 2022 est disponible
Le 16 novembre 2022 au matin (Pacific Time), et donc ce soir ici : c’est la sortie officielle […]
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 […]
Azure Data Studio November release
In this release of Azure Data Studio, we have exciting news to share across several of our core […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
#PASSdataCommunitySummit Keynote Day 1 Live Blog
I’m in Seattle for the biggest annual gathering of Microsoft data platform professionals, the PASS Data Community Summit. […]
Flyway Enterprise is here…
The post Flyway Enterprise is here… appeared first on SQLServerCentral.
SQL LIKE Statement for Various Text Patterns
The post SQL LIKE Statement for Various Text Patterns appeared first on SQLServerCentral.
Report Server Temporary database configuration with Always on Availability groups ...
Report Server uses Report Server Temporary database to store session and execution data, information related to cached reports. […]
How monitoring tools can help you excel at your job
The post How monitoring tools can help you excel at your job appeared first on SQLServerCentral.
Build Your Own SQL Server Central Monitoring Solution with PowerShell
The post Build Your Own SQL Server Central Monitoring Solution with PowerShell appeared first on SQLServerCentral.
Tutorial to Create a Power BI Report Using PostgreSQL
Introduction The current article will show how to create a Power BI report using PostgreSQL data. This article […]
Introducing the MySQL DELETE statement
Preparing your MySQL environment As with the previous few articles, I used the same database and tables […]
Office Hours: Read This, Watch This Edition
This week, a lot of the questions you posted at https://pollgab.com/room/brento just need pointers to resources at other […]
Released: Microsoft.Data.SqlClient 5.1 Preview 2
Microsoft.Data.SqlClient 5.1 Preview 2 has been released. This release contains improvements and updates to the Microsoft.Data.SqlClient data provider […]
The Art of Data Ingestion – Part 1
Data movement is a fundamental piece of a data engineer’s duties, and recently I’ve been thinking about the […]
Refresh a Power BI Dataset using Microsoft Power Automate
The post Refresh a Power BI Dataset using Microsoft Power Automate appeared first on SQLServerCentral.
Optimizing MySQL: The Basics of Query Optimization
MySQL is a very interesting beast to deal with – both junior developers and expert database administrators […]
Optimum performance for your data with SQL Server 2022
Dell, HPE, Lenovo, and Supermicro, amongst other Server OEMs, announced availability today of new systems running on AMD EPYC™ […]
[Video] Office Hours: Sponsored By Black Friday Edition
Y’all post questions at https://pollgab.com/room/brento, upvote the ones you’d like to see me cover, and then I talk […]
Women as Tech Leads – Tackling the Challenges at the ...
The WIT Luncheon has been a tradition at the Summit since 2008. It happens during lunch on Thursday […]
Azure Data Studio and BDC Retirement
In February of this year, retirement of SQL Server 2019 Big Data Clusters Add-On was announced (Big data […]
PASS Data Community Summit 2022 keynote: Transform your data estate ...
I look forward to seeing you at PASS Data Community Summit, a conference curated for the Microsoft data […]
.NET 7 is Available Today
Download .NET 7 today! .NET 7 brings your apps increased performance and new features for C# 11/F# […]
Entity Framework Core 7 (EF7) is available today
Entity Framework Core (EF Core) 7 is available on NuGet today! EF Core 7 is the successor […]
[Video] Office Hours: Surprise Edition
Y’all post questions at https://pollgab.com/room/brento, upvote the ones you’d like to see me cover, and then I talk […]
The Basics of Deleting Data from a SQL Server Table
Greg Larsen’s series on Learning T-SQL so far: The basic T-SQL Select Statement Ordering a result set […]
Connecting the Dots of Azure SQL CICD Part 2: Local ...
Join us for part two of our Azure SQL database change management (CICD) series. This post covers […]
SQL Server Indexes to Improve Query Performance
The post SQL Server Indexes to Improve Query Performance appeared first on SQLServerCentral.
MDX in Power BI tutorial
Introduction MDX in Power BI will help us to extract part of the information from multidimensional cubes in […]
Meetup du Club Power BI de Strasbourg, novembre 2022
Le 2 novembre 2022, le Club Power BI de Strasbourg a organisé un nouveau Meetup titré « Allons […]
How to Use Any SQL Database in GO with GORM
Object Relational Mapping is a database abstraction technique that aids developers in manipulating and interacting with SQL […]
Take the SQL Server Mac challenge
When I graduated from college, one of the first computers I ever used was a MacIntosh. I loved […]
Early technical preview of JDBC Driver 12.1.0 for SQL Server ...
We have released a new early technical preview of the JDBC Driver for SQL Server which contains several […]
Join a community like no other at Summit
The post Join a community like no other at Summit appeared first on SQLServerCentral.
Leveraging the Script Activity within Azure Data Factory
The post Leveraging the Script Activity within Azure Data Factory appeared first on SQLServerCentral.
Cassandra Springboot Integration
Article Overview In this article, we will learn how to integrate a Spring boot application with a Cassandra […]
Update: ODBC Driver 18.1.2 for SQL Server Released
Version 18.1.2 of the Microsoft ODBC Driver 17 for SQL Server has been released. Version 18.1.2 brings a few […]