Think Marathon, not Sprint
DevOps is a journey, not a project. Today Steve reminds us that while we want to work across time and constantly improve, we also need some urgency. A marathon is the balance.
A Programmer’s Guide to Flyway Configuration
Phil Factor offers a programmer's guide to Flyway's configuration settings, explaining the different categories of parameters, the role of each of parameter within each category, and how to exploit Flyway's multi-level configuration file system.
Deep SQL Query Optimization with SQL Grease
Learn how to conduct deep SQL Query optimization with SQL Grease with the Enterprise dashboard, historical data, troubleshooting SQL Server Wait Stats, capturing anomalies and intelligent notifications.
Making Video Chat Better
Video chat is how many of us see our colleagues every week. It's not a great system, but maybe it can get better.
PostgreSQL in Azure Data Studio
Learn how to install PostgreSQL and using Azure Data Studio to work with it.
7 Trends in DB DevOps & Monitoring: The infographic
Earlier this year, we surveyed 5,700 global IT professionals and found out what the most pressing issues in DevOps and monitoring were. Read the round up in our infographic.
Creating a Database and Tables in PostgreSQL: Learning PostgreSQL with Grant
The syntax for creating databases and tables in PostgreSQL is similar to other RDBMS. In this article, Grant Fritchey shows how to create databases and tables.
Model Good Behavior
I'm answering a question in the forums and I spot something that crawls up my spine: ;WITH... The person was using a Common Table Expression (CTE) which requires that the preceding statement in the batch have a statement terminator, the semi-colon. However, since the terminator isn't required everywhere, lots of people don't use it at […]
Are You a Good Engineer?
A thread about what it takes to be a good engineer has Steve commenting on those characteristics that are important to him.
Debugging Flyway Callbacks and Migrations that Use Placeholders
Placeholders come in very handy in Flyway, but troubleshooting the SQL migration and callback scripts that use them can be tricky. This articles demonstrates how to develop, test and debug these scripts in a tool designed for these tasks, such as SSMS, leaving Flyway to do what it's designed for, which is running the scripts.
Blogs
Master the Foundational Basics
By Brian Kelley
It tells us to take the time to master the foundational basics of whatever...
Simple Talks Episode 9–Data masking and subsetting
By Steve Jones
The episode on data masking and subetting is out. You can see it here:...
T-SQL Tuesday #180: Avoid Perfect for Good Enough
By Brian Kelley
I'm listening to Effortless by Greg McKeon (link to author's page) through Audible.com. He...
Forums
ssrs order of operation question
hi i need "sample size" in my report's 4th data region which is a...
Query Network Protocols from T-SQL or PowerShell
Hello experts, I want to be more organized about the SSL certificates we have...
Occasional Sql Server 2019 slowness (upgraded from 2014) -- please help...
Hi everyone, We recently upgraded our server to Sql Server 2019 (15.0.2125.1 (X64) on...
Question of the Day
The Hash Join I
What are the two inputs called to a hash join operation in SQL Server? (choose 2)
See possible answers