Welcome to MSMVPS.COM Sign in | Join | Help

SQL Server (RSS)

SQL Server

Remind me to buy some SQL 2005 reading material

Ward Pond's SQL Server blog : SQL Server 2005 Service Pack 1 QFE Rollup Released: http://blogs.technet.com/wardpond/archive/2006/05/22/429859.aspx I don't even have SQL 2005 on my server yet and already they have a SP1 and a QFE rollup.... and that reminds Read More
posted Tuesday, May 23, 2006 8:16 PM by bradley | 2 Comments
Filed Under:

To those in Australia - if your DSL connection is a tad slow

It's just a SQL 2005 SP1 coming down on that pipe is all.... Closet Genius Technology Blog: SQL Server 2005 SP1 via WSUS: http://cgenius.blogspot.com/2006/05/sql-server-2005-sp1-via-wsus.html So if you have all products, all patches syncing... just Read More
posted Tuesday, May 23, 2006 7:03 PM by bradley | 0 Comments
Filed Under:

So how do I go from standard to premium for CRM 3.0?

I've been pinged a few times by folks looking at the CRM 3.0 SBE version wanting to know how to go from Standard to Premium.  They get the Premium CDrom package and want to know if they can go up to Premium without having to reinstall all over again. Read More
posted Tuesday, February 28, 2006 7:19 PM by bradley | 1 Comments
Filed Under: ,

Okay do I need a SQL course or what?

As you have probably seen if you are a follower of the blog... we have had issues with uptime lately and quite frankly I think I need to take a course in SQL server. Given that databases are becoming more and more important lately, I soooooo do not know Read More
posted Wednesday, November 16, 2005 6:30 PM by bradley | 0 Comments
Filed Under:

Coming to a Desktop near you

Today in San Francisco, Visual Studio 2005, SQL Server 2005, and Biztalk Server 2005 launched.  Can't be there?  You can watch it here [in about an hour from when this blog post goes live] And before everyone asks whether SBS gets SQL 2005....from Read More
posted Monday, November 07, 2005 12:21 PM by bradley | 1 Comments
Filed Under:

The migration issue

Richard in the comments brings up an excellent point about databases.  The migration issue.  Historially SQL has been this “thing” that sits over there and some of us use and and some of us don't.  But I think that day of where Read More
posted Monday, October 10, 2005 6:17 PM by bradley | 0 Comments
Filed Under:

You can tell I'm a GUI gal allright...

So Robert recommends that I try this command at the server to see what versions/instances of SQL I have:   osql -S server -U userid -P password -q "select @@version" -o "c:\temp\version.txt"   And you can definitely tell I'm a gui gal as Read More
posted Sunday, August 07, 2005 9:46 PM by bradley | 1 Comments
Filed Under:

Looking at some SQL/MSDE/WMSDE log files

So the other day I was asking how one figured out what was running on what verision of a database.. MSDE or WMSDE...and Chad forwards me this KB about how you can tell which instance is which... BUG: You may not be able to distinguish Read More
posted Saturday, August 06, 2005 5:06 PM by bradley | 1 Comments
Filed Under:

I have no SQL books

I realized today I have no SQL books...no blue with the male hardware tool item on the front... official Microsoft Press... Pocket whatever books... that are specifically about SQL. You see I want to know if there's a way to ...hold your hats on this Read More
posted Thursday, August 04, 2005 5:38 PM by bradley | 1 Comments
Filed Under:

I HATE SQL SERVER!

Okay so maybe hate is a harsh word, but how about severely dislike instead?  We moved over the blogs to a more private SQL server and in the process had to reattach some things.  My SQL server knowledge is about a -5 on a scale of 1 to 10 so Read More
posted Monday, June 20, 2005 5:55 PM by bradley | 2 Comments
Filed Under:

We may be AWEsome but we don't use AWE

On the SQL server sp4 page it lists a warning about patching if you have AWE: Warning: Microsoft has found an issue with the final build of SP4 that impacts customers who run SQL Server with Address Windowing Extensions (AWE) support enabled. This issue Read More
posted Wednesday, May 18, 2005 12:15 PM by bradley | 0 Comments
Filed Under:

Allocated Memory Alert - part deux

You remember my allocated memory alert problem?  My SBS Monitoring would start growing after I rebooted for monthly patches and would just keep notching up until I would get umpteen annoying alerts in the system telling me that something was wrong.  Read More
posted Monday, March 07, 2005 7:03 PM by bradley | 1 Comments
Filed Under:

Allocated Memory Alert Revisited

You remember my allocated memory alert? Got it under control thanks to a newsgroup posting by David Copeland. First off if you are seeing messages like this: Allocated Memory Alert on DOMAIN A large amount of memory is committed to applications Read More
posted Friday, February 04, 2005 7:22 PM by bradley | 10 Comments
Filed Under:

If you are having issues with SQL server and Volume Shadow Copy, you may need this fix

826936 - Time-Out Errors Occur in Volume Shadow Copy Service Writers, and Shadow Copies Are Lost During Backup and During Times When There Are High Levels of Input/Output: http://support.microsoft.com/?id=826936 Read More
posted Sunday, December 21, 2003 7:10 PM by bradley | 3 Comments
Filed Under: ,