database free space

select name, filename, CONVERT(decimal(12,2),round(a.size/128.000,2))as FileSizeMB, CONVERT(decimal(12,2),round(fileproperty(a.name,’SpaceUsed’)/128.000,2))as SpaceUsedMB, convert(decimal(12,2),round((a.size-fileproperty(a.name,’SpaceUsed’))/128.000,2))as FreeSpaceMB from dbo.sysfiles a

manually failover

http://www.sqlservergeeks.com/sql-server-failover-cluster-initiating-manual-failover/ Expand Services and Applications & select SQL Server service. You should  be able to see the current owner of the service. In my example below, node1 owns the service. Right click the service and click on the options as shown in the image… You…

Config SSL for SQL Server

https://technet.microsoft.com/en-us/library/ms189067(v=sql.105).aspx The following procedure describes how to configure SSL for SQL Server. To configure SSL 1. Install a certificate in the Windows certificate store of the server computer. 2. Click Start, in the Microsoft SQL Server program group, point to Configuration Tools, and then click…