To make Sql Server to be accessed remotely, check the belows. 1. Use correct server name. The server name is machine name + instance name. e.g. My-PC\SQLExpress The server name shouldn’t start with ‘\\’ 2. Tick Allow remote connection to this server from the tab Connection of Server Property from SQL Server Management Studio. 3. Enable TCP/IP… Continue reading SQL Server remote access
Category: DB
Useful command of MSSQL Query when comparing and manipulating text data
Extract table from another table SELECT * FROM dbo.SFG_Event_21_22 except SELECT * FROM dbo.SFG_Event_21 Bulk insert BULK insert dbo.SFG_Event_21_22 from ‘C:\Users\joemac\Desktop\final.csv’ WITH ( firstrow = 1, fieldterminator = ‘,’, rowterminator = ‘0x0a’ ); GO bulk insert cannot understand text qualifier bulk insert add NULL for blank data by default Replace string value of a column… Continue reading Useful command of MSSQL Query when comparing and manipulating text data
Bulk data import to MSSQL
I was about to upload 2 million record of data using NHibernate’s default save method, which will transact every record independently. It estimated almost 2 days to upload all data. In this mass data upload, bulk import utility, bcp is pretty useful. It takes 10 minutes for 2 million record to import. Related well written article. http://lostechies.com/jimmybogard/2010/06/24/bulk-processing-with-nhibernate/ And… Continue reading Bulk data import to MSSQL
MSSQL backup & restore using script.sql
MSSQL has the function called backup & restore, which is useful. It works fine between different versions. But, if you need to restore from script.sql, you can do it on command line. sqlcmd -S <server> -i C:\<your file here>.sql -o Full explanation : Link and Sometimes connection string can be tricky. You can get full help… Continue reading MSSQL backup & restore using script.sql
Entity Framework vs NHibernate
NHibernate vs EntityFramework – Experience From the Real World This is a really great article, unbiased well developed review between EF4 & NHibernate. NHibernate and Entity Framework essentials using a Model First approach This is brief sample of implementation with comparison BTW, the conclusion is If no special reason, stick to ADO.Net with DataSet If use… Continue reading Entity Framework vs NHibernate