There will come as time when you need to upgrade the host operating system and SQL Server to a newer version. If you are using SQL Server Integration Services (SSIS), one of the things you may need to do is to move the SSIS catalog (SSISDB database) to the new server. We will cover the steps in this tutorial to migrate the SSISDB from one server to another.
2025-02-21
Accelerated Database Recovery (ADR) is a database-level feature that makes transaction rollbacks nearly instantaneous. Here’s how it works.
2025-02-19
How can I accurately find which SQL Server Stored Procedures, Views or Functions are using a specific text string, which can be a table name or any string that is part of the code?
2025-02-17
Imagine a candle that is lit and takes 1 hour to burn out. Now imagine one hundred candles. How many hours will it last? That depends. If they are lit simultaneously, it will take 1 hour. That is the basic idea of running in the background or asynchronously. Of course, the 100 candles can execute independently of one another, unlike if you try to run 100 processes on a computer with 2 cores. PowerShell has some ways to manage that, as PowerShell job – which we will see in this article – runspaces – needs to add programmable using .net.
2025-02-14
In this tip, we will look at how group Managed Service Accounts (gMSA)
2025-02-12
Let me cut to the chase. If you are like me, you may have been searching for: How to turn on Dark Mode in SSMS V21. Searching for that very thing today inspired me to write this blog to help others do the same thing because I couldn’t seem to find an easy answer.
2025-02-10
I would like to know the number of rows affected by my SQL Server query. I know this is displayed as a message in SQL Server Management Studio, but I have to check the number of rows in an IF statement to verify if everything went alright. How can I do this in SQL Server?
2025-02-07
In this second installment of our series comparing Frappe and Laravel, we probe into critical aspects of database management and migrations.
2025-02-05
You’re running an ad-hoc query in a Microsoft SQL Server database with SQL Server Management Studio (SSMS) and need to further analyze the result set in an Excel spreadsheet. How do you export the data?
2025-02-03
There may come a time when you want to or need to rename a database. In this tip we look at a couple different options.
2025-01-31
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
By Steve Jones
“You don’t need more time because you already have all the time that you...
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
I do have a question. At work, some groups of people have an inordinate...
Comments posted to this topic are about the item What Did Healthy Look Like?
Comments posted to this topic are about the item DML Trigger Types
How many types of DML triggers are there?
See possible answers