Sites anglophones


A Brief Introduction to PowerShellAI, an Intelligent Command-line

Publié le 24 avril 2023 sur sqlservercentral.com
 

The rising popularity of ChatGPT has led to the development of a PowerShell module called PowerShellAI, which allows users to access ChatGPT via API using scripts rather than a graphical user interface. Developed by Doug Finke, this module simplifies t …

Automatically Tracking and Deploying Static Data in Flyway Enterprise

Publié le 24 avril 2023 sur sqlservercentral.com
 

The post Automatically Tracking and Deploying Static Data in Flyway Enterprise appeared first on SQLServerCentral.

Experimenting with Go-SQLCMD

Publié le 21 avril 2023 sur sqlservercentral.com
 

At a few different conferences in early 2023, I’ve heard Microsoft employees talking about the version of sqlcmd, called go-sqlcmd. I’m not sure why the language it’s written in matters, and I suspect that Microsoft developers are proud of their work, …

SQL Prompt Safety Net Features for SSMS: Tab Coloring

Publié le 21 avril 2023 sur sqlservercentral.com
 

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 CSV using Power Automate

Publié le 21 avril 2023 sur sqlservercentral.com
 

The post Extract SharePoint List Data and save to SharePoint Folder as CSV using Power Automate appeared first on SQLServerCentral.

 

One use case for NOT using schema prefixes

Publié le 20 avril 2023 sur simple-talk.com
 

I’ve long been a huge advocate for always referencing objects with a schema prefix in SQL Server. In spite of what may be a controversial title to many of my regular blog readers, I don’t really want you to stop that practice in most of you …

 

What Does Setting the SQL Server Compatibility Level Do?

Publié le 20 avril 2023 sur brentozar.com
 

If you right-click on a database in SQL Server Management Studio, you get an option to set Compatibility Level at the database level: When you upgrade SQL Server or you want to improve performance, which option should you choose? Should you always go w …

[Video] Office Hours Speed Round: 21 Answers in 15 Minutes

Publié le 19 avril 2023 sur brentozar.com
 

HONK HONK! It’s time for a fast round of answers to concise questions y’all posted and upvoted at https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:19 TheyBlameMe: Hi Brent. What is your view on using Dacpac diff …

Office Hours Speed Round, Easy Text Answers Edition

Publié le 18 avril 2023 sur brentozar.com
 

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 Brent, what recently has been the most challenging/surprising/new-to-you performance issue you have encoun …

SQL Prompt Safety Net Features for SSMS: SQL History

Publié le 17 avril 2023 sur sqlservercentral.com
 

The post SQL Prompt Safety Net Features for SSMS: SQL History appeared first on SQLServerCentral.

Create an Empty Database Using SQL Server Integration Services

Publié le 17 avril 2023 sur sqlservercentral.com
 

Recently, we were working on a small project. The requirement was to create an empty copy of an existing database, meaning the new database could contain only database objects without data. The database was smaller and less complicated, so we completed …

Use DDL Triggers to Automatically Keep SQL Server Views in Sync

Publié le 17 avril 2023 sur sqlservercentral.com
 

The post Use DDL Triggers to Automatically Keep SQL Server Views in Sync appeared first on SQLServerCentral.

Finding and Tuning Expensive Stored Procedures using SQL Monitor

Publié le 14 avril 2023 sur sqlservercentral.com
 

The post Finding and Tuning Expensive Stored Procedures using SQL Monitor appeared first on SQLServerCentral.

Data Oriented Cloud Security Mechanisms

Publié le 14 avril 2023 sur sqlservercentral.com
 

Introduction Cloud Computing escalates the security risks of an organization. This happens because of the extended trust boundary associated with deploying IT assets beyond the data centers of the asset owners. The trust boundary exposes organizations …

Three Use Case Examples for SQL Subqueries

Publié le 14 avril 2023 sur sqlservercentral.com
 

The post Three Use Case Examples for SQL Subqueries appeared first on SQLServerCentral.


Pages :