Sites anglophones


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 …

9 Signs Your T-SQL Might Fail a Code Review

Publié le 19 mai 2021 sur brentozar.com
 

It’s hard to set absolute rules about, “Feature X should absolutely never be used.” However, there are some features that set off alarm bells when I see them. Usually, when I start asking more questions about when we’re using th …

Hidden Pitfalls with INNER JOIN and NOT IN Operators

Publié le 19 mai 2021 sur sqlservercentral.com
 

I want to show you how two common operators can deceive you into believing you have constructed a proper SQL statement for your solution. We may want to filter results in a table by using using a IN/NOT IN or a INNER JOIN/LEFT JOIN to another table. Th …

Measuring Team Performance: Calculate LeadTime metric using JIRA and GitHub data

Publié le 19 mai 2021 sur sqlservercentral.com
 

The post Measuring Team Performance: Calculate LeadTime metric using JIRA and GitHub data appeared first on SQLServerCentral.

Contest: My Favorite Caption Wins a Live Class Season Pass

Publié le 17 mai 2021 sur brentozar.com
 

Let’s have a few laughs this week. In the comments, write a caption for this: Prizes: My favorite caption overall wins a Live Class Season Pass Runners-up get both a Recorded Class Season Pass: Mastering Classes and Recorded Class Season Pass: Fu …


Pages :