How to Configure Ola Hallengren’s Database Maintenance Scripts for Backups
Someone told you that you should be using Ola Hallengren’s Maintenance Scripts. You’ve downloaded his Maintenance Solution.sql, you […]
Archives de l’année : 2023
[Video] Office Hours: Testing the First Responder Kit
I tested the April release of the FRK, then answered your questions from https://pollgab.com/room/brento. Here’s what we […]
How to Create a SQL Database on a New Drive ...
This article explains different methods to move a SQL database into a new directory of Ubuntu Linux. This […]
Free Webcast Next Week! What’s New (and Actually Good) in ...
It’s May 2023, and believe it or not, some of the flagship features in Microsoft’s latest version still […]
Power BI Embedded – Club Power BI – Mai 2023
Le 4 mai 2023, le Club Power BI de Strasbourg a organisé un nouveau meetup titré « Power […]
SQL Server Management Studio のインストール手順
こんにちは、 SQL Server サポートです。 今回は、日本語版 SQL Server Management Studio (以降 「SSMS」) のインストール手順をご案内します。 ●手順 1. 以下のURLにアクセスします。 // […]
A Technical Journey into API Design-First: Best Practices and Lessons ...
A Technical Journey into API Design-First: Best Practices and Lessons Learned Introduction As software engineers, we all […]
Add a Second NIC for an Availability Group to Separate ...
Introduction Sometimes we face the scenario in an enterprise environment that the database in SQL Server Always On […]
Redgate opens the doors to cross-database DevOps Test Data Management
The post Redgate opens the doors to cross-database DevOps Test Data Management appeared first on SQLServerCentral.
Benefits and Limitations of SCHEMABINDING Views in SQL Server
The post Benefits and Limitations of SCHEMABINDING Views in SQL Server appeared first on SQLServerCentral.
Released: Multiple Microsoft.Data.SqlClient Updates
We have released multiple updates to supported versions of Microsoft.Data.SqlClient in the last couple of months. Just because […]
Early technical preview of JDBC Driver 12.3.0 for SQL Server ...
We have released a new early technical preview of the JDBC Driver for SQL Server which contains several […]
Finding External References in Database Deployments
The post Finding External References in Database Deployments appeared first on SQLServerCentral.
Cheat Sheet for SQL Server DBA Daily Operations
The post Cheat Sheet for SQL Server DBA Daily Operations appeared first on SQLServerCentral.
PostgreSQL Table Import/Export from and to CSV File
Overview In this article, we will cover a very important technique of working with a PostgreSQL table. Let […]
Importing data into a MySQL database using LOAD DATA
Database and development teams often load data from plain text files into their MySQL databases. The files […]
[Video] Office Hours: 25 Pretty Good Questions
You post questions at https://pollgab.com/room/brento and upvote the ones you’d like to see, and my job is to […]
SQL Server et la redondance de zone sur Azure
L’actualité récente nous a encore montré que même un grand nom des acteurs du cloud public n’est pas […]
Classing Up SSMS is as Easy as 1, 2, 3.
Step 1: go into Tools, Options and set this: Step 2, set this: Step 3, check this box: […]
Create an HTML Report on the Status of SQL Server ...
SQL Server jobs are an integral part of any SQL Server environment. These jobs run a predefined set […]
Upgrade SQL Server container with Always On availability groups configured ...
This is a follow-up to my previous blog post I published a while ago titled « Updating SQL Server […]
Happy 21st Anniversary, BrentOzar.com. What’s Coming Next?
It’s pretty cool to look at a blog post and see, “Last updated: 21 years ago.” It’s pretty […]
PostgreSQL Basics: Essential psql Tips and Tricks
Having access to the psql command-line tool is essential for any developers or DBAs that are actively […]
ChatGPT in Visual Studio tutorial
Introduction In this article, we will learn how to work with ChatGPT in Visual Studio. We will install […]
How to Slice Data by Week in a Calendar Table ...
The post How to Slice Data by Week in a Calendar Table using DAX appeared first on SQLServerCentral.
Working with Flyway And Entity Framework Code First: An Overview
The post Working with Flyway And Entity Framework Code First: An Overview appeared first on SQLServerCentral.
How to Automate Cross-Platform Database Development
The post How to Automate Cross-Platform Database Development appeared first on SQLServerCentral.
Using the New Open Source SQLCMD to Create Containers
In my previous article, I looked at the basics of the new, open-source SQLCMD, which is a new […]
Updated First Responder Kit and Consultant Toolkit for April 2023
This month’s big changes are performance tuning in sp_BlitzFirst & sp_BlitzLock. Part of the benefits of using the […]
Capitalize on your investments with the new centrally managed Azure ...
Introducing the new centrally managed Azure Hybrid Benefit for SQL Server. Today, Microsoft is pleased to announce the […]
How to Go Live on SQL Server 2022
You’re planning to migrate to SQL Server 2022, and you want your databases to be faster after the […]
PASS Data Community Summit registration is open!
The post PASS Data Community Summit registration is open! appeared first on SQLServerCentral.
Revolutionizing Real-Time Data Management with SQL Server, Kafka, and Informatica
The field of data engineering involves handling vast amounts of data through processing, transformation, and storage to enable […]
[Video] Office Hours: Live Q&A
This one’s broken up into two parts because I took a bio break mid-stream: 00:00 Start 03:04 Clippy: […]
PostgreSQL Basics: Getting started with psql
PostgreSQL has a separate command-line tool that’s been available for decades and is included with any installation […]
Using Ledger in Azure SQL Database
Transactions have to be protected and you need to know when something is altered or prevent altering […]
Creating a Standalone Executable Python Application
The post Creating a Standalone Executable Python Application appeared first on SQLServerCentral.
A Brief Introduction to PowerShellAI, an Intelligent Command-line
The rising popularity of ChatGPT has led to the development of a PowerShell module called PowerShellAI, which allows […]
Automatically Tracking and Deploying Static Data in Flyway Enterprise
The post Automatically Tracking and Deploying Static Data in Flyway Enterprise appeared first on SQLServerCentral.
What is causing the Always On AG issue? Is it ...
Do any of these questions sound familiar? – My AG fails to failover – Why did my […]
Experimenting with Go-SQLCMD
At a few different conferences in early 2023, I’ve heard Microsoft employees talking about the version of sqlcmd, […]
SQL Prompt Safety Net Features for SSMS: Tab Coloring
The post SQL Prompt Safety Net Features for SSMS: Tab Coloring appeared first on SQLServerCentral.
Extract SharePoint List Data and save to SharePoint Folder as ...
The post Extract SharePoint List Data and save to SharePoint Folder as CSV using Power Automate appeared first […]
One use case for NOT using schema prefixes
I’ve long been a huge advocate for always referencing objects with a schema prefix in SQL Server. […]
What Does Setting the SQL Server Compatibility Level Do?
If you right-click on a database in SQL Server Management Studio, you get an option to set Compatibility […]
イメージのランダム化を強制する(必須ASLR) に「既定でオンにする」を設定した場合、Express Edition の日本語版のインストーラの起動に失敗します
こんにちは。日本マイクロソフト SQL Server サポートチームです。 事象： イメージのランダム化を強制する(必須ASLR) に「既定でオンにする」を設定した場合、SQL Server 2016 ならびにSQL Server 2019 のExpress Edition の日本語版のインストーラ(SQLEXPR_x64_JPN.exe) の起動に失敗します。 なお、イメージのランダム化を強制する(必須ASLR) […]
[Video] Office Hours Speed Round: 21 Answers in 15 Minutes
HONK HONK! It’s time for a fast round of answers to concise questions y’all posted and upvoted at […]
Office Hours Speed Round, Easy Text Answers Edition
Some of the questions y’all post at https://pollgab.com/room/brento have easy one-line answers. Let’s knock ’em out: George: Hi […]
SQL Server でオフライン バックアップおよびオフライン リストアを行うと問題が出ることがある
こんにちは。日本マイクロソフト SQL Server サポートチームです。 公開ドキュメントとして公開されていた内容を、ブログとして掲載します。 現象Microsoft SQL Server で SQL Server のサービスを停止した状態の場合、データベース ファイルをバックアップしたり (オフライン バックアップ)、ファイルを復元する (オフライン […]
SQL Prompt Safety Net Features for SSMS: SQL History
The post SQL Prompt Safety Net Features for SSMS: SQL History appeared first on SQLServerCentral.