navigation

• Home
• SQL Server DBA
• Oracle DBA
• MySQL DBA
• Latest Articles

Partners

• Florida SEO
• Real Estate SEO
• SM SOFT Online
• SM SOFT

QUICK Tip

To connect to Windows Server based computer console remotely, use "-console" switch with remote desktop client. Example: mstsc -v:ServerName /F -console You can use RUN or command prompt to type the command, this will connect you to console directly

Applies To: Windows Server Remote Desktop

articles - tips & tricks

Search

Search Query :

Select Category : -- Select One -- SQL Server --> Commands --> Administration --> Performance --> Concepts Oracle MySQL --> SQL Scripts MS Access .NET Framework --> Visual Studio 2005 PHP TSQL Scripts Database General --> Data Warehouse Products --> .NET Gauge (Optional)

Select a Categories

SQL Server Oracle MySQL MS Access .NET Framework PHP TSQL Scripts Database General Products

 

Articles

sql server database on UNC network drive trace flag 1807

sql commands

401 unautherized access asp.net and sql reporting services when accessing on remote server

load sample data in sql server table for testing

Finding Missing Primary Keys in SQL Server

database standards for object naming conventions

b-tree indexes clustered and nonclustered

check if file exists in sql server

normalization and good table design

find duplicate records to delete or update in sql server

sp_pkeys and sp_fkeys to find primary keys and foreign keys

determine if number is odd even in tsql sql server

view database restore history in sql server

learn how to be a sql server dba

view sql server work load processes running

get dbid or database name in sql server

sql server case sensitive search compare

change ownership of objects in sql server

view indexes in sql server

sql server dba developer interview questions and answers

View connections threads in mysql SHOW PROCESSLIST

mysql with nolock

find list all user tables objects in sql server

find duplicates using sql

sql server database status DataBasePropertyEX

 

SQL Server DBA

I am a SQL Server DBA with almost 9 years of experience in database technologies.

Right now I am in process of redesigning this website in ASP.NET 2.0 and AJAX. The main purpose of new SQL DBA website is to offer more help to database professionals and make it easy for me to update contents on regular basis.