Welcome to Home of SQL DBA GURU
SQL DBA Guru website is just a hobby site. I have several years of experience in Information Technology industry specially in databases and application development. SQL DBA Guru is not a commercial website and not registered as a business any where atleast i don't know. :)
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