SQL Multi Script does one thing and does it well: it will run whatever script or scripts you select, on a list of databases, and collate all the results neatly. However, it has a surprising number of uses. Phil Factor explains how it works and then uses it to search 100 databases, for occurrences of a string, in about 7 seconds.
2020-08-05
This article will explain how to use PowerShell to call a stored procedure and export results to the screen or a file.
2020-08-04
3,415 reads
In Redgate Change Control v3.0, you can now commit your database changes to your local Git repository and collaborate with your team by pushing and pulling changes from the remote Git repository. If you’re using branches, you can also create and switch Git branches from within Redgate Change Control.
2020-08-04
In this article we look at some reasons why you cannot connect to SSIS using SQL Server Management Studio and how to solve the problem.
2020-08-04
As a part of my DBA activities, I do a lot of SQL Server installations every week. Most of the time, I install the instance with the default collation. A collation is a configuration setting in SQL Server that determines how the database engine should read the data. SQL Server has huge list of collations […]
2020-08-03
2,053 reads
There is a huge number of databases available. How many could you name? Create our list and then compare to our list of well over 100 databases!
2020-08-03
With the new labeling and classificiation options in SQL Server, there might be a need to remove these labels before deploying the database.
2020-07-31 (first published: 2018-12-20)
2,406 reads
Learn the step by step process to install SQL Server 2019 Integration Services in Visual Studio as well as the history for the tool.
2020-07-31
Phil Factor explains how to use SQL Prompt, or SQL Change Automation, to detect use of deprecated SQL Server syntax, during development, and Dynamic Management Views and Extended Events to track its use on working databases.
2020-07-31
As data professionals, we should understand how language and forms of address can impact our data model. In the 21st century, we should also learn how to communicate with colleagues in a respectful and professional manner.
2020-07-30
2,008 reads
Most of DBA are coming from On-premise Database Servers they know very well How...
By Steve Jones
This is a non-technical post, and my opinion. If you don’t want to read...
By kleegeek
I’m thrilled to support and participate in this year’s VMworld 2020 conference, which is...
Summary: We had migrated SSISDB from SQL Server version 11.0.6260 to SQL Server version...
Hi, I'm using SQL Server 2017, I need to give developers only to view...
Comments posted to this topic are about the item Offline Filegroups
Ask SSC