Blog
How to Check SQL Server Transaction Log File Size (With T-SQL)
1. Open SQL Query
2. Write DBCC SQLPERF ( LOGSPACE )
3. Execute query

How to check how many users are connected to a SQL Server
You can retrieve information about the number of connected users to a SQL Server. It is also possible to check which users are connected to a particular database.
Few examples in below:
Example 1: To check all users and process connection
select @@servername as server, count(distinct usr) as users, count(*) as processes from
( select sp.loginame as usr, sd.name as db
from sysprocesses sp join sysdatabases sd on sp.dbid = sd.dbid ) as db_usage
Example 2: To check individual users and process connection
select Users, count(distinct db) as Databases, count(*) as processes from
( select sp.loginame as Users, sd.name as db
from sysprocesses sp join sysdatabases sd on sp.dbid = sd.dbid ) as db_usage
group by Users
order by Users
Example 3: To check database, user and process connections
select db, users, count(*) as processes from
( select sp.loginame as users, sd.name as db
from sysprocesses sp join sysdatabases sd on sp.dbid = sd.dbid ) as db_usage
where db like('%')
group by db, users
order by db, users
Database to Single-user Mode in MS SQL Server 2008
Today I will discussed about, how to restrict access to single user.
Why need restrict access database?
* Single-user mode specifies that only one user at a time can access the database and is generally used for maintenance actions.
* When multiple users are connected to the database at the time that you set the database to single-user mode, their connections to the database will be closed without warning.
How to setup database to single user mode.
Step 1: Go to Start menu > All Programs > Microsoft SQL Server 2008 > SQL Server Management Studio and Connect to database server


Step 2: Right-click the database and click Properties.

Step 3: In Database Properties dialog box, click Options page from left menu.

Step 4: Select SINGLE_USER from the Restrict Access option

Step 5: If other users are connected to the database, an Open Connections message will appear. To change the property and close all other connections, click Yes.

How to setup selenium WebDriver with Nunit and Visual Studio (C#)
Selenium is an open source software tools which supporting tests automation. Now days, Software automation tools are becoming popular. Software automation tools are a time efficient. You will find different kinds of software automation tools, such as Load Runner, QTP, MS Test Manager, Jmeter etc. Selenium webdriver is a one of them. It is most popular automation tools.
Today, I am going to discussed about how to run selenium WebDriver with Nunit and Visual Studio (C#)
- Download Nunit (http://www.nunit.org) and install in your system

- Download selenium web-driver (http://docs.seleniumhq.org/download)

- Open a new project and Create a Class Library


- Add reference webdriver dll (selenium-dotnet-2.35.0 > net40) and nunit dll (Where you installed).

Webdriver dll
Nunit Dll
Or you can add Nunit dll from assemblies > Extension

- When all of this is done and you can start write a code
Point 1:
using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using NUnit.Framework; using OpenQA.Selenium; using OpenQA.Selenium.Firefox; using OpenQA.Selenium.Internal; using OpenQA.Selenium.Support.UI;
Point 2:
namespace Automation
{
[TestFixture]
public class framework
{
private IWebDriver driver;
[SetUp]
public void LoadDriver()
{
Console.WriteLine("Check SetUp");
driver = new FirefoxDriver();
// To Maximise browser
driver.Manage().Window.Maximize();
}
[Test]
public void Login()
{
driver.Navigate().GoToUrl("http://localhost/nopcommerce/login");
Console.WriteLine("Check URL");
// Type UserName
driver.FindElement(By.Id("Email")).SendKeys("admin@yourStore.com");
// Type Password
driver.FindElement(By.Id("Password")).SendKeys("admin");
// Clicked on Login Button
driver.FindElement(By.CssSelector("input.button-1.login-button")).Click();
}
[TearDown]
public void UnloadDriver()
{
Console.WriteLine("TearDown");
driver.Quit();
}
}
}

Above marked area. Just described how you will get id from login page
- Build your application or press (Ctrl + Shift + B)
- You have to run Nunit window to run this code.

- Now, open a project from file menu and choose the project dll file or you can drag and drop the dll.
- Click on ‘Run’ button to define result pass / fail

How to enable FILESTREAM in SQL Server 2008 (After Install)
If you forgot to enable FILESTREAM when install SQL Server 2008.
Don’t worry about it. You can enable FILESTREAM later.
To enable filestream settings:
1. Go to Start menu > All Programs > Microsoft SQL Server 2008 > Configuration Tools > SQL Server Configuration Manager.

2. If asking for user account control then click yes

3. In the list of services, right-click SQL Server Services, and then click Open

4. Now go to Filestream tab and ticked ‘Enable FILESTREAM for Transact-SQL access’.

5. If you want to read and write FILESTREAM data from Windows, click Enable FILESTREAM for file I/O streaming access. Enter the name of the Windows share in the Windows Share Name box.
6. If remote clients must access the FILESTREAM data that is stored on this share, select Allow remote clients to have streaming access to FILESTREAM data
7. Click Apply
8. Go to SQL Server Management Studio, click New Query to display the Query Editor

9. In Query Editor, enter the following Transact-SQL code:
EXEC sp_configure filestream_access_level, 2
RECONFIGURE
10. Click Execute or Press ‘F5’ button
11. Make File-stream access level full

12. Restart the SQL Server service
