Testing Flyway Migrations Using Transactions
When you are using Flyway, how can you test your database migration script first to make sure it works exactly as you intended before you let Flyway execute it?
What does SET NOCOUNT ON do?
When you’re working with T-SQL, you’ll often see SET NOCOUNT ON at the beginning of stored procedures and triggers. What SET NCOUNT ON does is prevent the “1 row affected” messages from being returned for every operation. Read Brent's blog to see him demo it by writing a stored procedure in the Stack Overflow database.
Happy Birthday USA!
This is the Fourth of July weekend here in the US when we celebrate the birth of the country based on the publication of the Declaration of Independence. For those who don't know, this celebration mostly consists of fireworks and outdoor cookouts. However, at our house we've always tried to do a little bit more […]
Learning Intentionally with a List
We're coming up on the middle of the year, and I wonder if you are improving your career this year? Did you make plans and are you sticking to them? I've been tracking progress on my goals, and so far mediocre progress. It's tough to learn, but even tougher to learn when you don't have […]
Real Time data streams from SQL Server using Kafka Connect in the Cloud
See a simple demonstration of how Kafka can stream events for changes to data in SQL Server tables.
A Quick Diff Checker for SQL Server Databases
Compare the schemas of two SQL Server databases using SQL Compare command line then quickly produce a diff report showing you immediately which tables, views and functions have changed.
Introduction to generic Power BI themes
Formatting Power BI visuals can be tedious. In this article, Adam Aspin explains custom Power BI themes that will save you time when creating reports.
Patching Challenges
Having a patching strategy for your systems is important, and Steve notes that you ought to be organized and allow for some flexibility when designing one.
Top SQL Queries to Safeguard JIRA
Troubleshooting Performance Problems is not very easy process and can be complicated when it comes to identifying problems with JIRA application.
SQL Server transaction log architecture
The transaction log file for a SQL Server database critical for for maintaining database integrity. In this article, Greg Larsen explains SQL Server transaction log architecture.
Blogs
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
"Click" your SQL Server into an MCP agent, with RBAC and full security
Hi guys and gals, I've created a system that automatically allows you to "generate"...
Demo Tracking Dropped Objects
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers