Viewing 15 posts - 1 through 15 (of 972 total)
You need to exclude the Extended Events from being copied. While SQL Server 2008 R2 did support XE it was very limited and SMO itself won't work against that version....
July 22, 2019 at 4:16 pm
March 23, 2018 at 7:42 am
The ability to script out all linked servers can be done now using dbatools PowerShell module.
Copy-DbaLinkedServer will let you migrate the linked server to another instance, and will...
March 21, 2018 at 4:26 pm
If your requirements allow for the table to be the same name on your destination as it is on the source, you can utilize the dbatools module to help make...
March 10, 2018 at 11:20 pm
The only article that seems to mention ports being open on the firewall is when you are configuring firewall rules for Azure SQL. There is a note that shows
March 10, 2018 at 10:54 pm
March 10, 2018 at 10:30 pm
March 10, 2018 at 10:21 pm
Being that Azure SQL is a PaaS service, no you do not have any control over the infrastructure side of that service...meaning port and all. You control access to a...
March 10, 2018 at 9:46 pm
I'll assume you are referring to the time it takes to perform those restores using SSMS, since you mentioned setting the "device". Most of the time I see that taking...
November 27, 2017 at 4:49 am
You cannot read data from a URL path for an Excel file, it is not possible.
November 13, 2017 at 1:58 am
You can quickly and easily reset the "sa" account to regain access to a SQL Server instance using the "Reset-DbaAdmin" command from the PowerShell module dbatools.
October 9, 2017 at 4:28 am
yhandz_21 - Monday, September 25, 2017 8:59 PMHi,See update above for expected output.
See update above for expected output.
In PowerShell and .NET world that third column of data...
September 26, 2017 at 8:22 pm
For example:Select @@servername
September 25, 2017 at 1:51 am
June 23, 2017 at 6:38 am
You can clone an EC2 instance by making an AMI image of it. Then create another one based off it. There are some things that are not copied in that...
June 22, 2017 at 10:05 pm