E-Bitz - SBS MVP the Official Blog of the SBS "Diva"

A polite service pack

Well that's a polite service pack now isn't it? SQL 2005 sp1 just warning me that it has files in use and needs me to shut down services if I want it to not make me reboot. Share this post: email it! | bookmark it! | digg it! | live it! Read More...

Filed under: SQL Server

2006 10 4

Shoot I just realized.... I'm behind a service pack

I just realized that the SQL 2005 workgroup that I have on my server is now behind a service pack and I need to upgrade it to SP1...but... I think I'll visit a locksmith first and get an additional office key made.. don't ya think? http://www.microsoft.com/sql/sp1.mspx Read More...

Filed under: SQL Server

2006 10 2

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...

Filed under: SQL Server

2006 05 23

2 Comments

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 be Read More...

Filed under: SQL Server

2006 05 23

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. ...and Read More...

Filed under: News, SQL Server

2006 02 28

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...

Filed under: SQL Server

2005 11 16

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 the web Read More...

Filed under: SQL Server

2005 11 7

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 we really don't Read More...

Filed under: SQL Server

2005 10 10

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 I screwed something Read More...

Filed under: SQL Server

2005 08 7

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 between instances Read More...

Filed under: SQL Server

2005 08 6

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...

Filed under: SQL Server

2005 08 4