Question: How do you disable a rule in a sealed MP and show that rule is disabled? This is another question that I encountered with OpsMgr aka SCOM 07 (I am counting…!). Facts: 1. All the rules have default Yes/No in the Enabled column. 2. You wouldn’t be able to disable/enable a rule if the [...]
Archive for June, 2009
SCOM: Riding Overrides
Posted in SCOM, tagged overrides, rules on 27 June 2009 | Leave a Comment »
Kill Multiple SPIDs
Posted in SQL Server, tagged scripts on 25 June 2009 | Leave a Comment »
Quite a handy script if you want to clear out ALL spids connected to a database. USE master go DECLARE @dbname sysname SET @dbname = ‘yourdbname’ DECLARE @spid int SELECT @spid = min(spid) FROM master.dbo.sysprocesses WHERE dbid = db_id(@dbname) WHILE @spid IS NOT NULL BEGIN EXECUTE (‘KILL ‘ + @spid) SELECT @spid = min(spid) FROM [...]
Locking Remote Desktop – Windows
Posted in Windows, tagged remote desktop on 18 June 2009 | 4 Comments »
If you have an access to your desktop via a VPN, you’d realise that you won’t be able to lock your desktop remotely using Ctrl + Alt +Del or Windows + L . To work around this issue, the easiest way is to create a shortcut on the remote desktop to lock the work station. [...]
Update Your Bookmark: A New Domain Name
Posted in General on 17 June 2009 | Leave a Comment »
Hi there, thanks for reading my blog! Hope you find the content useful for your day-to-day work. As you know, I am at the early stage of my DBA life and thinking it will be interesting to blog what I learnt over time. Time to get a bit serious, I said and I am taking [...]
Many Ways To Restart An SQL Server
Posted in SQL Server, tagged administration on 10 June 2009 | Leave a Comment »
Here’s my list: 1. By GUI On Object Explorer in SSMS, right click the server then click Restart. 2. By Cluster Administrator Go to Administrative Tools>Cluster Administrator. Click Open. Select Action: Open connection to cluster and type or select the cluter/server name. Click OK. Expand Groups. Select the instance that you want to restart. Right [...]
A SCOM Tale: Alerts Overflow
Posted in SCOM, tagged alerts on 5 June 2009 | 1 Comment »
Some time last year, I had a brief encounter with SCOM. I was happily playing around with it, reading SCOM materials and blogs (Jakub Olesky’s , Kevin Holman’s, etc) and trying on some hands-on materials, such as writing a script with MOMAPI. One day, I was inundated by hundreds of thousands of SCOM alerts. Needless [...]
Altering Table Schema and Schema Ownership – SQL Server 2005
Posted in SQL Server, tagged schema, security on 3 June 2009 | Leave a Comment »
Do you see something like this in your database? DOMAIN\login.myTable Username.myView Username.someStoredProc Sometimes these objects are created ”accidently” under user’s schema. So how do we change it back to dbo or to other schema? ALTER SCHEMA dbo TRANSFER DOMAIN\login.myTable This will alter the schema of myTable to dbo. Want to dig more information for schemas [...]
