Latest Contents

restrict mysql user to one database

rename sql server database

check verify email address and validation

calculate age in vb.net

get host name from ip address in vb.net

SQL Server Data Types 2000, 2005 and 2008

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

view database connections in sql server

SQL DBO SQL Server Database Object Owner dbo

generate a random number in SQL Server RAND()

connecting to mysql using php

benefits of data warehouse

what is data warehouse

convert datatime to date only in tsql sql server

tsql script waitfor delay and waitfor time in SQL Server

ROW_NUMBER and OVER in SQL Server Paging

truncate table in MySQL

LIMIT in MySQL SELECT Statement

creating ascending and descending indexes

How to identify your SQL Server version and edition

visual studio intellisense not working solution

difference between unique and primary key constraints

SELECT Statement


Advertisements

MySQL HOSTING
MySQL hosting provider, clustering and replication supported. DBA Services Included.

SQL SERVER HOSTING
Reliable, powerful SQL Server 2008 hosting with ASP.NET on Windows 2008 Servers.

SQL Server DBA

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

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