Ramblings of a DBA

Tara Kizer
posts - 166, comments - 837, trackbacks - 75

My Links

Advertisement

News

Subscribe
Search this Blog

Archives

Post Categories

Work

August 2008 Blog Posts

How to run a process using different credentials

There are times when I need to run some process using credentials other than my current security context, such as when my userid doesn't have permissions to a remote resource but another userid does.  I can easily do this interactively via the "Run as..." option (right click a process and then enter credentials) or via the runas command in a cmd window.  The problem with these though is that I have to type in a password, which creates a problem when I want to do this as a scheduled job.  In the past, I've written a batch file to map...

posted @ Monday, August 25, 2008 2:34 PM | Feedback (3) | Filed Under [ Other ]

Backup SQL Server Databases

EDIT: There is a new version of this stored procedure. I've made several changes to my backup stored procedure, isp_Backup.  I fixed a few things and added some much needed features.  Here are all of my changes: Fixed the retention code so that only those files that pertain to the type of backup are deleted.  I had previously decided that I wanted all files older than @retention to be deleted, however I've changed my mind due to requests from my blog readers. Added support for database names with spaces, dashes, single quotes, and other...

posted @ Tuesday, August 19, 2008 2:09 PM | Feedback (12) | Filed Under [ SQL Server - Database Administration ]

1-click installation for SQL Server 2005 - FineBuild

Has anyone used SQL Server FineBuild before?  According to the web site, it "provides 1-click install and best-practice configuration of SQL Server 2005."  It doesn't mention anything about clusters though, which is what I'd be interested in as installing SQL Server on a cluster is a bit of a pain.  Do you know of other tools that simplify the installation of SQL Server?  Do they work on clusters?

posted @ Wednesday, August 13, 2008 2:41 PM | Feedback (2) | Filed Under [ SQL Server - General ]

SQL Profiler best practices

SQL Profiler is a great tool that allows you to see what's going on inside SQL Server.  You can find out what your worst performing queries are, how often a query is executed, and loads of other stuff.  I'm typically interested in the things that are impacting performance such as long durations of stored procedures. One important thing to know when running a trace using SQL Profiler is that the trace can degrade performance.  To minimize its impact, you should follow these best practices: Never run SQL Profiler on the database server ...

posted @ Wednesday, August 06, 2008 5:36 PM | Feedback (6) | Filed Under [ SQL Server - Database Administration ]

How to get physical CPU count on a server

With hyper-threading and multi-core CPUs, it isn't easy to find out how many physical CPUs (or sockets) there are on a server. Recently we were given such a task to ensure we were properly licensed.


Read more here.

posted @ Tuesday, August 05, 2008 9:48 AM | Feedback (2) | Filed Under [ SQL Server - Database Administration ]

OT: Kevin Bacon Theory

Microsoft "confirms" the small world theory. We are linked by 6.6 degrees of separation.


Read more here.

posted @ Saturday, August 02, 2008 5:58 PM | Feedback (1) | Filed Under [ Other ]

Powered by:
Powered By Subtext Powered By ASP.NET