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 …
9 Signs Your T-SQL Might Fail a Code Review
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
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
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
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 …
PostgreSQL HAVING,LIMIT and FETCH Clauses
Overview In this article, we will cover these PostgreSQL clauses with examples: HAVING, LIMIT and FETCH. In a previous article we discussed the WHERE, ORDER BY and GROUP BY clauses. Click the link if you wish to learn about those clauses. HAVING …