Welcome to BrianDesmond.com Sign in | Join

Browse by Tags

All Tags » SQL2000/Databases   (RSS)

Installing MOM 2005 on SQL 2005 x64

Microsoft claims that MOM 2005 with SP1 supports installing to SQL 2005. This is actually true, however none of these articles make reference to the fact that the tools on the MOM CD (either momcreatedb.exe or the setup wizard) will correctly create the Read More...
Posted Friday, December 15, 2006 9:17 PM by Brian Desmond | 0 Comments
Filed under: , ,

Site Move/Upgrade

I decided to get a box, actually a virtual server over at www.bitshop.com . I'm in the process of getting that all squared away and working, and then I'm going to swing this site over, and hopefully in the process upgrade the blog software and get rid Read More...
Posted Saturday, December 03, 2005 4:09 PM by Brian Desmond | 0 Comments

SQL Clusters - Changing the group VIP

A tidbit I learnt the hard way last week about changing the VIP for a SQL resource group - changing it in the MSCS console is not the way to do it. You have to run the SQL installer, put in the name of the virtual server you want to change the IP of, Read More...
Posted Wednesday, June 29, 2005 3:21 AM by Brian Desmond | 0 Comments
Filed under: ,

Gotta Update this thing

I'm so behind on so many things, this site being one of them. I've got a lot going on right now and my hope is that I can spin some good content out of it. I'm up to a lot of AD stuff - provisioning, management, etc. Got a ton of Sharepoint flying around Read More...
Posted Sunday, June 19, 2005 12:51 AM by Brian Desmond | 0 Comments
Filed under: ,

Back!

My server amchine that I ran this site off of from the house lost its motherboard a few weeks ago. I've been so swamped I still haven't fixed it. To make things easier, I've moved the site off to a shared host instead. Hopefully will have some time to Read More...
Posted Monday, May 16, 2005 5:40 PM by Brian Desmond | 0 Comments

MSDE Deployment Kit

MS has posted an add-in for VS.Net which will allow you to package MSDE into setup & deployment projects, it appears. Here's the info on it: Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Deployment Toolkit (Release Candidate) The MSDE 2000 Read More...
Posted Saturday, December 13, 2003 10:32 PM by Brian Desmond | 0 Comments

Cool Word Tables Trick

I wanted to print out a table form of some data I copied out of SQL EM and into Word. EM just sends text and column headings, so, it looks pretty dissheveled. However, if you select all the data in Word, and then press the Table toolbar button, Word will Read More...
Posted Thursday, November 27, 2003 3:37 PM by Brian Desmond | 0 Comments
Filed under: ,

ASP Enterprise Manager: Help Wanted

I've posted a want ad on SourceForge.net for someone to help connect the v1 GUI with the v2 code, and debug. ASP.Net, VB.Net, and basic SQL skills are necessary. The graphics are done, having a copy of SQL Enterprise Manager is extremely useful, but not Read More...
Posted Sunday, October 26, 2003 3:10 PM by Brian Desmond | 1 Comments

Pick 4 MS Press Titles

I've been tasked with picking out four books from MS Press. What do you all recommend? I'm mainly looking at High - Mid Level .Net, High Level Win Server stuff, General/Adv SQL Server, & General/Adv Exchange Server. Thanks! Share this post: email Read More...
Posted Saturday, October 25, 2003 11:12 PM by Brian Desmond | 0 Comments

ASP Enterprise Manager

Ashutosh Nilkanth : “The first is Web Data Administrator (from Micorosft) and the other one is ASP Enterprise Manager . Both are great for basic web-based database administration (i.e. creating tables, SP's, managing users etc.). As a side note, I don't Read More...
Posted Sunday, September 28, 2003 11:30 AM by Brian Desmond | 0 Comments

New Content Source

Well, I've got a new source of content: Interesting problems people Google for, click through to my blog, and don't find anything. It seems I have a couple of long posts with lots of tech keywords (my rant on ms blaster, and my introductory post). It Read More...
Posted Wednesday, September 17, 2003 10:20 PM by Brian Desmond | 0 Comments

Password Encryption - in your SProcs!

Whilst working on the login system for a now complete project, I learnt about a couple of unsupported but useful functions in sql - pwdencrypt and pwdcompare. SQL uses these to 1-Way hash passwords. Here's an example of how to use them: You'll want a Read More...
Posted Friday, August 15, 2003 11:33 PM by Brian Desmond | 1 Comments

SQL Error #5177

The other day, I seriously locked down the drive I keep my SQL & Web data on, to the extent, that I granted solely Domain & Enterprise Admin rights to the root drive, and explicitly gave the Network Service account (for IIS) permissions on wwwroot, Read More...
Posted Sunday, August 10, 2003 11:32 PM by Brian Desmond | 1 Comments
Filed under: , ,