Sites anglophones


Bulk Formatting of the SQL Server SQL Files

Publié le 18 mars 2022 sur sqlservercentral.com
 

The post Bulk Formatting of the SQL Server SQL Files appeared first on SQLServerCentral.

Monitoring Azure SQL Databases

Publié le 18 mars 2022 sur sqlservercentral.com
 

There are many reasons you should monitor your databases, including avoiding performance problems or running out of disk space. Ideally, you want a scalable monitoring solution where you can monitor all your SQL databases in one single place. This arti …

The effects of NULL with NOT IN on Oracle transformations

Publié le 18 mars 2022 sur sqlservercentral.com
 

The post The effects of NULL with NOT IN on Oracle transformations appeared first on SQLServerCentral.

[Video] Office Hours: Morning in Mexico Edition

Publié le 16 mars 2022 sur brentozar.com
 

Got SQL Server questions? Post ’em at https://pollgab.com/room/brento and upvote the questions you’d like to see me discuss. Here’s what we covered this morning: 00:00 Introductions 00:45 SQL Simian: Everybody loves free advice, but w …

Prevent Accidental Resource Deletion Using Locks in Azure Data Factory

Publié le 16 mars 2022 sur sqlservercentral.com
 

Introduction While working in Azure Data Factory a user can delete a resource unknowingly. We can implement Azure Locks to prevent this accidental resource deletion. You can create your own custom roles to give users read-only access to the Azure Data …

The basic T-SQL SELECT statement

Publié le 16 mars 2022 sur sqlservercentral.com
 

The post The basic T-SQL SELECT statement appeared first on SQLServerCentral.

Summit 2022 Call for Speakers Now Open

Publié le 16 mars 2022 sur sqlservercentral.com
 

The post Summit 2022 Call for Speakers Now Open appeared first on SQLServerCentral.

Announcing Quest Database Training Days 2022

Publié le 15 mars 2022 sur brentozar.com
 

Wanna learn for free? On April 13, I’m doing a session called My Cloud Database Costs are Too High. You’ve moved to the cloud, and now management is asking questions about your monthly bills. They’ve asked you to cut costs. Now what? …

New Lower Prices on My Mastering Class Recordings and End-of-Year Live Class Season Pass

Publié le 14 mars 2022 sur brentozar.com
 

If you’ve been watching my Instagram feed or any of my recent Office Hours videos, you’ve noticed that I’ve moved down to Cabo San Lucas, Mexico. I’m absolutely loving it, having a great time watching whales, sitting on the …

DBAs and DevOps: A match made in heaven?

Publié le 14 mars 2022 sur sqlservercentral.com
 

The post DBAs and DevOps: A match made in heaven? appeared first on SQLServerCentral.

What’s new in SQL Monitor? Tagging and Current Activity Page (minor release v12.1)

Publié le 14 mars 2022 sur sqlservercentral.com
 

The post What’s new in SQL Monitor? Tagging and Current Activity Page (minor release v12.1) appeared first on SQLServerCentral.

Query History and Server Reports in Azure Data Studio

Publié le 14 mars 2022 sur sqlservercentral.com
 

Introduction Query history and server reports are two popular extensions in Azure Data Studio. In this article, we will cover these extensions. Firstly, the Query History extension allows having the history of the queries executed. Secondly, the Server …

Populate a SQL Server column with a sequential number not using an identity

Publié le 11 mars 2022 sur sqlservercentral.com
 

The post Populate a SQL Server column with a sequential number not using an identity appeared first on SQLServerCentral.

Exploring Knowledge Center in Azure Synapse Analytics

Publié le 11 mars 2022 sur sqlservercentral.com
 

Introduction Azure Synapse Analytics is an enterprise analytics service that brings together popular data warehouse technologies and big data systems together. It provides SQL for enterprise data warehousing, Spark technologies for big data, Data explo …

SQL Prompt ALT S Magic

Publié le 11 mars 2022 sur sqlservercentral.com
 

The post SQL Prompt ALT S Magic appeared first on SQLServerCentral.


Pages :