I know SQL Server from 7.0 and knows the internals so I know it is not possible to pass exam 70-431 with above 900 score if you don't know SSMS...

I like the vm idea. My strengths are definitely in the trial by fire troubleshooting, performance and administration. I am good at coding and db creation but i thrive in...

paul.knibbs (5/12/2009)

---

Speaking as someone who got the old bait and switch pulled on me--e.g. turned up for what I thought was going to be an interview, but they decided to...

Start with the samples and use BOL and you should know if you need to connect to Oracle and Teradata there is a new connector from Microsoft partners. The...

It supports SSAS and SSIS however SSRS 2005 comes with Windows authentication as a requirement so you...

The...

I m using Vista Home Prem, but I have got IIS-7 installed already.

when you said IIS-7 configured, do u have any instruction / website I can refer to?? thanks!!

I...

You may have added SSIS and SSAS but not SSRS because SSRS require IIS7 installed and configured in IIS6 mode, so you need Vista Ultimate or Business to install IIS7...

I think your plan is complicated closer to convoluted, here is what we did after two SQL Server hardware failure in one month. All developers save their compiled stored procedures...

Assuming your AIX is X64 then you need to download and install the Win2003 x64 OLE DB driver in the link below. The reason I have not seen x86...

I would not buy a book on SQL Server security written in 2003 because that was before SQL Server 2005 which comes with security sections within each database, schema definitions...

I think you are installing SQL Server 2005 Express without service because the Express editions comes with service pack bundled so you need to download and install SQL Server Express...

Glad to see you got it working.

If your application is transaction intensive you may have to rewrite your data access because it will improve your application by almost 50% because 2008 Microsoft implemented ANSI SQL 2003...

You get this error because SQL Server 2005/8 Express, Express Advanced and Developer comes with most features disabled by default. In 2005 you have to go to SAC(surface area...