Viewing 15 posts - 916 through 930 (of 7,472 total)
Check the "remarks" section and "Errors Unaffected by a TRY…CATCH Construct" in the try-catch documentation : https://docs.microsoft.com/en-us/sql/t-sql/language-elements/try-catch-transact-sql
January 18, 2018 at 3:43 am
No. local software is updated and scripts are provided to upgrade the db at startup (failover) time.
At startup (failover) time upgrades are being checked and executed if needed.
If...
January 15, 2018 at 3:44 am
( Starting with SQL2012, ) you could opt to move tempdb to a local drive on each node. ref: http://www.sqlservercentral.com/articles/failover/137066/
Each node has to be hotfixed ( cumulative...
January 15, 2018 at 2:00 am
As a picture says more than 1000 words: Statler & Waldorf ( and I hope everybody still knows the duo )
November 13, 2017 at 5:20 am
As a starter I always use the target versions Data Migration Assistant (formerly known as Upgrade Advisor ).
Have a look at https://docs.microsoft.com/en-us/sql/dma/dma-overview
November 9, 2017 at 12:14 am
are you using a 3th party backup solution or native SQLserver backups ?
Plug in into your existing backup infrastructure !
Doing that you can use it to test...
November 8, 2017 at 7:03 am
FWIW (free) dbatools may help you out if you are open for a bit of Powershell
November 2, 2017 at 5:49 am
If you still want to experiment with sp_msforeachDB, you could try it quick and dirty like this:
October 31, 2017 at 3:13 am
As always: it depends !
With a SQLServer clustered instance, the pain point may be the shared storage.
A single SAN is such a liability ( and still...
October 30, 2017 at 8:09 am
This is a way where you can copy data to your AzureSQLDB ( provided you've already implemented the schema ) using Powershell
Write-Datatable can be found here
October 25, 2017 at 3:46 am
chances are you didn't get a result because tblOrders may exist in multiple schema !
Best practise: always schema-qualify your objects !
Select ...
from...
October 10, 2017 at 2:12 am
First of all: the concepts: https://docs.microsoft.com/en-us/azure/architecture/best-practices/data-partitioning
Did you have a look at : https://www.mssqltips.com/sqlservertip/3494/azure-sql-database--table-partitioning/ ?
I haven't tested this on a Azure...
October 10, 2017 at 12:39 am
Time to learn Powershell !
To keep it simple, just add an extra variable (e.g. $ResultFileName )
#Create the report and save it to...
October 5, 2017 at 2:20 am
Viewing 15 posts - 916 through 930 (of 7,472 total)
