Sites anglophones


SQL Server Backup Monitoring with PowerShell

Publié le 24 juillet 2020 sur sqlservercentral.com
 

The post SQL Server Backup Monitoring with PowerShell appeared first on SQLServerCentral.

Basic Git for DBAs: Merging Code Between Branches

Publié le 23 juillet 2020 sur sqlservercentral.com
 

This is the fifth article in a series on the basics of using Git. The other articles in the series are: Basic Git for DBAs: Getting Started with Git Basic Git for DBAs: Sharing Files Through GitHub Basic Git for DBAs: the Basics of Branches Basic Git f …

SQL Server MSDB Database Tutorial

Publié le 23 juillet 2020 sur sqlservercentral.com
 

The post SQL Server MSDB Database Tutorial appeared first on SQLServerCentral.

Storage 101: Data Security and Privacy

Publié le 22 juillet 2020 sur simple-talk.com
 

The series so far: Storage 101: Welcome to the Wonderful World of Storage Storage 101: The Language of Storage Storage 101: Understanding the Hard-Disk Drive  Storage 101: Understanding the NAND Flash Solid State Drive Storage 101: Data Cente …

How to Install Azure Data Studio to Work with SQL Server

Publié le 22 juillet 2020 sur brentozar.com
 

(intro will go here) Download Azure Data Studio on your desktop. Do this on your desktop, not the SQL Server itself. You always want to run management tools from your own machine to reduce the overhead on the SQL Server itself. After it downloads, inst …

Automate Database Restore for SQL Server

Publié le 22 juillet 2020 sur sqlservercentral.com
 

The post Automate Database Restore for SQL Server appeared first on SQLServerCentral.

How to Get Started with SQL Server Management Studio

Publié le 21 juillet 2020 sur brentozar.com
 

In the big picture, you need to: Download the free Microsoft SQL Server Management Studio and install it, accepting the defaults Connect to your SQL Server Create a low-privileged login so that you don’t accidentally drop objects Learn to switch …

Hands-On with Columnstore Indexes: Part 3 Maintenance and Additional Options

Publié le 21 juillet 2020 sur simple-talk.com
 

The series so far: Hands-On with Columnstore Indexes: Part 1 Architecture Hands-On with Columnstore Indexes: Part 2 Best Practices and Guidelines Hands-On with Columnstore Indexes: Part 3 Maintenance and Additional Options Like other indexes, columnsto …

TDE BYOK and Geo-Replication in Azure SQL DB

Publié le 21 juillet 2020 sur sqlservercentral.com
 

Recently a customer asked me for help with setting up a test of an Azure SQL Database in the single database tier with Geo-Replication to work with Transparent Data Encryption (TDE) with a customer-managed key, also known as Bring Your Own Key (BYOK). …

Announcing Saturday & Sunday Office Hours.

Publié le 20 juillet 2020 sur brentozar.com
 

During the quarantines, I’m doing free training. It looks like we’re going to be stuck inside here for another long while, so for the next couple of months, I’m bringing back Office Hours, but on a different schedule. Every Saturday …

Getting Started with GitFlow

Publié le 20 juillet 2020 sur sqlservercentral.com
 

The post Getting Started with GitFlow appeared first on SQLServerCentral.

Power BI Incremental Refresh for SQL Sources

Publié le 20 juillet 2020 sur sqlservercentral.com
 

The post Power BI Incremental Refresh for SQL Sources appeared first on SQLServerCentral.

Loading data in Azure Synapse Analytics using Azure Data Factory

Publié le 20 juillet 2020 sur sqlservercentral.com
 

Introduction In my last article, Loading data in Azure Synapse using Copy, I discussed about loading data in the SQL Pool of Azure Synapse Analytics using the COPY command. Here, I will discuss the step-by-step process for data loading in the SQL Pool …

6 New Courses Published on the Redgate University

Publié le 17 juillet 2020 sur sqlservercentral.com
 

The post 6 New Courses Published on the Redgate University appeared first on SQLServerCentral.

Unable to connect SSIS remotely

Publié le 16 juillet 2020 sur sqlservercentral.com
 

I was working with one of my client queries and they were having issue while connecting to SSIS on the database server, SQL1, from the application server, APP1. They were getting the below error message: Connecting to the Integration Services service o …


Pages :