Tag: SqlServer
-
Import large Excel file into SqlServer
I have to import the list of NGO from Romania to SqlServer. Before seeing my solution,please do it yourself: the file could be found at http://www.just.ro/registrul-national-ong/ and the name is Asociatii I have tried with SSMS – no luck ( text will be truncated,even when I put nvarchar(max)) The I tried with flat file from…
-
Monitor SqlServer Stored Proc execution time
I have had the task to made something to monitor what stored procedure,in Sql Server,in most used. The problem that I have had is that the host_name is easily changed by putting,in the connection string WSID (see http://msdn.microsoft.com/en-us/library/ms178598.aspx ) The code is for sql server 2005 and I have not realized without the help of…
-
Sql Server Management Studio free awesome addons
The two addons that I can not live without in Sql Server and that,more,are free : SSMS Tools Pack – now 1.7.5.1,http://www.ssmstoolspack.com/Download SQL Search – now1.0 http://www.red-gate.com/products/SQL_Search/ The SSMS Tools Pack maintains a history of your commands . More,it saves on the C:\SSMSTools\SQLQueryActionLog The Sql Search finds a text in the objects in…
-
How To … Read database connection strings from app.config or web.config file
Step 1 : Add a app.config file Step 2: Add the connection string Step 3: Add reference to system.configuration Step 4: Use the connection from ConfigurationManager.ConnectionsStrings download visual studio solution
-
How to … test database code with BDD(NBehave)
In this video,that is the continuation after How To … Test code from database with nunit I will show how to transform a NUnit test into an BDD – NBehave test. As usual,you can download the code from here here
-
How To … Test code from database with nunit
In this video we will test the Business Layer for a shortening application. The Data Access Layer is made with Entity Framework . You can download files from here