Book Review – DBA Survivor: Become a Rock Star DBA
Hi there,
check out Garland MacNeill’s review of Thomas LaRock’s
new book called “DBA Survivor” … which targets all aspects of
DBA’s duties …and Thomas own journey as a DBA ….
should be on your MUST READ list for the year …as its on mine !!!!!!! 🙂
http://www.nyteshades.com/dba-survivor-become-a-rock-star-dba/
Thomas LaRock’s link
error while Creating an instance of the COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2}
Hi There ,
got below error while trying to EDIT a job which .. i have created and edited few times earlier..
COMPLETE Error –> TITLE: Microsoft SQL Server Management Studio
——————————
Creating an instance of the COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2} from the IClassFactory failed due to the following error: c001f011. (Microsoft.SqlServer.ManagedDTS)
——————————
ADDITIONAL INFORMATION:
Creating an instance of the COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2} from the IClassFactory failed due to the following error: c001f011. (Microsoft.SqlServer.ManagedDTS)
——————————
BUTTONS:
OK
——————————
it turns out that few people already faced this issue and reported on below connect linK
My SSMS and Shared features as below ::
Microsoft SQL Server Management Studio 10.50.1617.0
Microsoft Analysis Services Client Tools 10.50.1617.0
Microsoft Data Access Components (MDAC) 3.85.1132
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 8.0.6001.18702
Microsoft .NET Framework 2.0.50727.3634
Operating System 5.1.2600
Solution : Try any one of the below workaround as your environment permits (as no single one has worked for all)
(Restarting the SSMS is what works as the first solution … but as we may have few scripts already typed in SSMS .. we would prefer a longer fix)
1> Run your SSMS as administrator
2> disable UAC
3> if on SQL2008 .. then install SP3
4> if using SQL 2008 R2 .. then install SP1
related post :: http://support.microsoft.com/kb/2315727/en-us
hope this is helpful to you 🙂
corrupt allocation pages
Hi There ,
its heck of a pain to restore ,recover or do page level restore allocation pages and you have no other option other then doing a clean restore of your database ..
some people can do a HEX editing on the file ,but that’s not recommenced
for more info Check out DAVIS site .. and his 30 day series on Disaster and recovery
Enjoy 🙂
list of all SQL SERVER MVP till date
Hi There,
check below link about all our SQL SERVER MVP’s ,their blogs links and much more …
http://mvp.microsoft.com/en-us/mvp/search-mvp.aspx?ty=a&ex=SQL+Server&sc=n
http://mvp.microsoft.com/en-us/default.aspx
MVP’s are great asset for the community and great role models for junior’s ..
they share their learning and experiences without holding anything back …
A BIG CONGRATULATION to ALL MVP’s for the year 2013 ..
ENJOY 🙂
Check out SQLSERVER-Performance-Tuning blog
Hi All,
Check out below Link for all latest trends and news on SQL SERVER Performance
tuning ,its an unique efforts in GULF and MIDDLE EAST ,
do join the subscription list and stay updated with latest blog-post ,,, ENJOY 🙂
http://sqlserver-performance-tuning.net/
SQL Server Performance Tuning is a specialized SQL Server community fully of several rich blogs ,videos tutorials , offline and online event for widely concerned topics on Microsoft SQL Server like T-SQL performance optimization , Data Warehousing solutions, Replication Solutions , DMV library ,new SQL Server 2012 features ,index tuning , heavy locks and deadlocks ..etc
Stay motivated !!!!!!!!!!!!
We often loose sight of our goals and tend to follow the trends or life style lived
and embraced by closed and dearest friends .. below Video boost your nerves to stay focused
on what you want … AS “WHAY you FOCUS on ……GROWS”
so stay focused on what you want .. and see the effect of conscious /deliberate thoughts ..
taking you closer to what you want ENJOY 🙂
Related articles
- Help! Motivation needed! (bpinks3.wordpress.com)
- How To Self Motivate (projecteve.com)
What’s my OS bit LEVEL 32 or 64
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 
data 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’
let me know if you are facing any issue with this script ..
enjoy 🙂
Installing SQL Server 2014 CTP1 – Step by Step
Getting Started 2014 CTP1 ..
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.
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.
Step…
View original post 215 more words
Amazing SQL server tools every DBA must have!!! – Part 2
Amazing SQL server tools every DBA must have!!!
SQL DBA learning curve 
