Kevin Remde's IT Pro Weblog
SQL Server 2005 Tidbit 026
This tidbit comes as an answer to a really good question asked at a recent TechNet Event:
“If I’m running SQL Server 2005 Standard Edition, and I use the Database Engine Tuning Advisor, will I see Partition options available?”
This quesiton came about mainly because partitioning is available SQL Server 2005 Enterprise Edition, but not Standard. The answer is that the Tuning Advisor will simply not make partitioning suggestions on Standard Edition.
Got an IT question? Give me a comment, or contact me.
Fresh out of the oven
Get the SQL Server 2005 September Community Technology Preview.
Microsoft Word came out 22 years ago today.
Microsoft Introduces Word9/29/83 Microsoft introduces its full-featured word processing program, Microsoft Word for MS-DOS 1.00. PC World subscribers receive a free demonstration floppy disk of Microsoft Word in the magazine's special Software Review. "This is the first time in the history of publishing that a magazine has featured a floppy-disk bind-in," said David Bunnell, Publisher of PC World.
(And on a related note, today is the 21st anniversary of my marriage. Wow. Our marriage is of legal drinking age here. …and it’s 5:00 somewhere…)
…and there aren’t any!
That’s right. Today is “Patch Tuesday”. <sigh> Just where did the month go?
There are no Security Updates this month. No new security bulletins. None. Zip. Zilch. Nada.
“Well… is there at least something?”
Yes. There’s a new version of the Malware Detection/Removal tool. And there’s a “high priority, non-security related update” (KB891861) now being made available via Windows Update, Microsoft Update, Software Update Services, and Windows Server Update Services.
Once again, that’s WU, MU, SUS, and WSUS. PDQ.
**Obscure Steve Martin movie reference.
Yessir! That was the rumor, anyway, according to a Business Week article last week.
And that rumor was confirmed.
Check out the press conference announcement here.
I'll add a link to the artlcles when they're available.
September 26, 2005Strategic alliance to accelerate the Smartphone market segment with a new device for mobile professionals and businesses.More...
With all the focus on SQL Server 2005 our team has been doing lately, I was very glad to find this web site. The team that builds the SQL Server engine has a blog of their own: SQL Server Engine Tips.
One post in general got my attention – the team is requesting your feedback on Database Mirroring. In fact, they’re even providing scripts you can use to play with Database Mirroring and familiarize yourself with it.
Here is their “Feedback requested on database mirroring” post. Help ‘em out!
SQL Server 2005 Tidbit 013
Credit for this one goes to my friend and teammate Matt Hester...
Q: How do I upgrade SQL 2005 beta to the Full SQL 2005?
A: There will not be a setup-based upgrade from preRTM to RTM. You will need to un install the preRTM and then install RTM. The un install will not remove your user databases. Once you reinstall you can connect those databases to the new install. They will automatically upgrade when they're installed. One word of caution: it's best to move between the same editions (i.e. Beta -> Developer, Standard -> Standard, etc).
SQL Server 2005 Tidbit 016
(Warning: Old song reference)“You (up)load 16 tidbits… whaddya get?…”
Q: How do you resync in a peer to Peer replication?A: There is a restarable synch capability built into the replication engine, There is a great Q/A log here:http://msdn.microsoft.com/SQL/2005/2005Webcasts/ReplicationQandA.aspx
Also you can view an awesome replication web cast here: http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032263302&EventCategory=5&culture=en-us&CountryCode=US
XBOX 360 will be in stores November 22nd (two days before Thanksgiving) in North America. Launch in Europe is December 2nd, with a December 10th launch in Japan.
SQL Server 2005 Tidbit 017
Number 17 Tidbit here…
Wouldn’t you like to have the installable ‘books online’ for the next version of SQL, Microsoft SQL Server 2005, installed and available on your local workstation?
Your wish is granted! You can download and install the Books Online from the SQL Server 2005 June CTP.
Here is the link.
And if you’re interested in downloading and evaluating SQL 2005, the June full CTP can be accessed HERE.
SQL Server 2005 Tidbit 010
Q: How does SQL 2005 handle online databases during the upgrade, what about the applications that are in use?
A: This questions was very interesting to me so I did some checking. The best bet to see how this is going to work, is to use the Upgrade Advisor, this will give you great advice on any potential database or application issues. However ultimately for any upgrade, some good ole’ fashion testing is in order. For more information, and to down load the Upgrade Advisor look here: http://www.microsoft.com/downloads/details.aspx?FamilyID=cf28daf9-182e-4ac2-8e88-f2e936558bf2&DisplayLang=en
VERY interesting developments on the MS vs. Open Source battlegrounds…
Yes, perhaps I’m a bit biased, considering who signs my paycheck. But to me, Stuart Cohen sounds scared. This eWeek article talks about him and OSDL turning down Microsoft’s offer of a joint, co-sponsored “independent” research study. And what were they afraid of? Well.. Cohen pretty much accuses Microsoft of taking parts of studies and only selling the news that is good for Microsoft in the midst of overwhelming bad news. He accuses us of lieing.
“What do you think about that, Kevin?”
Bullsh**. Yep… I’m getting opinionated here… probably not something I should do on a Microsoft-owned blog.
Have you seen http://www.microsoft.com/getthefacts ? Have you, Mr. Cohen?
The site has a HUGE amount of information.. white-papers and research (yes, many sponsored by Microsoft, but some not) on
These are not just snippets, either. The complete studies are included when practical, and if not, they’re linked to and made available elsewhere. Add to that the wealth of great case studies in categories of
Perhaps we highlight the good points in our marketing. That’s granted. That’s what MARKETING does, afterall. But we do not hide any of the findings. If we did so, you would have a valid concern. But your accusation is weak, defensive, and without merit. And frankly, sounds a bit whiney to me, too. Get the facts, Mr. Cohen.
What also infuriates me about the eWeek article is that it only gives Cohen’s side of the story. I’d like to know more details about how Martin Taylor approached them, and what the specifics were.. but we’ll probably never know. The original discussions were supposed to have been kept secret.
No doubt someone posted about it on their blog. Stupid bloggers.
SQL Server 2005 Tidbit 014
Q: What if I do no want to give SQL 2005 Management Studio to my Developers how to I give them access to the databases?
A: Matt was talking with some of his event attendees, and they recommend that you use SQL 2000 query analyzer for that type of access. During their testing this worked fine with the 2000 QA specifically if you used SQL 2005 Express.
My thought on this is that you should go ahead and USE THE MANAGEMENT STUDIO. The issue isn’t one of what tool is installed, but of security. If you’ve set things up right, you won’t be giving your developers anything they shouldn’t have… and you WILL be giving them a tool they can use powerfully.
Bill Steele is a developer and a skilled presenter on our MSDN team. He is also a former military pilot and currently owns one or two small planes.
Recently he was given the okay to take some time off to help out in the hurricane Katrina relief efforts. A couple days ago he sent this email update to the rest of us on the team:
Well... Today is the first day of Internet access since I started this adventure. I'm flying out of Baton Rouge International... and have so far moved enough meals to feed about 6000 people. When I say meal, I mean MRE... Meal, Ready to Eat. I've been reacquainting myself to them as well... wow... I forgot how good some of them were. I've also been delivering bottled water and some medical supplies. My plane can handle about 700 meals with a bottle of water each and a couple boxes of medicines each trip. (That puts me slightly over gross, but who's counting - we do remove the meals from the cardboard boxes to lighten the load a bit... and I only get about 50 gallons of fuel - since each trip is less then 1 hour.) Anyway, I've had to stop for a little while while some maintenance on my plane is done... I lost the left mag on the left engine on my last take off . The maintenance staff over at "Million Aire" are fixing me up no charge... that's very cool. I have to tell you, most of my flights have been to the lower part of Mississippi which was just hammered. I flew into one airport that was so badly damaged that I literally landed on an access road, because the runway didn't exist. The control tower actually fell over from the wind. It's a real mess in some places. I did a small tour of the coast line for some damage assessment purposes (I've had relief coordinators with me on every flight) and it's just shocking to see the magnitude of the damage. I've lived through some pretty bad tornados at home and the damage looks similar, but it's just so much more massive. Tornados cut paths... there's no paths down here... just destruction everywhere. Anyway, the food deliveries are actually winding down because either the people are leaving or they now have "ground transportation of goods" which means that I'll move into a new type of role shuttling medical supplies and people. (I removed the seats from my plane so we're going to have to reinstall them as well.) There are about 50 planes doing this work... and we're all running about 6 or 7 trips a day. We've got good sleeping quarters... a nearby Holiday Inn Select hotel and plenty of food... when I get hungry, I was just stealing an MRE. The best so far is the Chili Mac... nice and spicy. I'm getting ready to enjoy a Boneless Pork Chop dinner right now, however... you guessed it... it's an MRE as well. By the way... I see we're sending down the MSAM Buses... that's very cool! The thing this is really lacking down here is communications... nothing works. I'm currently using a US National Guard mobile communications van for this access - it's actually a Humvee with a bunch of antennas on it. We get to use it for about 1 hour a day (when it's available.) Oh well... I'll let you know the progress the next time I can. Bill
Bill also wanted me to mention that if you want to help him and other pilots like him who are volunteering so much of their time and resources there are ways to do that:
My hat’s off to you, Bill. You make us all extremely proud.
SQL Server 2005 Tidbit 015
Fifteen. It’s a one, followed by a 5. 15.
Q: Can you rename the SQL 2005 SA account?
A: Yes, as a matter of fact, you can! With the new security model there are some great ways to really secure the SQL Instance. You can rename the account with the ALTER LOGIN statement. This is a great way to reduce surface area for your SQL instances. Here is an example:
ALTER LOGIN sa WITH NAME = [new name here];
Additionally you can disable the account as well:
ALTER LOGIN sa DISABLE;
You can download a great presentation on the new Security enhancements for SQL 2005 here:http://download.microsoft.com/documents/australia/msdn/Session_2_Greg_Low.ppt
A friend passed this along to me. I was never a huge Rush fan… but I sure like this song and especially what this Neil Peart fan did to animate this tribute.
"A Digital Man"
A young man destined-to-be-an-MVP someday – Jose Francisco blogs today about the games that potentially may be included in Windows Vista.
Honestly, I haven’t looked at these yet. I’ve had so much fun with the other features that I’ll have to re-look at the build I’m running and see what’s there… Fun stuff!
<— That’s Ed Faulkner, the program manager of our Microsoft Across America “Mobile Event Experience”.
Ed has a blog now, and he’s using it to put up stories (and pictures) about how several of these trucks are being used in the efforts to help hurricane Katrina victims in Louisianna and Mississippi. (Here's my earlier blog entry about those trucks.)