March, 2009

Consider the following Scenario, You are using SQL Server 2008 Enterprise edition RTM or higher version and you are Transparent database encryption (new feature introduce in SQL Server 2008) to encrypt the Database to be mirrored. The database encryption...

Part2 In the part1 we discussed the basic difference between encryption and hashing. So now let’s look into how we can implement hashing and encryption using the SQL server functions. We have a function called the “HashBytes” function which performs the...

  When I first looked at encryption and hashing I found it to be the same. It was confusing. So here we would be discussing two topics 1) the basic difference between encryption and hashing. 2) How do we implement encryption and hashing in SQL server...

While using Logshipping, if a servername for monitor is used which is other than the @@servername output, for example an alias, the transaction log shipping status report on the monitor server will NOT show any information about the primary and secondary...

Well I’ve looked around in our blog and it pained me to see there were no posts on Full Text Search; an often misunderstood and under-utilized feature that SQL Server provides. Wait no more, here comes the first one (of many I hope) :) . In this post...

The SQL Server instances are independent and do not know each other. The method is to query the registry to find the instances. You can use the following Script to list all the installed sql server on the server using TSQL Solution ======...

Setup is always known to have a mind of its own; this blog is meant to demystify this process. We are specifically talking about SQL Server 2005 Setup on a cluster. It has been observed that the installation of the SQL server 2005 instance on the cluster...

Performance Monitor Counters has always been the "Bread and Butter" for System Engineers and Administrators alike. With each new version of Windows, Microsoft has always improved on and provided a "better than ever" performance monitors. With the performance...

We have seen a couple of cases, wherein we are unable to create maintenance plan or DBMail Fails after applying SP on SQL Server 2005 failover cluster instance running on Windows 2008 Cluster . Resource Database and other system databases may not be...

The Field Terminator specified in the BCP command changes to a different character than specified. This occurs when the bcp command is run in a batch file. The bcp works as expected when it’s run directly in the command prompt. In our example the section...

Have you ever wondered if there is a programmatic way to detect all the SQL server instances and services installed on a machine. Well, worry no more as the code below will do exactly that. There are 2 ways to go about this : Method 1 – For the Programmer...

There are quite a few blog posts out there to manage SQL Server 2005 services using the :\\.\root\Microsoft\SqlServer\ComputerManagement\ However, WMI Admin Provider is not pre-installed for SQL Server 2000. It needs to be installed separately using the...

The default database role members are not scripted when we use the "Generate Script Wizard" Cause ====== This is an issue with the Generate Script Wizard code . It considers the rolemember as a part of Permissions for the Role and hence scripts...

We have observed a number of cases where Sql Server resource fails to come online on Windows 2000 Cluster after applying a security patch. As mentioned in my previous posts whenever a sql server resource fails to come online we should start by checking...

When we use the Microsoft OLEDB provider for DB2 from the Feature Pack for Microsoft SQL Server 2005 in SSIS connection manager and set the component level or package level Transaction option to Required. The package execution fails with the error below...