Viewing 15 posts - 16 through 30 (of 317 total)
Interesting scenario! Sounds like a Microsoft exam question 🙂
My first thought would be to use a Domain Local Group in the Trusted Domain, containing the Universal Group.
I suspect the problem...
November 2, 2020 at 11:26 am
ADS, Azure Data Studio, is a pain to install on a non-internet-connected machine. To date, SSMS can be installed without any hassles. Apart from some dev machines, none of my...
November 2, 2020 at 11:15 am
There are two Azure SQL PaaS offerings: Azure SQL Database and Azure SQL MI (Managed Instance).
Azure SQL Database is a single database; whereas Azure SQL MI is closer to a...
October 26, 2020 at 10:53 am
As already mentioned, SCOM can be configured to use a service account to connect to MSSQL instances; not a good idea to use the (default) SYSTEM account.
In SCOM, you need...
September 11, 2020 at 3:54 pm
Like David, I am lucky to have a spare room, which was already setup as an office; best investment was an adjustable standing desk (can be lowered to a normal...
September 11, 2020 at 3:42 pm
I have come across this error before, when upgrading PBIRS to a newer version. For me, the problem was the newer version of PBIRS was trying to create the URL...
July 17, 2020 at 7:57 am
Hi Again,
The 1% is a wild approximation; entirely dependent upon how often you apply the log files to the readable Secondary; whilst the log files are being applied, all other...
April 29, 2020 at 4:16 pm
Log-Shipping is per-database, not per MSSQL Instance; you would be able to read the DMZ log-shipped database 99% of the time (the 1% when reads are not allowed is whilst...
April 28, 2020 at 4:37 pm
Sure, you could setup replication; but that will tie together your two MSSQL instances, perhaps in ways you don't want; for example, schema changes are difficult; permissions/accounts are awkward.
What do...
April 24, 2020 at 9:24 am
You could look into "Always On Basic Availability Groups" but they don't allow a readable secondary (worth checking though).
Next up would be "Domain Independent Availability Groups" although I have never...
April 16, 2020 at 3:54 pm
You can have SSMS versions 16, 17 and 18 running side-by-side, as well as the version of SSMS bundled with SQL Server 2014.
As Sue_H highlights, there are hidden compatibility problems...
April 16, 2020 at 8:19 am
Interesting questions.... and I'm sure many possible answers. My initial thoughts are:
April 16, 2020 at 8:10 am
Sorry, I won't even attempt to open the ZIP file. Preferably you can attach the images inline...
To try to answer your question: normally you require local admin rights to open...
April 1, 2020 at 11:57 am
This has been a long running debate.... for example, see:
Personally, I don't see a danger in enabling it on x64 systems (and ensuring the MSSQL service account is...
September 11, 2019 at 3:58 pm
Also worth familiarising yourself with the licensing terms for redistribution rights:
Microsoft® SQL Server® Express License Terms for Redistribution and Hosting
https://www.microsoft.com/en-us/download/details.aspx?id=29693
Documents:
SQL 2014 Express_Hosting_Redistribution_EULA.docx
SQL Express 2012 Express (Revised).docx
I couldn't find...
September 6, 2019 at 12:30 pm
Viewing 15 posts - 16 through 30 (of 317 total)