Archive

Archive for June 30, 2013

What’s my OS bit LEVEL 32 or 64

June 30, 2013 3 comments

recently I needed to check OS level of few servers   most servers in my environment , I was looking for query I could run from

CMS .. to get a consolidated CentralManagementServerdata from all servers .

I got an initial idea from link .. A big Thanks to Thomas LaRock

I had few servers where DMV or 2005 + onwards features or tables where

not available .. so I have modified Thomas’s script a bit to suit my needs

below script can be RAN on CMS or individual SQL server

output will have Servername, OS bit level,SQL bit level and whether Server

is VM (works for Hypervisor or VM) or Physical

SELECT

@@servername ‘Servername’,

case

when RIGHT(SUBSTRING(@@VERSION,CHARINDEX(‘<‘,@@VERSION), 4), 2)like ’64’ then ’64’

else ’32’

END ‘OS TYPE’,

case

when RIGHT(SUBSTRING(CONVERT(varchar,SERVERPROPERTY(‘Edition’)),CHARINDEX(‘(‘,CONVERT(varchar,SERVERPROPERTY(‘Edition’))), 3), 2)like’64’ then’64’

else ’32’

end ‘SQL TYPE’,

case when substring(@@version,CHARINDEX(‘Hypervisor’,@@version),10)like’Hypervisor’ then ‘VM’

when substring(@@version,CHARINDEX(‘VM’,@@version),2)like’VM’ then ‘VM’
else ‘physical’ END ‘SERVER TYPE’

Version2

let me know if you are facing any issue with this script ..

enjoy 🙂

Advertisements

Installing SQL Server 2014 CTP1 – Step by Step

June 30, 2013 Leave a comment

Getting Started 2014 CTP1 ..

SQLSailor

Great news !!! SQL Server 2014 CTP1 is out and the wait is over. Drop everything(Except the databases !) and download your fresh copy from here.

SQL2014Install16

Here is the official announcement with some high level details.

In this post we will do a quick step by step walk through of the whole install process and see if there are any changes from the prior installs.

* Note  – The below point from the download page should be noted

Microsoft SQL Server 2014 CTP1 is pre-release software and should be installed only on a clean machine. It does not support upgrade from or side-by-side installations with any previous version of SQL Server, including SQL Server 2012.

Below is the step by step install process –

[Please click on the images for a better resolution]

Step 1 –  

We will run the setup.exe to get the regular install screen.

SQL2014Install1

Step…

View original post 215 more words

Categories: INDEXES