List all SQL Servers running on your Domain using a single command

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

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

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)