Browse by Tags

All Tags » operating systems (RSS)

Bare Metal Restore Part 2

I blogged previously about how Windows 2008 R2 has native "bare metal restore"   http://sqlblogcasts.com/blogs/grumpyolddba/archive/2011/05/13/windows-2008-r2-bare-metal-restore.aspx , see the Core Team's blog post here; ...

Windows 2008 R2 Bare Metal Restore

I don't know how many DBAs work with the o/s but I work at o/s level a lot and currently build our dev servers, a collection of IBM x346, HP DL580s and DL585s. I'm currently working through rebuilding them with windows 2008 R2 and I've been...

Do you manage your SQL Server with rdp sessions?

I was just having a catch up on FeedReader and I found this gem from the Windows Cluster Team http://blogs.msdn.com/b/clustering/archive/2010/06/23/10028855.aspx If you use rdp sessions and currently manage them with remote desktop manager I think you'll...

Why do I bother with RAID 10 ?

Before I post anything I just want to clarify what I mean by RAID 10 , this is sets of mirrored pairs that have been striped as against a RAID 0 which has been mirrored. I've just had a disk failure in the data array for one of my dev servers, it's...

Setting Environment variables

Now you may well ask what on earth windows server environment variables have to do with SQL Server, and it's a fair question and only relevant in certain circumstances. I'm currently running a series of replay profiler traces on a server, I need...
Posted by GrumpyOldDBA | with no comments

How to determine that hardware DEP is available and configured on your computer

Well here we are again with another post I’d been saving up until I resolved the images issue. DEP and how it affects memory on your SQL Server!!! Microsoft KB: 912923    MICROSOFT KB: 875352 ===========================================...

x64 Memory Problems

(  I’m hopeful that Livewriter will enable me to publish a blog post which includes screen shots as this one has a large number! ) Please READ everything and the documentation with the download before you install this I’ve blogged about memory issues...

NTFS Fragmentation may be more harmful than you think

I’ve posted previously about the adverse affect of ntfs fragmentation and I’ve also mentioned that it is sometimes suggested that fragmentation is not a concern on a SAN. I’ve yet to finish testing this on a SAN, after all you don’t often get a free play...

Cannot generate SSPI context

Now here's a slightly interesting point about this error. Although the kb does actually mention this reason for the error it is about the last thing on the article, a footnote, and it doesn't specifically word it to cover this scenario, and we...

Dates - especially when SQL Server can't be British!

Just like memory config dates never seem to go away and I've had some discussions with our BI team recently on why things were not working quite as expected, especially on the 13th of the month; and I noticed the same issue had arisen for a member...
More Posts Next page »