I agree with Antares686 on the placement of the files. If you want to encrypt the data files anywhere, there's a pretty good product I've looked at called netlib (...

If you look at the Microsoft site, you'll find lots of propaganda about this. THere are tons of case studies at http://www.microsoft.com/sql . We have the same...

Yeah, I'm afraid that SQL Server will negotiate with the OS and grab whatever memory it can. I generally set a max to that though in the server properties. With...

The MCDBA is a huge step and it shows that you have the drive to learn something. It's a lot of work though! It will...

quote:

---

Are there any good books on SQL-DMO?-JG

---

I've got to agree with the analysis of the...

They work great on my home machine.

Brian Knight

bknight@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bknight

For the basics of data warehousing, look into Kimballs' Data Warehousing Lifecycle Toolkit. For OLAP specific, I like the MS Press Step-by-step series personally.

Brian Knight

bknight@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bknight

DTS is a redistributable application and can be freely used. I beliebe SQLRedis.exe distributes this file, but if you like, I have a list of DLL files I could post.

-

-

Brian...

There looks to be a good one by Voss called ItemAction. It's well below the $1k mark, but I don't think it has VS integration. SQLServerCentral.com members get a...

If you're using SQL Server 2000, you can use the Dynamic Properties task to perform this task.

Brian Knight

bknight@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bknight

None that I'm aware of. You'd have to use the SP_OA* stored procedures if you want to do this programatically.

Brian Knight

bknight@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bknight

You can use the OSQL command with the -i (case sensitive) command. If you want to do it in T-SQL, then use xp_cmdshell followed by the osql command.

Brian Knight

Great idea ians. I'll add that to our wish list for FAQs and Scripts.

Brian Knight

bknight@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bknight

quote:

---

These are and will be good improvements. I hope the ratings on FAQ's will not automatically be factors in the on...

I liked your idea so much I went ahead and created a new graphic for the scripts as well and flagged any script within 30 days as new. Thanks...