Category Archives: System/DB Administration

Internal SLAs

Posted on October 31, 2013 by pfb_admin

Thanks to Google, here are some interesting links regarding internal service level agreements: http://www.bhconsulting.ie/Developing%20an%20Internal%20SLA.pdf http://en.wikipedia.org/wiki/Service-level_agreement http://pic.dhe.ibm.com/infocenter/tivihelp/v49r1/index.jsp?topic=%2Fcom.ibm.mbs.doc%2Fsla%2Fc_types_slas.html But off late a radical sildenafil overnight treatment was prescribed to manage Type 2 diabetes in men. The other day this couple lost their … Continue reading →

Posted in Business, System/DB Administration | Leave a comment

Slow-growing SQL Server transaction log

Posted on September 17, 2013 by pfb_admin

Our MES system has a reasonably-sized transaction log; 9GB for a 3GB primary database. This is somewhat larger than normal recommendations (1.5x), but we import large volumes of batch data each morning which increases the number of transactions and pushes … Continue reading →

Posted in SQL Server, System/DB Administration | Leave a comment

Replacing SSMS

Posted on August 19, 2013 by pfb_admin

Phil Factor’s thought-provoking article “Cold Turkey with SSMS” on a way to replace SQL Server Management Studio: https://www.simple-talk.com/blogs/2008/10/14/cold-turkey-with-ssms/ I am in a position where it would be NICE to have a replacement for SSMS, but I lack the time and budget to build or buy a … Continue reading →

Posted in C#, Office, Programming, SQL Server, System/DB Administration | Leave a comment

stdole.dll in the GAC

Posted on July 31, 2012 by pfb_admin

Let’s say you’ve got a utility suite that uses Office Interop for a subset of functionality. Let’s say that you have a variety of computers, some of which have Office installed and some of which do not. Let’s say that you use … Continue reading →

Posted in Office, Programming, System/DB Administration | Leave a comment

Uptime in Windows

Posted on October 31, 2011 by pfb_admin

I guess I haven’t looked for a script replacement for UPTIME.EXE in a few years. On Windows XP and Vista and Windows Server 2003 (R2): Systeminfo | find “Up Time” On Windows 7: In that case, couples need to go … Continue reading →

Posted in System/DB Administration | Leave a comment

Make a printer compatible with a wireless network

Posted on February 15, 2010 by pfb_admin

I was asked, “How do you make a printer compatible with a wireless network like the one at your house?” This information might be useful to others, so I’m posting my response: You have 2 options, both of which I … Continue reading →