Blog Detail

SQL Solace

SQL Solace

http://sqlsolace.blogspot.com/

SQL Solace, a blog by a DBA and database developer

subscribe Recent Posts

  • Bookmark : How to build and maintain a tiered WSUS infrastructure

    Posted on Wednesday December 16th, 2009 at 02:34 in systems, wsus, windows 2008

    Could have done with this a couple of months back...How to build and maintain a tiered WSUS infrastructure...

  • SQL 2008 Management Datawarehouse : CU 5 Fix

    Posted on Sunday December 6th, 2009 at 17:56 in sql 2008

    I wasted a lot of time originally trying to get the SSIS data collectors functioning consistently in the MDW.Therefore i'm happy to see this fix...http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/e1aa9f08-2239-4c0b-b902-b19b8693a799...

  • Bookmark : How To Create tables in Blogger via Excel

    Posted on Thursday December 3rd, 2009 at 17:27 in blogging, bookmark

    This link shows how to apply a style to a DIV and prevent tables expanding.http://www.mt-soft.com.ar/2008/12/06/how-to-create-tables-in-blogger/I found the easiest way to generate a clean table structure (i.e. without the styling info that a MS Word ...

  • SQL 2005 Express Edition - No Sql agent!

    Posted on Thursday December 3rd, 2009 at 17:24 in sql 2005

    I've never had a cause to look at the Express edition of SQL 2005 until today.My suprise finding (and reason for this post) is that there is no SQL Agent!Google brings back no end of third party solutions however...http://www.microsoft.com/Sqlserver/...

  • SSIS : Credential & Proxy

    Posted on Monday November 16th, 2009 at 09:46

    USE [master]GOCREATE CREDENTIAL [SSIS_Credential] WITH IDENTITY = N'Domain\SQLServiceAgent', SECRET = N'longcomplicatedpassword'GOUSE [msdb]GOEXEC msdb.dbo.sp_add_proxy @proxy_name=N'SSIS_Proxy',@credential_name=N'SSIS_Credential', @enabled=1GOEXEC...

  • SQL 2008: Modifying Resource Governor\'s workload classification

    Posted on Sunday November 15th, 2009 at 15:15 in resource governor

    How to change Resource Governor Classifier function on the fly...Here's the TSQL >-- 1) Disable Resource GovernorALTER RESOURCE GOVERNOR DISABLE GO-- 2) Remove the classifier function from Resource Governor so that you can change itALTER RESOURCE GO...

Comments & Reviews

There is no rating for this blog because there are no comments yet.

Post A Comment/Review

* Your IP is being logged.
* Your e-mail address is used only for verification purposes only and will not be sold, or shown publicly.
* No HTML tags allowed
* DO NOT use the Comments/Reviews to promote your own site.

Name: or Login
E-mail:
Rating:
Verify: Spam Protection: sum of 3 + 3
Comment:
  Remember Information