Viewing 15 posts - 16 through 30 (of 331 total)
When I first saw the question, I would have put good money on a selection of SQL-based solutions!
I slapped this one together, but I'm sure there are better ways of...
February 14, 2022 at 3:19 pm
If a User has the EXECUTE permissions on a SP, they are automagically granted the rights to perform whatever the SP can do.
The User, when creating the SP, requires the...
January 17, 2022 at 5:24 pm
Can you describe where these connections are initated from?
What do you see when you run: select * from sys.dm_exec_connections
What protocols are enabled for the Instance? And how are they configured?
August 9, 2021 at 12:48 pm
The installation binaries are identical; the only difference (might be) the licence file embedded in the ISO image.
I think the licence file is: \x64\DefaultSetup.ini
Depending upon your Microsoft agreement, and whether...
July 12, 2021 at 4:10 pm
Not sure I understand the architecture here. You say your datasource is a DB in Azure; is that Azure SQL Database, MI or a VM running MSSQL?
Looking at the connection...
July 12, 2021 at 10:48 am
As a follow-up:
The "servername\instance" format relies on the Browser service; it will only work correctly if your local machine can reach the remote Browser service.
The SQL Server Browser service listens...
July 12, 2021 at 10:16 am
Where is the table being created? In the Subscriber database? Does the table also exist in the Publisher database? (and does it get replicated?).
Have you dug into what is happening...
June 11, 2021 at 11:32 am
Unfortunately, Replication is an unloved area of MSSQL. Microsoft hasn't made any changes for years. On the plus side, it still works and is reliable.
I don't quite understand your scenario,...
June 11, 2021 at 7:06 am
As Andreas said, the CU and GDR updates are different and cannot be mixed.
Previously, you could change between CU and GDR after installing a new SP; but with SPs now...
March 1, 2021 at 10:19 am
If I come across this license expiry in the future, and find a solution/workaround, I'll try to remember to post here.
Andy
January 13, 2021 at 6:56 am
How did you build/download the original installation package?
We run VS2017 on a few clients, all 100% disconnected from the internet. Downloading the package is a bit of a pain, getting...
January 12, 2021 at 5:38 pm
Grant, thank you for the Editorial piece and your thoughts. It did make me stop and think about how PASS has affected me and influenced my professional career, as well...
November 27, 2020 at 12:10 pm
Ooops, did not know about this 2TB max. Thanks for setting the question!
November 17, 2020 at 9:52 am
I think you will have problems if the cloud MSSQL is using the default built-in virtual service account. "NT SERVICE\MSSQLSERVER" will appear on the network as "DOMAIN\servername$", effectively using the...
November 2, 2020 at 2:45 pm
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
Viewing 15 posts - 16 through 30 (of 331 total)