BIDS is a BI development tool that can be used to develop reports, SSIS projects which includes ETL and SSAS projects which includes dimension modeling. When your SSIS packages...

Windows service and Asp.net application cannot be compared because the later is very complicated. That said the first link takes you to free decent tutorials and the second link...

Denise McMillan (1/28/2010)

---

Thanks very much for the quick response. The version and edition upgrade document on Microsoft site said it is possible, so I thought I would try. I'll...

Denise McMillan (1/28/2010)

---

I'm trying to upgrade SQL Server 2005 from developer ed to standard ed. Am using command:

c:\sql2005\Servers\setup.exe SKUUPGRADE=1

I get up to the Upgrade logon information screen and then run...

1. The contracting process for sophisticated equipment like a drone takes a long, long time from the initial idea to the actual product being employed. When the contract was written...

Ray K (1/28/2010)

---

I probably should get a little more specific. ...

mike.styers (1/28/2010)

---

It isn't just that the "Military" missed it. The defense contactor should know better. I have no experience with General Atomics Aeronautical Systems but have worked with...

I am glad I could help.

🙂

rambilla4 (1/27/2010)

---

From the above link, I understand that share point databases will be created with the...

Scott Duncan-251680 (1/27/2010)

---

I've got my server collation set to Latin1_General_CI_AS (I'm in New Zealand). Sharepoint didn't have a problem with this. It sets a different collation on the...

lptech (1/27/2010)

---

Someone besides a DBA really does need to understand SAN implications for database files. lets say I request three LUN's, one each for database files, log files, and tempdb....

Steve Jones - Editor (1/26/2010)

---

Not sure about that. I saw a few postings on the Toshiba forums about hibernate problems, but nothing quite as severe as this one. The Tech...

Tom.Thomson (1/25/2010)

---

Gift Peddie (11/20/2009)

---

You want to explain why there are no roles in Windows and there is roles in SQL Server from the time I have been using it which...

No I need for you to right click on the database and check if it is compatibility 100, that means...

Quick question is the database 2008 or upgrade? If upgrade I always advice drop all Full Text indexes and recreate new ones so all will be native to SQL...