Reading and Writing your Database’s Documentation using JSON
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
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
The post Constraints and declarative referential integrity appeared first on SQLServerCentral.
Introducing the PASS Data Community SUMMIT
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
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
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?
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
The post Save the date: PASS Data Community Summit 2021 appeared first on SQLServerCentral.
Creating Deep and Shallow Delta Clones in Azure Databricks
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
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.
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
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
The post Database DevOps: 10 Trends for 2021 appeared first on SQLServerCentral.
Creating Idempotent DDL Scripts for Database Migrations
The post Creating Idempotent DDL Scripts for Database Migrations appeared first on SQLServerCentral.
DBA in training: SQL Server high availability options
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 …