Monthly Archives: August 2018

R accessing SQL Server Northwind table columns

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

Reconstruct database with tables using C#

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

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

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

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