The Subtle Differences Between COALESCE and ISNULL
See how ISNULL and COALESCE behave in different situations and ensure you know which one to pick when.
Upgrading Your OS
Windows 7 support is ending, but Microsoft doesn't have a good plan for home users. Steve notes that the OS upgrade treadmill ought to come to an end soon.
The State of the Database Landscape in 2025: Insights and trends
How are you navigating the database landscape? Our latest report sheds light on the current state of database management and offers valuable insights into how organizations can navigate and simplify the growing complexities of the database landscape.
Using the Default Trace in SQL Server
I have heard of the default trace in SQL Server. I know it’s on by default, but I don’t know how to use it. What can I do with the default trace?
Database First or Application First
Today Steve is wondering how you approach coordinating application and database changes. Share which one you deploy first.
Metadata Driven Pipelines (Full Load): The Fabric Modern Data Platform
Learn how you can create a full data load process in Fabric.
Securing the DevOps Pipeline Part 1: Tools and Strategies for Safer Deployments
DevOps has transformed software delivery, but with rapid deployments come increased security risks. As a DevOps engineer, I’ve seen firsthand how small security oversights can lead to major vulnerabilities.
How Much AI Code Would You Use?
Today Steve asks the question of how much of your code could be written by GenAI.
How to Remove Constraints from a SQL Server Table
I need to drop constraints on a number of my SQL Server tables. Most of our constraints are primary key and foreign keys, but there are other constraints too. How can we script it so it will deploy with a pipeline in a repeatable manner?
Two Events, Two Worlds: A Week in the Life of a Technologist
Last week, I had the chance to speak at two very different events, and the contrast between them really stuck with me. The first was all a traditional vendor conference- enterprise-level, built around a well-established product with over 40 years of vendor-driven development. Think polished sponsor tables, polished shoes, and more than a few suits […]
Blogs
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
ALAMAT BCA KCU PURI INDAH Telp:08218154393
WA:08218154393 Gedung C3 Lt. 1-3 Komplek, Jl. Puri Indah Raya No.1-3 Blk 02, RT.3/RW.2,...
ALAMAT KONTAK BCA KCP Santa Telp:08218154393
WA:08218154393 Jl. Wolter Monginsidi No.54, RT.2/RW.4, Petogogan, Kec. Kby. Baru, Kota Jakarta Selatan, Daerah...
Have you done a Mid year check in?
Comments posted to this topic are about the item Have you done a Mid...
Question of the Day
Independence Day 2026
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers