Sites anglophones


Reading and Writing your Database’s Documentation using JSON

Publié le 28 mai 2021 sur sqlservercentral.com
 

One of the problems to which I keep returning is finding the best way to read and apply documentation for databases. As part of a series of articles I’m doing for Redgate’s Product Learning, I’ve been demonstrating how to maintain a single source of da …

SQL Server performance tuning: Nine best practices

Publié le 28 mai 2021 sur simple-talk.com
 

SQL Server is a powerful and feature-rich database management platform that can support a wide range of applications, but if queries are not performing well or workloads are running into deadlocks, latency issues, and other disruptions in service, no o …

Constraints and declarative referential integrity

Publié le 28 mai 2021 sur sqlservercentral.com
 

The post Constraints and declarative referential integrity appeared first on SQLServerCentral.

Introducing the PASS Data Community SUMMIT

Publié le 28 mai 2021 sur sqlservercentral.com
 

The post Introducing the PASS Data Community SUMMIT appeared first on SQLServerCentral.

Real Time data streams from SQL Server using Kafka Connect in the Cloud

Publié le 27 mai 2021 sur sqlservercentral.com
 

Introduction Real-time data has never been more critical as it is today to understand customer needs for the business in a digital world where everything happens at a fast pace. Many organizations have realized in recent days that business reports gene …

Top SQL Queries to Safeguard JIRA

Publié le 27 mai 2021 sur sqlservercentral.com
 

Editor: This is something we might consider if it weren’t written as a series of bullet lists. If you restructure this as a set of problems, remove colons from titles, and get a proofreader to clean up some grammar, we would consider this. Problem Stat …

Do You Have to License Your Standby SQL Server?

Publié le 27 mai 2021 sur brentozar.com
 

Businesses who need high availability and disaster recovery usually want three servers: A primary SQL Server where all the writes & reads take place A high availability SQL Server sitting right next to the primary, in the same data center, keeping …

Save the date: PASS Data Community Summit 2021

Publié le 26 mai 2021 sur sqlservercentral.com
 

The post Save the date: PASS Data Community Summit 2021 appeared first on SQLServerCentral.

Creating Deep and Shallow Delta Clones in Azure Databricks

Publié le 26 mai 2021 sur sqlservercentral.com
 

The post Creating Deep and Shallow Delta Clones in Azure Databricks appeared first on SQLServerCentral.

Free Webcast: Architecture Design for SQL Server High Availability & Disaster Recovery

Publié le 25 mai 2021 sur brentozar.com
 

You’re building a new SQL Server, and you need to protect it. You want to learn when it’s right to use clustering, AlwaysOn Availability Groups, virtualization, or storage replication. You don’t have an unlimited budget, either, so yo …

You Captioned This Pic and Won Free Stuff.

Publié le 24 mai 2021 sur brentozar.com
 

Last week, over 600 of y’all captioned this picture, and we had a lot of laughs: My favorite caption overall was from Aart Bluestoke, who won a Live Class Season Pass for this: The funniest part to me was that I’ve had that exact exper …

Dimensionality Reduction Techniques – PCA, Kernel-PCA and LDA Using Python

Publié le 24 mai 2021 sur sqlservercentral.com
 

Summary In this article, we will be looking at some of the useful techniques on how to reduce dimensionality in our datasets. When we talk about dimensionality,  we are referring to the number of columns in our dataset assuming that we are working …

Database DevOps: 10 Trends for 2021

Publié le 24 mai 2021 sur sqlservercentral.com
 

The post Database DevOps: 10 Trends for 2021 appeared first on SQLServerCentral.

Creating Idempotent DDL Scripts for Database Migrations

Publié le 21 mai 2021 sur sqlservercentral.com
 

The post Creating Idempotent DDL Scripts for Database Migrations appeared first on SQLServerCentral.

DBA in training: SQL Server high availability options

Publié le 19 mai 2021 sur simple-talk.com
 

The series so far: DBA in training: So, you want to be a DBA… DBA in training: Preparing for interviews DBA in training: Know your environment(s) DBA in training: Security DBA in training: Backups, SLAs, and restore strategies DBA in training: Know y …


Pages :