26ai Quick Tip for Database Links
It seems an odd thing that so many facilities on the cloud environment take advantage of the concept of stored database credentials when it comes to authenticating/authorising access to...
2026-01-29
14 reads
Blog Posts
Deploying an Updated Model with SQL Compare 16
In a previous post, I deployed a model to a database using SQL Compare 16. This used a new feature in that connects to Redgate Data Modeler. In this...
2026-01-28
36 reads
Getting Your Data GenAI-Ready: The Next Stage of Data Maturity
I remember a meeting where a client’s CEO leaned in and asked me, “So, we have tons of data… Why can’t we just add AI and call it a...
2026-01-28 (first published: 2026-01-14)
329 reads
Looking Back at the Redgate 2026 Company Kickoff
Last week I spent a few days in Cambridge, UK for the Redgate Company Kickoff. I landed at 1130a Monday and flew away at 1215p Thursday. I wish I...
2026-01-28 (first published: 2026-01-26)
25 reads
Runing tSQLt Tests with Claude
Running tSQLt unit tests is great from Visual Studio but my development workflow isn’t just write tests, run tests, fix tests, run tests anymore, it is 2026 and...
2026-01-28 (first published: 2026-01-14)
590 reads
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to boost memory or I/O, you had to scale the whole instance, paying for extra CPU...
2026-01-26 (first published: 2026-01-12)
293 reads
Learn Better: Pause to Review More
If you want to learn better, pause more in your learning to intentionally review.
2026-01-26 (first published: 2026-01-13)
245 reads
SQL, MDX, DAX – the languages of data
Ramblings of a retired data architect Let me start by saying that I have been working with data for over thirty years. I think that just means I am...
2026-01-23 (first published: 2026-01-12)
494 reads
Using Prompt AI to Help Setup Data Analysis
I used Claude to build an application that loaded data for me. However, there were a few others things I needed done to help me get the data ready...
2026-01-23 (first published: 2026-01-07)
348 reads
Using SQL Compare with Redgate Data Modeler
Redgate recently released SQL Compare v16, which included a new feature to work with Redgate Data Modeler. I decided to give it a try in this post. I’ll take...
2026-01-23 (first published: 2026-01-22)
35 reads
Blogs
Excellent article on securing msdb
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Forums
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers