Main menu


Database cannot be opened due to inaccessible files or insufficient memory or disk space

Database cannot be opened due to inaccessible files or insufficient memory or disk space Msg 945, Level 14, State 2, Line 1 Database ‘database’ cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL…

Sector19 Windows10 Image

Features will amaze you in windows10

Microsoft announced it’s next windows release windows10 and it’s preview available for download.  Microsoft’s window10 will run on many Microsoft devices including desktop, mobile, tablet and servers. Microsoft windows10 bring really some cool features, let’s dig deeper into it.. 1.…


Installing LAN drivers for Windows Server on Intel Desktop PC

I have installed Windows server 2012 on my Intel Desktop DH61WW Board with Core i5 processor. With windows 8 everything was working fine but after installing Windows Server LAN driver become unavailable. I have downloaded LAN driver from Intel website…

Sector19 Database ICON

Database administration tricks

Here are some of my routine database scripts, collected from various sources. This can help database administrators to do day to day jobs. Finding the health of MSSQL server.       Find SQL Server information //Check SQL server edition…


Windows Shortcuts Commands CheatSheet

Windows shortcut command help users to work faster and efficiently compare to navigate.  Here are some of useful shortcut command which help you in day to day administration. Windows Shortcuts Commands CheatSheet was last modified: March 2nd, 2016 by zolan…

Sector19 Microsoft Logo

Kill all process of a program Windows

Many times you face a problem like multiple process of chrome browser and when you kill a process from task manager other process of same program still persist. You need a way to kill all process at once. If you…


SQL server: shrink database files

I have just notice today that i am getting low disk space and after some digging i found that one of my database log consuming 20GB of disk space. MSSQL Database having default recovery model of full. What does it…


MSSQL Developement: TSQL cursor tutorial with example

What is cursor: In TSQL cursor process the one row at a time in set of records. Let’s check sysntex for detailed information . — Declare cursor variable and store set of records on it. DECLARE [CursorName] CURSOR FOR [SelectStatement…


MSSQL all database backup and restore script

Database maintenance not always easy and must always prepare for disaster. If we have thousand of databases and we are planning to migrate then or just trying to recover from a disaster we need a way. This script will simply…


MSSQL Developement : Basic Transact-SQL Query

CREATE DATABASE WinDB; EXEC sp_databases; USE WinDB; CREATE TABLE WinDBUsers (id int, name varchar(20), email varchar(20)); EXEC sp_tables ; SELECT * FROM sys.tables; EXEC sp_columns WinDBUsers; ALTER TABLE WinDBUsers ALTER COLUMN name nvarchar(100); ALTER TABLE WinDBUsers ADD lastname varchar(20); INSERT…