Adding Columns in Katmai

March 04, 2008
I've come across some new functionality in SSMS that you should be aware of. By default, you can't perform any action, like inserting columns, that forces the table to be recreated. But there's a flag for that. I've put together a short Camtasia just to demonstrate how it works. Hope this helps someone. Download file Watch my free SQL Server Tutorials at: http://MidnightDBA.ITBookworm.com Read my book reviews at
DBMS
Read more »

The New Local Internet

March 03, 2008
I've been saying for years now, why can't my LAN be like the internet?  Why do I have to search for docs or even phrases in docs manually on my different file servers?  What I want is to go to a location on my LAN, and type in what I want to find, and have it go out for me to all my servers and bring back my results.  You know... like Google and Yahoo.  Why can't it just be that simple? Well,
DBMS
Read more »

Katmai's Cool DBA Feature

February 25, 2008
OK, I said I would be looking for a DBA-specific feature, and it looks like I found one. I knew about this before, it just didn't come to mind the other day when I was writing the other blog. Katmai has this cool feature where you can run code against a group of servers. And I don't know if it's specifically for DBAs, but it's certainly well suited for us. I'm constantly having to run code on a number of servers
DBMS
Read more »

Talking to Myself

February 21, 2008
Sometimes it's like I'm just talking to myself. I just got a chance to poke around in the Katmai SSMS and I really hope it's not feature complete. I've talked before about crossing the finish line and how it's the little things that count. Well, here are a couple of the little things that are getting overlooked. The job monitor doesn't remember your refresh settings. I would say that most of the time, and by mos
DBMS
Read more »

New Katmai Install Notes

February 20, 2008
OK, I downloaded and installed the new Katmai CTP today. And for those of you who don't follow Microsoft that much, CTP is just a fancy way of saying beta. Actually, it's not really all that fancy is it? Oh well... Anyway, here are my install notes so you'll know what to expect. Now, I did this on my XP box and I only installed the tools so far, so take this with a grain of salt. I had to uninstall the previous
DBMS
Read more »

Search and Replace

February 19, 2008
In writing some code this morning I found it necessary to make some major changes that involved search and replace in SQL Mgmt Studio. I was a little disappointed in the ability of both the SQL tools and Visual Studio to perform rich replace routines. Here's a simple example of what I was trying to do: Create View myView as Select * from myTable where col1 = 63 I had a couple hundred of these statements in the s
DBMS
Read more »

Still Just Disappointed

February 07, 2008
OK, I downloaded Visual Studio 2008 a couple weeks ago. I've got a couple AJAX sites that I wanted to start working with in the new environment. I also wanted to get more involved in LINQ. However, I'm still just disappointed in VS08. It's got some decent features as far as deployment goes, but man, this thing is still just dog slow on vista. I don't know if the problem is vista by itself, or the combo, but it's
DBMS
Read more »

Database Insurance

February 06, 2008
It's difficult having an IT shop these days. You have to manage different types of people along with different priorities from your wide-ranging customer bases. And as an IT director, you want to get the biggest bang for your buck. So you have devs and it's best to have them actively writing code as much as possible. That's how you get your money out of them. And if you have some really expensive sr.-level devs,
DBMS
Read more »

Felt Around the World

January 29, 2008
As I sit here typing I find I really don't know what to say. Ken Henderson, the author of the Guru's Guide to SQL Server series of books (and others), died Sunday. Ken was a good friend of mine and I just talked to him not long ago. I have no words to express my deep sadness of this event. I've been reading other blogs on this and everyone is crediting him with how much he's taught them and how much he'll be mis
DBMS
Read more »

A New Spin on Crime

November 30, 2007
OK, somebody's going to have to help me here. Apparently I don't even know what a crime is anymore. I just read an article on a SQL Server Magazine blog about this whole Idera lawsuit business. You can read it here. In there is an inberview with Rick Pleczko where he said: "This is a civil case, not a criminal case, and neither Quest [nor anyone else] has accused us of criminal behavior. Any information to the c
DBMS
Read more »
©1994-2014 Infoworld, Inc.