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
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers