Sometimes you want to find all the SQL servers running on your Domain with one quick command. SQLCMD providess facility to do so. Your client workstation should have Microsoft SQL server client installed on it for SQLCMD to work. 1. Go to Command Prompt. If you are on Windows Server 2008. Right Click Command Prompt … Continue reading List all SQL Servers running on your Domain using a single command
SQL 2005
Search a specific column name in all tables SQL Server
SELECT name FROM sysobjects WHERE id IN ( SELECT id FROM syscolumns WHERE name = 'COLUMN_NAME' ); SELECT name FROM sysobjects WHERE id IN ( SELECT id FROM syscolumns WHERE name like '%COLUMN_NAME%' );
Mutiple Inserts. Normal method VS Union ALL method
I know the eternal war between DBA’s and Developers rages on :D, While most developers prefer to make multiple inserts. DBA’s always use UNION all. While highly debatable which is fast performance wise. But if you are doing thousands of insert’s UNION ALL is definitely faster. I have narrowed down inserts from 40 second to … Continue reading Mutiple Inserts. Normal method VS Union ALL method
Error : the RPC security information for the publisher is missing or invalid
This is genereally an error which will be throw when you have a replicated set of data in SQL Server and if you are trying to perform a DML statement on the table it gives this error. This error is generally related to network transaction in DCOM service in Windows. To allow the network transaction, … Continue reading Error : the RPC security information for the publisher is missing or invalid
Access Oracle tables from SQL Server 2005
In a heterogeneous environment it sometimes becomes necessary to access information across different database. In this exercise I will demonstrate how you can access Oracle db tables in SQL Server 2005. 1. First you need to install Oracle client on the SQL server 2005 server. You can install using the instant client option. I am … Continue reading Access Oracle tables from SQL Server 2005
Find Duplicate Records in SQL Server
Microsoft SQL Server tables should never contain duplicate rows, nor non-unique primary keys. For brevity, we will sometimes refer to primary keys as "key" or "PK" in this article, but this will always denote "primary key." Duplicate PKs are a violation of entity integrity, and should be disallowed in a relational system. SQL Server has … Continue reading Find Duplicate Records in SQL Server
Automate and Improve Your Database Maintenance Using Ola Hallengren’s Free Script
One of the most amazing SQL Server script available for maintenance tasks on SQL Server 2005 and onwards. The scripts are much better than the maintaince task wizard which comes along with SQL Server 2005. A must have for novice as well as experienced DBA's. Read More..
Managing Transaction Logs
What is the Transaction Log? At its simplest, the transaction log is a log of all transactions run against a database and all database modifications made by those transactions. The transaction log is a critical part of the database’s architecture. The transaction log is not an audit log. It’s not there so that the DBA … Continue reading Managing Transaction Logs
Microsoft SQL Server for Oracle Professionals.
Database Architecture In Oracle, a database refers to the entire Oracle RDBMS environment and includes the following components: • Oracle database processes and buffers (instance). • SYSTEM tablespace containing one centralized system catalog, which is made up of one or more datafiles. • Other optional tablespaces as defined by the database administrator (DBA), each made … Continue reading Microsoft SQL Server for Oracle Professionals.
A connection was succesfully established with the server but then an error occured during pre-login handshake(provider SSL ,error:0)
You get an error in SQL Server 2005 like: A connection was succesfully established with the server but then an error occurred during pre-login handshake(provider SSL ,error:0).................. Most likely you cant connect to management studio. In this scenario sometimes you can make remote connections from another client. The easiest solution is to run "cliconfg.exe" network … Continue reading A connection was succesfully established with the server but then an error occured during pre-login handshake(provider SSL ,error:0)
SimpleSQLDBA | Shadab Mohammad 