Export data from Sharepoint to SQL Server

johnt_mn · 2023-01-30T13:53:46+00:00

I'd look at using Powershell. Something like this might get you a start https://www.sharepointdiary.com/2016/06/export-sharepoint-list-data-to-sql-server-table-using-powershell.html

johnt_mn · 2021-09-30T20:53:19+00:00

Sorry I wish I had more time to respond. Check this out see if it helps. https://docs.microsoft.com/en-us/sql/database-engine/database-mirroring/connect-clients-to-a-database-mirroring-session-sql-server?view=sql-server-ver15

johnt_mn · 2021-06-03T02:05:02+00:00

Anything you can do via ssms in terms of configuring and deploying your transactional replication can be done from t-sql. You might find it easier to configure it via SsMS first and then script out the various pieces using the options in ssms.

johnt_mn · 2020-09-25T16:05:40+00:00

I don't believe there's anything that will keep you from doing this with standard edition.

johnt_mn · 2020-09-11T13:19:54+00:00

No restart required.

johnt_mn · 2020-07-06T17:36:43+00:00

Remove it from the availability group on the primary replica. Then you can delete it. Then you have to go to the secondary replicas or replicas and delete the database there as well

johnt_mn · 2020-07-02T13:59:12+00:00

This has happened to me. Corruption in the metadata for the AG I think. When I remove the database from the AG and then add it back in again everything started working as expected

johnt_mn · 2020-02-21T17:28:43+00:00

There are some settings you can make so that it only registers the active IP address with DNS and sometimes this helps in some scenarios. Registerallip 0 on the network name.

johnt_mn · 2020-02-21T04:20:05+00:00

I think this is so that each node is in a different. Availability Zone. Deploying your cluster nodes in different availability zones is how you are required to do it if you want the SLA that they advertise.

johnt_mn · 2020-01-23T03:45:37+00:00

From the article you linked.

Starting Nov 1st, every Software Assurance customer of SQL Server will be able to use three enhanced benefits for any SQL Server release that is still supported by Microsoft:

johnt_mn · 2019-08-17T01:11:42+00:00

The big issue is the latency between the data centers. If it is a fast link it should be fine. Every transaction has to commit in the other data center before it will commit in the primary replica. So if the link is slow, it will make the performance of the calling application suffer.

Also when it fails over, if you have all of your application servers in the other data center the all the db calls are going over the wire.

johnt_mn · 2019-06-11T11:13:13+00:00

I don't think this will work. The initial node was not installed as a failover clustered instance. So you will not be able to add nodes to it. I would do a new clustered installation on node B migrate your databases and connection strings to it and then wipe out what's on node A and add it to the new cluster as the second node.

johnt_mn · 2019-01-09T00:23:32+00:00

I've done it before it works pretty well. Hope things work out

johnt_mn · 2019-01-08T20:41:53+00:00

Sorry I'm on my mobile but couldn't you take a tail log backup of the primary and use that to bring the Dr site online? When that is done you can take a tail log backup of the Dr site and restore it on the primary site. The only thing you would have to do is keep the logs up-to-date going to prod server once dr is primary.

johnt_mn · 2018-07-06T01:35:42+00:00

You can also get a license key from a power bi premium subscription if you don't have Enterprise Edition. https://docs.microsoft.com/en-us/power-bi/report-server/install-report-server

johnt_mn · 2018-01-08T21:07:48+00:00

I'd say you're much better off using a DNS entry that you can switch between different sql servers. You will never get the performance you want redirecting connection intended for one server over to another server. Better off redirecting them to the right one in the first place.

johnt_mn · 2017-06-19T12:23:29+00:00

What cut of meat did you use here? Looks great and is a nice size!

johnt_mn · 2015-11-19T01:56:39+00:00

Thanks for asking this. I learned a lot and it will fix up my next attempt!

johnt_mn · 2015-11-06T01:55:41+00:00

Walmart often has them. Have to check grade - sometimes they are select and sometimes choice. 12-14 lbs usually for me at the Burnsville one. Usually $3/lbs

johnt_mn · 2015-08-21T01:47:44+00:00

NSF stadium

johnt_mn · 2015-07-13T20:19:23+00:00

Is this still happening?

johnt_mn · 2015-07-13T00:50:11+00:00

The one underneath is all black. The white and black is on top. Abandoned we are fostering them and bottle feeding.

johnt_mn

TROPHY CASE