Monthly Archives: August 2018

R accessing SQL Server Northwind table columns

Posted on August 31, 2018 by chanmingman

This post shows you how to access to SQL Server database table using R. In the previous Connect R to Microsoft SQL Server https://chanmingman.wordpress.com/2018/08/21/connect-r-to-microsoft-sql-server/ article. I showed you how to access to the database. In here we will access to … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged , | 2 Comments

Reconstruct database with tables using C#

Posted on August 30, 2018 by chanmingman

This post shows you how to reconstruct the database using the scripts you have generated, https://chanmingman.wordpress.com/2018/08/11/sql-server-generate-database-script/. This code split into 2 major functionalities. 1. Reconstruct the database. 2. Reconstruct the tables. The below is to construct database only without the … Continue reading →

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

Database ‘Database’ is already open and can only have one user at a time

Posted on August 28, 2018 by chanmingman

This post gives one of the possible solution to the following error for SQL Server. Most of the time we will be setting the database properties using SQL Server Management Studio, the GUI management interface. Somehow for some of the … Continue reading →

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

Connect R to Microsoft SQL Server

Posted on August 21, 2018 by chanmingman

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 | 1 Comment

SQL Server replication new table not replicated

Posted on August 18, 2018 by chanmingman

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

Posted on August 15, 2018 by chanmingman

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

Posted on August 11, 2018 by chanmingman

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 | 1 Comment

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

Posted on August 10, 2018 by chanmingman

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 , | 3 Comments

Finding font in PowerPoint and replace

Posted on August 8, 2018 by chanmingman

This post is to show you how to eliminate the following warning when you are saving a PowerPoint file. Obvious, looking at the picture below I do not have a font. You can go to Home tab then select Replace … Continue reading →

Posted in Community, Computers and Internet, Microsoft Office, Office 365 | Tagged , | Leave a comment

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

Posted on August 5, 2018 by chanmingman

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