The article A gentle introduction to dbt explains how you can get dbt in the cloud version, how you can set up a free account, and how to create a connection to a Microsoft Fabric warehouse.
2025-04-30
Join Redgate on May 1st for an insightful webinar cohosted with analyst firm, Bloor Research, featuring independent Senior Analyst Daniel Howard and Redgate's Steve Jones. Discover the biggest test data challenges, the latest approaches like AI synthetic data generation, and how effective test data management can benefit your entire organization. Don't miss out on this opportunity to gain valuable insights and solutions.
2025-04-30 (first published: 2025-04-07)
2025-04-28
453 reads
A great new option that has been around since SQL Server 2005 is the ability to use the Try..Catch paradigm that exists in other development languages. Doing error handling in SQL Server has not always been the easiest thing, so this option definitely makes it much easier to code for and handle errors.
2025-04-28
I wrote a piece on getting started with the Data API Builder (DAB), which looked at how this product works and how to start using it. That was a basic look, but it gives data professionals an idea of how this might help them work more closely with front-end developers who are more comfortable with […]
2025-04-25
3,938 reads
I was recently on a project to migrate a very transactional installation of SQL Server to Azure SQL Managed Instance (MI). SQL Managed Instance is a good stepping stone between a full, on-prem SQL instance / Azure VM and an Azure SQL Database.
2025-04-25
I have a lot of SQL update queries where I need to make IF/ELSE types of decisions. In some cases, I am using a cursor but looping through thousands of rows for update takes a long time. I also use some dynamic SQL to handle some query parameter decision making. Is there a better alternative?
2025-04-23
Loading data into Snowflake is a common need. Using Python and pandas is a common go-to solution for data professionals
2025-04-21
See how ISNULL and COALESCE behave in different situations and ensure you know which one to pick when.
2025-04-18
4,988 reads
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.
2025-04-18 (first published: 2025-03-10)
In my previous post, I showed you how to build a snapshot backup catalog...
By Steve Jones
Train employees well enough that they could get another job but treat them well...
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item Docker Advice for SQL Server...
Comments posted to this topic are about the item DevOps is DevOps
In SQL Server 2022, how many backup files can I have in a striped backup?
See possible answers