How to Load a Date Dimension in Microsoft Fabric using Macros in dbt?
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.
Navigating Your Test Data Challenges: Insights and Solutions
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.
Evergreen SQL Server
Microsoft talks about evergreen SQL, where you never need to patch your database.
How to Forecast Data in Power BI
Learn how you can use Power BI to forecase the future trends of data.
Is SQL Server Feature Complete?
Steve asks the question about whether you think SQL Server is feature complete today.
Using try catch in SQL Server stored procedures
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.
Life Moves Pretty Fast
Driving my soon-to-be granddaughter to school today (my son is getting married and will adopt the young lady), we saw a dead armadillo, a turtle in the road (rescued it) and an escaped cow (left it alone). THEN... old soon-to-be granddad had forgotten lunch, so had to deliver that back at the school (cow must […]
50 Years of Microsoft
Steve looks back at his history with Microsoft and asks what your memories are of using their products.
Blogs
Speaking at SQL Saturday Austin 2025
By Steve Jones
SQL Saturday Austin 2025 is in just a few days. I am honored to...
Updating SSMS is Easy (w/ v21)
By Steve Jones
I’ve been using the SSMS preview for v21. This is the next evolution of...
Execute Fabric Data Pipeline from Azure Data Factory
In the blog post Call a Fabric REST API from Azure Data Factory I...
Forums
The Long Running Backup
Comments posted to this topic are about the item The Long Running Backup
Interview Tips
Comments posted to this topic are about the item Interview Tips
importing from PowerQuery... but with multiple powerqueries
I finally got the PowerQuery source to "show" in SSIS (so I can see...
Question of the Day
The Long Running Backup
I have a long running backup of the Sales database during a maintenance window that is going to take another 2 hours to complete on SQL Server 2022. I also need to perform some proactive work and add another file (ndf) to the Sales database to handle the expected growth of the next month. Can I do both simultaneously?
See possible answers