In this article, we shall look at something that may not be done as frequently as you would want to. It is Downgrading a SQL Server 2005 from an Enterprise Edition to Standard Edition. First you need to know why such an exercise is carried out any ...

In this article, we shall look at something that may not be done as frequently as you would want to. It is Downgrading a SQL Server 2005 from an Enterprise Edition to Standard Edition. ...

In order to know the SQL Server and Edition details you would be possibly looking at the SQL Server properties and find out the details. Occasionally it might be needed to check the same as part of a job / or a script, you need to query the SQ...

<a href="/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/brumedis...

I agree your thoughts......

I agree your thoughts......

<p>You cannot query the mirrored database. Optionally you can create a database snapshot on that database and query that snapshot to check.</p> <p>You can also check the status using Database Mirroring Monitor..</p>...

I was recently asked by a friend, how to find the names of the nodes that are participating in a failover cluster. The Dynamic Management View sys.dm_os_cluster_nodes will give this information. The following script will return the list of Node names i...

I was recently asked by a friend, how to find the names of the nodes that are participating in a failover cluster. The Dynamic Management View sys.dm_os_cluster_nodes...

This article will guide through the steps to install .NET Framework 3.5 on a Windows Server 2008 R2. I recently installed and started working on a Windows Server 2008 R2 Enterprise. I started installing SQL Server and I knew SQL Server 2008 requires th...