Sites anglophones


 

Undo Human Errors in SQL Server – SQL in Sixty Seconds #109 – Point in Time Restore

Publié le 25 août 2020 sur journey to sqlauthority
 

In this blog post, we are going to talk about how to undo human errors in SQL Server with the help of Point in Time Recovery. Let me start asking some questions –Have you ever dropped your table by mistake?Have you ever wrote an UPDATE statement …

 

Configuring Availability Groups in Ubuntu

Publié le 25 août 2020 sur sqlservercentral.com
 

In this article, we will review how to configure Always On Availability Groups in Ubuntu Server using the Pacemaker cluster. The following are the high-level steps to configure Always On Availability Groups (AOAG) with an Ubuntu server. Install SQ …

Subset in R including List, Data Frame, Matrix and Vector

Publié le 25 août 2020 sur sqlservercentral.com
 

The post Subset in R including List, Data Frame, Matrix and Vector appeared first on SQLServerCentral.

The Curious Case of… setting up a server for DBCC CHECKDB

Publié le 24 août 2020 sur sqlskills.com - paul randall
 

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working …

 

Solve Puzzle about Data type – SQL in Sixty Seconds #108

Publié le 24 août 2020 sur journey to sqlauthority
 

A very interesting puzzle, where you see the data type conversion in action. I have previously blogged about this puzzle and had received amazing feedback about it. Lots of people realize that they do not know why this particular behaviour is happening …

 

Deployment Suite for Oracle: What’s New? Git Integration in Redgate Change Control v3.0

Publié le 24 août 2020 sur sqlservercentral.com
 

The post Deployment Suite for Oracle: What’s New? Git Integration in Redgate Change Control v3.0 appeared first on SQLServerCentral.

An Introduction to Azure Synapse Analytics Workspace

Publié le 24 août 2020 sur sqlservercentral.com
 

Introduction The Azure Synapse workspace is in preview mode as of July 2020. The workspace brings together enterprise data warehousing and big data analytics. This workspace has the best of the SQL technologies used in enterprise data warehousing, Spar …

 

How to Insert Multiple Values into Multiple Tables in a Single Statement? – Interview Question of the Week #290

Publié le 23 août 2020 sur journey to sqlauthority
 

Question: How to Insert Multiple Values into Multiple Tables in a Single Statement?Answer: One of the most popular questions, I often receive from my client  Comprehensive Database Performance Health Check. I often see people implementing trigger …

 

 

Move TempDB for Performance – SQL in Sixty Seconds #107

Publié le 22 août 2020 sur journey to sqlauthority
 

Just another day while working with a client Comprehensive Database Performance Health Check, we figured out that they had slow overall performance because they had TempDB located on the slow drive. Today we will learn how we can move TempDB for Perfor …

 

 

Storage 101: The Future of Storage

Publié le 21 août 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 …

 

 

Do MAX(col) Scan Table? – SQL in Sixty Seconds #106

Publié le 21 août 2020 sur journey to sqlauthority
 

Query tuning and optimization is my favourite thing when I am working on a Comprehensive Database Performance Health Check. The other day while working with a client, I realized that they have a query where they are using an aggregate function like MIN …

 

Compare Artificial Intelligence Models Built with T-SQL

Publié le 21 août 2020 sur sqlservercentral.com
 

The post Compare Artificial Intelligence Models Built with T-SQL appeared first on SQLServerCentral.

The Mentoring Class of 2020

Publié le 20 août 2020 sur sqlskills.com - paul randall
 

Since my first round of community mentoring back in 2015, when I mentored 54 people for six months, I’ve been asked periodically whether I’d do it again. My answer was always something like ‘maybe – it was a lot of work’ a …

Half Of You Don’t Understand Variables and Transactions.

Publié le 20 août 2020 sur brentozar.com
 

Do table variables and variables respect transactions? If I set the value of a variable during a transaction, and I roll it back, what happens?DECLARE @MySalary INT = 100000; BEGIN TRAN SET @MySalary = @MySalary * 2; ROLLBACK; SELECT @MySalary; I polle …

 

Rollback TRUNCATE – Script – SQL in Sixty Seconds #105

Publié le 20 août 2020 sur journey to sqlauthority
 

One of the most popular questions, I keep on receiving is that – Is it possible to Rollback Truncate operation? The answer is YES, let me explain the entire process with example and video.Let me confess first that when I started my career with SQ …

 


Pages :