Category Archives: Cloud

Connect R to Microsoft SQL Server

This post is showing you how to connect R language to Microsoft SQL Server. I could not use the odbc as stated here https://support.rstudio.com/hc/en-us/articles/214510788-Setting-up-R-to-connect-to-SQL-Server-.. I have tried it in R 3.4.3 as well as R 3.5.1. I used RODBC, and … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | Leave a comment

SQL Server replication new table not replicated

This post shows you why you are waiting for the table to replicate and there never replicated. There is something call Article Properties in the Publisher Properties. Right click the Publisher and choose Properties. Go to Articles then you will … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged , | Leave a comment

SQL Server Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding

This post only provides one of the possibilities to resolve the error “”Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.” in SQL Server. When I use C# to backup … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | Leave a comment

SQL Server Generate Database Script

This post is showing you how to generate the scripts for all the database structure in a SQL Server. You can right click the database in SQL Server Management Studio for sure but in that way you can only generate … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | Leave a comment

‘Publisher1’ is not enabled as a Publisher at the Distributor, ‘Distributor1’

This post shows you one of the common issues people will overlook. When you are configuring the database replication of Microsoft SQL database. You then get the error “‘Publisher1’ is not enabled as a Publisher at the Distributor, ‘Distributor1’. I … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged , | Leave a comment

SQL Server replication Could not connect to server ‘Server1’ because ‘Server2’

This post shows on of the possible solutions to the following error for replication setting up. “Could not connect to server ‘Server1’ because ‘Server2’ is not defined as a remote server. Verify that you have specified the correct server name. … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | Leave a comment

Cannot alter the role ‘SQLAgentReaderRole’, because it does not exist or you do not have permission

This short post shows you one of the possibilities to resolve the error Cannot alter the role ‘SQLAgentReaderRole’, because it does not exist or you do not have permission.“. When I issued the below command: EXECUTE sp_addrolemember @rolename = ‘SQLAgentReaderRole’, … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged , | Leave a comment