Export and Import SSISDB in just a few clicks
In this article, I will describe how to export and import SSISDB using SSIS Catalog Migration Wizard in just a few clicks.
Looking Forward to the PASS Data Community Summit 2023
Steve takes a moment to think ahead to the PASS Data Community Summit 2023 and what he's looking forward to at the event.
Setting up Drill Through in the New Power BI Report User Interface
In this article, learn how to implement drill-through in Power BI reports using the new user interface.
Working around schema drift in SQL Server
At Stack Overflow, our environment has multiple implementations of a largely – but not 100% – identical schema. (By “schema,” I mostly mean the set of tables within a database.) I sometimes need to retrieve or update data across a large number of sites. Let’s say, pulling or removing information from the Users table, and related tables, across all of our databases.
The IT Jobs AI Can't Do
This was a provocative title: 6 ITOps Skills That Will Never Be Automated. In a time when AI use is growing quickly and many people fear for their jobs, it's nice to see someone writing about areas that AI will struggle to handle. Ironically, lots of these articles are written by writers without much technical […]
Let’s talk about Artificial Intelligence, ChatGPT and Gobbledegook
I use Chat-GPT occasionally, instead of Google, to get answers to technical questions. However, I regard Chat-GPT as an indiscriminate conveyor of existing information, not artificial intelligence.
How to export data to SQL Server using Bard (Google chatbot)
See how well the Bard AI does with moving data into SQL Server.
10 reasons to choose Flyway
Thousands of organizations use DevOps practices every day to deliver application changes. But what about the database? Excluding the database from your DevOps pipeline and processes risks application performance, data security and integrity. With Flyway, Redgate solves this challenge in one complete solution that sits inside your existing DevOps platform and processes. Find out the 10 reasons why organizations worldwide choose Flyway.
Different Ways to Format Currency Output in SQL
In this tutorial, we will show different ways to output different currency formats with the T-SQL language.
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers