Sites anglophones


How to Create a SQL Database on a New Drive in Ubuntu

Publié le 10 mai 2023 sur sqlservercentral.com
 

This article explains different methods to move a SQL database into a new directory of Ubuntu Linux. This article covers the following topics. How to install SQL Server 2022 on Ubuntu Linux. How to add a new drive in Linux. Attach the StackOverflow dat …

Free Webcast Next Week! What’s New (and Actually Good) in SQL Server 2022

Publié le 9 mai 2023 sur brentozar.com
 

It’s May 2023, and believe it or not, some of the flagship features in Microsoft’s latest version still aren’t ready for prime time yet. Good news, though: there are a few things that genuinely make your life easier with minimal work …

Add a Second NIC for an Availability Group to Separate Network Traffic

Publié le 8 mai 2023 sur sqlservercentral.com
 

Introduction Sometimes we face the scenario in an enterprise environment that the database in SQL Server Always On Availability Group (AOAG) has high concurrency read and write access from application servers. If we keep using the one network interface …

Redgate opens the doors to cross-database DevOps Test Data Management

Publié le 8 mai 2023 sur sqlservercentral.com
 

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

Publié le 8 mai 2023 sur sqlservercentral.com
 

The post Benefits and Limitations of SCHEMABINDING Views in SQL Server appeared first on SQLServerCentral.

Finding External References in Database Deployments

Publié le 5 mai 2023 sur sqlservercentral.com
 

The post Finding External References in Database Deployments appeared first on SQLServerCentral.

Cheat Sheet for SQL Server DBA Daily Operations

Publié le 5 mai 2023 sur sqlservercentral.com
 

The post Cheat Sheet for SQL Server DBA Daily Operations appeared first on SQLServerCentral.

PostgreSQL Table Import/Export from and to CSV File

Publié le 5 mai 2023 sur sqlservercentral.com
 

Overview In this article, we will cover a very important technique of working with a PostgreSQL table. Let us take a look at the topics we will cover in this article: Export table to CSV file. Import CSV file into table The only prerequisite for this a …

 

Importing data into a MySQL database using LOAD DATA

Publié le 4 mai 2023 sur simple-talk.com
 

Database and development teams often load data from plain text files into their MySQL databases. The files might be used to add lookup data, support test and development environments, populate new MySQL instances, load data from regular feeds, or in ot …

 

[Video] Office Hours: 25 Pretty Good Questions

Publié le 4 mai 2023 sur brentozar.com
 

You post questions at https://pollgab.com/room/brento and upvote the ones you’d like to see, and my job is to come up with accurate answers on the fly. Let’s see how I did. Here’s what we discussed: 00:00 Start 03:25 SickOf: Brent is …

Classing Up SSMS is as Easy as 1, 2, 3.

Publié le 3 mai 2023 sur brentozar.com
 

Step 1: go into Tools, Options and set this: Step 2, set this: Step 3, check this box: And presto, no one will ever again question whether or not you know what you’re doing.

Create an HTML Report on the Status of SQL Server Agent Jobs

Publié le 3 mai 2023 sur sqlservercentral.com
 

SQL Server jobs are an integral part of any SQL Server environment. These jobs run a predefined set of tasks and commands at specified intervals, ensuring the database is up-to-date and performing optimally. As a database administrator, it is essential …

Happy 21st Anniversary, BrentOzar.com. What’s Coming Next?

Publié le 1 mai 2023 sur brentozar.com
 

It’s pretty cool to look at a blog post and see, “Last updated: 21 years ago.” It’s pretty fun to see old pictures of me in the media library, too. When I first started blogging over two decades ago, it wasn’t a business. …

 

PostgreSQL Basics: Essential psql Tips and Tricks

Publié le 1 mai 2023 sur simple-talk.com
 

Having access to the psql command-line tool is essential for any developers or DBAs that are actively working with and connecting to PostgreSQL databases. In our first article, we discussed the brief history of psql and demonstrated how to install it o …

 

ChatGPT in Visual Studio tutorial

Publié le 1 mai 2023 sur sqlservercentral.com
 

Introduction In this article, we will learn how to work with ChatGPT in Visual Studio. We will install and use an extension in a SQL Server Database Project. Requirements First, we need to have SQL Server installed. Secondly, we need to have Adventurew …


Pages :